Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: LEFT OUTER JOIN sub-SELECT produces a column != NULL when all NULLs are expected
Date
Msg-id 24750.1285698255@sss.pgh.pa.us
Whole thread Raw
In response to LEFT OUTER JOIN sub-SELECT produces a column != NULL when all NULLs are expected  (Kirill Simonov <xi@resolvent.net>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unexpected omission of tables with duplicate names across schemas
Next
From: "Maksym Boguk"
Date:
Subject: BUG #5681: Using set returning function as subrequest can result losing rows in result set