[GitHub] [shardingsphere] 448700174 removed a comment on issue #12315: left join result in cross table merge

[GitBox <gi...@apache.org>]

448700174 removed a comment on issue #12315:
URL: https://github.com/apache/shardingsphere/issues/12315#issuecomment-921521823


   And another simple query failed:
   select s.* from care_patrol_subtask s where s.tenant_id = ? and s.task_id = ? and s.carer_id=?
   
   The actual SQL is:
   2021-09-17 13:55:59.570 [http-nio-8099-exec-5] INFO  ShardingSphere-SQL - Actual SQL: ds ::: select s.* from care_patrol_subtask_1 s where s.tenant_id = ? and s.task_id = ? and s.carer_id=? ::: [12, 1438502973387612160, 14]
   2021-09-17 13:55:59.570 [http-nio-8099-exec-5] INFO  ShardingSphere-SQL - Actual SQL: ds ::: select s.* from care_patrol_subtask_2 s where s.tenant_id = ? and s.task_id = ? and s.carer_id=? ::: [12, 1438502973387612160, 14]
   2021-09-17 13:55:59.570 [http-nio-8099-exec-5] INFO  ShardingSphere-SQL - Actual SQL: ds ::: select s.* from care_patrol_subtask_3 s where s.tenant_id = ? and s.task_id = ? and s.carer_id=? ::: [12, 1438502973387612160, 14]
   


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