mirror of
https://github.com/MariaDB/server.git
synced 2025-04-18 21:25:32 +02:00

In particular: * @@debug deprecated since 5.5.37 * sr_YU locale deprecated since 10.0.11 * "engine_condition_pushdown" in the @@optimizer_switch deprecated since 10.1.1 * @@date_format, @@datetime_format, @@time_format, @@max_tmp_tables deprecated since 10.1.2 * @@wsrep_causal_reads deprecated since 10.1.3 * "parser" in mroonga table comment deprecated since 10.2.11
22 lines
659 B
SQL
22 lines
659 B
SQL
# Helper for hostcache_*.test
|
|
|
|
# Set a known initial state for the test
|
|
|
|
flush status;
|
|
flush hosts;
|
|
flush user_resources;
|
|
flush privileges;
|
|
|
|
# Print critical setup
|
|
|
|
#select @@global.debug_dbug;
|
|
#select @@global.max_connect_errors;
|
|
#select @@global.max_user_connections;
|
|
#select @@global.max_connections;
|
|
|
|
# Make sure there are no remaining records that can change the test outcome
|
|
|
|
select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
|
|
select `User`, `Host` from mysql.`user` where `user` like '192.%';
|
|
select `User`, `Host` from mysql.`user` where `user` like '2001:%';
|
|
select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
|