[ https://issues.apache.org/jira/browse/CALCITE-5420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Starr reassigned CALCITE-5420: ------------------------------------ Assignee: James Starr > 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 > Assignee: James Starr > Priority: Major > > 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)