Debian Codegraph @

mysql-test/suite/galera/t/galera_var_fkchecks.test

raw
1 #
2 # Test the operation on the foreign_key_checks variable
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE parent (
9 id INT PRIMARY KEY,
10 KEY (id)
11 ) ENGINE=InnoDB;
12
13 CREATE TABLE child (
14 id INT PRIMARY KEY,
15 parent_id INT,
16 FOREIGN KEY (parent_id)
17 REFERENCES parent(id)
18 ) ENGINE=InnoDB;
19
20 INSERT INTO parent VALUES (1);
21 INSERT INTO child VALUES (1,1);
22
23 SET SESSION foreign_key_checks = 0;
24
25 INSERT INTO child VALUES (2,2);
26
27 --connection node_2
28 SELECT COUNT(*) = 1 FROM child WHERE id = 2;
29
30 --error ER_NO_REFERENCED_ROW_2
31 INSERT INTO child VALUES (3,3);
32
33 SET SESSION foreign_key_checks = 0;
34 DELETE FROM parent;
35
36 --connection node_1
37 SELECT COUNT(*) = 0 FROM parent;
38
39 DROP TABLE child;
40 DROP TABLE parent;