db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-836) ResultSetMetaData.getColumnDisplaySize sometimes returns wrong values for DECIMAL columns
Date Thu, 06 Jul 2006 19:24:30 GMT
    [ http://issues.apache.org/jira/browse/DERBY-836?page=comments#action_12419586 ] 

Daniel John Debrunner commented on DERBY-836:
---------------------------------------------

I believe the failures you are seeing are due to the change. It's probably because the change
in metadata information for DECIMAL columns is causing ij to display its output differently,
causing the changes.

I ran functions.sql with and without the patch, it fails with the patch and passes without.

> ResultSetMetaData.getColumnDisplaySize sometimes returns wrong values for DECIMAL columns
> -----------------------------------------------------------------------------------------
>
>          Key: DERBY-836
>          URL: http://issues.apache.org/jira/browse/DERBY-836
>      Project: Derby
>         Type: Bug

>   Components: JDBC, Newcomer
>     Versions: 10.2.0.0
>     Reporter: Daniel John Debrunner
>     Assignee: Mayuresh Nirhali
>     Priority: Minor
>  Attachments: derby836-v2.diff, derby836-v3.diff, derby836-v4.diff, derby836.diff, derby836_v5.diff
>
> DECIMAL(10,0)
> max display width value:   -1234567890  length 11
> embedded : 11 correct
> client: 12 WRONG
> DECIMAL(10,10)
> max display width value:   -0.1234567890  length 13
> embedded : 13 correct
> client: 12 WRONG
> DECIMAL(10,2)
> max display width value:   -12345678.90  length 12
> embedded : 13 WRONG
> client: 12 correct
> I've added output early on in jdbcapi/metadata_test.java (and hence the tests metadata.jar
and odbc_metadata.java) to show this issue:
> E.g. for embedded
> DECIMAL(10,0) -- precision: 10 scale: 0 display size: 12 type name: DECIMAL
> DECIMAL(10,10) -- precision: 10 scale: 10 display size: 12 type name: DECIMAL
> DECIMAL(10,2) -- precision: 10 scale: 2 display size: 12 type name: DECIMAL
> I will add this test output once DERBY-829 is fixed so as not to cause conflicts.

-- 
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


Mime
View raw message