1# Tests for PERFORMANCE_SCHEMA
2
3--source include/not_embedded.inc
4--source include/have_perfschema.inc
5
6-- error ER_DBACCESS_DENIED_ERROR
7alter table performance_schema.setup_objects add column foo integer;
8
9--disable_warnings
10drop table if exists test.setup_objects;
11--enable_warnings
12
13create table test.setup_objects as
14  select * from performance_schema.setup_objects;
15
16truncate table performance_schema.setup_objects;
17
18select count(*) from performance_schema.setup_objects;
19
20insert into performance_schema.setup_objects
21  select * from test.setup_objects;
22drop table test.setup_objects;
23
24-- error ER_DBACCESS_DENIED_ERROR
25ALTER TABLE performance_schema.setup_objects ADD INDEX test_index(OBJECT_NAME);
26
27-- error ER_DBACCESS_DENIED_ERROR
28CREATE UNIQUE INDEX test_index ON performance_schema.setup_objects(OBJECT_NAME);
29
30