Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4
5 select @@global.performance_schema_show_processlist into @save_processlist;
6 set @@global.performance_schema_show_processlist = 'on';
7
8 --disable_result_log
9 select * from performance_schema.processlist
10 where user like 'event_scheduler';
11
12 select * from performance_schema.processlist
13 where user = 'FOO';
14 --enable_result_log
15
16 --error ER_TABLEACCESS_DENIED_ERROR
17 insert into performance_schema.processlist
18 values (12, 'foo', 'bar', 'test', null, 1000, 'state', 'info');
19
20 --error ER_TABLEACCESS_DENIED_ERROR
21 update performance_schema.processlist
22 set id=12, user='foo';
23
24 --error ER_TABLEACCESS_DENIED_ERROR
25 delete from performance_schema.processlist
26 where id <> 99;
27
28 --error ER_TABLEACCESS_DENIED_ERROR
29 delete from performance_schema.processlist;
30
31 --error ER_TABLEACCESS_DENIED_ERROR
32 LOCK TABLES performance_schema.processlist READ;
33 UNLOCK TABLES;
34
35 --error ER_TABLEACCESS_DENIED_ERROR
36 LOCK TABLES performance_schema.processlist WRITE;
37 UNLOCK TABLES;
38
39 set @@global.performance_schema_show_processlist = @save_processlist;