Debian Codegraph @

mysql-test/suite/innodb/r/secondary_unique_index_range_locking.result

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 BEGIN;
8 SELECT * FROM t;
9 id val
10 4 10
11 7 20
12 DELETE FROM t WHERE val=10;
13 BEGIN;
14 INSERT INTO t (val,id) VALUES (10,3);
15 SELECT LOCK_MODE, COUNT(*)
16 FROM performance_schema.data_locks
17 WHERE OBJECT_SCHEMA='test'
18 AND OBJECT_NAME='t'
19 AND INDEX_NAME='val'
20 AND LOCK_TYPE='RECORD'
21 GROUP BY 1;
22 LOCK_MODE COUNT(*)
23 S 1
24 S,GAP 2
25 ROLLBACK;
26 ROLLBACK;
27 DROP TABLE t;