Debian Codegraph @

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

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