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 --disable_result_log
7 SELECT * FROM performance_schema.replication_applier_status
8 LIMIT 1;
9
10 SELECT * FROM performance_schema.replication_applier_status
11 WHERE service_state='YES' OR remaining_delay=12;
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 INSERT INTO performance_schema.replication_applier_status
16 SET service_state='YES', remaining_delay=12;
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 UPDATE performance_schema.replication_applier_status
20 SET remaining_delay=12;
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 UPDATE performance_schema.replication_applier_status
24 SET remaining_delay=12 WHERE service_state='YES';
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 DELETE FROM performance_schema.replication_applier_status
28 WHERE service_state='YES';
29
30 --error ER_TABLEACCESS_DENIED_ERROR
31 DELETE FROM performance_schema.replication_applier_status;
32
33 -- error ER_TABLEACCESS_DENIED_ERROR
34 LOCK TABLES performance_schema.replication_applier_status READ;
35 UNLOCK TABLES;
36
37 -- error ER_TABLEACCESS_DENIED_ERROR
38 LOCK TABLES performance_schema.replication_applier_status WRITE;
39 UNLOCK TABLES;