fantacy2001 commented on issue #4861: two tables left join with different 
routing rules are not supported
URL: 
https://github.com/apache/incubator-shardingsphere/issues/4861#issuecomment-604801451
 
 
   > Can you use SQL to explain your expected behaviour?
   shardingsphere's route is no problem. 
   i mean a convention is :  select a.*,b.* from a left join b on a.col = b.col 
where a.col = '123'
   but not :     select a.*,b.* from a left join b on a.col = b.col where a.col 
= '123' and b.col = '123'
   t does not affect the function, but talk about whether it is possible to 
optimize 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.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

Reply via email to