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/sp-destruct.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/sp-destruct.test')
| -rw-r--r-- | mysql-test/t/sp-destruct.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/sp-destruct.test b/mysql-test/t/sp-destruct.test index 6e19fd885e3..31da235d906 100644 --- a/mysql-test/t/sp-destruct.test +++ b/mysql-test/t/sp-destruct.test @@ -39,7 +39,7 @@ create table t1 (id int); create trigger t1_ai after insert on t1 for each row call bug14233(); # Unsupported tampering with the mysql.proc definition -alter table mysql.proc drop type; +alter table mysql.proc drop security_type; --error ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2 call bug14233(); --error ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2 @@ -238,7 +238,7 @@ let $MYSQLD_DATADIR= `select @@datadir`; create database mysqltest; --echo # Corrupt mysql.proc to make it unusable by current version of server. -alter table mysql.proc drop column type; +alter table mysql.proc drop column security_type; --echo # The below statement should not cause assertion failure. drop database mysqltest; |