DECIMAL NULL value

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: DECIMAL NULL value
Date: 2001-04-30 01:52:05
Message-ID: 200104300152.f3U1q5p23191@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Xavier Bergade (xavierb(at)benon(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2001-04-30 02:29:57 Re: DECIMAL NULL value
Previous Message Nick Gazaloff 2001-04-29 15:45:20