Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_fk_conflict.test

raw
1 #
2 # Test Foreign Key with SR
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE grandparent (
9 id INT NOT NULL PRIMARY KEY
10 ) ENGINE=InnoDB;
11
12 CREATE TABLE parent (
13 id INT NOT NULL PRIMARY KEY,
14 grandparent_id INT,
15 FOREIGN KEY (grandparent_id)
16 REFERENCES grandparent(id)
17 ON UPDATE CASCADE
18 ) ENGINE=InnoDB;
19
20 CREATE TABLE child (
21 id INT NOT NULL PRIMARY KEY,
22 grandparent_id INT,
23 FOREIGN KEY (grandparent_id)
24 REFERENCES parent(grandparent_id)
25 ON UPDATE CASCADE
26 ) ENGINE=InnoDB;
27
28 INSERT INTO grandparent VALUES (1),(2),(3),(4);
29 INSERT INTO parent VALUES (1,1), (2,2);
30 INSERT INTO child VALUES (1,1), (2,2);
31
32 # Start and SR transaction
33
34 --connection node_1
35 SET AUTOCOMMIT=OFF;
36 SET SESSION wsrep_trx_fragment_size = 1;
37 START TRANSACTION;
38
39 UPDATE grandparent SET id = 5 WHERE id = 1;
40
41 # No conflicting transactions are allowed to proceed on slave
42
43 --connection node_2
44 SET SESSION innodb_lock_wait_timeout = 1;
45
46 --error ER_LOCK_WAIT_TIMEOUT
47 UPDATE grandparent SET id = 10 WHERE id = 5;
48
49 --error ER_LOCK_WAIT_TIMEOUT
50 DELETE FROM child;
51
52 # SR transaction succesffull
53
54 --connection node_1
55 COMMIT;
56
57 --let $diff_servers = 1 2
58 --source include/diff_servers.inc
59
60 DROP TABLE child;
61 DROP TABLE parent;
62 DROP TABLE grandparent;