You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Steshin (Jira)" <ji...@apache.org> on 2025/07/10 16:12:00 UTC

[jira] [Updated] (IGNITE-25357) Calcite engine. Wrong required columns calculation for double correlate

     [ https://issues.apache.org/jira/browse/IGNITE-25357?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Steshin updated IGNITE-25357:
--------------------------------------
    Affects Version/s: 2.17

> Calcite engine. Wrong required columns calculation for double correlate
> -----------------------------------------------------------------------
>
>                 Key: IGNITE-25357
>                 URL: https://issues.apache.org/jira/browse/IGNITE-25357
>             Project: Ignite
>          Issue Type: Bug
>    Affects Versions: 2.17
>            Reporter: Aleksey Plekhanov
>            Assignee: Vladimir Steshin
>            Priority: Major
>              Labels: calcite, ise
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Reproducer:
> {code:java}
>     /** */
>     @Test
>     public void testCorrelateWrongRequiredColumn() throws Exception {
>         IgniteSchema schema = createSchema(
>             createTable("T1", IgniteDistributions.single(), "ID", Integer.class, "NAME", String.class, "REF", Integer.class),
>             createTable("T2", IgniteDistributions.single(), "ID", Integer.class, "REF", Integer.class),
>             createTable("T3", IgniteDistributions.single(), "ID", Integer.class, "REF", Integer.class)
>         );
>         assertPlan("SELECT * FROM T1 WHERE EXISTS (" +
>                 "SELECT 1 FROM T2 WHERE T2.ID = T1.REF AND T2.REF = (SELECT 1 FROM T3 WHERE T3.ID = T1.REF))", schema,
>             nodeOrAnyChild(isTableScan("T1")));
>     }
> {code}
>  Throws an assertion error:
> {noformat}
>  java.lang.AssertionError: Required columns {2} not subset of left columns {0, 1}
> 	at org.apache.calcite.util.Litmus.lambda$static$0(Litmus.java:31) ~[calcite-core-1.37.0.jar:1.37.0]
> 	at org.apache.calcite.util.Litmus.check(Litmus.java:76) ~[calcite-core-1.37.0.jar:1.37.0]
> 	at org.apache.calcite.rel.core.Correlate.isValid(Correlate.java:145) ~[calcite-core-1.37.0.jar:1.37.0]
> 	at org.apache.calcite.rel.core.Correlate.<init>(Correlate.java:109) ~[calcite-core-1.37.0.jar:1.37.0]
> 	at org.apache.calcite.rel.logical.LogicalCorrelate.<init>(LogicalCorrelate.java:73) ~[calcite-core-1.37.0.jar:1.37.0]
> 	at org.apache.calcite.rel.logical.LogicalCorrelate.create(LogicalCorrelate.java:116) ~[calcite-core-1.37.0.jar:1.37.0]
> {noformat}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)