[
https://issues.apache.org/jira/browse/CALCITE-4833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated CALCITE-4833:
----------------------------------------
Attachment: test.patch
> 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
> Priority: Major
> 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)
