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 2021/09/15 09:46:37 UTC

[GitHub] [shardingsphere] tuichenchuxin commented on issue #12315: left join result in cross table merge

tuichenchuxin commented on issue #12315:
URL: https://github.com/apache/shardingsphere/issues/12315#issuecomment-919868109


   @448700174 
   I saw the actual sql is like 
   ``` FROM care_patrol_task_76 cpt,care_patrol_subtask_76 cps```
   ```FROM care_patrol_task_77 cpt,care_patrol_subtask_77 cps```
   these tables have binding relationship. If they are not binding each other, the sql will be like 
   ```FROM care_patrol_task_1 cpt,care_patrol_subtask_2 cps```
   So, may be the sharding column or strategy ?
   And Maybe can you try to use the latest code to see if you have the same problem?


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