Debian Codegraph @

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

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