Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.events_stages_summary_by_host_by_event_name
5 where event_name like 'stage/%' limit 1;
6
7 select * from performance_schema.events_stages_summary_by_host_by_event_name
8 where event_name='FOO';
9 --enable_result_log
10
11 --error ER_TABLEACCESS_DENIED_ERROR
12 insert into performance_schema.events_stages_summary_by_host_by_event_name
13 set event_name='FOO', thread_id=1,
14 count_star=1, sum_timer_wait=2, min_timer_wait=3,
15 avg_timer_wait=4, max_timer_wait=5;
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 update performance_schema.events_stages_summary_by_host_by_event_name
19 set count_star=12;
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 update performance_schema.events_stages_summary_by_host_by_event_name
23 set count_star=12 where event_name like "FOO";
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 delete from performance_schema.events_stages_summary_by_host_by_event_name
27 where count_star=1;
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 delete from performance_schema.events_stages_summary_by_host_by_event_name;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.events_stages_summary_by_host_by_event_name READ;
34 UNLOCK TABLES;
35
36 -- error ER_TABLEACCESS_DENIED_ERROR
37 LOCK TABLES performance_schema.events_stages_summary_by_host_by_event_name WRITE;
38 UNLOCK TABLES;
39