Debian Codegraph @

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

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