ORDER/GROUP BY expression not found in targetlist

Поиск
Список
Период
Сортировка
От Andres Freund
Тема ORDER/GROUP BY expression not found in targetlist
Дата
Msg-id 20160526021235.w4nq7k3gnheg7vit@alap3.anarazel.de
обсуждение исходный текст
Ответы Re: ORDER/GROUP BY expression not found in targetlist  (Peter Geoghegan <pg@heroku.com>)
Re: ORDER/GROUP BY expression not found in targetlist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: Parallel pg_dump's error reporting doesn't work worth squat
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: ORDER/GROUP BY expression not found in targetlist