Debian Codegraph @

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