Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.31, 10.2.11, 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
-
Linux Mint
Description
I try to alter table to add a composite primary key with "if not exists clause" to a table. One of these column is already in a composite unique index with an other column.
I get warning code 1061 "Multiple primary key defined".
But without "IF NOT EXISTS", it works fine.
This is my example :
CREATE TABLE `HORIZON` ( |
`ID` BIGINT(20) NOT NULL, |
`RANK` MEDIUMINT(4) NOT NULL, |
`CHECK_POINT` BIGINT(20) NOT NULL, |
UNIQUE INDEX `HORIZON_UIDX01` (`ID`, `RANK`) |
) COLLATE='utf8_general_ci' ENGINE=InnoDB ; |
 |
ALTER TABLE `HORIZON` ADD PRIMARY KEY IF NOT EXISTS (`ID`, `CHECK_POINT`); /* warning code 1061 */ |
ALTER TABLE `HORIZON` ADD PRIMARY KEY (`ID`, `CHECK_POINT`); /* works fine */ |
Attachments
Issue Links
- relates to
-
MDEV-8358 ALTER TABLE .. ADD PRIMARY KEY IF NOT EXISTS -> ERROR 1068 (42000): Multiple primary key defined
- Closed