Debian Codegraph @

mysql-test/suite/galera/r/galera_var_fkchecks.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE parent (
4 id INT PRIMARY KEY,
5 KEY (id)
6 ) ENGINE=InnoDB;
7 CREATE TABLE child (
8 id INT PRIMARY KEY,
9 parent_id INT,
10 FOREIGN KEY (parent_id)
11 REFERENCES parent(id)
12 ) ENGINE=InnoDB;
13 INSERT INTO parent VALUES (1);
14 INSERT INTO child VALUES (1,1);
15 SET SESSION foreign_key_checks = 0;
16 INSERT INTO child VALUES (2,2);
17 connection node_2;
18 SELECT COUNT(*) = 1 FROM child WHERE id = 2;
19 COUNT(*) = 1
20 1
21 INSERT INTO child VALUES (3,3);
22 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`))
23 SET SESSION foreign_key_checks = 0;
24 DELETE FROM parent;
25 connection node_1;
26 SELECT COUNT(*) = 0 FROM parent;
27 COUNT(*) = 0
28 1
29 DROP TABLE child;
30 DROP TABLE parent;