General Bug Report: Error parsing negative numbers

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.

--------------------------------------------------------------------------

Responses

Browse pgsql-bugs by date

  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