Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY, c2 INT NOT NULL, c3 INT NOT NULL) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES (0, 0, 0);
3
4 # On connection 1
5 START TRANSACTION;
6 SELECT c1, c2 FROM t1 WHERE c1=0 LOCK IN SHARE MODE;
7 c1 c2
8 0 0
9
10 # On connection 2
11 START TRANSACTION;
12 SELECT c3, c2 FROM t1 WHERE c1=0 LOCK IN SHARE MODE;
13 c3 c2
14 0 0
15
16 # On connection 3
17 include/start_transaction_high_prio.inc
18 START TRANSACTION /* HIGH PRIORITY */;
19 UPDATE t1 SET c1=3 WHERE c1=0;
20 COMMIT;
21
22 # On connection 1
23 COMMIT;
24 ERROR HY000: Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT
25
26 # On connection 2
27 COMMIT;
28 ERROR HY000: Got error 149 - 'Lock deadlock; Retry transaction' during COMMIT
29 include/assert.inc ['There is a 3.0.0 in t1']
30 include/assert.inc ['There is no 0.0.0 in t1']
31 DROP TABLE t1;