Debian Codegraph @

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

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 CREATE TABLE parent(parent_id int not null AUTO_INCREMENT PRIMARY KEY,
5 parent_name varchar(80)) ENGINE=InnoDB;
6
7 CREATE TABLE child(child_id int not null AUTO_INCREMENT PRIMARY KEY,
8 child_name varchar(80),
9 child_parent_id int not null,
10 CONSTRAINT `fk_child_parent`
11 FOREIGN KEY (child_parent_id) REFERENCES parent (parent_id)
12 ON DELETE CASCADE
13 ON UPDATE CASCADE) ENGINE=InnoDB;
14
15 INSERT INTO parent VALUES (1, 'first'),(2,'second'),(3,'foo'),(4,'tmp');
16 INSERT INTO child VALUES (NULL,'first_child',1);
17 INSERT INTO child VALUES (NULL,'second_child',1);
18 INSERT INTO child VALUES (NULL,'first_child2',2);
19 INSERT INTO child VALUES (NULL,'first_child3',2);
20 INSERT INTO child VALUES (NULL,'first_child4',3);
21
22 BEGIN;
23 UPDATE parent SET parent_name = 'bar' WHERE parent_id = 2;
24
25 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
26 SET SESSION innodb_lock_wait_timeout=2;
27 --error ER_LOCK_WAIT_TIMEOUT
28 UPDATE child SET child_parent_id = 5 where child_parent_id = 2;
29
30 --connection node_1
31 COMMIT;
32 SELECT * FROM parent;
33 SELECT * FROM child;
34
35 --connection node_2
36
37 SELECT * FROM parent;
38 SELECT * FROM child;
39 DROP TABLE child, parent;
40
41 --disconnect node_1a