1--source include/galera_cluster.inc
2--source include/have_innodb.inc
3
4CREATE TABLE parent (
5    id INT NOT NULL,
6    PRIMARY KEY (id)
7) ENGINE=InnoDB;
8
9CREATE 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
18INSERT INTO parent VALUES (1),(2);
19INSERT INTO child VALUES (1,1),(2,2);
20
21--connection node_2
22DELETE FROM parent WHERE id = 1;
23SELECT parent_id IS NULL FROM child WHERE id = 1;
24
25--connection node_1
26SELECT parent_id IS NULL FROM child WHERE id = 1;
27
28UPDATE parent SET id = 3 WHERE id = 2;
29SELECT parent_id IS NULL FROM child WHERE id = 2;
30
31--connection node_2
32SELECT parent_id IS NULL FROM child WHERE id = 2;
33
34--connection node_1
35DROP TABLE child;
36DROP TABLE parent;
37