[GitHub] [shardingsphere] FlyingZC commented on issue #24422: Special SQL about not executing ComplexKeysShardingAlgorithm.dosharding()

["FlyingZC (via GitHub)" <gi...@apache.org>]

FlyingZC commented on issue #24422:
URL: https://github.com/apache/shardingsphere/issues/24422#issuecomment-1459165907

   @zy1263188600 Hi, It's a bug, would you want to try to fix it.
   ```sql
   mysql> select * from t_order where user_id=1 and user_id=2;
   Empty set (0.01 sec)
   
   mysql> select * from t_order where user_id in(1,2);
   +----------+---------+--------+
   | order_id | user_id | status |
   +----------+---------+--------+
   |        2 |       2 | 2      |
   |        1 |       1 | 1      |
   +----------+---------+--------+
   2 rows in set (0.07 sec)
   ```


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