embedded: Inserting BigDecimal value 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
            Reporter: Kathey Marsden
            Priority: Minor


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.

Reply via email to