[MDEV-10533] wrong error on MyISAM ALTER TABLE ... ADD UNIQUE Created: 2016-08-10  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Storage Engine - MyISAM
Affects Version/s: 10.0
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Sergei Golubchik Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

See myisam_enable_keys-10506 test. Starting from 10.0, MyISAM adds unique indexes using “repair by sort”. Not surprisingly, it cannot correctly detect the conflicting key value. It reports a "duplicate key value XXX", while XXX is not, in fact, duplicate.

Possible fixes:

  • use a different error message in this case, the one that does not print the conflicting key value
  • detect the conflicting key value correctly, somehow.

Generated at Thu Feb 08 07:42:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.