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)