mysql-test/suite/perfschema/t/ddl_host_cache.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.host_cache add column foo integer; |
| 8 | |
| 9 | truncate table performance_schema.host_cache; |
| 10 | |
| 11 | -- error ER_DBACCESS_DENIED_ERROR |
| 12 | ALTER TABLE performance_schema.host_cache ADD INDEX test_index(IP); |
| 13 | |
| 14 | -- error ER_DBACCESS_DENIED_ERROR |
| 15 | CREATE UNIQUE INDEX test_index ON performance_schema.host_cache(IP); |
| 16 |