Quelle  ddl_processlist.test  Sprache: unbekannt

# Tests for PERFORMANCE_SCHEMA

--source include/not_embedded.inc

select @@global.performance_schema_show_processlist into @save_processlist;
set @@global.performance_schema_show_processlist = 'on';

--error ER_DBACCESS_DENIED_ERROR
alter table performance_schema.processlist
  add column foo integer;

--error ER_WRONG_PERFSCHEMA_USAGE
truncate table performance_schema.processlist;

--error ER_DBACCESS_DENIED_ERROR
alter table performance_schema.processlist
  add index test_index(info);

--error ER_DBACCESS_DENIED_ERROR
create unique index test_index
  on performance_schema.processlist(host);

-- error ER_DBACCESS_DENIED_ERROR
drop index `PRIMARY`
  on performance_schema.processlist;

CREATE TABLE test.create_select
  AS SELECT * from performance_schema.processlist;

DROP TABLE test.create_select;

set @@global.performance_schema_show_processlist = @save_processlist;