[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Haisheng Yuan updated CALCITE-4726: ----------------------------------- Comment: was deleted (was: Fixed in [https://github.com/apache/calcite/commit/8a1535f94aad1e0ce77797eb84d75b4a5b1692c1,] thanks for the PR.) > Add support for filters in AggregateExpandWithinDistinctRule > ------------------------------------------------------------ > > Key: CALCITE-4726 > URL: https://issues.apache.org/jira/browse/CALCITE-4726 > Project: Calcite > Issue Type: Improvement > Reporter: Will Noble > Assignee: Will Noble > Priority: Blocker > > 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: > {code:java} > SELECT deptno, > SUM(sal), > SUM(sal) WITHIN DISTINCT (job) FILTER (WHERE ename LIKE 'A%') > FROM emp > GROUP BY deptno > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)