Debian Codegraph @

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

raw
1 #
2 # Test two transactions on separate nodes which conflict on a FK
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE parent (
9 id INT PRIMARY KEY,
10 KEY (id)
11 ) ENGINE=InnoDB;
12
13 CREATE TABLE child (
14 id INT PRIMARY KEY,
15 parent_id INT,
16 FOREIGN KEY (parent_id)
17 REFERENCES parent(id)
18 ) ENGINE=InnoDB;
19
20 INSERT INTO parent VALUES (1), (2);
21 INSERT INTO child VALUES (1,1);
22
23 --connection node_1
24 SET AUTOCOMMIT = OFF;
25 START TRANSACTION;
26 DELETE FROM parent WHERE id = 2;
27
28 --connection node_2
29 SET AUTOCOMMIT = OFF;
30 START TRANSACTION;
31 INSERT INTO child VALUES (2, 2);
32
33 --connection node_1
34 COMMIT;
35
36 --connection node_2
37 --error ER_LOCK_DEADLOCK
38 COMMIT;
39
40 DROP TABLE child;
41 DROP TABLE parent;