'#________________________VAR_06_Host_Cache_Size__________________#'
echo '##'
--echo '#---------------------WL6372_VAR_6_01----------------------#'
####################################################################
#   Checking default value                                         #
####################################################################
select @@global.Host_Cache_Size > 0
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;