[FLINK-8355] DataSet Should not union a NULL row for AGG without GROUP BY clause.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: 1.4.1, 1.5.0
• Component/s: Table SQL / API
• Assignee: sunjincheng
• Reporter: sunjincheng
• Created: 03/Jan/18 14:38
• Updated: 19/Jan/18 22:14
• Resolved: 19/Jan/18 22:14

Description

Currently DataSetAggregateWithNullValuesRule will UINON a NULL row for non grouped aggregate query. when CountAggFunction support COUNT(FLINK-8325). the result will incorrect.
for example, if Tabble T1 has 3 records. when we run the follow SQL in DataSet:

SELECT COUNT(*) as cnt from Tab // cnt = 4(incorrect).

Issue Links

• is blocked by: FLINK-8325 Add COUNT AGG support constant parameter, i.e. COUNT(*), COUNT(1)
• links to: GitHub Pull Request #5320