"Malformed string" instead of key value in PK violation error message [CORE5847] #6108
Labels
affect-version: 2.5.3 Update 1
affect-version: 2.5.3
affect-version: 2.5.4
affect-version: 2.5.5
affect-version: 2.5.6
affect-version: 2.5.7
affect-version: 2.5.8
affect-version: 3.0.0
affect-version: 3.0.1
affect-version: 3.0.2
affect-version: 3.0.3
affect-version: 4.0 Alpha 1
affect-version: 4.0 Initial
component: engine
fix-version: 2.5.9
fix-version: 3.0.4
fix-version: 4.0 Beta 1
priority: minor
qa: done successfully
type: bug
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
The text was updated successfully, but these errors were encountered: