iwanttobepowerful commented on code in PR #4382:
URL: https://github.com/apache/calcite/pull/4382#discussion_r2094168311
##########
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:
```sql
SELECT e1.*
FROM emp e1
LEFT JOIN dept d
ON e1.deptno = d.deptno
AND e1.empno not IN ( -- not
SELECT e3.empno
FROM emp e3
WHERE e1.comm > e3.comm
)
ORDER BY e1.empno, e1.deptno;
```
maybe can add this case, and show plans diff if have
--
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]
