1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
#
# Verify that query results are the same with and without indexes.
#
--source include/have_debug_sync.inc
#setup
let $select_column = SUM_CONNECT_ERRORS;
let $table = performance_schema.host_cache;
# Create an entry in the host_cache
# [Warning] IP address '192.0.2.4' could not be resolved:
# no reverse address mapping.
call mtr.add_suppression("192.0.2.4");
--source ../include/hostcache_set_state.inc
CREATE USER 'user4'@'santa.claus.ipv4.example.com';
GRANT SELECT ON test.* TO 'user4'@'santa.claus.ipv4.example.com';
SET global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
connect (con4, "127.0.0.1", user4, , test, $MASTER_MYPORT,);
SELECT "Con4 is alive" AS "";
SELECT current_user() AS "";
disconnect con4;
--connection default
SET global debug= default;
###########################################################################
# Test index on IP
###########################################################################
let $column_count = 1;
let $col1 = IP;
let $col1_act = "192.0.2.4";
--source ../include/idx_explain_test.inc
###########################################################################
# Test index on HOST
###########################################################################
let $column_count = 1;
let $col1 = HOST;
let $col1_act = "santa.claus.ipv4.example.com";
--source ../include/idx_explain_test.inc
# Cleanup
REVOKE SELECT ON test.* FROM 'user4'@'santa.claus.ipv4.example.com';
DROP USER 'user4'@'santa.claus.ipv4.example.com';
|
