Mihai Budiu created CALCITE-7821:
------------------------------------
Summary: Correlated query crashes SqlToRelConverter
Key: CALCITE-7821
URL: https://issues.apache.org/jira/browse/CALCITE-7821
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.42.0
Reporter: Mihai Budiu
The following program as a SqlToRelConverterTest fails an assertion:
{code:java}
final String sql = "select * from emp as t where t.mgr not in"
+ " (select s.mgr from emp as s where s.empno = t.empno)";
sql(sql).withExpand(true).ok(); {code}
Stack trace:
{code:java}
java.lang.AssertionError: contains $cor0
at org.apache.calcite.util.Litmus.lambda$static$0(Litmus.java:31)
at
org.apache.calcite.plan.RelOptUtil.notContainsCorrelation(RelOptUtil.java:347)
at org.apache.calcite.rel.core.Correlate.isValid(Correlate.java:148)
at org.apache.calcite.rel.core.Correlate.<init>(Correlate.java:110)
at
org.apache.calcite.rel.logical.LogicalCorrelate.<init>(LogicalCorrelate.java:73)
at
org.apache.calcite.rel.logical.LogicalCorrelate.create(LogicalCorrelate.java:116)
at
org.apache.calcite.sql2rel.SqlToRelConverter.createJoin(SqlToRelConverter.java:3406)
at
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.register(SqlToRelConverter.java:5672)
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
