DECIMAL NULL value - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject DECIMAL NULL value
Date
Msg-id 200104300152.f3U1q5p23191@hub.org
Whole thread Raw
Responses Re: DECIMAL NULL value
List pgsql-bugs
Xavier Bergade (xavierb@benon.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
DECIMAL NULL value

Long Description
Version: 7.0.3
Platform: Intel 586, 512 megs RAM

CREATE TABLE test (price DECIMAL(9,2));
INSERT INTO test VALUES ('NULL');

Will crash the backend, anytime.

It should come with a message:
ERROR:  Bad numeric input format 'NULL'

Anything instead of 'NULL' will correctly report the error without crashing.

Sample Code
CREATE TABLE test (price DECIMAL(9,2));
INSERT INTO test VALUES ('NULL');


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Peter Mount
Date:
Subject: Re:
Next
From: Bruce Momjian
Date:
Subject: Re: DECIMAL NULL value