Debian Codegraph @

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

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