Re: LEFT OUTER JOIN sub-SELECT produces a column != NULL when all NULLs are expected

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: LEFT OUTER JOIN sub-SELECT produces a column != NULL when all NULLs are expected
Дата
Msg-id 24750.1285698255@sss.pgh.pa.us
обсуждение исходный текст
Ответ на LEFT OUTER JOIN sub-SELECT produces a column != NULL when all NULLs are expected  (Kirill Simonov <xi@resolvent.net>)
Список pgsql-bugs
Дерево обсуждения 
Kirill Simonov <xi@resolvent.net> writes:
> I found a bug where a column from a LEFT OUTER JOIN sub-SELECT is not
> equal to NULL when the whole row must be NULL because the join condition
> is not satisfied.

I've applied a patch for this; it'll be in next week's update releases.
Thanks for the report!

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unexpected omission of tables with duplicate names across schemas
Следующее
От: "Maksym Boguk"
Дата:
Сообщение: BUG #5681: Using set returning function as subrequest can result losing rows in result set