Debian Codegraph @

mysql-test/suite/perfschema/t/dml_ews_by_account_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 --replace_column 1 # 2 # 3 # 4 # 5 # 6 # 7 # 8 #
7 select * from performance_schema.events_waits_summary_by_account_by_event_name
8 where event_name like 'Wait/Synch/%' limit 1;
9
10 select * from performance_schema.events_waits_summary_by_account_by_event_name
11 where event_name='FOO';
12
13 --error ER_TABLEACCESS_DENIED_ERROR
14 insert into performance_schema.events_waits_summary_by_account_by_event_name
15 set event_name='FOO', user='BAR', host='BAZ',
16 count_star=1, sum_timer_wait=2, min_timer_wait=3,
17 avg_timer_wait=4, max_timer_wait=5;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 update performance_schema.events_waits_summary_by_account_by_event_name
21 set count_star=12;
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 update performance_schema.events_waits_summary_by_account_by_event_name
25 set count_star=12 where event_name like "FOO";
26
27 --error ER_TABLEACCESS_DENIED_ERROR
28 delete from performance_schema.events_waits_summary_by_account_by_event_name
29 where count_star=1;
30
31 --error ER_TABLEACCESS_DENIED_ERROR
32 delete from performance_schema.events_waits_summary_by_account_by_event_name;
33
34 -- error ER_TABLEACCESS_DENIED_ERROR
35 LOCK TABLES performance_schema.events_waits_summary_by_account_by_event_name READ;
36 UNLOCK TABLES;
37
38 -- error ER_TABLEACCESS_DENIED_ERROR
39 LOCK TABLES performance_schema.events_waits_summary_by_account_by_event_name WRITE;
40 UNLOCK TABLES;
41
42 --echo #
43 --echo # MDEV-25325 column_comment for performance_schema tables
44 --echo #
45 select column_name, column_comment
46 from information_schema.columns
47 where table_schema='performance_schema' and table_name='events_waits_summary_by_account_by_event_name';