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/r/sp-destruct.result | |
| 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/r/sp-destruct.result')
| -rw-r--r-- | mysql-test/r/sp-destruct.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/sp-destruct.result b/mysql-test/r/sp-destruct.result index 0eddfa70dd1..5bb3b17d4b8 100644 --- a/mysql-test/r/sp-destruct.result +++ b/mysql-test/r/sp-destruct.result @@ -12,7 +12,7 @@ create function bug14233_f() returns int return 42; create table t1 (id int); create trigger t1_ai after insert on t1 for each row call bug14233(); -alter table mysql.proc drop type; +alter table mysql.proc drop security_type; call bug14233(); ERROR HY000: Column count of mysql.proc is wrong. Expected 20, found 19. The table is probably corrupted create view v1 as select bug14233_f(); @@ -142,7 +142,7 @@ drop database if exists mysqltest; flush table mysql.proc; create database mysqltest; # 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; # The below statement should not cause assertion failure. drop database mysqltest; Warnings: |