Debian Codegraph @

mysql-test/suite/perfschema/r/ddl_processlist.result

raw
1 select @@global.performance_schema_show_processlist into @save_processlist;
2 set @@global.performance_schema_show_processlist = 'on';
3 Warnings:
4 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
5 alter table performance_schema.processlist
6 add column foo integer;
7 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
8 truncate table performance_schema.processlist;
9 ERROR 42000: DROP command denied to user 'root'@'localhost' for table 'processlist'
10 alter table performance_schema.processlist
11 add index test_index(info);
12 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
13 create unique index test_index
14 on performance_schema.processlist(host);
15 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
16 drop index `PRIMARY`
17 on performance_schema.processlist;
18 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
19 CREATE TABLE test.create_select
20 AS SELECT * from performance_schema.processlist;
21 DROP TABLE test.create_select;
22 set @@global.performance_schema_show_processlist = @save_processlist;
23 Warnings:
24 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.