Error message "expected length N, actual M" contains wrong value of M when charset UTF8 is used in the field declaration of a table [CORE6414] #6652
Assignees
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandes |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 RC 1 [ 10930 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @pavel-zotov
Is related to CORE6419
recreate table test(nm varchar(1) character set win1251 default 'QWERTYUIOP' not null);
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 1, actual 10
/* 10 is OK, this is number of characters in the default string */
recreate table test(nm varchar(1) character set utf8 default 'QWERTYUIOP' not null);
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 1, actual 4
/* value 4 is wrong and is issued regardless of default string length */
Checked on: WI-V3.0.7.33372; WI-V4.0.0.2225
(ticket is created after discussion with Adriano; perhaps similar problem already was described in some another ticket)
Commits: 0174bda
The text was updated successfully, but these errors were encountered: