Debian Codegraph @

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