diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2016-07-02 12:22:58 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-07-02 14:52:23 +0200 |
| commit | b258f911032a04394b8e0f8f092da799d804a205 (patch) | |
| tree | f705108c034f820f25da7eec88f25417ad7502e1 /mysql-test | |
| parent | 5c764a0eb82c87ace0df9744922f27229a7e212a (diff) | |
| download | mariadb-git-b258f911032a04394b8e0f8f092da799d804a205.tar.gz | |
fix ALTER TABLE .. DROP CONSTRAINT IF NOT EXISTSmariadb-10.2.1
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/check_constraint.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/check_constraint.test | 1 |
2 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/check_constraint.result b/mysql-test/r/check_constraint.result index 1ffe0ba3ba6..babb42d93b8 100644 --- a/mysql-test/r/check_constraint.result +++ b/mysql-test/r/check_constraint.result @@ -84,6 +84,9 @@ t2 CREATE TABLE `t2` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 alter table t2 drop constraint c; ERROR 42000: Can't DROP CONSTRAINT `c`; check that it exists +alter table t2 drop constraint if exists c; +Warnings: +Note 1091 Can't DROP CONSTRAINT `c`; check that it exists alter table t2 drop constraint min; show create table t2; Table Create Table diff --git a/mysql-test/t/check_constraint.test b/mysql-test/t/check_constraint.test index 7bd6a654e9b..8dd6fcc4f27 100644 --- a/mysql-test/t/check_constraint.test +++ b/mysql-test/t/check_constraint.test @@ -48,6 +48,7 @@ create table t2 like t1; show create table t2; --error ER_CANT_DROP_FIELD_OR_KEY alter table t2 drop constraint c; +alter table t2 drop constraint if exists c; alter table t2 drop constraint min; show create table t2; |