Debian Codegraph @

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

raw
1 CREATE TABLE t1 (id INT PRIMARY KEY);
2 INSERT INTO t1 VALUES (1);
3 BEGIN;
4 SELECT * FROM t1;
5 id
6 1
7 DELETE FROM t1 WHERE id=1;
8 BEGIN;
9 SELECT * FROM t1 FOR SHARE;
10 id
11 BEGIN;
12 SET DEBUG_SYNC = "lock_wait_will_wait SIGNAL con2_will_wait";
13 SELECT * FROM t1 FOR UPDATE;
14 SET DEBUG_SYNC = "now WAIT_FOR con2_will_wait";
15 INSERT INTO t1 VALUES (1);
16 SET DEBUG_SYNC = "lock_wait_will_wait SIGNAL con3_will_wait";
17 INSERT INTO t1 VALUES (0);
18 SET DEBUG_SYNC = "now WAIT_FOR con3_will_wait";
19 DROP TABLE t1;