Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5
6 select * from performance_schema.setup_consumers;
7
8 select * from performance_schema.setup_consumers
9 where name='events_waits_current';
10
11 select * from performance_schema.setup_consumers
12 where enabled='YES';
13
14 select * from performance_schema.setup_consumers
15 where enabled='NO';
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 insert into performance_schema.setup_consumers
19 set name='FOO', enabled='YES';
20
21 --error ER_WRONG_PERFSCHEMA_USAGE
22 update performance_schema.setup_consumers
23 set name='FOO';
24
25 update performance_schema.setup_consumers
26 set enabled='YES';
27
28 --error ER_TABLEACCESS_DENIED_ERROR
29 delete from performance_schema.setup_consumers;
30
31 --error ER_TABLEACCESS_DENIED_ERROR
32 delete from performance_schema.setup_consumers
33 where name='events_waits_current';
34
35 LOCK TABLES performance_schema.setup_consumers READ;
36 UNLOCK TABLES;
37
38 LOCK TABLES performance_schema.setup_consumers WRITE;
39 UNLOCK TABLES;
40
41 --echo #
42 --echo # MDEV-25325 column_comment for performance_schema tables
43 --echo #
44 select column_name, column_comment
45 from information_schema.columns
46 where table_schema='performance_schema' and table_name='setup_consumers';