[TRAFODION-2669] Error message of 8402 cause misunderstanding

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: any
• Fix Version/s: 2.2.0
• Component/s: sql-general
• Assignee: Hans Zeller
• Reporter: Yuan Liu
• Created: 27/Jun/17 07:58
• Updated: 26/Mar/18 16:49
• Resolved: 29/Jun/17 22:44

Description

When inserting a value longer than the column data type, the error message caused misunderstanding.

Why 21 bytes can not be inserted into 24 bytes?

SQL>showddl test_utf8;

CREATE TABLE TRAFODION.SEABASE.TEST_UTF8
(
A VARCHAR(6 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED
)
ATTRIBUTES ALIGNED FORMAT
;

— SQL operation complete.

SQL>insert into test_utf8 values('我我我我我我');

— 1 row(s) inserted.

SQL>insert into test_utf8 values('我我我我我我我');

• • • ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:VARCHAR(REC_BYTE_V_ASCII,21 BYTES,UTF8) Source Value:我我我我我我我 to Target Type:VARCHAR(REC_BYTE_V_ASCII,24 BYTES,UTF8). [2017-06-27 15:44:45]

Issue Links

• links to: GitHub Pull Request #1156