1SET @start_value = @@global.key_cache_file_hash_size; 2SELECT @start_value; 3@start_value 4512 5'#--------------------FN_DYNVARS_056_01------------------------#' 6SET @@global.key_cache_file_hash_size = DEFAULT; 7SELECT @@global.key_cache_file_hash_size; 8@@global.key_cache_file_hash_size 9512 10'#---------------------FN_DYNVARS_056_02-------------------------#' 11SET @@global.key_cache_file_hash_size = @start_value; 12SELECT @@global.key_cache_file_hash_size = 300; 13@@global.key_cache_file_hash_size = 300 140 15'#--------------------FN_DYNVARS_056_03------------------------#' 16SET @@global.key_cache_file_hash_size = 128; 17SET @@global.key_cache_file_hash_size = 16384; 18SELECT @@global.key_cache_file_hash_size; 19@@global.key_cache_file_hash_size 2016384 21'#--------------------FN_DYNVARS_056_04-------------------------#' 22SET @@global.key_cache_file_hash_size = -1; 23Warnings: 24Warning 1292 Truncated incorrect key_cache_file_hash_size value: '-1' 25SELECT @@global.key_cache_file_hash_size; 26@@global.key_cache_file_hash_size 27128 28SET @@global.key_cache_file_hash_size = 42949672951; 29Warnings: 30Warning 1292 Truncated incorrect key_cache_file_hash_size value: '42949672951' 31SELECT @@global.key_cache_file_hash_size; 32@@global.key_cache_file_hash_size 3316384 34SET @@global.key_cache_file_hash_size = 10000.01; 35ERROR 42000: Incorrect argument type to variable 'key_cache_file_hash_size' 36SELECT @@global.key_cache_file_hash_size; 37@@global.key_cache_file_hash_size 3816384 39SET @@global.key_cache_file_hash_size = -1024; 40Warnings: 41Warning 1292 Truncated incorrect key_cache_file_hash_size value: '-1024' 42SELECT @@global.key_cache_file_hash_size; 43@@global.key_cache_file_hash_size 44128 45SET @@global.key_cache_file_hash_size = 99; 46Warnings: 47Warning 1292 Truncated incorrect key_cache_file_hash_size value: '99' 48SELECT @@global.key_cache_file_hash_size; 49@@global.key_cache_file_hash_size 50128 51SET @@global.key_cache_file_hash_size = ON; 52ERROR 42000: Incorrect argument type to variable 'key_cache_file_hash_size' 53SELECT @@global.key_cache_file_hash_size; 54@@global.key_cache_file_hash_size 55128 56SET @@global.key_cache_file_hash_size = 'test'; 57ERROR 42000: Incorrect argument type to variable 'key_cache_file_hash_size' 58SELECT @@global.key_cache_file_hash_size; 59@@global.key_cache_file_hash_size 60128 61'#-------------------FN_DYNVARS_056_05----------------------------#' 62SET @@session.key_cache_file_hash_size = 0; 63ERROR HY000: Variable 'key_cache_file_hash_size' is a GLOBAL variable and should be set with SET GLOBAL 64SELECT @@session.key_cache_file_hash_size; 65ERROR HY000: Variable 'key_cache_file_hash_size' is a GLOBAL variable 66'#----------------------FN_DYNVARS_056_06------------------------#' 67SELECT @@global.key_cache_file_hash_size = VARIABLE_VALUE 68FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 69WHERE VARIABLE_NAME='key_cache_file_hash_size'; 70@@global.key_cache_file_hash_size = VARIABLE_VALUE 711 72SELECT @@key_cache_file_hash_size = VARIABLE_VALUE 73FROM INFORMATION_SCHEMA.SESSION_VARIABLES 74WHERE VARIABLE_NAME='key_cache_file_hash_size'; 75@@key_cache_file_hash_size = VARIABLE_VALUE 761 77'#---------------------FN_DYNVARS_056_07----------------------#' 78SET @@global.key_cache_file_hash_size = TRUE; 79Warnings: 80Warning 1292 Truncated incorrect key_cache_file_hash_size value: '1' 81SELECT @@global.key_cache_file_hash_size; 82@@global.key_cache_file_hash_size 83128 84SET @@global.key_cache_file_hash_size = FALSE; 85Warnings: 86Warning 1292 Truncated incorrect key_cache_file_hash_size value: '0' 87SELECT @@global.key_cache_file_hash_size; 88@@global.key_cache_file_hash_size 89128 90'#---------------------FN_DYNVARS_056_08----------------------#' 91SET @@global.key_cache_file_hash_size = 150; 92SELECT @@key_cache_file_hash_size = @@global.key_cache_file_hash_size; 93@@key_cache_file_hash_size = @@global.key_cache_file_hash_size 941 95'#---------------------FN_DYNVARS_056_09----------------------#' 96SET key_cache_file_hash_size = 8000; 97ERROR HY000: Variable 'key_cache_file_hash_size' is a GLOBAL variable and should be set with SET GLOBAL 98SELECT @@key_cache_file_hash_size; 99@@key_cache_file_hash_size 100150 101SELECT local.key_cache_file_hash_size; 102ERROR 42S02: Unknown table 'local' in field list 103SELECT global.key_cache_file_hash_size; 104ERROR 42S02: Unknown table 'global' in field list 105SELECT key_cache_file_hash_size = @@session.key_cache_file_hash_size; 106ERROR 42S22: Unknown column 'key_cache_file_hash_size' in 'field list' 107SET @@global.key_cache_file_hash_size = @start_value; 108SELECT @@global.key_cache_file_hash_size; 109@@global.key_cache_file_hash_size 110512 111