[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:
|