============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Geoffrey Reedy
Your email address : vader21@imsa.edu
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium III
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.14 ELF SMP
PostgreSQL version (example: PostgreSQL-7.1.1): PostgreSQL-7.1.2
Compiler used (example: gcc 2.95.2) : unknown (binary RPM)
Please enter a FULL description of your problem:
------------------------------------------------
The money type fails at the roll-over value of 21474836.48 (2^31). On either
side of 21474836.48 (2^31) the money evaluates to the expected result
(+- 21474836.47). Calling some functions with this problematic monetary
value causes the backend to exit unexpectedly.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
vader21=> select (money '21474836.47');
?column?
----------------
$21,474,836.47
(1 row)
vader21=> select (money '21474836.49');
?column?
-----------------
-$21,474,836.47
(1 row)
vader21=> select (money '21474836.48');
?column?
-----------------
-$./,,),,(-*.,(
(1 row)
vader21=> select cash_words(money '21474836.48');
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Probably just a bounds check in src/backend/utils/adt/cash.c needs to be
added. I could probably whip up a patch, but don't have time to do that
right now. Perhaps in the next few days I will be able to do that.
--
Geoffrey Reedy vader21@imsa.edu