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.
Buggy select statment with numeric
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.
> 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
> select * from t where n=NULL;
n | s
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 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äring||Date: 2002-04-22 06:21:30|
|Subject: Re: Escaping of special characters in ARRAYs is broken|