Re: 7.4 aggregate OR TRUE yields strange results

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.4 aggregate OR TRUE yields strange results
Дата
Msg-id 4786.1076709773@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 7.4 aggregate OR TRUE yields strange results  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Список pgsql-bugs
"SZŰCS Gábor" <surrano@mailbox.hu> writes:
> SELECT count(*)<0 OR TRUE FROM mytable WHERE condition
> dumps the whole tuples meeting the condition.

Wow, that's bizarre.  The "x OR TRUE" expression will get simplified to
just TRUE, so that COUNT isn't really there at all, but that shouldn't
change the query semantics.  And it seems to work correctly in 7.3.*
and before.  Looking into it ...
        regards, tom lane


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

Предыдущее
От: "SZŰCS Gábor"
Дата:
Сообщение: 7.4 aggregate OR TRUE yields strange results
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.4 aggregate OR TRUE yields strange results