[DERBY-4793] Assert failure when concatenating strings with total size greater than 32K

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.6.1.0
• Component/s: SQL
• Labels: derby_triage10_8
• Urgency: Low
• Issue & fix info: Repro attached
• Bug behavior facts: Deviation from standard
• Assignee: Unassigned
• Reporter: Knut Anders Hatlen
• Created: 06/Sep/10 15:29
• Updated: 09/Dec/11 08:02

Description

When concatenating two strings whose total length exceeds the maximum length for a VARCHAR, an assert is triggered in the debug jars:

ij> values length('0123456789.....' || '0123456789.....');
ERROR XJ001: Java exception: 'ASSERT FAILED The maximum length 35000 for the result type VARCHAR can't be greater than it's maximum width of result's typeid32672: org.apache.derby.shared.common.sanity.AssertFailure'.

With non-debug jars, the same query completes successfully:

ij> values length('0123456789.....' || '0123456789.....');
1
-----------
35000

1 row selected

I think this query is supposed to fail, also with non-debug jars, but in any even it shouldn't be raising assert failures.

Issue Links

• is related to: DERBY-5235 Remove the artificial limit on the length of VARCHAR values, allowing them to be java.lang.Integer.MAX_VALUE long