[
https://issues.apache.org/jira/browse/HAWQ-428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15156348#comment-15156348
]
ASF GitHub Bot commented on HAWQ-428:
-------------------------------------
Github user zhangh43 commented on a diff in the pull request:
https://github.com/apache/incubator-hawq/pull/364#discussion_r53578942
--- Diff: src/backend/optimizer/plan/plangroupext.c ---
@@ -1867,7 +1867,12 @@ convert_gs_to_rollups(AttrNumber *grpColIdx,
* resno.
*/
sc.tleSortGroupRef = no+1;
- tle = get_sortgroupclause_tle(&sc, tlist);
+ tle = get_sortgroupclause_tle_internal(&sc, tlist);
--- End diff --
neet to format here
> 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)
