Debian Codegraph @

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

raw
1 #Test for Shared 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 READ;
7 select object_schema, object_name, lock_type, lock_mode, lock_status, lock_data from performance_schema.data_locks;
8 object_schema object_name lock_type lock_mode lock_status lock_data
9 test t1 TABLE S GRANTED NULL
10 unlock tables;
11 drop table t1;