[ https://issues.apache.org/jira/browse/IGNITE-16000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Steshin reassigned IGNITE-16000: ----------------------------------------- Assignee: Vladimir Steshin > Calcite engine. Assertion error on SubQueryRemoveRule for correlated queries > ---------------------------------------------------------------------------- > > Key: IGNITE-16000 > URL: https://issues.apache.org/jira/browse/IGNITE-16000 > Project: Ignite > Issue Type: Bug > Reporter: Aleksey Plekhanov > Assignee: Vladimir Steshin > Priority: Major > Labels: calcite2-required, calcite3-required > > Assertion error > {noformat} > 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) > {noformat} > For queries like: > {noformat} > SELECT i, (SELECT COUNT(*) FROM integers i2 WHERE i2.i>i1.i) FROM integers i1 > ORDER BY i NULLS FIRST; > {noformat} > Or > {noformat} > SELECT (SELECT (SELECT t.i)) FROM test t{noformat} > Related tests: > {noformat} > test_complex_correlated_subquery.test > test_correlated_aggregate_subquery.test > test_grouped_correlated_subquery.test_ignore {noformat} -- This message was sent by Atlassian Jira (v8.20.1#820001)