Debian Codegraph @

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

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