mihaibudiu commented on code in PR #4470:
URL: https://github.com/apache/calcite/pull/4470#discussion_r2216532126
##########
core/src/test/resources/sql/sub-query.iq:
##########
@@ -5151,4 +5151,100 @@ EnumerableCalc(expr#0..2=[{inputs}], expr#3=[IS
FALSE($t1)], expr#4=[null:BOOLEA
EnumerableValues(tuples=[[{ null }, { null }]])
!plan
+# [CALCITE-1583] Wrong results for query with correlated subqueries with
aggregate subquery expression
+# Correlated sub-query with aggregate expression can optimized by Metadata
RowCount
+select * from emp where exists (select count(deptno) from dept where
dept.deptno = emp.deptno);
++-------+--------+--------+
Review Comment:
If these have been validated using another database, please add a comment.
Is there value in having the plan here?
--
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]
