Debian Codegraph @

mysql-test/suite/perfschema/t/dml_log_status.test

raw
1 # ==== Purpose ====
2 #
3 # Tests for PERFORMANCE_SCHEMA
4 #
5 # This test verifies the correct behaviour in case of invalid
6 # usage of DMLs on the table log_status.
7 #
8 # ==== References ====
9 #
10 # WL#9452: Log Position Lock
11 #
12
13 --disable_result_log
14 SELECT * FROM performance_schema.log_status
15 LIMIT 1;
16 --enable_result_log
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 INSERT INTO performance_schema.log_status
20 SET server_uuid='ABC123';
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 UPDATE performance_schema.log_status
24 SET server_uuid='ABC123' WHERE server_uuid=@@server_uuid;
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 DELETE FROM performance_schema.log_status
28 WHERE server_uuid=@@server_uuid;
29
30 --error ER_TABLEACCESS_DENIED_ERROR
31 DELETE FROM performance_schema.log_status;
32
33 -- error ER_TABLEACCESS_DENIED_ERROR
34 LOCK TABLES performance_schema.log_status READ;
35 UNLOCK TABLES;
36
37 -- error ER_TABLEACCESS_DENIED_ERROR
38 LOCK TABLES performance_schema.log_status WRITE;
39 UNLOCK TABLES;