diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2018-01-30 17:08:36 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2018-01-30 17:08:36 +0400 |
| commit | 926adcfeeaf23f4414822e3da712fb5e2560f5cb (patch) | |
| tree | 35b1e6cd48546156c65ef3b816c25d349b1b9108 /mysql-test/r/alter_table.result | |
| parent | 5478547c96a33adf7848d9e7f84bc6dcb9dead2f (diff) | |
| download | mariadb-git-926adcfeeaf23f4414822e3da712fb5e2560f5cb.tar.gz | |
MDEV-14694 ALTER COLUMN IF EXISTS .. causes syntax error.
Implementing the 'IF EXISTS' option for statements
ALTER TABLE ALTER COLUMN SET/DROP DEFAULT.
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index b8f51ee25ad..ad2ec606839 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -2275,6 +2275,19 @@ t1 CREATE TABLE `t1` ( `c` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; +create table t1 (i int); +alter table t1 alter column if exists a set default 1; +Warnings: +Note 1054 Unknown column 'a' in 't1' +alter table t1 alter column if exists a drop default; +Warnings: +Note 1054 Unknown column 'a' in 't1' +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `i` int(11) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1; # # End of 10.2 tests # |