Maksim Zhuravkov created IGNITE-18667:
-----------------------------------------
Summary: 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
Reporter: Maksim Zhuravkov
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)
