Debian Codegraph @

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

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