[
https://issues.apache.org/jira/browse/HAWQ-427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
zhenglin tao resolved HAWQ-427.
-------------------------------
Resolution: Fixed
Assignee: zhenglin tao (was: Lei Chang)
Fix Version/s: 2.0.0
> 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: zhenglin tao
> Fix For: 2.0.0
>
>
> 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)
