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/10/10 06:40:38 UTC

[GitHub] [shardingsphere] lshirong opened a new issue, #18146: sharding Key "not in " how to route query to all databases

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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] github-actions[bot] closed issue #18146: sharding Key "not in " how to route query to all databases

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #18146: sharding Key "not in " how to route query to all databases
URL: https://github.com/apache/shardingsphere/issues/18146


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

[GitHub] [shardingsphere] terrymanu commented on issue #18146: sharding Key "not in " how to route query to all databases

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18146:
URL: https://github.com/apache/shardingsphere/issues/18146#issuecomment-1164421863

   I cannot get your point from the title, can you change it?


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

[GitHub] [shardingsphere] github-actions[bot] commented on issue #18146: sharding Key "not in " how to route query to all databases

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #18146:
URL: https://github.com/apache/shardingsphere/issues/18146#issuecomment-1272349670

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


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