Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 CREATE TABLE parent (
5 id INT NOT NULL,
6 PRIMARY KEY (id)
7 ) ENGINE=InnoDB;
8
9 CREATE TABLE child (
10 id INT,
11 parent_id INT,
12 FOREIGN KEY (parent_id)
13 REFERENCES parent(id)
14 ON UPDATE SET NULL
15 ON DELETE SET NULL
16 ) ENGINE=InnoDB;
17
18 INSERT INTO parent VALUES (1),(2);
19 INSERT INTO child VALUES (1,1),(2,2);
20
21 --connection node_2
22 DELETE FROM parent WHERE id = 1;
23 SELECT parent_id IS NULL FROM child WHERE id = 1;
24
25 --connection node_1
26 SELECT parent_id IS NULL FROM child WHERE id = 1;
27
28 UPDATE parent SET id = 3 WHERE id = 2;
29 SELECT parent_id IS NULL FROM child WHERE id = 2;
30
31 --connection node_2
32 SELECT parent_id IS NULL FROM child WHERE id = 2;
33
34 --connection node_1
35 DROP TABLE child;
36 DROP TABLE parent;