You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/11/23 14:21:40 UTC

[GitHub] [shardingsphere] RaigorJiang opened a new issue, #22371: [DistSQL] Add name to SHARDING TABLE REFERENCE RULE

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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero closed issue #22371: [DistSQL] Add name to SHARDING TABLE REFERENCE RULE

Posted by GitBox <gi...@apache.org>.

tristaZero closed issue #22371: [DistSQL] Add name to SHARDING TABLE REFERENCE RULE
URL: https://github.com/apache/shardingsphere/issues/22371


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org