You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "James Starr (Jira)" <ji...@apache.org> on 2020/09/01 22:30:00 UTC
[jira] [Created] (CALCITE-4210) Aggregation is dropped during
decorreleation
James Starr created CALCITE-4210:
------------------------------------
Summary: Aggregation is dropped during decorreleation
Key: CALCITE-4210
URL: https://issues.apache.org/jira/browse/CALCITE-4210
Project: Calcite
Issue Type: Bug
Components: core
Reporter: James Starr
Aggregation is dropped during decorreleation.
{code:java}
SELECT "employee"."department_id", "employee"."salary"
FROM "department"
LEFT JOIN "employee" ON "employee"."salary" = (
SELECT max("employee"."salary")
FROM "employee"
WHERE "employee"."department_id" = "department"."department_id"
)
{code}
{code:java}
LogicalProject(department_id=[$9], salary=[$13])
LogicalJoin(condition=[=($13, $0)], joinType=[left])
LogicalTableScan(table=[[foodmart, department]])
LogicalTableScan(table=[[foodmart, employee]]){code}
This may be related to CALCITE-4206.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)