Debian Codegraph @

mysql-test/suite/innodb/r/lock-inherit-existing.result

raw
1 CREATE TABLE t1 (id INT PRIMARY KEY);
2 INSERT INTO t1 (id) VALUES (1),(2), (4),(5);
3 ANALYZE TABLE t1;
4 Table Op Msg_type Msg_text
5 test.t1 analyze status OK
6 BEGIN;
7 DELETE FROM t1 WHERE id=2;
8 BEGIN;
9 SELECT * FROM t1 FORCE INDEX (PRIMARY) WHERE id=3 FOR SHARE;
10 id
11 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL c2_will_wait WAIT_FOR c2_can_go';
12 SELECT * FROM t1 FORCE INDEX (PRIMARY) WHERE id=2 FOR SHARE;
13 SET DEBUG_SYNC = 'now WAIT_FOR c2_will_wait';
14 SELECT trx_id
15 FROM information_schema.innodb_trx
16 WHERE trx_query =
17 'SELECT * FROM t1 FORCE INDEX (PRIMARY) WHERE id=2 FOR SHARE'
18 INTO @c2_trx_id;
19 COMMIT;
20 SET DEBUG_SYNC = 'now SIGNAL c2_can_go';
21 DROP TABLE t1;