summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result
diff options
context:
space:
mode:
authorunknown <timour@askmonty.org>2013-07-08 15:19:50 +0300
committerunknown <timour@askmonty.org>2013-07-08 15:19:50 +0300
commit54999b2863ed7f6b1fc64f8347ae24a7a325b427 (patch)
treed16f41be280d192ae960904ed146b84540ad11a4 /mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result
parent30e34252f48599d605466c718ceb81a1a0e23b70 (diff)
downloadmariadb-git-54999b2863ed7f6b1fc64f8347ae24a7a325b427.tar.gz
Merge performance schema test cases from MySQL 5.6.10
Merged the majority of the PFS test cases. There are still 19 failing test cases that need more attention.
Diffstat (limited to 'mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result')
-rw-r--r--mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result19
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result b/mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result
index 225b22e58d3..73741cf42ed 100644
--- a/mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result
+++ b/mysql-test/suite/perfschema/r/hostcache_ipv6_addrinfo_noname_deny.result
@@ -1,9 +1,28 @@
call mtr.add_suppression("santa.claus.ipv6.example.com");
flush status;
flush hosts;
+flush user_resources;
+flush privileges;
select @@global.debug;
@@global.debug
+select @@global.max_connect_errors;
+@@global.max_connect_errors
+100
+select @@global.max_user_connections;
+@@global.max_user_connections
+0
+select @@global.max_connections;
+@@global.max_connections
+151
+select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
+User Host
+select `User`, `Host` from mysql.`user` where `user` like '192.%';
+User Host
+select `User`, `Host` from mysql.`user` where `user` like '2001:%';
+User Host
+select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
+User Host
select "Con1 is alive";
Con1 is alive
Con1 is alive