Debian Codegraph @

mysql-test/suite/perfschema/t/dml_replication_applier_status_by_worker.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_by_worker.
5
6 --disable_result_log
7 SELECT * FROM performance_schema.replication_applier_status_by_worker
8 LIMIT 1;
9
10 SELECT * FROM performance_schema.replication_applier_status_by_worker
11 WHERE service_state='YES' OR last_error_message='ERROR';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 INSERT INTO performance_schema.replication_applier_status_by_worker
16 SET service_state='YES', last_error_message='ERROR',
17 worker_id=1, thread_id=2, last_error_number=1234;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 UPDATE performance_schema.replication_applier_status_by_worker
21 SET worker_id=12;
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 UPDATE performance_schema.replication_applier_status_by_worker
25 SET worker_d=12 where service_state like "YES";
26
27 --error ER_TABLEACCESS_DENIED_ERROR
28 DELETE FROM performance_schema.replication_applier_status_by_worker
29 WHERE worker_id=1;
30
31 --error ER_TABLEACCESS_DENIED_ERROR
32 DELETE FROM performance_schema.replication_applier_status_by_worker;
33
34 -- error ER_TABLEACCESS_DENIED_ERROR
35 LOCK TABLES performance_schema.replication_applier_status_by_worker READ;
36 UNLOCK TABLES;
37
38 -- error ER_TABLEACCESS_DENIED_ERROR
39 LOCK TABLES performance_schema.replication_applier_status_by_worker WRITE;
40 UNLOCK TABLES;