1'#________________________VAR_06_Host_Cache_Size__________________#' 2echo '##' 3--echo '#---------------------WL6372_VAR_6_01----------------------#' 4#################################################################### 5# Checking default value # 6#################################################################### 7select @@global.Host_Cache_Size > 0 81 Expected 9'#---------------------WL6372_VAR_6_02----------------------#' 10# Restart server with Host_Cache_Size 1 11SELECT @@GLOBAL.Host_Cache_Size; 12@@GLOBAL.Host_Cache_Size 131 141 Expected 15set @Default_host_cache_size=128; 16SET @@GLOBAL.Host_Cache_Size=DEFAULT; 17select @@global.Host_Cache_Size=@Default_host_cache_size; 18@@global.Host_Cache_Size=@Default_host_cache_size 191 201 Expected 21'#---------------------WL6372_VAR_6_03----------------------#' 22SET @@local.Host_Cache_Size=1; 23ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 24Expected error 'Global variable' 25SET @@session.Host_Cache_Size=1; 26ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable and should be set with SET GLOBAL 27Expected error 'Global variable' 28SET @@GLOBAL.Host_Cache_Size=1; 29SET @@GLOBAL.Host_Cache_Size=DEFAULT; 30SELECT COUNT(@@GLOBAL.Host_Cache_Size); 31COUNT(@@GLOBAL.Host_Cache_Size) 321 331 Expected 34select @@global.Host_Cache_Size=@Default_host_cache_size; 35@@global.Host_Cache_Size=@Default_host_cache_size 361 371 Expected 38'#---------------------WL6372_VAR_6_04----------------------#' 39SELECT @@GLOBAL.Host_Cache_Size = VARIABLE_VALUE 40FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 41WHERE VARIABLE_NAME='Host_Cache_Size'; 42@@GLOBAL.Host_Cache_Size = VARIABLE_VALUE 431 441 Expected 45SELECT COUNT(@@GLOBAL.Host_Cache_Size); 46COUNT(@@GLOBAL.Host_Cache_Size) 471 481 Expected 49SELECT COUNT(VARIABLE_VALUE) 50FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 51WHERE VARIABLE_NAME='Host_Cache_Size'; 52COUNT(VARIABLE_VALUE) 531 541 Expected 55'#---------------------WL6372_VAR_6_05----------------------#' 56SELECT @@Host_Cache_Size = @@GLOBAL.Host_Cache_Size; 57@@Host_Cache_Size = @@GLOBAL.Host_Cache_Size 581 591 Expected 60SELECT COUNT(@@local.Host_Cache_Size); 61ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable 62Expected error 'Variable is a GLOBAL variable' 63SELECT COUNT(@@SESSION.Host_Cache_Size); 64ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable 65Expected error 'Variable is a GLOBAL variable' 66SELECT COUNT(@@GLOBAL.Host_Cache_Size); 67COUNT(@@GLOBAL.Host_Cache_Size) 681 691 Expected 70SELECT Host_Cache_Size = @@SESSION.Host_Cache_Size; 71ERROR 42S22: Unknown column 'Host_Cache_Size' in 'field list' 72Expected error 'Unknown column Host_Cache_Size in field list' 73SET @@GLOBAL.Host_Cache_Size=DEFAULT; 74