zhenglin tao created HAWQ-427:
---------------------------------
Summary: Wrong results in mdqa+rollup
Key: HAWQ-427
URL: https://issues.apache.org/jira/browse/HAWQ-427
Project: Apache HAWQ
Issue Type: Bug
Components: Core
Reporter: zhenglin tao
Assignee: Lei Chang
Reproduce steps:
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 randomly;
insert into sale values ( 4, 40, 800, '1401-6-1', 1, 1);
select MAX(DISTINCT sale.vn),MAX(DISTINCT sale.prc) FROM sale GROUP BY
(sale.prc),ROLLUP(sale.prc);
No results is returned.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
