Re: Wrong result with constant quals

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Wrong result with constant quals
Дата
Msg-id 2198598.1667520868@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Wrong result with constant quals  (Vik Fearing <vik@postgresfriends.org>)
Ответы Re: Wrong result with constant quals
Список pgsql-bugs
Vik Fearing <vik@postgresfriends.org> writes:
> I allowed for this by saying it could be a single group with no rows if 
> you preferred to look at it that way.

That is exactly what the standard says.

> This does not explain why the WHERE FALSE is being ignored and producing 
> rows.

It's not ignored, but it applies to the pre-grouping rows, of which
there aren't any to remove.  But there's still a group.

            regards, tom lane



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

Предыдущее
От: Pantelis Theodosiou
Дата:
Сообщение: Re: Wrong result with constant quals
Следующее
От: Vik Fearing
Дата:
Сообщение: Re: Wrong result with constant quals