[DRILL-791] Using two aggregate functions in a query causes wrong results.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Query Planning & Optimization
• Assignee: DrillCommitter
• Reporter: Mehant Baid
• Created: 20/May/14 20:10
• Updated: 12/Jun/14 16:36
• Resolved: 12/Jun/14 16:36

Description

select min(employee_id), max(employee_id) from cp.`employee.json`;
----------------------+

EXPR$0

EXPR$1

----------------------+

1

1

----------------------+

In the above query we return the same result for both Min and Max. This seems to be related to multi phase aggregate not picking the correct ordinal.