[jira] [Created] (CALCITE-4833) Complex nested correlated subquery failed.

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

Evgeny Stanilovsky created CALCITE-4833:
-------------------------------------------

             Summary: Complex nested correlated subquery failed.
                 Key: CALCITE-4833
                 URL: https://issues.apache.org/jira/browse/CALCITE-4833
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.27.0
            Reporter: Evgeny Stanilovsky
         Attachments: test.patch

Query like:

{noformat}
SELECT * FROM depts t1 LEFT JOIN depts t2 ON (SELECT t2.deptno)<200
{noformat}

failed with :


{noformat}
Required columns {4} not subset of left columns {0, 1, 2, 3}
java.lang.AssertionError: Required columns {4} not subset of left columns {0, 1, 2, 3}
	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)
{noformat}

failed test attached.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)