Debian Codegraph @

mysql-test/suite/perfschema/r/innodb_data_locks2.result

raw
1
2 Bug #28176805 PERFORMANCE_SCHEMA.DATA_LOCKS.LOCK_MODE
3 DOES NOT RECOGNIZE LOCK_REC_NOT_GAP
4
5 CREATE TABLE t1 (id INT PRIMARY KEY) Engine=InnoDB;
6 INSERT INTO t1 VALUES (0),(10),(20),(30);
7 CREATE TABLE t2 (id INT PRIMARY KEY AUTO_INCREMENT, val INT) Engine=InnoDB;
8 BEGIN;
9 SELECT * FROM t1 WHERE id=10 FOR SHARE;
10 id
11 10
12 INSERT INTO t1 VALUES (5);
13 SELECT * FROM t1 WHERE id=25 FOR SHARE;
14 id
15 SELECT * FROM t1 WHERE id=22 FOR UPDATE;
16 id
17 SELECT * FROM t1 where id>=10 and id<=20 FOR SHARE;
18 id
19 10
20 20
21 SELECT * FROM t1 WHERE id>20 FOR UPDATE;
22 id
23 30
24 BEGIN;
25 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C2_will_wait';
26 INSERT INTO t1 VALUES (21);
27 SET DEBUG_SYNC = 'now WAIT_FOR C2_will_wait';
28 BEGIN;
29 SHOW VARIABLES LIKE 'innodb_autoinc_lock_mode';
30 Variable_name Value
31 innodb_autoinc_lock_mode 0
32 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C3_will_wait';
33 INSERT INTO t2 (val) SELECT id FROM t1 WHERE id>=0 AND id< 10;;
34 SET DEBUG_SYNC = 'now WAIT_FOR C3_will_wait';
35 BEGIN;
36 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C4_will_wait';
37 INSERT INTO t1 VALUES (35);
38 SET DEBUG_SYNC = 'now WAIT_FOR C4_will_wait';
39 SELECT
40 object_name,
41 index_name,
42 lock_type,
43 lock_mode,
44 lock_status,
45 lock_data
46 FROM performance_schema.data_locks
47 ORDER BY 1,2,3,4,5,6;
48 object_name index_name lock_type lock_mode lock_status lock_data
49 t1 NULL TABLE IS GRANTED NULL
50 t1 NULL TABLE IS GRANTED NULL
51 t1 NULL TABLE IX GRANTED NULL
52 t1 NULL TABLE IX GRANTED NULL
53 t1 NULL TABLE IX GRANTED NULL
54 t1 PRIMARY RECORD S GRANTED 20
55 t1 PRIMARY RECORD S WAITING 5
56 t1 PRIMARY RECORD S,GAP GRANTED 30
57 t1 PRIMARY RECORD S,REC_NOT_GAP GRANTED 0
58 t1 PRIMARY RECORD S,REC_NOT_GAP GRANTED 10
59 t1 PRIMARY RECORD X GRANTED 30
60 t1 PRIMARY RECORD X GRANTED supremum pseudo-record
61 t1 PRIMARY RECORD X,GAP GRANTED 30
62 t1 PRIMARY RECORD X,GAP,INSERT_INTENTION WAITING 30
63 t1 PRIMARY RECORD X,INSERT_INTENTION WAITING supremum pseudo-record
64 t1 PRIMARY RECORD X,REC_NOT_GAP GRANTED 5
65 t2 NULL TABLE AUTO_INC GRANTED NULL
66 t2 NULL TABLE IX GRANTED NULL
67 ROLLBACK;
68 ROLLBACK;
69 ROLLBACK;
70 ROLLBACK;
71 DROP TABLE t1;
72 DROP TABLE t2;