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 --disable_result_log
4 SELECT * FROM performance_schema.replication_group_members
5 LIMIT 1;
6
7 SELECT * FROM performance_schema.replication_group_members
8 WHERE channel_name='FOO';
9 --enable_result_log
10
11 --error ER_TABLEACCESS_DENIED_ERROR
12 INSERT INTO performance_schema.replication_group_members
13 SET channel_name='FOO', member_id=1;
14
15 --error ER_TABLEACCESS_DENIED_ERROR
16 UPDATE performance_schema.replication_group_members
17 SET member_id=12;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 UPDATE performance_schema.replication_group_members
21 SET member_id=12 WHERE channel_name LIKE "FOO";
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 DELETE FROM performance_schema.replication_group_members
25 WHERE member_id=1;
26
27 --error ER_TABLEACCESS_DENIED_ERROR
28 DELETE FROM performance_schema.replication_group_members;
29
30 --error ER_TABLEACCESS_DENIED_ERROR
31 LOCK TABLES performance_schema.replication_group_members READ;
32 UNLOCK TABLES;
33
34 --error ER_TABLEACCESS_DENIED_ERROR
35 LOCK TABLES performance_schema.replication_group_members WRITE;
36 UNLOCK TABLES;