Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE parent (
4 id INT,
5 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 CASCADE
13 ON DELETE CASCADE
14 ) ENGINE=InnoDB;
15 INSERT INTO parent VALUES (1), (1), (2), (2);
16 INSERT INTO child VALUES (1,1), (2,2), (1,1), (2,2);
17 connection node_2;
18 DELETE FROM parent WHERE id = 1;
19 SELECT COUNT(*) = 0 FROM child WHERE id = 1;
20 COUNT(*) = 0
21 1
22 connection node_1;
23 UPDATE parent SET id = 3 WHERE id = 2;
24 connection node_2;
25 SELECT COUNT(*) = 0 FROM child WHERE parent_id = 1;
26 COUNT(*) = 0
27 1
28 SELECT parent_id = 3 FROM child WHERE id = 2;
29 parent_id = 3
30 1
31 1
32 DROP TABLE child;
33 DROP TABLE parent;