Debian Codegraph @

mysql-test/suite/perfschema/t/ddl_setup_actors.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_actors add column foo integer;
8
9 --disable_warnings
10 drop table if exists test.setup_actors;
11 --enable_warnings
12
13 create table test.setup_actors as
14 select * from performance_schema.setup_actors;
15
16 truncate table performance_schema.setup_actors;
17
18 select count(*) from performance_schema.setup_actors;
19
20 insert into performance_schema.setup_actors
21 select * from test.setup_actors;
22 drop table test.setup_actors;
23
24 -- error ER_DBACCESS_DENIED_ERROR
25 ALTER TABLE performance_schema.setup_actors ADD INDEX test_index(HOST);
26
27 -- error ER_DBACCESS_DENIED_ERROR
28 CREATE UNIQUE INDEX test_index ON performance_schema.setup_actors(HOST);
29
30 -- error ER_DBACCESS_DENIED_ERROR
31 ALTER TABLE performance_schema.setup_actors ADD KEY ENA(ENABLED);