mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
73 lines
2.6 KiB
Text
73 lines
2.6 KiB
Text
'#________________________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 'SELECT'
|
|
Expected error 'Unknown column Host_Cache_Size in field list'
|
|
SET @@GLOBAL.Host_Cache_Size=DEFAULT;
|