db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (DERBY-3398) Support min/max values for Java types float/double in real/double columns
Date Tue, 19 Feb 2013 06:15:15 GMT

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

Dag H. Wanvik edited comment on DERBY-3398 at 2/19/13 6:14 AM:
---------------------------------------------------------------

Uploading patch #7 after rerunning regressions and finding issues.

It changes the metadata maximum display size for REAL and DOUBLE to 15 and 24, from 13 and
22 respectively, since some values were truncated by ij.

The patch adds many canon changes, and also disables the ResultSet#updateXXX part of the Changes10_10
test for pre-10.2 releases since they do not support forward updatable result sets.

The regressions ran ok with these changes modulo an error in derbynet/DerbyNetAutoStart.java,
but I see that on trunk as well.

                
      was (Author: dagw):
    Uploading patch #7 after rerunning regressions and finding issues.

It changes the metadata maximum display size for REAL and DOUBLE to 15 and 24, from 13 and
22 respectively, since some values were truncated by
ij.

The patch adds many canon changes, and also disables the ResultSet#updateXXX part of the Changes10_10
test for pre-10.2 releases since they do no support forward updatable result sets.

The regressions ran ok with these changes modulo an error in derbynet/DerbyNetAutoStart.java,
but I see that on trunk as well.

                  
> 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
>            Assignee: Dag H. Wanvik
>            Priority: Minor
>              Labels: derby_triage10_10
>         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.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

Mime
View raw message