[
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 5:59 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 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.
was (Author: dagw):
Uploading patch #7 after rerunning regressions and finding issues.
It adds more canon changes, changes the database metadata in the client driver
to also use 15 and 24 as the max display size for real, double, 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.
Th 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
