[FLINK-15466] `FlinkAggregateExpandDistinctAggregatesRule` generates wrong plan for cases that have distinct aggs with filter.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.3, 1.9.1
• Fix Version/s: 1.10.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Shuo Cheng
• Reporter: Shuo Cheng
• Created: 03/Jan/20 06:22
• Updated: 09/Jan/20 09:08
• Resolved: 09/Jan/20 09:08

Description

For the sql in batch mode,

 

SELECT 
   a, COUNT(a), SUM(DISTINCT b) FILTER (WHERE a > 0)
FROM MyTable 
GROUP BY a

 

plan generated after logical stage is as following, which is not correct. The `Filter $4` should be `$f2 and $g_0`.

Issue Links

• links to: GitHub Pull Request #10760