Debian Codegraph @

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

raw
1 # This test verifies the correct behaviour in case of invalid
2 # usage of DMLs on the table replication_group_members.
3
4 --source include/not_embedded.inc
5 --source include/have_perfschema.inc
6
7 --disable_result_log
8 SELECT * FROM performance_schema.replication_group_members
9 LIMIT 1;
10
11 SELECT * FROM performance_schema.replication_group_members
12 WHERE channel_name='FOO';
13 --enable_result_log
14
15 --error ER_TABLEACCESS_DENIED_ERROR
16 INSERT INTO performance_schema.replication_group_members
17 SET channel_name='FOO', member_id=1;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 UPDATE performance_schema.replication_group_members
21 SET member_id=12;
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 UPDATE performance_schema.replication_group_members
25 SET member_id=12 WHERE channel_name LIKE "FOO";
26
27 --error ER_TABLEACCESS_DENIED_ERROR
28 DELETE FROM performance_schema.replication_group_members
29 WHERE member_id=1;
30
31 --error ER_TABLEACCESS_DENIED_ERROR
32 DELETE FROM performance_schema.replication_group_members;
33
34 --error ER_TABLEACCESS_DENIED_ERROR
35 LOCK TABLES performance_schema.replication_group_members READ;
36 UNLOCK TABLES;
37
38 --error ER_TABLEACCESS_DENIED_ERROR
39 LOCK TABLES performance_schema.replication_group_members WRITE;
40 UNLOCK TABLES;