Thread

Re: [BUGS] General Bug Report: Error parsing negative numbers

Oleg Bartunov <oleg@sai.msu.su> — 1999-06-21T08:42:17Z

Just tried on my Linux 2.0.37, latest 6.5 cvs, compiled by egcs

test=> select -0.123456789012345;
          ?column?
------------------
-0.123456789012345(1 row)

test=> select version();
version                                                                 
------------------------------------------------------------------------
PostgreSQL 6.5.0 on i686-pc-linux-gnulibc1, compiled by gcc egcs-2.91.66
(1 row)


	Regards.
		
		Oleg


On Mon, 21 Jun 1999, Unprivileged user wrote:

> Date: Mon, 21 Jun 1999 03:49:00 -0400 (EDT)
> From: Unprivileged user <nobody@hub.org>
> Reply-To: "Sverre H. Huseby" <shh@computas.no>
> To: pgsql-bugs@postgreSQL.org
> Subject: [BUGS] General Bug Report: Error parsing negative numbers
> 
> 
> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
> 
> 
> Your name               : Sverre H. Huseby
> Your email address      : shh@computas.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.
> 
> --------------------------------------------------------------------------
> 
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83