[DRILL-1342] Aggregate functions produce wrong results when operating on null values

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.5.0
• Component/s: Execution - Codegen
• Assignee: Aman Sinha
• Reporter: Aman Sinha
• Created: 26/Aug/14 18:49
• Updated: 31/Aug/14 17:40
• Resolved: 31/Aug/14 17:40

Description

If all input values are null, we are producing wrong results for certain aggregate functions. This shows up with the following query on TPC-DS:

select  sum(wr_return_quantity), min(wr_return_quantity) from web_returns where wr_return_quantity is null;