[ https://issues.apache.org/jira/browse/CALCITE-4726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Julian Hyde resolved CALCITE-4726. ---------------------------------- Fix Version/s: 1.28.0 Resolution: Fixed Fixed in [8c462997|https://github.com/apache/calcite/commit/8c4629974815a5e919618375aa380c985047d256]; thanks for the PR, [~wnoble]! > 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 > Labels: pull-request-available > Fix For: 1.28.0 > > Time Spent: 10m > Remaining Estimate: 0h > > 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)