ORDER/GROUP BY expression not found in targetlist

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: ORDER/GROUP BY expression not found in targetlist
Date: 2016-05-26 02:12:35
Message-ID: 20160526021235.w4nq7k3gnheg7vit@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

trying to reproduce a performance problem I just found:

=# CREATE TABLE twocol(col01 int, col02 int);
=# SELECT DISTINCT col01, col02, col01 FROM twocol ;
ERROR: XX000: ORDER/GROUP BY expression not found in targetlist
LOCATION: get_sortgroupref_tle, tlist.c:341

which appears to be a 9.6 regression, presumable fallout from the path
restructuring.

Greetings,

Andres Freund

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2016-05-26 02:57:11 Re: ORDER/GROUP BY expression not found in targetlist
Previous Message Kyotaro HORIGUCHI 2016-05-26 01:57:01 Re: Parallel pg_dump's error reporting doesn't work worth squat