[
https://issues.apache.org/jira/browse/HAWQ-485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
zhenglin tao resolved HAWQ-485.
-------------------------------
Resolution: Fixed
Assignee: zhenglin tao (was: Lei Chang)
Fix Version/s: 2.0.0
> Wrong results in rollup with plan_append_aggs_with_rewrite
> ----------------------------------------------------------
>
> Key: HAWQ-485
> URL: https://issues.apache.org/jira/browse/HAWQ-485
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Core
> Reporter: zhenglin tao
> Assignee: zhenglin tao
> Fix For: 2.0.0
>
>
> create table vendor
> (
> vn int not null,
> vname text not null,
> vloc text
> ) WITH (appendonly=true, orientation = parquet) distributed by (vn);
> create table sale
> (
> cn int not null,
> vn int not null,
> pn int not null,
> dt date not null,
> qty int not null,
> prc float not null
> ) WITH (appendonly=true, orientation = parquet) distributed by (cn,vn,pn);
> insert into vendor values
> ( 10, 'Witches, Inc', 'Lonely Heath'),
> ( 20, 'Lady Macbeth', 'Inverness'),
> ( 30, 'Duncan', 'Forres'),
> ( 40, 'Macbeth', 'Inverness'),
> ( 50, 'Macduff', 'Fife');
> insert into sale values
> ( 2, 40, 100, '1401-1-1', 1100, 2400),
> ( 1, 10, 200, '1401-3-1', 1, 0),
> ( 3, 40, 200, '1401-4-1', 1, 0),
> ( 1, 20, 100, '1401-5-1', 1, 0),
> ( 1, 30, 300, '1401-5-2', 1, 0),
> ( 1, 50, 400, '1401-6-1', 1, 0),
> ( 2, 50, 400, '1401-6-1', 1, 0),
> ( 1, 30, 500, '1401-6-1', 12, 5),
> ( 3, 30, 500, '1401-6-1', 12, 5),
> ( 3, 30, 600, '1401-6-1', 12, 5),
> ( 4, 40, 700, '1401-6-1', 1, 1),
> ( 4, 40, 800, '1401-6-1', 1, 1);
> SELECT CASE WHEN sale.qty < 10 THEN 1 ELSE 2 END as newalias2,CASE WHEN
> sale.qty < 10 THEN 1 ELSE 2 END as newalias4, COUNT(DISTINCT sale.qty)
> FROM sale,vendor
> WHERE sale.vn=vendor.vn
> GROUP BY ROLLUP((newalias2,newalias2),(newalias4,newalias4)),sale.qty,sale.vn;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
