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)
