Debian Codegraph @

mysql-test/suite/perfschema/r/data_locks_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 CREATE TABLE t2 (
15 id INT PRIMARY KEY AUTO_INCREMENT,
16 lock_id VARCHAR(200) NOT NULL
17 ) Engine=InnoDB;
18 INSERT INTO t2 (lock_id)
19 SELECT engine_lock_id
20 FROM performance_schema.data_locks
21 WHERE object_name='t1';
22 SELECT COUNT(*) FROM t2;
23 COUNT(*)
24 4
25 SELECT COUNT(t2.id)
26 FROM t2
27 JOIN performance_schema.data_locks dl
28 ON(dl.engine_lock_id = t2.lock_id)
29 ORDER BY t2.id;
30 COUNT(t2.id)
31 4
32 DROP TABLE t2;
33 ROLLBACK;
34 DROP TABLE t1;