Debian Codegraph @

mysql-test/suite/perfschema/r/dml_replication_applier_configuration.result

raw
1 SELECT * FROM performance_schema.replication_applier_configuration
2 LIMIT 1;
3 SELECT * FROM performance_schema.replication_applier_configuration
4 WHERE desired_delay=12;
5 SELECT * FROM performance_schema.replication_applier_configuration
6 WHERE privilege_checks_user=NULL;
7 SELECT * FROM performance_schema.replication_applier_configuration
8 WHERE require_row_format="NO";
9 SELECT * FROM performance_schema.replication_applier_configuration
10 WHERE require_table_primary_key_check="STREAM";
11 SELECT * FROM performance_schema.replication_applier_configuration
12 WHERE assign_gtids_to_anonymous_transactions_type="OFF";
13 SELECT * FROM performance_schema.replication_applier_configuration
14 WHERE assign_gtids_to_anonymous_transactions_value=NULL;
15 INSERT INTO performance_schema.replication_applier_configuration
16 SET desired_delay=2;
17 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
18 INSERT INTO performance_schema.replication_applier_configuration
19 SET privilege_checks_user="'user'@'%'";
20 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
21 INSERT INTO performance_schema.replication_applier_configuration
22 SET require_row_format="YES";
23 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
24 INSERT INTO performance_schema.replication_applier_configuration
25 SET require_table_primary_key_check="ON";
26 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
27 INSERT INTO performance_schema.replication_applier_configuration
28 SET assign_gtids_to_anonymous_transactions="LOCAL";
29 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
30 UPDATE performance_schema.replication_applier_configuration
31 SET desired_delay=12 WHERE desired_delay=2;
32 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
33 UPDATE performance_schema.replication_applier_configuration
34 SET privilege_checks_user="'user'@'%'" WHERE privilege_checks_user=NULL;
35 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
36 UPDATE performance_schema.replication_applier_configuration
37 SET require_row_format="YES" WHERE require_row_format="NO";
38 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
39 UPDATE performance_schema.replication_applier_configuration
40 SET require_table_primary_key_check="OFF" WHERE require_table_primary_key_check="STREAM";
41 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
42 UPDATE performance_schema.replication_applier_configuration
43 SET assign_gtids_to_anonymous_transactions="LOCAL" WHERE assign_gtids_to_anonymous_transactions="OFF";
44 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
45 DELETE FROM performance_schema.replication_applier_configuration
46 WHERE desired_delay=12;
47 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
48 DELETE FROM performance_schema.replication_applier_configuration
49 WHERE privilege_checks_user="'user'@'%'";
50 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
51 DELETE FROM performance_schema.replication_applier_configuration
52 WHERE require_row_format="NO";
53 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
54 DELETE FROM performance_schema.replication_applier_configuration
55 WHERE require_table_primary_key_check="STREAM";
56 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
57 DELETE FROM performance_schema.replication_applier_configuration
58 WHERE assign_gtids_to_anonymous_transactions_type="OFF";
59 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
60 DELETE FROM performance_schema.replication_applier_configuration
61 WHERE assign_gtids_to_anonymous_transactions_value="OFF";
62 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
63 DELETE FROM performance_schema.replication_applier_configuration;
64 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
65 LOCK TABLES performance_schema.replication_applier_configuration READ;
66 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
67 UNLOCK TABLES;
68 LOCK TABLES performance_schema.replication_applier_configuration WRITE;
69 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'replication_applier_configuration'
70 UNLOCK TABLES;