Debian Codegraph @

mysql-test/suite/perfschema/t/ddl_setup_objects.test

raw
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
7 alter table performance_schema.setup_objects add column foo integer;
8
9 --disable_warnings
10 drop table if exists test.setup_objects;
11 --enable_warnings
12
13 create table test.setup_objects as
14 select * from performance_schema.setup_objects;
15
16 truncate table performance_schema.setup_objects;
17
18 select count(*) from performance_schema.setup_objects;
19
20 insert into performance_schema.setup_objects
21 select * from test.setup_objects;
22 drop table test.setup_objects;
23
24 -- error ER_DBACCESS_DENIED_ERROR
25 ALTER TABLE performance_schema.setup_objects ADD INDEX test_index(OBJECT_NAME);
26
27 -- error ER_DBACCESS_DENIED_ERROR
28 CREATE UNIQUE INDEX test_index ON performance_schema.setup_objects(OBJECT_NAME);
29