Thread

1. DECIMAL NULL value

   PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-04-30T01:52:05Z

   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
   
   
   

2. Re: DECIMAL NULL value

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-04-30T02:29:57Z

   With 7.1 I get:
   	
   	test=> CREATE TABLE test (price DECIMAL(9,2));
   	CREATE
   	test=> INSERT INTO test VALUES ('NULL');
   	ERROR:  Bad numeric input format 'NULL'
   
   > 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
   > 
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
   > 
   
   -- 
     Bruce Momjian                        |  http://candle.pha.pa.us
     pgman@candle.pha.pa.us               |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026