James Starr created CALCITE-5420:
------------------------------------
Summary: SqlToRel should populate projects corralate id for
queries with aggregates.
Key: CALCITE-5420
URL: https://issues.apache.org/jira/browse/CALCITE-5420
Project: Calcite
Issue Type: Bug
Reporter: James Starr
The following query does not populate correlate id in the project:
{code:sql}
SELECT SUM(
(select char_length(dname) from "scott".dept where dept.deptno = emp.empno))
as s
FROM "scott".emp
{code}
Having the correlate id populated is important for expanding nested queries.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
