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-487252855
 
 
   @codefairy08 please run test case in version 4.0.0-RC1 and version 3.0.1 
with this  two sql:
   ```sql
   select * from ts_order td where exists (select 1 from ts_order_address tda 
where tda.order_id = 1);
   select * from ts_order td where exists (select 1 from ts_order_address tda 
where tda.id = 1);
   ```
   In my first comment, I have described the differences between the two 
versions when use first sql.
   And the second comment has the differences description about the second sql.

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

Reply via email to