wescale icon indicating copy to clipboard operation
wescale copied to clipboard

[Enhancement Request] Branch filter support % operator.

Open gerayking opened this issue 1 year ago • 0 comments

Background

support

<!-- A clear and concise description of what the problem is -->
update mysql.branch_table_rules set filtering_rule='select id, fake(\'name\') as name from `user` WHERE id<=100' where source_table_name = 'user';
update mysql.branch_table_rules set filtering_rule='select customer_id, fake(\'email\') as email from `customer` WHERE customer_id<=100' where source_table_name = 'customer';
update mysql.branch_table_rules set filtering_rule='select * from `product`' where source_table_name = 'product';
update mysql.branch_table_rules set filtering_rule='SELECT * FROM corder where customer_id<=100' where source_table_name = 'corder';

expected support

update mysql.branch_table_rules set filtering_rule='select id, fake(\'name\') as name from `user` WHERE id%10=0' where source_table_name = 'user';
update mysql.branch_table_rules set filtering_rule='select customer_id, fake(\'email\') as email from `customer` WHERE customer_id%10=0' where source_table_name = 'customer';
update mysql.branch_table_rules set filtering_rule='select * from `product`' where source_table_name = 'product';
update mysql.branch_table_rules set filtering_rule='SELECT * FROM corder where customer_id%10=0' where source_table_name = 'corder';

Proposal

gerayking avatar Dec 08 '23 09:12 gerayking