Debian Codegraph @

mysql-test/suite/perfschema/t/ddl_replication_applier_status_by_worker.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_by_worker.
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_by_worker
11 add column foo integer;
12
13 -- error ER_WRONG_PERFSCHEMA_USAGE
14 TRUNCATE TABLE performance_schema.replication_applier_status_by_worker;
15
16 -- error ER_DBACCESS_DENIED_ERROR
17 ALTER TABLE performance_schema.replication_applier_status_by_worker
18 ADD INDEX test_index(worker_id);
19
20 -- error ER_DBACCESS_DENIED_ERROR
21 CREATE UNIQUE INDEX test_index ON
22 performance_schema.replication_applier_status_by_worker(worker_id);