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] [Updated] (DERBY-853) ResultSetMetaData.getScale returns inconsistent values for DOUBLE type.
Date Fri, 28 Dec 2012 19:32:13 GMT

     [ https://issues.apache.org/jira/browse/DERBY-853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-853:
-------------------------------------

    Attachment: Derby853.java

Attaching Derby853.java which reproduces the problem. It subtracts a DOUBLE from a DECIMAL(10,2)
and prints the scale and the type name of the result. On trunk, it prints:

scale: 2
type: DOUBLE
                
> 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
>              Labels: derby_triage10_5_2
>         Attachments: Derby853.java
>
>
> 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, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message