1SET @start_value = @@global.key_cache_block_size; 2SELECT @start_value; 3@start_value 41024 5'#--------------------FN_DYNVARS_057_01------------------------#' 6SET @@global.key_cache_block_size = DEFAULT; 7SELECT @@global.key_cache_block_size; 8@@global.key_cache_block_size 91024 10'#---------------------FN_DYNVARS_057_02-------------------------#' 11SET @@global.key_cache_block_size = @start_value; 12SELECT @@global.key_cache_block_size = 1024; 13@@global.key_cache_block_size = 1024 141 15'#--------------------FN_DYNVARS_057_03------------------------#' 16SET @@global.key_cache_block_size = 1024; 17SELECT @@global.key_cache_block_size; 18@@global.key_cache_block_size 191024 20SET @@global.key_cache_block_size = 16384; 21SELECT @@global.key_cache_block_size; 22@@global.key_cache_block_size 2316384 24SET @@global.key_cache_block_size = 1800; 25Warnings: 26Warning 1292 Truncated incorrect key_cache_block_size value: '1800' 27SELECT @@global.key_cache_block_size; 28@@global.key_cache_block_size 291536 30SET @@global.key_cache_block_size = 16383; 31Warnings: 32Warning 1292 Truncated incorrect key_cache_block_size value: '16383' 33SELECT @@global.key_cache_block_size; 34@@global.key_cache_block_size 3515872 36'#--------------------FN_DYNVARS_057_04-------------------------#' 37SET @@global.key_cache_block_size = -1; 38Warnings: 39Warning 1292 Truncated incorrect key_cache_block_size value: '-1' 40SELECT @@global.key_cache_block_size; 41@@global.key_cache_block_size 42512 43SET @@global.key_cache_block_size = 42949672951; 44Warnings: 45Warning 1292 Truncated incorrect key_cache_block_size value: '42949672951' 46SELECT @@global.key_cache_block_size; 47@@global.key_cache_block_size 4816384 49SET @@global.key_cache_block_size = 10000.01; 50ERROR 42000: Incorrect argument type to variable 'key_cache_block_size' 51SELECT @@global.key_cache_block_size; 52@@global.key_cache_block_size 5316384 54SET @@global.key_cache_block_size = -1024; 55Warnings: 56Warning 1292 Truncated incorrect key_cache_block_size value: '-1024' 57SELECT @@global.key_cache_block_size; 58@@global.key_cache_block_size 59512 60SET @@global.key_cache_block_size = 256; 61Warnings: 62Warning 1292 Truncated incorrect key_cache_block_size value: '256' 63SELECT @@global.key_cache_block_size; 64@@global.key_cache_block_size 65512 66SET @@global.key_cache_block_size = 511; 67Warnings: 68Warning 1292 Truncated incorrect key_cache_block_size value: '511' 69SELECT @@global.key_cache_block_size; 70@@global.key_cache_block_size 71512 72SET @@global.key_cache_block_size = 16385; 73Warnings: 74Warning 1292 Truncated incorrect key_cache_block_size value: '16385' 75SELECT @@global.key_cache_block_size; 76@@global.key_cache_block_size 7716384 78SET @@global.key_cache_block_size = ON; 79ERROR 42000: Incorrect argument type to variable 'key_cache_block_size' 80SELECT @@global.key_cache_block_size; 81@@global.key_cache_block_size 8216384 83SET @@global.key_cache_block_size = 'test'; 84ERROR 42000: Incorrect argument type to variable 'key_cache_block_size' 85SELECT @@global.key_cache_block_size; 86@@global.key_cache_block_size 8716384 88'#-------------------FN_DYNVARS_057_05----------------------------#' 89SET @@session.key_cache_block_size = 0; 90ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable and should be set with SET GLOBAL 91SELECT @@session.key_cache_block_size; 92ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable 93'#----------------------FN_DYNVARS_057_06------------------------#' 94SELECT @@global.key_cache_block_size = VARIABLE_VALUE 95FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 96WHERE VARIABLE_NAME='key_cache_block_size'; 97@@global.key_cache_block_size = VARIABLE_VALUE 981 99SELECT @@key_cache_block_size = VARIABLE_VALUE 100FROM INFORMATION_SCHEMA.SESSION_VARIABLES 101WHERE VARIABLE_NAME='key_cache_block_size'; 102@@key_cache_block_size = VARIABLE_VALUE 1031 104'#---------------------FN_DYNVARS_057_07----------------------#' 105SET @@global.key_cache_block_size = TRUE; 106Warnings: 107Warning 1292 Truncated incorrect key_cache_block_size value: '1' 108SELECT @@global.key_cache_block_size; 109@@global.key_cache_block_size 110512 111SET @@global.key_cache_block_size = FALSE; 112Warnings: 113Warning 1292 Truncated incorrect key_cache_block_size value: '0' 114SELECT @@global.key_cache_block_size; 115@@global.key_cache_block_size 116512 117'#---------------------FN_DYNVARS_057_08----------------------#' 118SET @@global.key_cache_block_size = 1024; 119SELECT @@key_cache_block_size = @@global.key_cache_block_size; 120@@key_cache_block_size = @@global.key_cache_block_size 1211 122'#---------------------FN_DYNVARS_057_09----------------------#' 123SET key_cache_block_size = 8000; 124ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable and should be set with SET GLOBAL 125SELECT @@key_cache_block_size; 126@@key_cache_block_size 1271024 128SELECT local.key_cache_block_size; 129ERROR 42S02: Unknown table 'local' in field list 130SELECT global.key_cache_block_size; 131ERROR 42S02: Unknown table 'global' in field list 132SELECT key_cache_block_size = @@session.key_cache_block_size; 133ERROR 42S22: Unknown column 'key_cache_block_size' in 'field list' 134SET @@global.key_cache_block_size = @start_value; 135SELECT @@global.key_cache_block_size; 136@@global.key_cache_block_size 1371024 138