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 -- error ER_DBACCESS_DENIED_ERROR
7 ALTER TABLE performance_schema.replication_applier_status_by_worker
8 add column foo integer;
9
10 -- error ER_TABLEACCESS_DENIED_ERROR
11 TRUNCATE TABLE performance_schema.replication_applier_status_by_worker;
12
13 -- error ER_DBACCESS_DENIED_ERROR
14 ALTER TABLE performance_schema.replication_applier_status_by_worker
15 ADD INDEX test_index(worker_id);
16
17 -- error ER_DBACCESS_DENIED_ERROR
18 CREATE UNIQUE INDEX test_index ON
19 performance_schema.replication_applier_status_by_worker(worker_id);
20
21 -- error ER_DBACCESS_DENIED_ERROR
22 DROP INDEX `PRIMARY`
23 ON performance_schema.replication_applier_status_by_worker;
24
25 CREATE TABLE test.create_select
26 AS SELECT * from performance_schema.replication_applier_status_by_worker;
27
28 DROP TABLE test.create_select;