[CALCITE-5420] SqlToRel should populate the correlate id of a Project for queries with aggregates

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: James Starr
• Reporter: James Starr
• Created: 02/Dec/22 23:18
• Updated: 02/Mar/23 14:22

Description

The following query does not populate correlate id in the project when SqlToRel.expand=false:

SELECT SUM(
  (select char_length(dname) from "scott".dept where dept.deptno = emp.empno)) as s
FROM "scott".emp

Having the correlate id populated is important for expanding nested queries.

Issue Links

• blocks: CALCITE-5418 Nested Queries are not expanded properly
• relates to: CALCITE-5421 SqlToRelConverter should populate correlateId for join with correlated query in HAVING condition