Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Tatsuhito Kasahara" <kasahara(dot)tatsuhito(at)oss(dot)ntt(dot)co(dot)jp>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).
- Date: Tue, 01 Apr 2008 10:34:27 -0400
- Message-id: <1869(dot)1207060467(at)sss(dot)pgh(dot)pa(dot)us>
"Tatsuhito Kasahara" <kasahara(dot)tatsuhito(at)oss(dot)ntt(dot)co(dot)jp> writes: > PostgreSQL version: 8.1.11 > Description: "IS NOT NULL (IS NULL)" return wrong answer even where > all fields are NULL(or NOT NULL). > I think following fix is related.. > http://archives.postgresql.org/pgsql-committers/2006-09/msg00439.php Yup, it is. Why are you reporting this? regards, tom lane
- Follow-Ups:
- References:
- BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).
- From: Tatsuhito Kasahara
- BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).
- Prev by Date: BUG #4081: Running Postgres as Windows service vs regular applications
- Next by Date: BUG #4082: Fatal error, close server
- Previous by thread: BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).
- Next by thread: Re: BUG #4076: "IS NOT NULL (IS NULL)" return wrong answer even where all fields are NULL(or NOT NULL).
- Indexes: