Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 -- error ER_DBACCESS_DENIED_ERROR
4 alter table performance_schema.status_by_host
5 add column foo integer;
6
7 truncate table performance_schema.status_by_host;
8
9 -- error ER_DBACCESS_DENIED_ERROR
10 ALTER TABLE performance_schema.status_by_host
11 ADD INDEX test_index(VARIABLE_NAME);
12
13 -- error ER_DBACCESS_DENIED_ERROR
14 CREATE UNIQUE INDEX test_index
15 ON performance_schema.status_by_host(VARIABLE_NAME);
16
17 -- error ER_DBACCESS_DENIED_ERROR
18 DROP INDEX `HOST`
19 ON performance_schema.status_by_host;
20
21 CREATE TABLE test.create_select
22 AS SELECT * from performance_schema.status_by_host;
23
24 DROP TABLE test.create_select;