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/t/alter_table.test | |
| 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/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 79a01d5e0c4..f11e7a2178c 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -1882,6 +1882,16 @@ alter table t1 drop column a, drop index a; show create table t1; drop table t1; +# +# MDEV-14694 ALTER COLUMN IF EXISTS .. causes syntax error +# + +create table t1 (i int); +alter table t1 alter column if exists a set default 1; +alter table t1 alter column if exists a drop default; +show create table t1; +drop table t1; + --echo # --echo # End of 10.2 tests --echo # |