db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Witold Szczerba (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4068) Numeric arguments to functions/parameters raise overflow condition in client/server configuration.
Date Thu, 07 Jan 2010 15:10:54 GMT

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


Mime
View raw message