[
https://issues.apache.org/jira/browse/CALCITE-7821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu reassigned CALCITE-7821:
------------------------------------
Assignee: Mihai Budiu
> 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
> Assignee: Mihai Budiu
> Priority: Minor
>
> 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)
