[GitHub] [shardingsphere] Peterosh commented on issue #18279: Use the source command to load SQL files and create sharding rules. Some of them will be ignored

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

Peterosh commented on issue #18279:
URL: https://github.com/apache/shardingsphere/issues/18279#issuecomment-1165554076

   there is not find any exception thrown.SHARDING TABLE RULE is not fully implemented。
   Here's my solution right now
   ```
   ADD RESOURCE test_0 (
       HOST=127.0.0.1,
       PORT=3306,
       DB=test_0,
       USER=root,
       PASSWORD=root
   ),test_1 (
       HOST=127.0.0.1,
       PORT=3306,
       DB=test_1,
       USER=root,
       PASSWORD=root
   );
   
   CREATE DEFAULT SINGLE TABLE RULE RESOURCE = test_0;
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test1 (
   DATANODES("test_${0..1}.test1"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test2 (
   DATANODES("test_${0..1}.test2"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test3(
   DATANODES("test_${0..1}.test3"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test4 (
   DATANODES("test_${0..1}.test4"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test5 (
   DATANODES("test_${0..1}.test5"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test6 (
   DATANODES("test_${0..1}.test6"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test7 (
   DATANODES("test_${0..1}.test7"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test8 (
   DATANODES("test_${0..1}.test8"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test9 (
   DATANODES("test_${0..1}.test9"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   
   The select sleep (1);
   CREATE SHARDING TABLE RULE test10 (
   DATANODES("test_${0..1}.test10"),
   DATABASE_STRATEGY(TYPE=standard,SHARDING_COLUMN=PlayerID,SHARDING_ALGORITHM(TYPE(NAME=BOUNDARY_RANGE,PROPERTIES("sharding-ranges"=20001))))
   );
   ```
   


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