RaigorJiang opened a new issue, #22371: URL: https://github.com/apache/shardingsphere/issues/22371
Hi community, This issue is for [#21659](https://github.com/apache/shardingsphere/issues/21659). ### Background Now our syntax for managing Sharding Table Reference Rules is as follows: ```sql CREATE SHARDING TABLE REFERENCE RULE (t_order,t_order_item),(t_1,t_2); ALTER SHARDING TABLE REFERENCE RULE (t_order,t_order_item); DROP SHARDING TABLE REFERENCE RULE (t_order,t_order_item); ``` When there are multiple sets of Sharding Table Reference Rules, if we want to alter or drop one of them, we need to write all the definitions, which is very inconvenient. ### Aim I plan to add a rule name to the SHARDING TABLE REFERENCE RULE, the expected form is: ```SQL CREATE SHARDING TABLE REFERENCE RULE ruleName (t1, t2) ALTER SHARDING TABLE REFERENCE RULE ruleName (t1, t2) DROP SHARDING TABLE REFERENCE RULE ruleName ``` In this way, when there are multiple sets of SHARDING TABLE REFERENCE RULE, accurate management can be performed. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
