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