[CALCITE-4673] If arguments to a table function are correlation variables, SqlToRelConverter should eliminate duplicate variables

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.27.0
• Fix Version/s: 1.28.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 30/Jun/21 10:33
• Updated: 01/Dec/21 17:02
• Resolved: 06/Aug/21 21:47

Description

request like:

select e.deptno, (select * from lateral table(DEDUP(e.deptno, e.deptno))) from emp e;

shows 2 different correlates, while it only one.

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]])

dev-list discussion

Issue Links

• is related to: CALCITE-1732 IndexOutOfBoundsException when using LATERAL TABLE with more than one field
• is related to: CALCITE-4913 Correlated variables in a select list are not deduplicated
• Testing discovered: CALCITE-4718 Erroneous correlate variables in case of using collect sub-queries into ARRAY, MAP and MULTISET.
• links to: GitHub Pull Request #2448