You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hawq.apache.org by "zhenglin tao (JIRA)" <ji...@apache.org> on 2016/02/21 13:16:18 UTC

[jira] [Created] (HAWQ-427) Wrong results in mdqa+rollup

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)