Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Enhancement Request] Branch filter support % operator. #381

Open
gerayking opened this issue Dec 8, 2023 · 0 comments
Open

[Enhancement Request] Branch filter support % operator. #381

gerayking opened this issue Dec 8, 2023 · 0 comments
Assignees
Labels
enhancement New feature or request

Comments

@gerayking
Copy link
Contributor

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 gerayking added the enhancement New feature or request label Dec 8, 2023
@gerayking gerayking self-assigned this Dec 8, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant