terrymanu commented on issue #18139:
URL:
https://github.com/apache/shardingsphere/issues/18139#issuecomment-1164428100
I found the logic SQL is `**select * from (**SELECT d.id,count(d.id) as cnt
FROM one_vacant_visit_detail d
left join one_visit_relate_order r on d.id = r.visit_id
WHERE 1 = 1
AND DATE_FORMAT(d.created_time, '%Y-%m-%d %H:%i%s') >=
concat('2022-05-24 00:00:00', ' 00:00:00')
AND concat('2022-05-31 23:59:59', ' 23:59:59') >=
DATE_FORMAT(d.created_time, '%Y-%m-%d %H:%i%s')
group by d.id order by d.created_time desc**) t**`
What is the `**` in the logic 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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
