Debian Codegraph @

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

raw
1 #
2 # Test foreign keys if no PK is present
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE parent (
9 id INT,
10 KEY (id)
11 ) ENGINE=InnoDB;
12
13 CREATE TABLE child (
14 id INT,
15 parent_id INT,
16 FOREIGN KEY (parent_id)
17 REFERENCES parent(id)
18 ON UPDATE CASCADE
19 ON DELETE CASCADE
20 ) ENGINE=InnoDB;
21
22 INSERT INTO parent VALUES (1), (1), (2), (2);
23 INSERT INTO child VALUES (1,1), (2,2), (1,1), (2,2);
24
25 --connection node_2
26 DELETE FROM parent WHERE id = 1;
27 SELECT COUNT(*) = 0 FROM child WHERE id = 1;
28
29 --connection node_1
30 UPDATE parent SET id = 3 WHERE id = 2;
31
32 --connection node_2
33 SELECT COUNT(*) = 0 FROM child WHERE parent_id = 1;
34 SELECT parent_id = 3 FROM child WHERE id = 2;
35
36 DROP TABLE child;
37 DROP TABLE parent;