Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 -- error ER_DBACCESS_DENIED_ERROR
4 alter table performance_schema.setup_actors add column foo integer;
5
6 --disable_warnings
7 drop table if exists test.setup_actors;
8 --enable_warnings
9
10 create table test.setup_actors as
11 select * from performance_schema.setup_actors;
12
13 truncate table performance_schema.setup_actors;
14
15 select count(*) from performance_schema.setup_actors;
16
17 insert into performance_schema.setup_actors
18 select * from test.setup_actors;
19 drop table test.setup_actors;
20
21 -- error ER_DBACCESS_DENIED_ERROR
22 ALTER TABLE performance_schema.setup_actors ADD INDEX test_index(HOST);
23
24 -- error ER_DBACCESS_DENIED_ERROR
25 CREATE UNIQUE INDEX test_index ON performance_schema.setup_actors(HOST);
26
27 -- error ER_DBACCESS_DENIED_ERROR
28 ALTER TABLE performance_schema.setup_actors ADD KEY ENA(ENABLED);
29
30 -- error ER_DBACCESS_DENIED_ERROR
31 DROP INDEX `PRIMARY`
32 ON performance_schema.setup_actors;
33
34 CREATE TABLE test.create_select
35 AS SELECT * from performance_schema.setup_actors;
36
37 DROP TABLE test.create_select;