Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES (0);
3 # On connection 1
4 BEGIN;
5 SELECT * FROM t1 WHERE c1=0 FOR SHARE;
6 c1
7 0
8 # On connection 2
9 BEGIN;
10 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con2_will_wait';
11 SELECT * FROM t1 WHERE c1=0 FOR UPDATE;
12 # On connection 3
13 SET DEBUG_SYNC = 'now WAIT_FOR con2_will_wait';
14 include/start_transaction_high_prio.inc
15 START TRANSACTION /* HIGH PRIORITY */;
16 SELECT * FROM t1 WHERE c1=0 FOR SHARE;
17 c1
18 0
19 COMMIT;
20 # On connection 1
21 COMMIT;
22 # On connection 2
23 c1
24 0
25 COMMIT;
26 DROP TABLE t1;