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 --disable_result_log
7 SELECT * FROM performance_schema.replication_applier_configuration
8 LIMIT 1;
9
10 SELECT * FROM performance_schema.replication_applier_configuration
11 WHERE desired_delay=12;
12
13 SELECT * FROM performance_schema.replication_applier_configuration
14 WHERE privilege_checks_user=NULL;
15
16 SELECT * FROM performance_schema.replication_applier_configuration
17 WHERE require_row_format="NO";
18
19 SELECT * FROM performance_schema.replication_applier_configuration
20 WHERE require_table_primary_key_check="STREAM";
21
22 SELECT * FROM performance_schema.replication_applier_configuration
23 WHERE assign_gtids_to_anonymous_transactions_type="OFF";
24
25 SELECT * FROM performance_schema.replication_applier_configuration
26 WHERE assign_gtids_to_anonymous_transactions_value=NULL;
27 --enable_result_log
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 INSERT INTO performance_schema.replication_applier_configuration
31 SET desired_delay=2;
32
33 --error ER_TABLEACCESS_DENIED_ERROR
34 INSERT INTO performance_schema.replication_applier_configuration
35 SET privilege_checks_user="'user'@'%'";
36
37 --error ER_TABLEACCESS_DENIED_ERROR
38 INSERT INTO performance_schema.replication_applier_configuration
39 SET require_row_format="YES";
40
41 --error ER_TABLEACCESS_DENIED_ERROR
42 INSERT INTO performance_schema.replication_applier_configuration
43 SET require_table_primary_key_check="ON";
44
45 --error ER_TABLEACCESS_DENIED_ERROR
46 INSERT INTO performance_schema.replication_applier_configuration
47 SET assign_gtids_to_anonymous_transactions="LOCAL";
48
49 --error ER_TABLEACCESS_DENIED_ERROR
50 UPDATE performance_schema.replication_applier_configuration
51 SET desired_delay=12 WHERE desired_delay=2;
52
53 --error ER_TABLEACCESS_DENIED_ERROR
54 UPDATE performance_schema.replication_applier_configuration
55 SET privilege_checks_user="'user'@'%'" WHERE privilege_checks_user=NULL;
56
57 --error ER_TABLEACCESS_DENIED_ERROR
58 UPDATE performance_schema.replication_applier_configuration
59 SET require_row_format="YES" WHERE require_row_format="NO";
60
61 --error ER_TABLEACCESS_DENIED_ERROR
62 UPDATE performance_schema.replication_applier_configuration
63 SET require_table_primary_key_check="OFF" WHERE require_table_primary_key_check="STREAM";
64
65 --error ER_TABLEACCESS_DENIED_ERROR
66 UPDATE performance_schema.replication_applier_configuration
67 SET assign_gtids_to_anonymous_transactions="LOCAL" WHERE assign_gtids_to_anonymous_transactions="OFF";
68
69 --error ER_TABLEACCESS_DENIED_ERROR
70 DELETE FROM performance_schema.replication_applier_configuration
71 WHERE desired_delay=12;
72
73 --error ER_TABLEACCESS_DENIED_ERROR
74 DELETE FROM performance_schema.replication_applier_configuration
75 WHERE privilege_checks_user="'user'@'%'";
76
77 --error ER_TABLEACCESS_DENIED_ERROR
78 DELETE FROM performance_schema.replication_applier_configuration
79 WHERE require_row_format="NO";
80
81 --error ER_TABLEACCESS_DENIED_ERROR
82 DELETE FROM performance_schema.replication_applier_configuration
83 WHERE require_table_primary_key_check="STREAM";
84
85 --error ER_TABLEACCESS_DENIED_ERROR
86 DELETE FROM performance_schema.replication_applier_configuration
87 WHERE assign_gtids_to_anonymous_transactions_type="OFF";
88
89 --error ER_TABLEACCESS_DENIED_ERROR
90 DELETE FROM performance_schema.replication_applier_configuration
91 WHERE assign_gtids_to_anonymous_transactions_value="OFF";
92
93 --error ER_TABLEACCESS_DENIED_ERROR
94 DELETE FROM performance_schema.replication_applier_configuration;
95
96 -- error ER_TABLEACCESS_DENIED_ERROR
97 LOCK TABLES performance_schema.replication_applier_configuration READ;
98 UNLOCK TABLES;
99
100 -- error ER_TABLEACCESS_DENIED_ERROR
101 LOCK TABLES performance_schema.replication_applier_configuration WRITE;
102 UNLOCK TABLES;