Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 # This test verifies the correct behaviour in case of invalid
4 # usage of DDLs on the table replication_applier_status
5
6 --source include/not_embedded.inc
7 --source include/have_perfschema.inc
8
9 -- error ER_DBACCESS_DENIED_ERROR
10 ALTER TABLE performance_schema.replication_applier_status
11 ADD COLUMN foo integer;
12
13 -- error ER_WRONG_PERFSCHEMA_USAGE
14 TRUNCATE TABLE performance_schema.replication_applier_status;
15
16 -- error ER_DBACCESS_DENIED_ERROR
17 ALTER TABLE performance_schema.replication_applier_status
18 ADD INDEX test_index(remaining_delay);
19
20 -- error ER_DBACCESS_DENIED_ERROR
21 CREATE UNIQUE INDEX test_index ON
22 performance_schema.replication_applier_status(remaining_delay);