Debian Codegraph @

mysql-test/suite/innodb/t/fk_drop_alter.test

raw
1 --source include/have_innodb.inc
2 --echo #
3 --echo # MDEV-22230 : Unexpected ER_ERROR_ON_RENAME upon DROP
4 --echo # non-existing FOREIGN KEY
5 --echo #
6 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
7 --error ER_CANT_DROP_FIELD_OR_KEY
8 ALTER TABLE t1 DROP FOREIGN KEY x, ALGORITHM=COPY;
9 --error ER_CANT_DROP_FIELD_OR_KEY
10 ALTER TABLE t1 DROP FOREIGN KEY x, ALGORITHM=INPLACE;
11 # Cleanup
12 DROP TABLE t1;
13
14 CREATE TABLE t1 (a INT, KEY(a)) ENGINE=InnoDB;
15 CREATE TABLE t2 (a INT, FOREIGN KEY fk_id (a) REFERENCES t1(a))ENGINE=InnoDB;
16 CREATE TABLE t3 (a INT, FOREIGN KEY fk_1 (a) REFERENCES t1(a))ENGINE=InnoDB;
17 ALTER TABLE t3 DROP FOREIGN KEY IF EXISTS fk_id;
18 DROP TABLE t3, t2;
19 ALTER TABLE t1 MODIFY COLUMN a VARCHAR(2), DROP FOREIGN KEY IF EXISTS x;
20 DROP TABLE t1;
21
22 CREATE DATABASE best;
23 CREATE TABLE best.t1(f1 INT, KEY(f1))ENGINE=InnoDB;
24 CREATE TABLE best.t2(f1 INT, FOREIGN KEY foo(f1) REFERENCES t1(f1))ENGINE=InnoDB;
25
26 CREATE TABLE t1(f1 INT, KEY(f1))ENGINE=InnoDB;
27 CREATE TABLE t2(f1 INT, FOREIGN KEY foo(f1) REFERENCES t1(f1))ENGINE=InnoDB;
28 ALTER TABLE t2 DROP FOREIGN KEY foo;
29 --error ER_CANT_DROP_FIELD_OR_KEY
30 ALTER TABLE t2 DROP FOREIGN KEY foo;
31 ALTER TABLE t2 DROP FOREIGN KEY IF EXISTS foo;
32 SHOW CREATE TABLE best.t2;
33 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN;
34 DROP TABLE best.t2, best.t1, t2, t1;
35 DROP DATABASE best;