Debian Codegraph @

mysql-test/suite/perfschema/t/ddl_replication_group_members.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_group_members.
5
6 --error ER_DBACCESS_DENIED_ERROR
7 ALTER TABLE performance_schema.replication_group_members
8 ADD COLUMN foo INTEGER;
9
10 -- error ER_TABLEACCESS_DENIED_ERROR
11 TRUNCATE TABLE performance_schema.replication_group_members;
12
13 --error ER_DBACCESS_DENIED_ERROR
14 ALTER TABLE performance_schema.replication_group_members
15 ADD INDEX test_index(Member_Id);
16
17 --error ER_DBACCESS_DENIED_ERROR
18 CREATE UNIQUE INDEX test_index
19 ON performance_schema.replication_group_members(Member_Id);
20
21 -- error ER_DBACCESS_DENIED_ERROR
22 DROP INDEX `PRIMARY`
23 ON performance_schema.replication_group_members;
24
25 CREATE TABLE test.create_select
26 AS SELECT * from performance_schema.replication_group_members;
27
28 DROP TABLE test.create_select;