Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: 10.5.10
-
Fix Version/s: N/A
-
Component/s: Storage Engine - Aria, Storage Engine - MyISAM
-
Labels:None
Description
See the attached simple table.
Adding a primary index on the table via
ALTER TABLE `test` ADD PRIMARY KEY(`ID`); |
results in
ERROR 1062 (23000): Duplicate entry '34843' for key 'PRIMARY'
which is totally wrong - the key which is duplicate is 16564 and 16741
This is totally misleading.
Attachments
Issue Links
- duplicates
-
MDEV-23507 Wrong duplicate key value printed in ER_DUP_ENTRY
-
- Open
-