Debian Codegraph @

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

raw
1 Bug #28733170
2 PERFORMANCE_SCHEMA.DATA_LOCKS DOES NOT HANDLE JOINS CORRECTLY
3 CREATE TABLE t1(
4 id INT PRIMARY KEY
5 ) Engine=InnoDB;
6 INSERT INTO t1 VALUES (1);
7 BEGIN;
8 SELECT * FROM t1 WHERE id=1 FOR SHARE;
9 id
10 1
11 SELECT * FROM t1 WHERE id=1 FOR UPDATE;
12 id
13 1
14 BEGIN;
15 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL C1_will_wait';
16 SELECT * FROM t1 WHERE id=1 FOR UPDATE;
17 SET DEBUG_SYNC = 'now WAIT_FOR C1_will_wait';
18 CREATE TABLE t2 (
19 id INT PRIMARY KEY AUTO_INCREMENT,
20 lock_id VARCHAR(200) NOT NULL
21 ) Engine=InnoDB;
22 INSERT INTO t2 (lock_id)
23 SELECT blocking_engine_lock_id
24 FROM performance_schema.data_lock_waits;
25 SELECT COUNT(*) FROM t2;
26 COUNT(*)
27 2
28 SELECT COUNT(t2.id)
29 FROM t2
30 JOIN performance_schema.data_lock_waits dlw
31 ON(dlw.blocking_engine_lock_id = t2.lock_id)
32 ORDER BY t2.id;
33 COUNT(t2.id)
34 2
35 CREATE TABLE t3 (
36 id INT PRIMARY KEY AUTO_INCREMENT,
37 lock_id VARCHAR(200) NOT NULL
38 ) Engine=InnoDB;
39 INSERT INTO t3 (lock_id)
40 SELECT requesting_engine_lock_id
41 FROM performance_schema.data_lock_waits
42 LIMIT 1;
43 INSERT INTO t3 (lock_id)
44 SELECT requesting_engine_lock_id
45 FROM performance_schema.data_lock_waits
46 LIMIT 1;
47 SELECT COUNT(DISTINCT t3.id)
48 FROM t3
49 JOIN performance_schema.data_lock_waits dlw
50 ON(dlw.requesting_engine_lock_id = t3.lock_id)
51 ORDER BY t3.id;
52 COUNT(DISTINCT t3.id)
53 2
54 SELECT COUNT(*) FROM performance_schema.data_lock_waits;
55 COUNT(*)
56 2
57 SELECT COUNT(*)
58 FROM performance_schema.data_lock_waits
59 JOIN performance_schema.data_locks r
60 ON(r.engine_lock_id = requesting_engine_lock_id)
61 JOIN performance_schema.data_locks b
62 ON(b.engine_lock_id = blocking_engine_lock_id);
63 COUNT(*)
64 2
65 DROP TABLE t2;
66 DROP TABLE t3;
67 ROLLBACK;
68 DROP TABLE t1;