1 files changed, 78 insertions, 0 deletions
diff --git a/mysql-test/r/host_cache_size_functionality.result b/mysql-test/r/host_cache_size_functionality.result
new file mode 100644
index 00000000000..e7f9e09fd2f
--- /dev/null
+++ b/mysql-test/r/host_cache_size_functionality.result
@@ -0,0 +1,78 @@
+'#________________________VAR_06_Host_Cache_Size__________________#'
+echo '##'
+--echo '#---------------------WL6372_VAR_6_01----------------------#'
+####################################################################
+#   Checking default value                                         #
+####################################################################
+SELECT COUNT(@@GLOBAL.Host_Cache_Size)
+1 Expected
+set @Default_host_cache_size=128;
+select @@global.Host_Cache_Size=@Default_host_cache_size;
+@@global.Host_Cache_Size=@Default_host_cache_size
+1
+1 Expected
+'#---------------------WL6372_VAR_6_02----------------------#'
+# Restart server with Host_Cache_Size 1
+SELECT @@GLOBAL.Host_Cache_Size;
+@@GLOBAL.Host_Cache_Size
+1
+1 Expected
+set @Default_host_cache_size=128;
+SET @@GLOBAL.Host_Cache_Size=DEFAULT;
+select @@global.Host_Cache_Size=@Default_host_cache_size;
+@@global.Host_Cache_Size=@Default_host_cache_size
+1
+1 Expected
+'#---------------------WL6372_VAR_6_03----------------------#'
+SET @@local.Host_Cache_Size=1;
+ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
+Expected error 'Global variable'
+SET @@session.Host_Cache_Size=1;
+ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
+Expected error 'Global variable'
+SET @@GLOBAL.Host_Cache_Size=1;
+SET @@GLOBAL.Host_Cache_Size=DEFAULT;
+SELECT COUNT(@@GLOBAL.Host_Cache_Size);
+COUNT(@@GLOBAL.Host_Cache_Size)
+1
+1 Expected
+select @@global.Host_Cache_Size=@Default_host_cache_size;
+@@global.Host_Cache_Size=@Default_host_cache_size
+1
+1 Expected
+'#---------------------WL6372_VAR_6_04----------------------#'
+SELECT @@GLOBAL.Host_Cache_Size = VARIABLE_VALUE
+FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
+WHERE VARIABLE_NAME='Host_Cache_Size';
+@@GLOBAL.Host_Cache_Size = VARIABLE_VALUE
+1
+1 Expected
+SELECT COUNT(@@GLOBAL.Host_Cache_Size);
+COUNT(@@GLOBAL.Host_Cache_Size)
+1
+1 Expected
+SELECT COUNT(VARIABLE_VALUE)
+FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
+WHERE VARIABLE_NAME='Host_Cache_Size';
+COUNT(VARIABLE_VALUE)
+1
+1 Expected
+'#---------------------WL6372_VAR_6_05----------------------#'
+SELECT @@Host_Cache_Size = @@GLOBAL.Host_Cache_Size;
+@@Host_Cache_Size = @@GLOBAL.Host_Cache_Size
+1
+1 Expected
+SELECT COUNT(@@local.Host_Cache_Size);
+ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable
+Expected error 'Variable is a GLOBAL variable'
+SELECT COUNT(@@SESSION.Host_Cache_Size);
+ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable
+Expected error 'Variable is a GLOBAL variable'
+SELECT COUNT(@@GLOBAL.Host_Cache_Size);
+COUNT(@@GLOBAL.Host_Cache_Size)
+1
+1 Expected
+SELECT Host_Cache_Size = @@SESSION.Host_Cache_Size;
+ERROR 42S22: Unknown column 'Host_Cache_Size' in 'field list'
+Expected error 'Unknown column Host_Cache_Size in field list'
+SET @@GLOBAL.Host_Cache_Size=DEFAULT;