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/12/16 15:58:17 UTC

[GitHub] [shardingsphere] RaigorJiang opened a new issue, #22926: Enhance the algorithm type check when create sharding table rule

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

   ## Bug Report
   ### Which version of ShardingSphere did you use?
   master 6f625cf
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Expected behavior
   When using the standard way to create sharding table rule, the auto sharding algorithm is not allowed, like `MOD`, `HASH_MOD`.
   
   ### Actual behavior
   Can now use the auto sharding algorithm to create standard sharding table rule
   ```sql
   mysql> CREATE SHARDING TABLE RULE t_order_item (
       -> DATANODES("ds_${0..1}.t_order_item"),
       -> DATABASE_STRATEGY(TYPE="standard",SHARDING_COLUMN=user_id,SHARDING_ALGORITHM(TYPE(NAME="MOD",PROPERTIES("sharding-count"=4))))
       -> );
   Query OK, 0 rows affected (0.38 sec)
   
   mysql> 
   ```
   
   ### Reason analyze (If you can)
   Similar to https://github.com/apache/shardingsphere/pull/22900
   


-- 
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] RaigorJiang closed issue #22926: Enhance the algorithm type check when create sharding table rule

Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #22926: Enhance the algorithm type check when create sharding table rule
URL: https://github.com/apache/shardingsphere/issues/22926


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