mirror of
https://github.com/MariaDB/server.git
synced 2025-02-13 17:05:35 +01:00
59dd58b17e
A few tests assumes that the CYCLE timer is always available, which is not true on some platforms (e.g. ARM). Fixing the tests not to reply on the CYCLE availability.
37 lines
1.1 KiB
Text
37 lines
1.1 KiB
Text
# Tests for PERFORMANCE_SCHEMA
|
|
|
|
--source include/not_embedded.inc
|
|
--source include/have_perfschema.inc
|
|
--source include/have_timer_cycle.inc
|
|
|
|
--replace_column 2 <frequency> 3 <resolution> 4 <overhead>
|
|
select * from performance_schema.performance_timers;
|
|
|
|
--replace_column 2 <frequency> 3 <resolution> 4 <overhead>
|
|
select * from performance_schema.performance_timers
|
|
where timer_name='CYCLE';
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
insert into performance_schema.performance_timers
|
|
set timer_name='FOO', timer_frequency=1,
|
|
timer_resolution=2, timer_overhead=3;
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
update performance_schema.performance_timers
|
|
set timer_frequency=12 where timer_name='CYCLE';
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
delete from performance_schema.performance_timers;
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
delete from performance_schema.performance_timers
|
|
where timer_name='CYCLE';
|
|
|
|
-- error ER_TABLEACCESS_DENIED_ERROR
|
|
LOCK TABLES performance_schema.performance_timers READ;
|
|
UNLOCK TABLES;
|
|
|
|
-- error ER_TABLEACCESS_DENIED_ERROR
|
|
LOCK TABLES performance_schema.performance_timers WRITE;
|
|
UNLOCK TABLES;
|
|
|