BUG #4021: UUID NULL and not equal query failed

From: "Yann ROBIN" <yann(dot)robin(at)withart(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4021: UUID NULL and not equal query failed
Date: 2008-03-09 11:57:01
Message-ID: 200803091157.m29Bv1em003352@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4021
Logged by: Yann ROBIN
Email address: yann(dot)robin(at)withart(dot)fr
PostgreSQL version: 8.3.0 build 140
Operating system: Windows XP SP2
Description: UUID NULL and not equal query failed
Details:

Hi,

I've tried to do a not like query on a UUID field and the row that i'd like
to get has a NULL value for the UUID field, it gives me no result. The
request :

SELECT *
FROM t_account
WHERE Update_Timestamp > '2008-03-09 12:35:10.309000' AND Update_Timestamp
<= '2008-03-09 12:35:37.861000' AND Update_Id !=
'48012851-3aa4-9940-9ab4-b8333da6b45b'

0 result.

The same request without the Update_Id condition :

SELECT *
FROM t_account
WHERE Update_Timestamp > '2008-03-09 12:35:10.309000' AND Update_Timestamp
<= '2008-03-09 12:35:37.861000'

1 result. The Update_Id field is null.

The same request but with a OR IS NULL condition :

SELECT *
FROM t_account
WHERE Update_Timestamp > '2008-03-09 12:35:10.309000' AND Update_Timestamp
<= '2008-03-09 12:35:37.861000'
AND (Update_Id != '48012851-3aa4-9940-9ab4-b8333da6b45b' OR Update_Id IS
NULL)

1 result.

So my conclusion is that the NOT EQUAL operator doesn't match how it should
the NULL value field.
Is it a bug or a wanted behavior ?

--
Yann

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Yann ROBIN 2008-03-09 12:20:39 Re: BUG #3986: Error ts_vector with UTF8 WS2003
Previous Message Alvaro Herrera 2008-03-07 21:43:32 Re: BUG #4020: RFE: have way to log autovacuum activity