xiedeyantu commented on code in PR #4382: URL: https://github.com/apache/calcite/pull/4382#discussion_r2094768570
########## core/src/test/resources/sql/sub-query.iq: ########## @@ -848,6 +848,38 @@ where sal + 100 not in ( !ok +SELECT e1.* +FROM emp e1 +LEFT JOIN dept d + ON e1.deptno = d.deptno + AND e1.empno IN ( + SELECT e3.empno + FROM emp e3 + WHERE e1.comm > e3.comm + ) Review Comment: I may not understand the purpose of the test `not in`. Do you want to add a case where `inputIntersectsLeftSide=false`? -- 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]
