Debian Codegraph @

mysql-test/suite/galera/r/MW-285.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE parent1 ( id INT PRIMARY KEY, KEY (id) ) ENGINE=InnoDB;
4 CREATE TABLE parent2 ( id INT PRIMARY KEY, KEY (id) ) ENGINE=InnoDB;
5 CREATE TABLE child (
6 id INT PRIMARY KEY,
7 parent1_id INT,
8 parent2_id INT,
9 FOREIGN KEY (parent1_id) REFERENCES parent1(id),
10 FOREIGN KEY (parent1_id) REFERENCES parent2(id)
11 ) ENGINE=InnoDB;
12 INSERT INTO parent1 VALUES (1);
13 INSERT INTO parent2 VALUES (1);
14 INSERT INTO child VALUES (1,1,1);
15 INSERT INTO child VALUES (2,1,1);
16 SET foreign_key_checks=OFF;
17 DROP TABLE parent1;
18 UPDATE child SET parent1_id=2 WHERE id=1;
19 DROP TABLE child;
20 DROP TABLE parent2;
21 SET foreign_key_checks=ON;