suibianwanwank commented on code in PR #4382: URL: https://github.com/apache/calcite/pull/4382#discussion_r2095362880
########## 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 tried adding this test but encountered some query errors. I suspect it's due to https://github.com/apache/calcite/pull/4328. I'll try again after this PR is merged. -- 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]
