Debian Codegraph @

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

raw
1 --disable_query_log
2 call mtr.add_suppression("No suitable 'keyring_component_metadata_query' service implementation found to fulfill the request.");
3 --enable_query_log
4
5 --disable_result_log
6 SELECT * FROM performance_schema.keyring_component_status
7 LIMIT 1;
8
9 SELECT * FROM performance_schema.keyring_component_status
10 where STATUS_KEY ='FOO' OR STATUS_VALUE ='BAR';
11 --enable_result_log
12
13 --error ER_TABLEACCESS_DENIED_ERROR
14 INSERT INTO performance_schema.keyring_component_status
15 SET CHANNEL='FOO', PROPERTY='BAR', VALUE='BAZ';
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 UPDATE performance_schema.keyring_component_status
19 SET STATUS_KEY='FOO';
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 UPDATE performance_schema.keyring_component_status
23 SET STATUS_KEY ='FOO' OR STATUS_VALUE ='BAR';
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 DELETE FROM performance_schema.keyring_component_status
27 WHERE STATUS_VALUE='BAR';
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 DELETE FROM performance_schema.keyring_component_status;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.keyring_component_status READ;
34 UNLOCK TABLES;
35
36 -- error ER_TABLEACCESS_DENIED_ERROR
37 LOCK TABLES performance_schema.keyring_component_status WRITE;
38 UNLOCK TABLES;