Debian Codegraph @

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

raw
1 --echo #Test for Exclusive 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 WRITE;
15
16 --connection con2
17 use performance_schema;
18 SELECT object_schema, object_name, lock_type, lock_mode, lock_status, lock_data FROM data_locks;
19
20 --connection con1
21 unlock tables;
22 drop table t1;
23
24 --disconnect con1
25 --disconnect con2