Debian Codegraph @

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

raw
1 --let $N=16
2 --let $i=0
3 while($i<$N){
4 eval
5 CREATE TABLE t$i (
6 id INT NOT NULL PRIMARY KEY,
7 a INT NOT NULL,
8 b INT NOT NULL
9 );
10 --let $records=2
11 while($records<56){
12 --eval INSERT INTO t$i VALUES ($records,0,0)
13 --inc $records
14 }
15 --inc $i
16 }
17
18 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
19 BEGIN;
20 --let $i=0
21 while($i<$N){
22 --eval UPDATE t$i SET `a` = 1 WHERE `b`
23 --inc $i
24 }
25 SELECT LOCK_DATA
26 FROM performance_schema.data_locks
27 WHERE LOCK_TYPE = 'RECORD' AND OBJECT_SCHEMA = 'test';
28 COMMIT;
29
30 --let $i=0
31 while($i<$N){
32 --eval DROP TABLE t$i
33 --inc $i
34 }