diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-01-13 16:18:37 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-01-13 16:18:37 +0400 |
| commit | 21e2c72bfbdccfdb0f72c6cbb61d7987bb7bb576 (patch) | |
| tree | 854328dff31a4fae4be48c5840e2f1c12f609169 /mysql-test/t/alter_table.test | |
| parent | 41b3fb05d5e1e732178ba9b05a548f15d17e9eeb (diff) | |
| download | mariadb-git-21e2c72bfbdccfdb0f72c6cbb61d7987bb7bb576.tar.gz | |
a fix (bug #2361: ALTER TABLE ... DROP PRIMARY KEY drops a non-primary key).
Diffstat (limited to 'mysql-test/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index eab4fd7f5f0..71991973105 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -244,3 +244,12 @@ LOCK TABLES t1 WRITE; ALTER TABLE t1 DISABLE KEYS; SHOW INDEX FROM t1; DROP TABLE t1; + +# +# Bug 2361 +# + +CREATE TABLE t1 (a int UNIQUE); +ALTER TABLE t1 DROP PRIMARY KEY; +SHOW CREATE TABLE t1; +DROP TABLE t1; |