General Bug Report: Error parsing negative numbers
От | Unprivileged user |
---|---|
Тема | General Bug Report: Error parsing negative numbers |
Дата | |
Msg-id | 199906210749.DAA90538@hub.org обсуждение исходный текст |
Ответы |
Re: [BUGS] General Bug Report: Error parsing negative numbers
|
Список | pgsql-bugs |
============================================================================ 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. --------------------------------------------------------------------------
В списке pgsql-bugs по дате отправления: