Debian Codegraph @

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

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