Re: BUG: IS NOT NULL on RECORD variable fails in 17.5-dev

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG: IS NOT NULL on RECORD variable fails in 17.5-dev
Дата
Msg-id CAKFQuwaDxSDPKVF1bTxC2-CrF0MVi=x1yEhJA3RfAgkKt1mK6Q@mail.gmail.com
обсуждение исходный текст
Ответ на BUG: IS NOT NULL on RECORD variable fails in 17.5-dev  (Peter Praxmarer <ppraxmarer@gmail.com>)
Ответы Re: BUG: IS NOT NULL on RECORD variable fails in 17.5-dev
Список pgsql-bugs
On Thu, Aug 7, 2025 at 12:44 PM Peter Praxmarer <ppraxmarer@gmail.com> wrote:

I have discovered what appears to be a severe bug in a development version of PostgreSQL 17 where a populated RECORD variable incorrectly fails an IS NOT NULL check. 


Working as documented.  You probably want to test:  NOT (r IS NULL)


If the expression is row-valued, then IS NULL is true when the row expression itself is null or when all the row's fields are null, while IS NOT NULL is true when the row expression itself is non-null and all the row's fields are non-null.

David J.

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