Debian Codegraph @

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

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