Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.data_locks;
5 --enable_result_log
6
7 select * from performance_schema.data_locks
8 where object_name='foo';
9
10 --error ER_TABLEACCESS_DENIED_ERROR
11 insert into performance_schema.data_locks
12 set object_name='FOO', thread_id=1;
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 update performance_schema.data_locks
16 set thread_id=12 where object_name='foo';
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 delete from performance_schema.data_locks;
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 delete from performance_schema.data_locks
23 where lock_mode='CYCLE';
24
25 -- error ER_TABLEACCESS_DENIED_ERROR
26 LOCK TABLES performance_schema.data_locks READ;
27 UNLOCK TABLES;
28
29 -- error ER_TABLEACCESS_DENIED_ERROR
30 LOCK TABLES performance_schema.data_locks WRITE;
31 UNLOCK TABLES;
32