[GitHub] [shardingsphere] RaigorJiang opened a new issue, #21706: [DistSQL] Optimize `BROADCAST TABLE` related syntax

[GitBox <gi...@apache.org>]

RaigorJiang opened a new issue, #21706:
URL: https://github.com/apache/shardingsphere/issues/21706

   Hi community,
   
   This issue is for #21659.
   
   ### Background
   The current syntax for broadcast tables are
   ```sql
   CREATE SHARDING BROADCAST TABLE RULES (t_b,t_a);
   ALTER SHARDING BROADCAST TABLE RULES (t_b,t_a,t_3);
   DROP SHARDING BROADCAST TABLE RULES;
   DROP SHARDING BROADCAST TABLE RULES t_b;
   ```
   Doc: https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/rule-definition/sharding/
   
   ### Inadequacy:
   1. If there are multiple broadcast tables, they must be declared within a bracket;
   2. There is only one broadcast table rule, once created, it can only be modified by ALTER, and all table names must be declared in a bracket
   3. If there are many binding tables, it is very difficult to change the rules
   
   ### Aim
   Optimize `BROADCAST TABLE ` related syntax, e.g.
   - `CREATE SHARDING BROADCAST TABLE RULES (t_b,t_a)` -> `CREATE BROADCAST TABLE RULE t_a, t_b`
   - `DROP SHARDING BROADCAST TABLE RULES` -> `DROP BROADCAST TABLE RULE t_a, t_b;`
   - `SHOW SHARDING BROADCAST TABLE RULES` -> `SHOW BROADCAST TABLE RULES`
   - Remove `ALTER SHARDING BROADCAST TABLE RULES`
   


-- 
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] strongduanmu closed issue #21706: [DistSQL] Optimize `BROADCAST TABLE` related syntax

[GitBox <gi...@apache.org>]

strongduanmu closed issue #21706: [DistSQL] Optimize `BROADCAST TABLE` related syntax
URL: https://github.com/apache/shardingsphere/issues/21706


-- 
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