Issue Details (XML | Word | Printable)

Key: CORE-5847
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

"Malformed string" instead of key value in PK violation error message

Created: 19/Jun/18 07:58 AM   Updated: 21/Jun/18 08:41 AM
Component/s: Engine
Affects Version/s: 2.5.3, 2.5.3 Update 1, 2.5.4, 2.5.5, 4.0 Initial, 3.0.0, 2.5.6, 3.0.1, 2.5.7, 3.0.2, 4.0 Alpha 1, 2.5.8, 3.0.3
Fix Version/s: 3.0.4, 4.0 Beta 1, 2.5.9

Issue Links:
Relate
 

QA Status: Done successfully


 Description  « Hide
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')


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun made changes - 19/Jun/18 07:58 AM
Field Original Value New Value
Link This issue is related to CORE-3881 [ CORE-3881 ]
Vlad Khorsun made changes - 19/Jun/18 07:59 AM
Assignee Vlad Khorsun [ hvlad ]
Vlad Khorsun made changes - 19/Jun/18 08:55 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 4.0 Beta 1 [ 10750 ]
Fix Version/s 3.0.4 [ 10863 ]
Fix Version/s 2.5.9 [ 10862 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 21/Jun/18 08:41 AM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status No test Done successfully
Pavel Zotov made changes - 21/Jun/18 08:41 AM
Status Resolved [ 5 ] Closed [ 6 ]