From 04b288ae47dec8bd1a41902889956c4b0d711cc5 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Sat, 12 Aug 2017 18:52:38 +0200 Subject: 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. --- mysql-test/t/check_constraint.test | 8 -------- 1 file changed, 8 deletions(-) (limited to 'mysql-test/t/check_constraint.test') 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 @@ -79,14 +79,6 @@ insert into t1(c1) values(1); 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 # -- cgit v1.2.1