Debian Codegraph @

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

raw
1 --disable_result_log
2 SELECT * FROM performance_schema.keyring_keys
3 LIMIT 1;
4
5 SELECT * FROM performance_schema.keyring_keys
6 where KEY_ID='FOO' OR KEY_OWNER='BAR';
7 --enable_result_log
8
9 --error ER_TABLEACCESS_DENIED_ERROR
10 INSERT INTO performance_schema.keyring_keys
11 SET KEY_ID='FOO', KEY_OWNER='BAR';
12
13 --error ER_TABLEACCESS_DENIED_ERROR
14 UPDATE performance_schema.keyring_keys
15 SET KEY_ID='FOO';
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 UPDATE performance_schema.keyring_keys
19 SET KEY_ID='FOO' WHERE KEY_OWNER='BAR';
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 DELETE FROM performance_schema.keyring_keys
23 WHERE KEY_OWNER='BAR';
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 DELETE FROM performance_schema.keyring_keys;
27
28 -- error ER_TABLEACCESS_DENIED_ERROR
29 LOCK TABLES performance_schema.keyring_keys READ;
30 UNLOCK TABLES;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.keyring_keys WRITE;
34 UNLOCK TABLES;