[jira] Commented: (DERBY-4068) Numeric arguments to functions/parameters raise overflow condition in client/server configuration.

["Witold Szczerba (JIRA)" <ji...@apache.org>]

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