[jira] [Resolved] (HAWQ-442) Wrong results in rollup which contains the same expr targetlist

["zhenglin tao (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

zhenglin tao resolved HAWQ-442.
-------------------------------
       Resolution: Fixed
    Fix Version/s: 2.0.0

> Wrong results in rollup which contains the same expr targetlist
> ---------------------------------------------------------------
>
>                 Key: HAWQ-442
>                 URL: https://issues.apache.org/jira/browse/HAWQ-442
>             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 by (cn,vn,pn);
> insert into sale values
> ( 2, 40, 100, '1401-1-1', 1100, 2400);
> taoz=# SELECT sale.qty as newalias1,sale.qty as newalias2 FROM sale GROUP BY ROLLUP(newalias2,newalias1);
> newalias1 | newalias2
> -----------+-----------
> 1100 | 1100
> 1100 | 1100
> |
> (3 rows)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)