[
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.
