Debian Codegraph @

mysql-test/suite/galera/t/MW-285.test

raw
1 #
2 # Broken FK constraints cause assertions
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE parent1 ( id INT PRIMARY KEY, KEY (id) ) ENGINE=InnoDB;
9 CREATE TABLE parent2 ( id INT PRIMARY KEY, KEY (id) ) ENGINE=InnoDB;
10
11 CREATE TABLE child (
12 id INT PRIMARY KEY,
13 parent1_id INT,
14 parent2_id INT,
15 FOREIGN KEY (parent1_id) REFERENCES parent1(id),
16 FOREIGN KEY (parent1_id) REFERENCES parent2(id)
17 ) ENGINE=InnoDB;
18
19 INSERT INTO parent1 VALUES (1);
20 INSERT INTO parent2 VALUES (1);
21 INSERT INTO child VALUES (1,1,1);
22 INSERT INTO child VALUES (2,1,1);
23
24 SET foreign_key_checks=OFF;
25 DROP TABLE parent1;
26
27 UPDATE child SET parent1_id=2 WHERE id=1;
28
29 DROP TABLE child;
30 DROP TABLE parent2;
31 SET foreign_key_checks=ON;