diff options
| author | unknown <sergefp@mysql.com> | 2004-06-23 11:40:42 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2004-06-23 11:40:42 +0400 |
| commit | 91e27b0266cf654efc364450b0d504b4b32f6a93 (patch) | |
| tree | eed0e09529a9967dd45d6b7490a64027c4c1335d /mysql-test/r/alter_table.result | |
| parent | 5adf6574bd1cfb02834a699a5794038a40773ee0 (diff) | |
| download | mariadb-git-91e27b0266cf654efc364450b0d504b4b32f6a93.tar.gz | |
Fix and test case for BUG#3899
mysql-test/r/alter_table.result:
Test case for BUG#3899
mysql-test/t/alter_table.test:
Test case for BUG#3899
sql/sql_yacc.yy:
Fix for BUG#3899: call ALTER_INFO::reset to clear ALTER_INFO::drop_list and ALTER_INFO::alter_list
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index c2ed40f3f94..1441b3c3600 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -470,3 +470,9 @@ t1 CREATE TABLE `t1` ( ALTER TABLE t1 DROP PRIMARY KEY; ERROR 42000: Can't DROP 'PRIMARY'; check that column/key exists DROP TABLE t1; +create table t1 (a int, b int, key(a)); +insert into t1 values (1,1), (2,2); +alter table t1 drop key no_such_key; +ERROR 42000: Can't DROP 'no_such_key'; check that column/key exists +alter table t1 drop key a; +drop table t1; |