Xurenhe created CALCITE-5000:
--------------------------------
Summary: Expand rule of `AGGREGATE_REDUCE_FUNCTIONS`,
Key: CALCITE-5000
URL: https://issues.apache.org/jira/browse/CALCITE-5000
Project: Calcite
Issue Type: Improvement
Reporter: Xurenhe
Using calcite's SubstitutionVisitor, we need do a lot work about canonicalizing
relnode.
Some sql should be simplified.
{noformat}
-- origin sql
select deptno, salary, max(salary), min(commission)
from emps
group by deptno, salary
-- simplified
select deptno, salary, salary as expr, min(commission) from emps group by
deptno, salary{noformat}
It should be simplified, but I didn't find any rule to simplify it.
This issue is related to
[CALCITE-4857|https://issues.apache.org/jira/browse/CALCITE-4857]
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
