You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I had searched in the issues and found no similar issues.
Version
2.0.5
What's Wrong?
What You Expected?
exists子查询中兼容distinct
How to Reproduce?
The sql such as:
select c.id from c
where
EXISTS (SELECT DISTINCT (psr.customer_id)
FROM tab1 psr
LEFT JOIN tab2 pt ON pt.id = psr.task_id AND pt.tenant_id = 1
WHERE psr.customer_id = c.id
AND psr.is_deleted = 0
)
Search before asking
Version
2.0.5
What's Wrong?
What You Expected?
exists子查询中兼容distinct
How to Reproduce?
The sql such as:
select c.id from c
where
EXISTS (SELECT DISTINCT (psr.customer_id)
FROM tab1 psr
LEFT JOIN tab2 pt ON pt.id = psr.task_id AND pt.tenant_id = 1
WHERE psr.customer_id = c.id
AND psr.is_deleted = 0
)
Anything Else?
No response
Are you willing to submit PR?
Code of Conduct
The text was updated successfully, but these errors were encountered: