Stanilovsky Evgeny created CALCITE-4673: -------------------------------------------
Summary: Correlate variables deduplication are not triggers under COLLECTION_TABLE. Key: CALCITE-4673 URL: https://issues.apache.org/jira/browse/CALCITE-4673 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.27.0 Reporter: Stanilovsky Evgeny request like: {noformat} select e.deptno, (select * from lateral table(DEDUP(e.deptno, e.deptno))) from emp e; {noformat} shows 2 different correlates, while it only one. {noformat} LogicalProject(DEPTNO=[$7], EXPR$1=[$SCALAR_QUERY({ LogicalProject(NAME=[$0]) LogicalTableFunctionScan(invocation=[DEDUP($cor0.DEPTNO, $cor1.DEPTNO)], rowType=[RecordType(VARCHAR(1024) NAME)]) })]) LogicalTableScan(table=[[CATALOG, SALES, EMP]]) {noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005)