You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/01/20 20:29:42 UTC
[jira] Created: (DERBY-853) ResultSetMetaData.getScale returns
inconsistent values for DOUBLE type.
ResultSetMetaData.getScale returns inconsistent values for DOUBLE type.
-----------------------------------------------------------------------
Key: DERBY-853
URL: http://issues.apache.org/jira/browse/DERBY-853
Project: Derby
Type: Bug
Components: JDBC, Newcomer
Versions: 10.2.0.0
Reporter: Daniel John Debrunner
Priority: Trivial
If a DOUBLE column is returned in the result set then getScale() returns 0.
If a DOUBLE expression is returned and the expression is the result of a DOUBLE combined with a DECIMAL then it seems the scale from the decimal sometimes affects the result set metadata.
E.g. DECIMAL(10,2) - DOUBLE returns a DOUBLE with getScale() returning 2.
See the test output for jdbcapi/metadata.java
double -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE
First line is a DOUBLE column, second is DOUBLE - DECIMAL, third is DECIMAL - DOUBLE
I assume the scale should always be zero for a DOUBLE, as it holds no meaning, but I can't see any proof of that in JDBC spec, javadoc or tutorial book.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-853) ResultSetMetaData.getScale returns
inconsistent values for DOUBLE type.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-853:
--------------------------------
Urgency: Normal
Triaged for 10.5.3: assigne normal urgency.
> ResultSetMetaData.getScale returns inconsistent values for DOUBLE type.
> -----------------------------------------------------------------------
>
> Key: DERBY-853
> URL: https://issues.apache.org/jira/browse/DERBY-853
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.2.1.6
> Reporter: Daniel John Debrunner
> Priority: Trivial
>
> If a DOUBLE column is returned in the result set then getScale() returns 0.
> If a DOUBLE expression is returned and the expression is the result of a DOUBLE combined with a DECIMAL then it seems the scale from the decimal sometimes affects the result set metadata.
> E.g. DECIMAL(10,2) - DOUBLE returns a DOUBLE with getScale() returning 2.
> See the test output for jdbcapi/metadata.java
> double -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
> double precision - dec(10,2) -- precision: 15 scale: 0 display size: 22 type name: DOUBLE
> dec(10,2) - double precision -- precision: 15 scale: 2 display size: 22 type name: DOUBLE
> First line is a DOUBLE column, second is DOUBLE - DECIMAL, third is DECIMAL - DOUBLE
> I assume the scale should always be zero for a DOUBLE, as it holds no meaning, but I can't see any proof of that in JDBC spec, javadoc or tutorial book.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.