Debian Codegraph @

mysql-test/suite/innodb/t/high_prio_trx_fk.test

raw
1 # Scenario:
2 # T1=({R(PARENT), W(PARENT)})
3 # T2=({R(CHILD), W(CHILD), C}, HIGH_PRIORITY).
4 #
5 # Outcome: T1 must abort, T2 must commit.
6
7 --source include/count_sessions.inc
8
9 CREATE TABLE t1 (c1 INT PRIMARY KEY)ENGINE=INNODB;
10 CREATE TABLE t2 (c2 INT PRIMARY KEY,
11 FOREIGN KEY (c2) REFERENCES t1(c1))ENGINE=INNODB;
12 INSERT INTO t1 VALUES(1);
13
14 --connect(con1, localhost, root,,test)
15 --connect(con2, localhost, root,,test)
16
17 --echo # On Connection 1
18 --connection con1
19 START TRANSACTION;
20 DELETE FROM t1 WHERE c1 = 1;
21
22 --echo # On Connection 2
23 --connection con2
24 --source include/start_transaction_high_prio.inc
25 INSERT INTO t2 VALUES(1);
26 COMMIT;
27
28 --echo # On connection 1
29 --connection con1
30 --error ER_ERROR_DURING_COMMIT
31 COMMIT;
32 connection default;
33
34 DROP TABLE t2, t1;
35
36 # UPDATE CASCADE FOREIGN KEY CONSTRAINT
37
38 CREATE TABLE t1 (c1 INT PRIMARY KEY)ENGINE=INNODB;
39 CREATE TABLE t2 (c2 INT PRIMARY KEY,
40 FOREIGN KEY (c2) REFERENCES t1(c1)
41 ON UPDATE CASCADE)ENGINE=INNODB;
42 INSERT INTO t1 VALUES(1);
43
44 --echo # On Connection 1
45 --connection con1
46 START TRANSACTION;
47 UPDATE t1 SET C1=2 where C1 = 1;
48
49 --echo # On Connection 2
50 --connection con2
51 --source include/start_transaction_high_prio.inc
52 INSERT INTO t2 VALUES (1);
53 COMMIT;
54 --disconnect con2
55
56 --echo
57 --echo # On connection 1
58 --connection con1
59 --error ER_ERROR_DURING_COMMIT
60 COMMIT;
61 --disconnect con1
62 connection default;
63
64 DROP TABLE t2, t1;
65 --source include/wait_until_count_sessions.inc