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

"Malformed string" instead of key value in PK violation error message [CORE5847] #6108

Closed
firebird-automations opened this issue Jun 19, 2018 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

Is related to CORE3881

1. Connect with UTF8 charset:

firebird>isql -ch utf8

SQL> recreate table t (uid char(16) character set octets primary key);
SQL> commit;
SQL>
SQL>
SQL> insert into t values (GEN_UUID());
SQL> select * from t;

UID

E5FCB3D11EB7472792F4819B06CB7099

SQL> insert into t select uid from t;
Statement failed, SQLSTATE = 23000
violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "T"
-Malformed string

2. Connect with non-UTF8 charset:

firebird>isql -ch win1251

SQL> insert into t select uid from t;
Statement failed, SQLSTATE = 23000
violation of PRIMARY or UNIQUE KEY constraint "INTEG_2" on table "T"
-Problematic key value is ("UID" = x'E5FCB3D11EB7472792F4819B06CB7099')

Commits: 7c8242c b9da7ba 0e793dd

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue is related to CORE3881 [ CORE3881 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

Fix Version: 3.0.4 [ 10863 ]

Fix Version: 2.5.9 [ 10862 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

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