Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2 # This test verifies the correct behaviour in case of invalid
3 # Usage of DDLs on the table replication_group_member_stats.
4
5 --error ER_DBACCESS_DENIED_ERROR
6 ALTER TABLE performance_schema.replication_group_member_stats
7 ADD COLUMN foo INTEGER;
8
9 -- error ER_TABLEACCESS_DENIED_ERROR
10 TRUNCATE TABLE performance_schema.replication_group_member_stats;
11
12 --error ER_DBACCESS_DENIED_ERROR
13 ALTER TABLE performance_schema.replication_group_member_stats
14 ADD INDEX test_index(Member_Id);
15
16 --error ER_DBACCESS_DENIED_ERROR
17 CREATE UNIQUE INDEX test_index
18 ON performance_schema.replication_group_member_stats(Member_Id);
19
20 -- error ER_DBACCESS_DENIED_ERROR
21 DROP INDEX `PRIMARY`
22 ON performance_schema.replication_group_member_stats;
23
24 CREATE TABLE test.create_select
25 AS SELECT * from performance_schema.replication_group_member_stats;
26
27 DROP TABLE test.create_select;