Debian Codegraph @

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

raw
1 #
2 # Test the operation where the definition of the FK is different from the one of the underlying key
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE parent (
9 id1 INT,
10 id2 INT,
11 PRIMARY KEY (id1, id2) /* Multipart PK */
12 ) ENGINE=InnoDB;
13
14 CREATE TABLE child (
15 id INT PRIMARY KEY,
16 parent_id1 INT,
17 FOREIGN KEY (parent_id1)
18 REFERENCES parent(id1) /* FK is subset of PK above */
19 ON UPDATE CASCADE
20 ON DELETE CASCADE
21 ) ENGINE=InnoDB;
22
23 INSERT INTO parent VALUES (1, 2);
24 INSERT INTO child VALUES (1, 1);
25
26 --connection node_2
27 UPDATE parent SET id1 = 3 WHERE id1 = 1;
28
29 --connection node_1
30 SELECT COUNT(*) = 1 FROM child WHERE parent_id1 = 3;
31
32 DELETE FROM parent WHERE id1 = 3;
33
34 --connection node_2
35 SELECT COUNT(*) = 0 FROM child WHERE parent_id1 = 3;
36
37 DROP TABLE child;
38 DROP TABLE parent;