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

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.4.1.3
• Component/s: JDBC
• Labels: derby_triage10_5_2
• Urgency: Normal
• Bug behavior facts: Deviation from standard
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 12/Oct/07 16:55
• Updated: 15/Feb/11 21:08

Description

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.