Debian Codegraph @

mysql-test/suite/perfschema/t/dml_replication_connection_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_connection_configuration.
5 --disable_result_log
6 SELECT * FROM performance_schema.replication_connection_configuration
7 LIMIT 1;
8
9 SELECT * FROM performance_schema.replication_connection_configuration
10 WHERE user='FOO' or host='BAR';
11 --enable_result_log
12
13 --error ER_TABLEACCESS_DENIED_ERROR
14 INSERT INTO performance_schema.replication_connection_configuration
15 SET user='FOO', host='BAR',
16 port=1, connection_retry_count=2;
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 UPDATE performance_schema.replication_connection_configuration
20 SET connection_retry_interval=12;
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 UPDATE performance_schema.replication_connection_configuration
24 SET connection_retry_interval=12 WHERE host LIKE "FOO";
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 DELETE FROM performance_schema.replication_connection_configuration
28 WHERE connection_retry_count=1;
29
30 --error ER_TABLEACCESS_DENIED_ERROR
31 DELETE FROM performance_schema.replication_connection_configuration;
32
33 -- error ER_TABLEACCESS_DENIED_ERROR
34 LOCK TABLES performance_schema.replication_connection_configuration READ;
35 UNLOCK TABLES;
36
37 -- error ER_TABLEACCESS_DENIED_ERROR
38 LOCK TABLES performance_schema.replication_connection_configuration WRITE;
39 UNLOCK TABLES;