Re: BUG #1528: Rows returned that should be excluded by WHERE clause

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #1528: Rows returned that should be excluded by WHERE clause
Дата
Msg-id 26929.1110498587@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #1528: Rows returned that should be excluded by WHERE clause  ("Peter Wright" <pete@flooble.net>)
Список pgsql-bugs
"Peter Wright" <pete@flooble.net> writes:
> I think this demonstrates the problem much better than I could explain in
> words. The bug is shown in the two
> SELECT queries with a WHERE clause. Very bizarre.

I've applied a patch that corrects this problem in CVS HEAD, but since
it changes the behavior of HAVING in a nontrivial way, I'm inclined to
think that we should not backpatch it into existing release branches.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] We are not following the spec for HAVING without GROUP BY
Следующее
От: John R Pierce
Дата:
Сообщение: Re: We are not following the spec for HAVING without GROUP