Skip site navigation (1) Skip section navigation (2)

Bug #638: Buggy select statment with numeric

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #638: Buggy select statment with numeric
Date: 2002-04-22 12:21:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Florian Steffen (mailing-list(at)urbanet(dot)ch) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Buggy select statment with numeric

Long Description
A select statement with a where clause on a numeric column tested 
for equality against null always return empty result. With ISNULL 
everything is fine, but not with the = operator. 

This has been tested on versions 7.1.3 and 7.2.

Sample Code
> create table t (n NUMERIC(39), s TEXT);
> insert into t values (NULL, 'asdasdasd');
INSERT 35860 1
> insert into t values (NULL, 'qqqqqqqqqqqq');
INSERT 35861 1
> select * from t where n ISNULL;
 n |      s
   | asdasdasd
   | qqqqqqqqqqqq
(2 rows)

> select * from t where n=NULL;
 n | s
(0 rows)

No file was uploaded with this report


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-04-22 12:28:02
Subject: Bug #639: JDBC interface, ResultSet.getObject on with an array of char is crashing.
Previous:From: Gerhard HäringDate: 2002-04-22 06:21:30
Subject: Re: Escaping of special characters in ARRAYs is broken

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group