Florian Steffen (mailing-list@urbanet.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);
CREATE
> 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