Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...
Дата
Msg-id 2151.1004472304@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Odd error in complex query (7.2): Sub-SELECT uses un-GROUPed...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Okay, I'm convinced: the problem is that the test for ungrouped vars
> used inside subselects is too simplistic.

Not only was that true, but the handling of GROUP BY expressions was
pretty grotty in general: they'd be re-evaluated at multiple levels of
the resulting plan tree.  Which is not too bad for "GROUP BY a+b",
but it's unpleasant when a complex subselect is involved.

I've committed fixes to CVS.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: timetz regression test is showing several DST-related failures
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Performance problems???