[DERBY-4040] SQLChar.getLength returns wrong length for some data values

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.3.1, 10.4.2.0, 10.5.1.1
• Fix Version/s: 10.3.3.1, 10.4.2.1, 10.5.1.1
• Component/s: SQL
• Bug behavior facts: Regression, Wrong query result
• Assignee: Kristian Waagan
• Reporter: Kristian Waagan
• Created: 30/Jan/09 12:04
• Updated: 01/Jul/09 16:25
• Resolved: 19/Feb/09 10:47

Description

SQLChar.getLength() returns the wrong length of the data value in some cases.
For the bug to be triggered, the value must contain characters that are represented by two or three bytes, and Derby must store the value as a stream.

In my ad-hoc testing, I found that a value of length 10886 with CJK characters doesn't trigger the bug, but 10887 does trigger the bug. Further, for a range of lengths the bug can also been observed for CLOB columns (when doing 'select length(clobcolumn)').

Issue Links

• is related to: DERBY-3741 SQL LENGTH function materializes CLOB into memory