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)