db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4068) Numeric arguments to functions/parameters raise overflow condition in client/server configuration.
Date Sat, 04 Jul 2009 23:40:47 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-4068:
--------------------------------------

    Attachment: ScaleAndPrecision.java

The underlying issue appears to be that ResultSetMetadata (in the embedded driver) reports
that both precision and scale for the return value are 31, whereas they are 7 and 2, respectively.
This confuses the network server since scale==precision means that all the numbers are to
the right of the decimal point, which is not the case for the returned value 12345.67. It
correctly concludes that the value doesn't fit into a NUMERIC(31,31) column and raises an
overflow error.

Attached is a small program that shows that the precision and the scale for a function declared
to return a NUMERIC(7,2) value are reported to be 31.

> Numeric arguments to functions/parameters raise overflow condition in client/server configuration.
> --------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4068
>                 URL: https://issues.apache.org/jira/browse/DERBY-4068
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Server
>            Reporter: Rick Hillegas
>         Attachments: ScaleAndPrecision.java
>
>
> The test_numeric_BigDecimal_BigDecimal() and test_decimal_BigDecimal_BigDecimal() test
cases in AnsiSignaturesTest raise overflow errors when run in client/server mode.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message