diff options
| author | unknown <serg@serg.mylan> | 2004-01-28 18:35:52 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-01-28 18:35:52 +0100 |
| commit | 832ea1206d74bba03cee2b7a9e88a622d8b7ac23 (patch) | |
| tree | 2d6eb1e6377b62d611b5f0fde6f0f6437b9814ac /mysql-test/t/alter_table.test | |
| parent | d01e81012876416b3691a513a13af26d13d2f307 (diff) | |
| download | mariadb-git-832ea1206d74bba03cee2b7a9e88a622d8b7ac23.tar.gz | |
better 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 | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 71991973105..c013b2251a9 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -249,7 +249,9 @@ DROP TABLE t1; # Bug 2361 # -CREATE TABLE t1 (a int UNIQUE); +CREATE TABLE t1 (a int PRIMARY KEY, b INT UNIQUE); ALTER TABLE t1 DROP PRIMARY KEY; SHOW CREATE TABLE t1; +--error 1091 +ALTER TABLE t1 DROP PRIMARY KEY; DROP TABLE t1; |