Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE parent (
4 id1 INT,
5 id2 INT,
6 PRIMARY KEY (id1, id2) /* Multipart PK */
7 ) ENGINE=InnoDB;
8 CREATE TABLE child (
9 id INT PRIMARY KEY,
10 parent_id1 INT,
11 FOREIGN KEY (parent_id1)
12 REFERENCES parent(id1) /* FK is subset of PK above */
13 ON UPDATE CASCADE
14 ON DELETE CASCADE
15 ) ENGINE=InnoDB;
16 INSERT INTO parent VALUES (1, 2);
17 INSERT INTO child VALUES (1, 1);
18 connection node_2;
19 UPDATE parent SET id1 = 3 WHERE id1 = 1;
20 connection node_1;
21 SELECT COUNT(*) = 1 FROM child WHERE parent_id1 = 3;
22 COUNT(*) = 1
23 1
24 DELETE FROM parent WHERE id1 = 3;
25 connection node_2;
26 SELECT COUNT(*) = 0 FROM child WHERE parent_id1 = 3;
27 COUNT(*) = 0
28 1
29 DROP TABLE child;
30 DROP TABLE parent;