insert of decimal value larger than max succeeds with jdk15

• Key: DERBY-225
• Type: Bug
• Status: Closed
• Resolution: Fixed
• Priority: Major
• Assignee: Daniel John Debrunner
• Reporter: Myrna van Lunteren
• Component/s: JDBC
• Affects Version/s: 10.0.2.1
• Fix Version/s: 10.1.1.0

Description

On the following table:
   create table tmp (d decimal(31,0));
an insert of a value with a precision larger than 31:
   insert into tmp values (+1.79769E+308);
Should fail with:
   ERROR 22003: The resulting value is outside the range for the data type DECIMAL/NUMERIC(31,0).

However, with jdk15, it does not.

The expected error is generated from org.apache.derby.iapi.types.SQLDecimal.setWidth(), which calls getWholeDigits(), which gets the length of a string based on a BigDecimal using toString, which has a different value using jdk14 vs. jdk15 since the fix for DERBY-38.

Note: I verified that the fix for DERBY-38 did not per se cause this failure.

Comments

[Daniel John Debrunner]

Handled negative scale values that can be returned by BigDecimal.scale() in J2SE 5.0

Sending java\engine\org\apache\derby\iapi\types\NumberDataValue.java
Sending java\engine\org\apache\derby\iapi\types\SQLDecimal.java
Transmitting file data ..
Committed revision 167832.