[CALCITE-5000] Expand rule of `AGGREGATE_REDUCE_FUNCTIONS`, when arg of agg-call is in the aggregate's group

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.31.0
• Labels: pull-request-available
• Assignee: Xurenhe
• Reporter: Xurenhe
• Created: 07/Feb/22 08:12
• Updated: 03/Aug/22 16:21
• Resolved: 15/Apr/22 03:53

Description

Using calcite's SubstitutionVisitor, we need do a lot work about canonicalizing relnode.

Some sql should be simplified.

-- 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

It should be simplified, but I didn't find any rule to simplify it.

This issue is related to CALCITE-4857

Issue Links

• links to: GitHub Pull Request #2714