Debian Codegraph @

mysql-test/suite/perfschema/t/innodb_x_gap_data_locks.test

raw
1 --echo #Test for Exclusive, GAP locks
2
3 -- connect (con1,localhost,root,,)
4 -- connect (con2,localhost,root,,)
5 -- connect (con3,localhost,root,,)
6
7 --disable_warnings
8 drop table if exists t1_x_gap;
9 --enable_warnings
10
11 --connection con1
12 use test;
13 create table t1_x_gap (id int(10) primary key, x int(10)) engine=INNODB;
14 insert into t1_x_gap values (1,10),(2,20),(3,30),(4,40),(5,50);
15
16 start transaction;
17 select * from t1_x_gap where id<5 for update;
18
19 --connection con3
20 select object_schema, object_name, lock_type, lock_mode, lock_status, lock_data
21 from performance_schema.data_locks
22 where object_name="t1_x_gap"
23 order by lock_type, lock_mode, lock_status, lock_data;
24
25 --connection con2
26 start transaction;
27 -- send
28 insert into t1_x_gap values (0,0);
29
30 -- connection default
31 let $wait_condition= SELECT COUNT(*)>=1 FROM performance_schema.data_locks
32 where OBJECT_NAME='t1_x_gap' and LOCK_STATUS='WAITING';
33 --source include/wait_condition.inc
34
35 --connection con3
36 # Do not display LOCK_DATA, it can be NULL,
37 # upon eviction from the innodb buffer pool
38 select object_schema, object_name, lock_type, lock_mode, lock_status
39 from performance_schema.data_locks
40 where object_name="t1_x_gap"
41 order by lock_type, lock_mode, lock_status;
42
43 --connection con1
44 commit;
45
46 # Wait for the con2 waiting lock to be granted, now that con1 is gone.
47 -- connection default
48 let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.data_locks
49 where OBJECT_NAME='t1_x_gap' and LOCK_STATUS='WAITING';
50 --source include/wait_condition.inc
51
52 --connection con3
53 select object_schema, object_name, lock_type, lock_mode, lock_status
54 from performance_schema.data_locks
55 where object_name="t1_x_gap";
56
57 --connection con2
58 -- reap
59 commit;
60
61 --connection con1
62 drop table t1_x_gap;
63
64 --connection default
65 --disconnect con1
66 --disconnect con2
67 --disconnect con3
68
69 let $count_sessions= 1;
70 --source include/wait_until_count_sessions.inc