Debian Codegraph @

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

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