[ https://issues.apache.org/jira/browse/HAWQ-428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ivan Weng closed HAWQ-428. -------------------------- > 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)