[
https://issues.apache.org/jira/browse/DERBY-4068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797647#action_12797647
]
Witold Szczerba commented on DERBY-4068:
----------------------------------------
I have exactly the same issue, my function returns BigDecimal, it is declared
as DECIMAL(12,2) and Derby throws:
Error code -1, SQL state 22003: Overflow occurred during numeric data type
conversion of "123.45".
This is a big issue, the only workaround is to return Strings and wrap them in
application logic (ugly!) or BigDecimal.movePointRight(2) and return integers,
but again - dirty tricks across application are required.
Can you consider raising the urgency of the issue?
> 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: JDBC, 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.
