AlbertTao commented on issue #2263: Must have sharding column with subquery error occurred when use “exists”. URL: https://github.com/apache/incubator-shardingsphere/issues/2263#issuecomment-486243478 If use the case run another sql : ```sql select * from ts_order td where exists (select 1 from ts_order_address tda where tda.id = 1); ``` The result is the opposite between version 4.0.0-RC1 and 3.0.1. In version 3.0.1 , get error : ``` Exception in thread "main" java.lang.IllegalStateException: Must have sharding column with subquery. ``` In version 4.0.0-RC, get result without error: ``` [main] INFO ShardingSphere-SQL - Actual SQL: ds_0 ::: select * from ts_order_0001 td where exists (select 1 from ts_order_address_0001 tda where tda.id = 1); ------------------------------------------------------------ id 1 ------------------------------------------------------------ Get Data rows 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
