guowdxp opened a new issue #1908: In query route error URL: https://github.com/apache/incubator-shardingsphere/issues/1908 ## Bug Report ### Which version of ShardingSphere did you use? 4.0.0.M1 ### Which project did you use? Sharding-JDBC or Sharding-Proxy? sharding-proxy ### Expected behavior sql： select * from customer t where party_id in(8001,8002,8003,8004); config： customer: actualDataNodes: ds_0.customer_000${0..1},ds_1.customer_000${2..3} databaseStrategy: inline: shardingColumn: party_id algorithmExpression: ds_${(party_id % 4).intdiv(2)} tableStrategy: inline: shardingColumn: party_id algorithmExpression: customer_${"000" + (party_id % 4)} route result error: ds_0 ::: select * from customer_0000 t where party_id in(8001,8002,8003,8004); ds_0 ::: select * from customer_0001 t where party_id in(8001,8002,8003,8004); ds_0 ::: select * from customer_0002 t where party_id in(8001,8002,8003,8004); ds_0 ::: select * from customer_0003 t where party_id in(8001,8002,8003,8004); ds_1 ::: select * from customer_0000 t where party_id in(8001,8002,8003,8004); ds_1 ::: select * from customer_0001 t where party_id in(8001,8002,8003,8004); ds_1 ::: select * from customer_0002 t where party_id in(8001,8002,8003,8004); ds_1 ::: select * from customer_0003 t where party_id in(8001,8002,8003,8004); The correct routing result should be as follows： ds_0 ::: select * from customer_0000 t where party_id in(8001,8002,8003,8004); ds_0 ::: select * from customer_0001 t where party_id in(8001,8002,8003,8004); ds_1 ::: select * from customer_0002 t where party_id in(8001,8002,8003,8004); ds_1 ::: select * from customer_0003 t where party_id in(8001,8002,8003,8004);
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
