Debian Codegraph @

mysql-test/suite/perfschema/r/ddl_setup_actors.result

raw
1 alter table performance_schema.setup_actors add column foo integer;
2 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
3 drop table if exists test.setup_actors;
4 create table test.setup_actors as
5 select * from performance_schema.setup_actors;
6 truncate table performance_schema.setup_actors;
7 select count(*) from performance_schema.setup_actors;
8 count(*)
9 0
10 insert into performance_schema.setup_actors
11 select * from test.setup_actors;
12 drop table test.setup_actors;
13 ALTER TABLE performance_schema.setup_actors ADD INDEX test_index(HOST);
14 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
15 CREATE UNIQUE INDEX test_index ON performance_schema.setup_actors(HOST);
16 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
17 ALTER TABLE performance_schema.setup_actors ADD KEY ENA(ENABLED);
18 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
19 DROP INDEX `PRIMARY`
20 ON performance_schema.setup_actors;
21 ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema'
22 CREATE TABLE test.create_select
23 AS SELECT * from performance_schema.setup_actors;
24 DROP TABLE test.create_select;