Debian Codegraph @

mysql-test/suite/innodb/t/secondary_unique_index_range_locking.test

raw
1 CREATE TABLE t (
2 id INT PRIMARY KEY,
3 val INT UNIQUE KEY
4 );
5 INSERT INTO t (val,id) VALUES (10,4);
6 INSERT INTO t (val,id) VALUES (20,7);
7 --connect (read_view_holder, localhost, root,,)
8 BEGIN;
9 SELECT * FROM t;
10 # +----+------+
11 # | id | val |
12 # +----+------+
13 # | 4 | 10 |
14 # | 7 | 20 |
15 # +----+------+
16 --connection default
17 DELETE FROM t WHERE val=10; # delete-mark (val=10 --> id=4)
18 BEGIN;
19 INSERT INTO t (val,id) VALUES (10,3);
20
21 # Make sure that there is no "S" lock placed on val index val=20, id=7.
22 # There should be an "S,GAP" lock though, but LOCK_DATA may contain NULLs
23 # if a page is missing from BP or latched, so to avoid nondeterminism, we
24 # will simply count :
25 # how many "S" locks we have - there should be just one on the val=10,id=4
26 # how many "S,GAP" locks we have - there should be two, on 20,7 and 10,3 :
27 # +------------+-----------+-----------+-------------+-----------+
28 # | INDEX_NAME | LOCK_TYPE | LOCK_MODE | LOCK_STATUS | LOCK_DATA |
29 # +------------+-----------+-----------+-------------+-----------+
30 # | NULL | TABLE | IX | GRANTED | NULL |
31 # | val | RECORD | S | GRANTED | 10, 4 |
32 # | val | RECORD | S,GAP | GRANTED | 20, 7 |
33 # | val | RECORD | S,GAP | GRANTED | 10, 3 |
34 # +------------+-----------+-----------+-------------+-----------+
35 --sorted_result
36 SELECT LOCK_MODE, COUNT(*)
37 FROM performance_schema.data_locks
38 WHERE OBJECT_SCHEMA='test'
39 AND OBJECT_NAME='t'
40 AND INDEX_NAME='val'
41 AND LOCK_TYPE='RECORD'
42 GROUP BY 1;
43 ROLLBACK;
44
45 --connection read_view_holder
46 ROLLBACK;
47 --connection default
48 --disconnect read_view_holder
49 DROP TABLE t;