[MDEV-8358] ALTER TABLE .. ADD PRIMARY KEY IF NOT EXISTS -> ERROR 1068 (42000): Multiple primary key defined Created: 2015-06-23  Updated: 2017-12-16  Resolved: 2015-10-25

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Affects Version/s: 10.0.19, 10.0, 10.1
Fix Version/s: 10.0.22

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: alter

Issue Links:
Relates
relates to MDEV-14668 ADD PRIMARY KEY IF NOT EXISTS on comp... Closed
Sprint: 10.0.22

 Description    

MariaDB [test]> CREATE TABLE `market_deductions` (
 
    ->   `event_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
    ->   `market_id` bigint(20) unsigned NOT NULL DEFAULT '0',
 
    ->   PRIMARY KEY (`event_id`,`market_id`)
 
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
 
Query OK, 0 rows affected (0.01 sec)
 
 
 
MariaDB [test]>  ALTER TABLE market_deductions ADD PRIMARY KEY IF NOT EXISTS event_id (event_id,market_id);
 
ERROR 1068 (42000): Multiple primary key defined

Seems IF NOT EXISTS is not really checked.

Haven't checked if 10.0.22 has fixed this as part of MDEV-8212

 Comments   
Comment by Alexey Botchkov [ 2015-10-25 ]

FIxing patch: http://lists.askmonty.org/pipermail/commits/2015-October/008530.html

Comment by Daniel Black [ 2015-10-30 ]

thank you

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