Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5 --source include/have_timer_cycle.inc
6
7 --replace_column 2 <frequency> 3 <resolution> 4 <overhead>
8 select * from performance_schema.performance_timers;
9
10 --replace_column 2 <frequency> 3 <resolution> 4 <overhead>
11 select * from performance_schema.performance_timers
12 where timer_name='CYCLE';
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.performance_timers
16 set timer_name='FOO', timer_frequency=1,
17 timer_resolution=2, timer_overhead=3;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 update performance_schema.performance_timers
21 set timer_frequency=12 where timer_name='CYCLE';
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 delete from performance_schema.performance_timers;
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 delete from performance_schema.performance_timers
28 where timer_name='CYCLE';
29
30 -- error ER_TABLEACCESS_DENIED_ERROR
31 LOCK TABLES performance_schema.performance_timers READ;
32 UNLOCK TABLES;
33
34 -- error ER_TABLEACCESS_DENIED_ERROR
35 LOCK TABLES performance_schema.performance_timers WRITE;
36 UNLOCK TABLES;
37
38 --echo #
39 --echo # MDEV-25325 column_comment for performance_schema tables
40 --echo #
41 select column_name, column_comment
42 from information_schema.columns
43 where table_schema='performance_schema' and table_name='performance_timers';