Aleksey Plekhanov created IGNITE-16000:
------------------------------------------
Summary: Java thin client: 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
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}
Related tests:
{noformat}
test_complex_correlated_subquery.test
test_correlated_aggregate_subquery.test
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
