[jira] [Commented] (DERBY-3398) Support min/max values for Java types float/double in real/double columns

["Knut Anders Hatlen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-3398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13572452#comment-13572452 ] 

Knut Anders Hatlen commented on DERBY-3398:
-------------------------------------------

Thanks, Dag. I think this is a useful improvement.

Some ideas for more tests:

- Use the extreme values in some additional contexts. For example in arithmetic operations and as literals.

- What happens if a previously not allowed value is stored in a soft-upgraded database and then later attempted read after downgrade?

- The patch has test cases for MIN_VALUE and MAX_VALUE. Should probably also test for +/- MIN_NORMAL, which used to be out of range, but should be supported now.
                
> Support min/max values for Java types float/double in real/double columns
> -------------------------------------------------------------------------
>
>                 Key: DERBY-3398
>                 URL: https://issues.apache.org/jira/browse/DERBY-3398
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.4.1.3
>            Reporter: Knut Anders Hatlen
>            Priority: Minor
>              Labels: derby_triage10_10
>         Attachments: derby-3398.diff, derby-3398.status
>
>
> Derby doesn't support the entire range of valid (finite) values of the Java primitive types double/float in columns with SQL type DOUBLE or REAL. This appears to be a limitation that was introduced for compatibility with DB2. There have been some requests on derby-user that we lift this restriction.
> The restriction is enforced by the methods normalizeREAL() and normalizeDOUBLE() in org.apache.derby.iapi.types.NumberDataType.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira