Debian Codegraph @

mysql-test/suite/perfschema/r/innodb_x_data_locks.result

raw
1 #Test for Exclusive lock
2 drop table if exists t1;
3 create table t1 (id integer, x integer) engine=INNODB;
4 insert into t1 values(0, 0);
5 SET autocommit=0;
6 lock table t1 WRITE;
7 use performance_schema;
8 SELECT object_schema, object_name, lock_type, lock_mode, lock_status, lock_data FROM data_locks;
9 object_schema object_name lock_type lock_mode lock_status lock_data
10 test t1 TABLE X GRANTED NULL
11 unlock tables;
12 drop table t1;