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