Debian Codegraph @

mysql-test/suite/innodb/r/high_prio_trx_fk.result

raw
1 CREATE TABLE t1 (c1 INT PRIMARY KEY)ENGINE=INNODB;
2 CREATE TABLE t2 (c2 INT PRIMARY KEY,
3 FOREIGN KEY (c2) REFERENCES t1(c1))ENGINE=INNODB;
4 INSERT INTO t1 VALUES(1);
5 # On Connection 1
6 START TRANSACTION;
7 DELETE FROM t1 WHERE c1 = 1;
8 # On Connection 2
9 include/start_transaction_high_prio.inc
10 START TRANSACTION /* HIGH PRIORITY */;
11 INSERT INTO t2 VALUES(1);
12 COMMIT;
13 # On connection 1
14 COMMIT;
15 ERROR HY000: Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT
16 DROP TABLE t2, t1;
17 CREATE TABLE t1 (c1 INT PRIMARY KEY)ENGINE=INNODB;
18 CREATE TABLE t2 (c2 INT PRIMARY KEY,
19 FOREIGN KEY (c2) REFERENCES t1(c1)
20 ON UPDATE CASCADE)ENGINE=INNODB;
21 INSERT INTO t1 VALUES(1);
22 # On Connection 1
23 START TRANSACTION;
24 UPDATE t1 SET C1=2 where C1 = 1;
25 # On Connection 2
26 include/start_transaction_high_prio.inc
27 START TRANSACTION /* HIGH PRIORITY */;
28 INSERT INTO t2 VALUES (1);
29 COMMIT;
30
31 # On connection 1
32 COMMIT;
33 ERROR HY000: Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT
34 DROP TABLE t2, t1;