Re: BUG #15604: NOT IN condition incorrectly returns False

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: sergey(at)romanovsky(dot)org, Zhijiang Li <zl256(at)cornell(dot)edu>
Subject: Re: BUG #15604: NOT IN condition incorrectly returns False
Date: 2019-01-23 06:59:36
Message-ID: 87bm473ln6.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Andrew" == Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:

Andrew> The condition 1 NOT IN (2,NULL) is equivalent to (1=2) OR
Andrew> (1=NULL),

I mean NOT ((1=2) OR (1=NULL)) of course, but NOT (NULL) is still NULL.

--
Andrew (irc:RhodiumToad)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-01-23 08:57:43 BUG #15605: Unstable regression test "tablespace"
Previous Message Andrew Gierth 2019-01-23 06:57:36 Re: BUG #15604: NOT IN condition incorrectly returns False