Debian Codegraph @

mysql-test/suite/perfschema/t/dml_replication_applier_configuration.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_configuration.
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_configuration
11 LIMIT 1;
12
13 sELECT * FROM performance_schema.replication_applier_configuration
14 WHERE desired_delay=12;
15 --enable_result_log
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 INSERT INTO performance_schema.replication_applier_configuration
19 SET desired_delay=2;
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 UPDATE performance_schema.replication_applier_configuration
23 SET desired_delay=12 WHERE desired_delay=2;
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 DELETE FROM performance_schema.replication_applier_configuration
27 WHERE desired_delay=12;
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 DELETE FROM performance_schema.replication_applier_configuration;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.replication_applier_configuration READ;
34 UNLOCK TABLES;
35
36 -- error ER_TABLEACCESS_DENIED_ERROR
37 LOCK TABLES performance_schema.replication_applier_configuration WRITE;
38 UNLOCK TABLES;