[jira] Updated: (DERBY-3128) embedded: Inserting object into non-DECIMAL column with setObject using specified scale does not adjust scale

["Kathey Marsden (JIRA)" <ji...@apache.org>]

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

Kathey Marsden updated DERBY-3128:
----------------------------------

    Affects Version/s: 10.4.0.0

> embedded: Inserting object  into non-DECIMAL column with setObject using specified scale does not adjust scale
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3128
>                 URL: https://issues.apache.org/jira/browse/DERBY-3128
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>            Priority: Minor
>         Attachments: ZeroScaleTest.java
>
>
> For embedded specifying target type java.sql.Types.DECIMAL and inserting into a non-decimal column, e.g. REAL, DOUBLE, VARCHAR, does not properly adjust the scale when using the api calls below:
> public void *setObject*(int parameterIndex,
>                      Object  x,
>                      int targetSqlType)
> and
> public void *setObject*(int parameterIndex,
>                      Objec x,
>                      int targetSqlType,
>                      int scale)
> For example, with a scale specified as zero embeded will not truncate the fractional digits if inserted into a DOUBLE column (DECIMAL columns are fine).  Client will truncate the fractional digits properly.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.