diff options
author | Monty <monty@mariadb.org> | 2019-12-30 13:34:28 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2020-03-24 20:47:41 +0200 |
commit | bff79492c5f6c9669b9dc9bf2cf0483b3b001da7 (patch) | |
tree | 7d13874ae2bf8a8c2caba079f1010d401d65dcaf /mysql-test/main/alter_table.result | |
parent | 5f5c63e0fe6eac590549bdb76204a07cb2fe2aa1 (diff) | |
download | mariadb-git-bff79492c5f6c9669b9dc9bf2cf0483b3b001da7.tar.gz |
Added IF EXISTS to RENAME TABLE and ALTER TABLE
Diffstat (limited to 'mysql-test/main/alter_table.result')
-rw-r--r-- | mysql-test/main/alter_table.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/alter_table.result b/mysql-test/main/alter_table.result index c2c5813a100..36fb35f05b4 100644 --- a/mysql-test/main/alter_table.result +++ b/mysql-test/main/alter_table.result @@ -3244,3 +3244,22 @@ drop table t1; # # End of 10.5 tests # +# +# ALTER TABLE IF EXISTS +# +create table t1 (a int); +alter table if exists t1 add column b int; +alter table if exists t2 add column c int; +Warnings: +Error 1146 Table 'test.t2' doesn't exist +alter table if exists t9 rename t1; +Warnings: +Error 1146 Table 'test.t9' doesn't exist +alter table if exists t1 rename t2; +show create table t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `a` int(11) DEFAULT NULL, + `b` int(11) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t2; |