Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 select * from performance_schema.setup_consumers;
4
5 select * from performance_schema.setup_consumers
6 where name='events_waits_current';
7
8 select * from performance_schema.setup_consumers
9 where enabled='YES';
10
11 select * from performance_schema.setup_consumers
12 where enabled='NO';
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.setup_consumers
16 set name='FOO', enabled='YES';
17
18 --error ER_WRONG_PERFSCHEMA_USAGE
19 update performance_schema.setup_consumers
20 set name='FOO';
21
22 update performance_schema.setup_consumers
23 set enabled='YES';
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 delete from performance_schema.setup_consumers;
27
28 --error ER_TABLEACCESS_DENIED_ERROR
29 delete from performance_schema.setup_consumers
30 where name='events_waits_current';
31
32 LOCK TABLES performance_schema.setup_consumers READ;
33 UNLOCK TABLES;
34
35 LOCK TABLES performance_schema.setup_consumers WRITE;
36 UNLOCK TABLES;
37