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