Debian Codegraph @

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

raw
1 --echo #Test for Shared lock
2
3 -- connect (con1,localhost,root,,)
4 -- connect (con2,localhost,root,,)
5
6 --disable_warnings
7 drop table if exists t1;
8 --enable_warnings
9
10 --connection con1
11 create table t1 (id integer, x integer) engine=INNODB;
12 insert into t1 values(0, 0);
13 set autocommit=0;
14 lock table t1 READ;
15
16 --connection con2
17 select object_schema, object_name, lock_type, lock_mode, lock_status, lock_data from performance_schema.data_locks;
18
19 --connection con1
20 unlock tables;
21 drop table t1;
22
23 --disconnect con1
24 --disconnect con2