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

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2001-04-30 02:29:57
Subject: Re: DECIMAL NULL value
Previous:From: Nick GazaloffDate: 2001-04-29 15:45:20
Subject:

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