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