Debian Codegraph @

mysql-test/suite/perfschema/t/ddl_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 --error ER_DBACCESS_DENIED_ERROR
9 alter table performance_schema.processlist
10 add column foo integer;
11
12 --error ER_WRONG_PERFSCHEMA_USAGE
13 truncate table performance_schema.processlist;
14
15 --error ER_DBACCESS_DENIED_ERROR
16 alter table performance_schema.processlist
17 add index test_index(info);
18
19 --error ER_DBACCESS_DENIED_ERROR
20 create unique index test_index
21 on performance_schema.processlist(host);
22
23 -- error ER_DBACCESS_DENIED_ERROR
24 drop index `PRIMARY`
25 on performance_schema.processlist;
26
27 CREATE TABLE test.create_select
28 AS SELECT * from performance_schema.processlist;
29
30 DROP TABLE test.create_select;
31
32 set @@global.performance_schema_show_processlist = @save_processlist;