search

wesql / wescale

WeScale is a Modern MySQL proxy that supports read-write-split, read-after-write-consistency, load balancing and OnlineDDL.
Apache License 2.0
199 stars 8 forks source link

[Enhancement Request] Allow 'Plans' and 'fully_qualified_table_names' to be empty for 'create/alter filter' statement #479

Closed earayu closed 5 months ago

earayu commented 5 months ago 
create filter ccl(
        desc='test ccl',
        priority='999',
        status='ACTIVE'
)
with_pattern(
        plans='',
        fully_qualified_table_names='d1.t1',
        query_regex='',
        query_template='delete from t1',
        request_ip_regex='',
        user_regex='',
        leading_comment_regex='',
        trailing_comment_regex='',
        bind_var_conds=''
)
execute(
        action='CONCURRENCY_CONTROL',
        action_args='max_queue_size=0; max_concurrency=0'
);
earayu commented 5 months ago

So does fully_qualified_table_names

create filter sql_block_list (
        priority='900'
)
with_pattern(
        query_template='select * from t1'
)
execute(
        action='FAIL'
);