[DERBY-786] Casting to a CLOB value does not truncate.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.1.2.1
• Fix Version/s: 10.2.1.6
• Component/s: SQL
• Assignee: Daniel John Debrunner
• Reporter: Daniel John Debrunner
• Created: 31/Dec/05 05:41
• Updated: 04/Jan/06 02:48
• Resolved: 04/Jan/06 02:48

Description

ij> values cast(cast ('123456' as varchar(5)) as varchar(10));
1
----------
12345

1 row selected
ij> values cast(cast ('123456' as clob(5)) as varchar(10));
1
----------
123456

I think caused by CLOB not returning true for TypeId.variableLength() not returning true for CLOB.
Comments in code indicate some confusion, will add comments indicating the method is for types where
the length is application defined. Will also remove XML as a variable type.