From c9185225cba8bb6a2a6745d98a168efe6dfaddcd Mon Sep 17 00:00:00 2001 From: Alexey Botchkov Date: Sun, 25 Oct 2015 22:45:48 +0400 Subject: MDEV-8358 ALTER TABLE .. ADD PRIMARY KEY IF NOT EXISTS -> ERROR 1068 (42000): Multiple primary key defined Checks for multiple primary keys added. --- mysql-test/t/alter_table.test | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'mysql-test/t/alter_table.test') diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 4dde3ed6971..05d915ec478 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -1699,3 +1699,16 @@ alter table t1 add unique index if not exists idx(i); alter table t1 add unique index if not exists idx(i); show create table t1; DROP TABLE t1; + +# +# MDEV-8358 ADD PRIMARY KEY IF NOT EXISTS -> ERROR 1068 (42000): Multiple primary key +# + +CREATE TABLE t1 ( + `event_id` bigint(20) unsigned NOT NULL DEFAULT '0', + `market_id` bigint(20) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`event_id`,`market_id`) + ); +ALTER TABLE t1 ADD PRIMARY KEY IF NOT EXISTS event_id (event_id,market_id); +DROP TABLE t1; + -- cgit v1.2.1