diff options
author | Sergei Golubchik <serg@mariadb.org> | 2017-08-12 18:52:38 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2017-08-14 19:45:59 +0200 |
commit | 04b288ae47dec8bd1a41902889956c4b0d711cc5 (patch) | |
tree | 20f850d7109609320dedab2484040ab59b88e1a8 /mysql-test/t/check_constraint.test | |
parent | 28ddc9b3bbbb56a3146779b1f0ccf42a6ef50f2b (diff) | |
download | mariadb-git-04b288ae47dec8bd1a41902889956c4b0d711cc5.tar.gz |
MDEV-11114 Cannot drop column referenced by CHECK constraint
SQL Standard behavior for DROP COLUMN xxx RESTRICT:
* If a constraint (UNIQUE or CHECK) uses only the dropped column,
it's automatically dropped too. If it uses many columns - an error.
Diffstat (limited to 'mysql-test/t/check_constraint.test')
-rw-r--r-- | mysql-test/t/check_constraint.test | 8 |
1 files changed, 0 insertions, 8 deletions
diff --git a/mysql-test/t/check_constraint.test b/mysql-test/t/check_constraint.test index c70a208f774..43b4417cfa3 100644 --- a/mysql-test/t/check_constraint.test +++ b/mysql-test/t/check_constraint.test @@ -80,14 +80,6 @@ insert into t1(c1) values(2); drop table t1; # -# MDEV-11114 Cannot drop column referenced by CHECK constraint: Unknown column 'a' in 'virtual column function' -# -create table t1 (a int, b int, check(a>0)); ---error ER_BAD_FIELD_ERROR -alter table t1 drop column a; -drop table t1; - -# # MDEV-11117 CHECK constraint fails on intermediate step of ALTER # -- error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED |