448700174 commented on issue #12315:
URL:
https://github.com/apache/shardingsphere/issues/12315#issuecomment-916603164
If I remve the binding-tables config,The LogicSQL is:
...
2021-09-10 11:27:54.248 [http-nio-8099-exec-1] INFO ShardingSphere-SQL -
Actual SQL: ds ::: select count(*)
from care_task_12 t,care_task_item_12 i left join
care_task_detail_67 d on d.task_item_id = i.id and d.tenant_id = ?
where i.task_id = t.id and t.enabled = 1 and t.done_count > 0
and i.enabled = 1
and t.tenant_id = ?
and i.tenant_id = ?
and t.target_value=?
and t.target_type=?
and t.service_id=?
AND i.operate_time >= ?
and i.operate_time <= ? ::: [12, 12, 12, 959, 0, 1128,
2020-01-01 00:00:00, 2021-09-09 23:59:59]
2021-09-10 11:27:54.248 [http-nio-8099-exec-1] INFO ShardingSphere-SQL -
Actual SQL: ds ::: select count(*)
from care_task_12 t,care_task_item_12 i left join
care_task_detail_68 d on d.task_item_id = i.id and d.tenant_id = ?
where i.task_id = t.id and t.enabled = 1 and t.done_count > 0
and i.enabled = 1
and t.tenant_id = ?
and i.tenant_id = ?
and t.target_value=?
and t.target_type=?
and t.service_id=?
AND i.operate_time >= ?
and i.operate_time <= ? ::: [12, 12, 12, 959, 0, 1128,
2020-01-01 00:00:00, 2021-09-09 23:59:59]
2021-09-10 11:27:54.248 [http-nio-8099-exec-1] INFO ShardingSphere-SQL -
Actual SQL: ds ::: select count(*)
from care_task_12 t,care_task_item_12 i left join
care_task_detail_69 d on d.task_item_id = i.id and d.tenant_id = ?
where i.task_id = t.id and t.enabled = 1 and t.done_count > 0
and i.enabled = 1
and t.tenant_id = ?
and i.tenant_id = ?
...
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
