db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-3398) Support min/max values for Java types float/double in real/double columns
Date Wed, 20 Feb 2013 16:17:13 GMT

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

Knut Anders Hatlen commented on DERBY-3398:

Hi Kim,

Yes, those limits need to be updated. New values are:

Smallest DOUBLE: 4.9e-324 (aka Double.MIN_VALUE)
Largest DOUBLE: 1.7976931348623157e+308 (aka Double.MAX_VALUE)
Smallest positive DOUBLE: 2.2250738585072014E-308 (aka Double.MIN_NORMAL)
Largest negative DOUBLE: -2.2250738585072014E-308
Smallest REAL: 1.4e-45 (aka Float.MIN_VALUE)
Largest REAL: 3.4028235e+38 (aka Float.MAX_VALUE)
Smallest positive REAL: 1.17549435E-38 (aka Float.MIN_NORMAL)
Largest negative REAL: -1.17549435E-38
> 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:
>            Reporter: Knut Anders Hatlen
>            Assignee: Dag H. Wanvik
>            Priority: Minor
>              Labels: derby_triage10_10
>             Fix For:
>         Attachments: derby-3398-2.diff, derby-3398-3.diff, derby-3398-3.stat, derby-3398-4.diff,
derby-3398-5.diff, derby-3398-5.stat, derby-3398-7.diff, derby-3398-7.stat, derby-3398-8.diff,
derby-3398.diff, derby-3398.status, releaseNote.html, releaseNote.html
> 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

View raw message