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)