[ https://issues.apache.org/jira/browse/IGNITE-18667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Iurii Gerzhedovich updated IGNITE-18667: ---------------------------------------- Epic Link: IGNITE-22700 > sql. left outer join with correlated subquery fails > --------------------------------------------------- > > Key: IGNITE-18667 > URL: https://issues.apache.org/jira/browse/IGNITE-18667 > Project: Ignite > Issue Type: Bug > Components: sql > Reporter: Maksim Zhuravkov > Priority: Major > Labels: calcite2-required, calcite3-required, ignite-3 > Fix For: 3.0.0-beta2 > > > The following queries must work but the fail: > {code:java} > # left outer join on arbitrary correlated subquery > statement ok > SELECT * FROM integers s1 LEFT OUTER JOIN integers s2 ON (SELECT CASE WHEN > s1.i+s2.i>10 THEN TRUE ELSE FALSE END) ORDER BY s1.i; > {code} > Expected: > {code:java} > i i > 1 null > 2 null > 3 null > null null > {code} > Actual: > {code:java} > Caused by: java.lang.AssertionError: All correlation variables should resolve > to the same namespace. Prev > ns=org.apache.calcite.sql.validate.IdentifierNamespace@7f74c84c, new > ns=org.apache.calcite.sql.validate.IdentifierNamespace@11b2d99c > at > org.apache.calcite.sql2rel.SqlToRelConverter.getCorrelationUse(SqlToRelConverter.java:3006) > at > org.apache.calcite.sql2rel.SqlToRelConverter.createJoin(SqlToRelConverter.java:2916) > at > org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.register(SqlToRelConverter.java:4865) > at > org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.reRegister(SqlToRelConverter.java:4930) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertOnCondition(SqlToRelConverter.java:3253) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertJoin(SqlToRelConverter.java:3173) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2392) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:2280) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:694) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:675) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3737) > at > org.apache.ignite.internal.sql.engine.prepare.IgniteSqlToRelConvertor.convertQueryRecursive(IgniteSqlToRelConvertor.java:68) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:595) > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)