[
https://issues.apache.org/jira/browse/IGNITE-16000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17460914#comment-17460914
]
Vladimir Steshin commented on IGNITE-16000:
-------------------------------------------
Found similar problen within Calcite 1.29 master:
{code:java}
Required columns {7} not subset of left columns {0, 1}
java.lang.AssertionError: Required columns {7} not subset of left columns {0, 1}
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:2789)
at
org.apache.calcite.rel.rules.SubQueryRemoveRule.rewriteScalarQuery(SubQueryRemoveRule.java:130)
at
org.apache.calcite.rel.rules.SubQueryRemoveRule.apply(SubQueryRemoveRule.java:93)
at
org.apache.calcite.rel.rules.SubQueryRemoveRule.matchProject(SubQueryRemoveRule.java:785)
at
org.apache.calcite.rel.rules.SubQueryRemoveRule.access$200(SubQueryRemoveRule.java:74)
at
org.apache.calcite.rel.rules.SubQueryRemoveRule$Config.lambda$static$0(SubQueryRemoveRule.java:863)
at
org.apache.calcite.rel.rules.SubQueryRemoveRule.onMatch(SubQueryRemoveRule.java:85)
{code}
on
{code:sql}
select e.department_id, sum(e.employee_id),
( select sum(e2.employee_id)
from employee e2
where e.department_id = e2.department_id
)
from employee e
group by e.department_id;
{code}
Looks like it is same as CALCITE-685.
> 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)
