Ivan Weng created HAWQ-428:
------------------------------
Summary: 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
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)
