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