[CALCITE-4726] Add support for filters in AggregateExpandWithinDistinctRule

• Type: Improvement
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 1.28.0
• Labels: pull-request-available
• Assignee: Will Noble
• Reporter: Will Noble
• Created: 11/Aug/21 18:26
• Updated: 20/Oct/21 05:24
• Resolved: 04/Sep/21 00:31

Description

Currently, AggregateExpandWithinDistinctRule does not fire if any of the aggregate calls in the aggregate have a filter. We should support filters.

For example, the following query will not be handled by the current rule due to the FILTER clause:

SELECT deptno,
    SUM(sal),
    SUM(sal) WITHIN DISTINCT (job) FILTER (WHERE ename LIKE 'A%')
FROM emp
GROUP BY deptno

Issue Links

• links to: GitHub Pull Request #2483