Re: ORDER/GROUP BY expression not found in targetlist

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: ORDER/GROUP BY expression not found in targetlist
Дата
Msg-id CAM3SWZRJu4Csxu4yU-q0HEQcjoNaM6xk1=QsaER7xny-pNtSvg@mail.gmail.com
обсуждение исходный текст
Ответ на ORDER/GROUP BY expression not found in targetlist  (Andres Freund <andres@anarazel.de>)
Ответы Re: ORDER/GROUP BY expression not found in targetlist  (Andreas Seltenreich <seltenreich@gmx.de>)
Список pgsql-hackers
Дерево обсуждения 
On Wed, May 25, 2016 at 7:12 PM, Andres Freund <andres@anarazel.de> wrote:
>
> =# 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.

It's surprising that SQL Smith didn't catch something with such simple
steps to reproduce.


-- 
Peter Geoghegan

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: ORDER/GROUP BY expression not found in targetlist
Следующее
От: Noah Misch
Дата:
Сообщение: Re: statistics for shared catalogs not updated when autovacuum is off