mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
39 lines
1.1 KiB
Text
39 lines
1.1 KiB
Text
# Tests for PERFORMANCE_SCHEMA
|
|
|
|
--source include/not_embedded.inc
|
|
|
|
select @@global.performance_schema_show_processlist into @save_processlist;
|
|
set @@global.performance_schema_show_processlist = 'on';
|
|
|
|
--disable_result_log
|
|
select * from performance_schema.processlist
|
|
where user like 'event_scheduler';
|
|
|
|
select * from performance_schema.processlist
|
|
where user = 'FOO';
|
|
--enable_result_log
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
insert into performance_schema.processlist
|
|
values (12, 'foo', 'bar', 'test', null, 1000, 'state', 'info');
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
update performance_schema.processlist
|
|
set id=12, user='foo';
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
delete from performance_schema.processlist
|
|
where id <> 99;
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
delete from performance_schema.processlist;
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
LOCK TABLES performance_schema.processlist READ;
|
|
UNLOCK TABLES;
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
LOCK TABLES performance_schema.processlist WRITE;
|
|
UNLOCK TABLES;
|
|
|
|
set @@global.performance_schema_show_processlist = @save_processlist;
|