[jira] [Resolved] (HAWQ-428) ORDER/GROUP BY not found in target list error found in olap query

["Ivan Weng (JIRA)" <ji...@apache.org>]

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

Ivan Weng resolved HAWQ-428.
----------------------------
       Resolution: Fixed
    Fix Version/s: 2.0.0

> ORDER/GROUP BY not found in target list error found in olap query
> -----------------------------------------------------------------
>
>                 Key: HAWQ-428
>                 URL: https://issues.apache.org/jira/browse/HAWQ-428
>             Project: Apache HAWQ
>          Issue Type: Bug
>            Reporter: Ivan Weng
>            Assignee: Lei Chang
>             Fix For: 2.0.0
>
>
> create table r(a int, b int);
> CREATE TABLE
> insert into r values (1,1),(2,2);
> INSERT 0 2
> select grouping(a) from r group by rollup(a) order by 1;
> psql:/data/gpadmin/pulse2-agent/agents/agent1/work/HAWQ-feature-mn-hawq2.0-taoz-parquet/tinctest_query/cdbunit/tincrepo/mpp/hawq/tests/query/olap_group/parquestoutput/mpp20377.sql:10: ERROR:  ORDER/GROUP BY expression not found in targetlist (tlist.c:205)
> The case need to revert to 
> --start_ignore
> drop table if exists r;
> --end_ignore
> create table r(a int, b int);
> insert into r values (1,1),(2,2);
> select grouping(a) from r group by rollup(a) order by 1;
> ~                                                               



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