[MDEV-22635] Cannot add PK when identical UNIQUE key exists Created: 2020-05-19 Updated: 2020-05-21 Resolved: 2020-05-21 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.4 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Dorian Sechesan | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Given there is an InnoDB table with no PK, and (at least) one unique key:
Attempting to add a PK on the same columns:
Gives the following error:
and the PK is not created. This doesn't happen on latest 10.3 or latest 10.5 from dockerhub, only with 10.4 |
| Comments |
| Comment by Elena Stepanova [ 2020-05-21 ] |
|
Thanks for the report. We already have it filed as MDEV-19598, so let's keep tracking it there. |