[DERBY-3991] Clob.truncate(0) throws exception

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.3.3.1, 10.4.2.1, 10.6.1.0
• Fix Version/s: 10.4.2.1, 10.5.2.0, 10.6.1.0
• Component/s: JDBC
• Issue & fix info: Newcomer, Release Note Needed
• Bug behavior facts: Deviation from standard
• Assignee: Yun Lee
• Reporter: Kristian Waagan
• Created: 15/Dec/08 12:48
• Updated: 16/Jul/09 21:24
• Resolved: 08/May/09 13:32

Description

Truncating a Clob to zero length is allowed according to the JDBC specification, which says the following about the len argument (in the @throws tag):
"SQLException - if there is an error accessing the CLOB value or if len is less than 0 "

Derby throws an exception if zero is passed to truncate.

A quick inspection of the code suggests that truncating a Clob to the empty string is easy to support.