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
Truncation of strings to put in MON$ tables do not work correctly [CORE6419] #6657
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandes |
Modified by: @asfernandes |
Modified by: @asfernandes |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 RC 1 [ 10930 ] |
Commented by: @pavel-zotov Consider following script:set list on; select select
|
Commented by: @pavel-zotov PS. On 4.0.0.2225 second query ( "... where mon$variable_name starting with 'ASDFGHJKLP€€€' ) issues expected result: Statement failed, SQLSTATE = 22001 |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: See notes of 19.10.2020 09:30. Waiting for reply. |
Commented by: @asfernandes > 2) string which is cuted on some position where 'euro' character must be: Yes, considering that mon$variable_name uses charset NONE. |
Commented by: @asfernandes > On 4.0.0.2225 second query ( "... where mon$variable_name starting with 'ASDFGHJKLP€€€' ) issues expected result: So it was a bug. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred => Done successfully Test Details: See notes of 19.10.2020 09:30. Waiting for reply. => |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @asfernandes
Relate to CORE6414
Relate to CORE6415
Relate to CORE6248
This is related to CORE6248.
Multibyte character set strings may be split in the middle of a character raising errors instead of truncation.
Also see this test case which generate error instead of truncation:
select rdb$set_context('USER_SESSION', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890', '1') from rdb$database;
select MON$VARIABLE_NAME from mon$context_variables;
Statement failed, SQLSTATE = 22001
arithmetic exception, numeric overflow, or string truncation
-string right truncation
-expected length 80, actual 90
Commits: 0174bda
The text was updated successfully, but these errors were encountered: