Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Assertion error
java.lang.AssertionError: Required columns {2} not subset of left columns {0} at org.apache.calcite.util.Litmus$1.fail(Litmus.java:32) at org.apache.calcite.util.Litmus$1.check(Litmus.java:44) at org.apache.calcite.rel.core.Correlate.isValid(Correlate.java:127) at org.apache.calcite.rel.core.Correlate.<init>(Correlate.java:104) at org.apache.calcite.rel.logical.LogicalCorrelate.<init>(LogicalCorrelate.java:66) at org.apache.calcite.rel.logical.LogicalCorrelate.create(LogicalCorrelate.java:94) at org.apache.calcite.rel.core.RelFactories$CorrelateFactoryImpl.createCorrelate(RelFactories.java:417) at org.apache.calcite.tools.RelBuilder.join(RelBuilder.java:2799) at org.apache.calcite.rel.rules.SubQueryRemoveRule.rewriteScalarQuery(SubQueryRemoveRule.java:131) at org.apache.calcite.rel.rules.SubQueryRemoveRule.apply(SubQueryRemoveRule.java:94) at org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:786) at org.apache.calcite.rel.rules.SubQueryRemoveRule.access$200(SubQueryRemoveRule.java:75) at org.apache.calcite.rel.rules.SubQueryRemoveRule$Config.lambda$static$0(SubQueryRemoveRule.java:864) at org.apache.calcite.rel.rules.SubQueryRemoveRule.onMatch(SubQueryRemoveRule.java:86)
For queries like:
SELECT i, (SELECT COUNT(*) FROM integers i2 WHERE i2.i>i1.i) FROM integers i1 ORDER BY i NULLS FIRST;
Or
SELECT (SELECT (SELECT t.i)) FROM test t
Related tests:
test_complex_correlated_subquery.test test_correlated_aggregate_subquery.test test_grouped_correlated_subquery.test_ignore
Attachments
Issue Links
- Dependency
-
CALCITE-4833 Complex nested correlated subquery failed.
- In Progress
- is part of
-
IGNITE-12248 Apache Calcite based query execution engine
- Open
- relates to
-
CALCITE-685 Correlated scalar sub-query in SELECT clause throws
- Open
-
CALCITE-4943 Type mismatch in Project / HepPlanner: INTEGER to JavaType(int)
- Open