lshirong opened a new issue, #18146:
URL: https://github.com/apache/shardingsphere/issues/18146
## Question
Which version of ShardingSphere did you use?
5.1.1
Which project did you use?
shardingsphere-jdbc-core-spring-boot-starter
Question
When sql "id not in ('1')", there are no route query all database, but only
route query the database where '1' is located
Demo
## sharding-config
spring.shardingsphere.rules.sharding.default-database-strategy.standard.sharding-column=id
spring.shardingsphere.rules.sharding.default-database-strategy.standard.sharding-algorithm-name=id-sharding
spring.shardingsphere.rules.sharding.sharding-algorithms.id-shardingtype=CLASS_BASED
spring.shardingsphere.rules.sharding.sharding-algorithms.id-sharding.props.strategy=STANDARD
spring.shardingsphere.rules.sharding.sharding-algorithms.id-sharding.props.algorithmClassName=com.ShardingAlgorithm
## ShardingAlgorithm
public class ShardingAlgorithm implements StandardShardingAlgorithm<String>
## query sql
select * from demo where id not in ('1')
--
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]
