From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | General Bug Report: Error parsing negative numbers |
Date: | 1999-06-21 07:49:00 |
Message-ID: | 199906210749.DAA90538@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Sverre H. Huseby
Your email address : shh(at)computas(dot)no
Category : unknown
Severity : serious
Summary: Error parsing negative numbers
System Configuration
--------------------
Operating System : Linux, Solaris
PostgreSQL version : 6.5
Compiler used : egcs (Linux), gcc (Solaris)
Hardware:
---------
2.0.34, pentium
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
Negative numbers with more than a certain number og
digits produce an error message when being parsed.
Didn't see this problem on 6.4.x.
--------------------------------------------------------------------------
Test Case:
----------
wox=> select -0.123456789012345;
?column?
------------------
-0.123456789012345
(1 row)
wox=> select -0.1234567890123456;
ERROR: Unable to convert left operator '-' from type 'unknown'
--------------------------------------------------------------------------
Solution:
---------
I flagged this as serious, as applications that worked
before may stop working (as happened for me). The temporary
solution is to rewrite applications to limit the number
of digits sent to PostgreSQL.
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 1999-06-21 08:42:17 | Re: [BUGS] General Bug Report: Error parsing negative numbers |
Previous Message | Gianni Mariani | 1999-06-21 05:57:36 | Disregard bug on distinct and limit regression test failures |