[
https://issues.apache.org/jira/browse/IGNITE-25357?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18005092#comment-18005092
]
Ignite TC Bot commented on IGNITE-25357:
----------------------------------------
{panel:title=Branch: [pull/12183/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/12183/head] Base: [master] : New Tests
(4)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
4|https://ci2.ignite.apache.org/viewLog.html?buildId=8517361]]
* {color:#013220}IgniteCalciteTestSuite:
CorrelatedSubqueryPlannerTest.testPaddedCorrelateInSecondFilterSubquery -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
CorrelatesIntegrationTest.testPaddedCorrelateInSecondFilterSubquery[sqlTxMode=NONE]
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
CorrelatesIntegrationTest.testPaddedCorrelateInSecondFilterSubquery[sqlTxMode=RANDOM]
- PASSED{color}
* {color:#013220}IgniteCalciteTestSuite:
CorrelatesIntegrationTest.testPaddedCorrelateInSecondFilterSubquery[sqlTxMode=ALL]
- PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8517344&buildTypeId=IgniteTests24Java8_RunAll]
> 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: 1h 10m
> 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)
