Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_result_log
4 select * from performance_schema.host_cache
5 where IP like '%' limit 1;
6
7 select * from performance_schema.host_cache
8 where IP='localhost';
9 --enable_result_log
10
11 --error ER_TABLEACCESS_DENIED_ERROR
12 insert into performance_schema.host_cache
13 set IP='FOO', SUM_BLOCKING_ERRORS=1, COUNT_FCRDNS_ERRORS=2;
14
15 --error ER_TABLEACCESS_DENIED_ERROR
16 update performance_schema.host_cache
17 set COUNT_UNKNOWN_ERRORS=12;
18
19 --error ER_TABLEACCESS_DENIED_ERROR
20 update performance_schema.host_cache
21 set SUM_BLOCKING_ERRORS=12 where IP='127.0.0.1';
22
23 select HOST from performance_schema.host_cache
24 where IP='::1';
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 delete from performance_schema.host_cache
28 where IP='::1';
29
30 --error ER_TABLEACCESS_DENIED_ERROR
31 delete from performance_schema.host_cache;
32
33 --error ER_TABLEACCESS_DENIED_ERROR
34 LOCK TABLES performance_schema.host_cache READ;
35 UNLOCK TABLES;
36
37 --error ER_TABLEACCESS_DENIED_ERROR
38 LOCK TABLES performance_schema.host_cache WRITE;
39 UNLOCK TABLES;
40