[TAJO-2082] Aggregation on a derived table which includes union can cause incorrect result

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.11.0, 0.11.1
• Fix Version/s: 0.12.0, 0.11.2
• Component/s: distributed query plan
• Assignee: Jihoon Son
• Reporter: Jihoon Son
• Created: 25/Feb/16 08:05
• Updated: 04/Mar/16 08:01
• Resolved: 04/Mar/16 07:15

Description

This problem can be reproduced by running the following query on 10GB TPC-H data set.

select 
  sum(t.cnt) as cnt, o_orderkey, o_custkey 
from 
  (
    select 
      o_orderkey, o_custkey, CAST(COUNT(1) AS INT4) as cnt 
    from 
      orders 
    group by 
      o_orderkey, o_custkey 
    union all 
    select 
      o_orderkey, o_custkey, o_shippriority 
    from 
      orders
  ) as t 
group by 
  o_orderkey, o_custkey