Debian Codegraph @

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

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