Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
firebird-issue-importer opened this issue Oct 13, 2020 · 5 comments

Comments

@firebird-issue-importer

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 13, 2020

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 18, 2020

Modified by: @asfernandes

Link: This issue is related to CORE6419 [ CORE6419 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 18, 2020

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 RC 1 [ 10930 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 19, 2020

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 19, 2020

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants