diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2015-10-25 22:45:48 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2015-10-25 22:45:48 +0400 |
| commit | c9185225cba8bb6a2a6745d98a168efe6dfaddcd (patch) | |
| tree | 036d3f9f8464fafa5ac939cce5ca2cdff1360f10 /mysql-test/r/alter_table.result | |
| parent | 2c0bcfff8c8e32a9b70d1090ab34a5f53182ad52 (diff) | |
| download | mariadb-git-c9185225cba8bb6a2a6745d98a168efe6dfaddcd.tar.gz | |
MDEV-8358 ALTER TABLE .. ADD PRIMARY KEY IF NOT EXISTS -> ERROR 1068 (42000): Multiple primary key defined
Checks for multiple primary keys added.
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 5df0c2e3c96..e572fdb197c 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -2012,3 +2012,12 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `idx` (`i`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DROP TABLE t1; +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); +Warnings: +Note 1061 Multiple primary key defined +DROP TABLE t1; |