Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5
6 --disable_result_log
7 select * from performance_schema.host_cache
8 where IP like '%' limit 1;
9
10 select * from performance_schema.host_cache
11 where IP='localhost';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.host_cache
16 set IP='FOO', SUM_BLOCKING_ERRORS=1, COUNT_FCRDNS_ERRORS=2;
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 update performance_schema.host_cache
20 set COUNT_UNKNOWN_ERRORS=12;
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 update performance_schema.host_cache
24 set SUM_BLOCKING_ERRORS=12 where IP='127.0.0.1';
25
26 select HOST from performance_schema.host_cache
27 where IP='::1';
28
29 --error ER_TABLEACCESS_DENIED_ERROR
30 delete from performance_schema.host_cache
31 where IP='::1';
32
33 --error ER_TABLEACCESS_DENIED_ERROR
34 delete from performance_schema.host_cache;
35
36 --error ER_TABLEACCESS_DENIED_ERROR
37 LOCK TABLES performance_schema.host_cache READ;
38 UNLOCK TABLES;
39
40 --error ER_TABLEACCESS_DENIED_ERROR
41 LOCK TABLES performance_schema.host_cache WRITE;
42 UNLOCK TABLES;
43
44 --echo #
45 --echo # MDEV-25325 column_comment for performance_schema tables
46 --echo #
47 select column_name, column_comment
48 from information_schema.columns
49 where table_schema='performance_schema' and table_name='host_cache';