peilinqian commented on issue #19102:
URL: 
https://github.com/apache/shardingsphere/issues/19102#issuecomment-1259488130

   we find java version: java8, full_version=1.8.0_342, 
full_path=/home/peilq_sharding/bisheng-jdk1.8.0_342//bin/java
   ShardingSphere-5.2.1-SNAPSHOT
   Commit ID: dirty-4114e7ee4cbe5923c2b403a3e86d1f23355cadf3
   Commit Message: Fix parse exception when execute insert statement with 
negative value (#21197)
   Branch: 4114e7ee4cbe5923c2b403a3e86d1f23355cadf3
   Build time: 2022-09-27T16:37:07+0800
   
   ```
   tpch_db=> CREATE READWRITE_SPLITTING RULE ms_group_0 (
   tpch_db(> WRITE_RESOURCE=resource_0 ,
   tpch_db(> READ_RESOURCES(resource_0 ,resource_0),
   tpch_db(> TYPE(NAME="random")
   tpch_db(> );
   ERROR:  Invalid `readwrite splitting` rule `ms_group_0`, error message is: 
Can not config duplicate read resource `resource_0` in database `tpch_db`
   tpch_db=> CREATE READWRITE_SPLITTING RULE ms_group_0 (
   tpch_db(> WRITE_RESOURCE=resource_0 ,
   tpch_db(> READ_RESOURCES(resource_0),
   tpch_db(> TYPE(NAME="random")
   tpch_db(> );
   
   SUCCESS
   tpch_db=> CREATE READWRITE_SPLITTING RULE ms_group_0 (
   tpch_db(> WRITE_RESOURCE=resource_1 ,
   tpch_db(> READ_RESOURCES(resource_0),
   tpch_db(> TYPE(NAME="random")
   tpch_db(> );
   ERROR:  Duplicate readwrite splitting rule names `[ms_group_0]` in database 
`tpch_db`
   tpch_db=> CREATE READWRITE_SPLITTING RULE ms_group_0 (
   tpch_db(> WRITE_RESOURCE=resource_0 ,
   tpch_db(> READ_RESOURCES(resource_1),
   tpch_db(> TYPE(NAME="random")
   tpch_db(> );
   ERROR:  Duplicate readwrite splitting rule names `[ms_group_0]` in database 
`tpch_db`
   tpch_db=> CREATE READWRITE_SPLITTING RULE ms_group_0 (
   tpch_db(> WRITE_RESOURCE=resource_1 ,
   tpch_db(> READ_RESOURCES(resource_1),
   tpch_db(> TYPE(NAME="random")
   tpch_db(> );
   ERROR:  Duplicate readwrite splitting rule names `[ms_group_0]` in database 
`tpch_db`
   tpch_db=>
   tpch_db=>
   tpch_db=>
   tpch_db=> CREATE READWRITE_SPLITTING RULE ms_group_1 (
   WRITE_RESOURCE=resource_1 ,
   READ_RESOURCES(resource_1),
   TYPE(NAME="random")
   );
   SUCCESS
   tpch_db=>
   
   ```


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

Reply via email to