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 = 512; 17SELECT @@global.key_cache_block_size; 18@@global.key_cache_block_size 19512 20SET @@global.key_cache_block_size = 1024; 21SELECT @@global.key_cache_block_size; 22@@global.key_cache_block_size 231024 24SET @@global.key_cache_block_size = 16384; 25SELECT @@global.key_cache_block_size; 26@@global.key_cache_block_size 2716384 28SET @@global.key_cache_block_size = 1800; 29Warnings: 30Warning 1292 Truncated incorrect key_cache_block_size value: '1800' 31SELECT @@global.key_cache_block_size; 32@@global.key_cache_block_size 331536 34SET @@global.key_cache_block_size = 16383; 35Warnings: 36Warning 1292 Truncated incorrect key_cache_block_size value: '16383' 37SELECT @@global.key_cache_block_size; 38@@global.key_cache_block_size 3915872 40'#--------------------FN_DYNVARS_057_04-------------------------#' 41SET @@global.key_cache_block_size = -1; 42Warnings: 43Warning 1292 Truncated incorrect key_cache_block_size value: '-1' 44SELECT @@global.key_cache_block_size; 45@@global.key_cache_block_size 46512 47SET @@global.key_cache_block_size = 42949672951; 48Warnings: 49Warning 1292 Truncated incorrect key_cache_block_size value: '42949672951' 50SELECT @@global.key_cache_block_size; 51@@global.key_cache_block_size 5216384 53SET @@global.key_cache_block_size = 10000.01; 54ERROR 42000: Incorrect argument type to variable 'key_cache_block_size' 55SELECT @@global.key_cache_block_size; 56@@global.key_cache_block_size 5716384 58SET @@global.key_cache_block_size = -1024; 59Warnings: 60Warning 1292 Truncated incorrect key_cache_block_size value: '-1024' 61SELECT @@global.key_cache_block_size; 62@@global.key_cache_block_size 63512 64SET @@global.key_cache_block_size = 256; 65Warnings: 66Warning 1292 Truncated incorrect key_cache_block_size value: '256' 67SELECT @@global.key_cache_block_size; 68@@global.key_cache_block_size 69512 70SET @@global.key_cache_block_size = 511; 71Warnings: 72Warning 1292 Truncated incorrect key_cache_block_size value: '511' 73SELECT @@global.key_cache_block_size; 74@@global.key_cache_block_size 75512 76SET @@global.key_cache_block_size = 16385; 77Warnings: 78Warning 1292 Truncated incorrect key_cache_block_size value: '16385' 79SELECT @@global.key_cache_block_size; 80@@global.key_cache_block_size 8116384 82SET @@global.key_cache_block_size = " "; 83ERROR 42000: Incorrect argument type to variable 'key_cache_block_size' 84SELECT @@global.key_cache_block_size; 85@@global.key_cache_block_size 8616384 87SET @@global.key_cache_block_size = ON; 88ERROR 42000: Incorrect argument type to variable 'key_cache_block_size' 89SELECT @@global.key_cache_block_size; 90@@global.key_cache_block_size 9116384 92SET @@global.key_cache_block_size = 'test'; 93ERROR 42000: Incorrect argument type to variable 'key_cache_block_size' 94SELECT @@global.key_cache_block_size; 95@@global.key_cache_block_size 9616384 97'#-------------------FN_DYNVARS_057_05----------------------------#' 98SET @@session.key_cache_block_size = 0; 99ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable and should be set with SET GLOBAL 100SELECT @@session.key_cache_block_size; 101ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable 102'#----------------------FN_DYNVARS_057_06------------------------#' 103SELECT @@global.key_cache_block_size = VARIABLE_VALUE 104FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 105WHERE VARIABLE_NAME='key_cache_block_size'; 106@@global.key_cache_block_size = VARIABLE_VALUE 1071 108SELECT @@key_cache_block_size = VARIABLE_VALUE 109FROM INFORMATION_SCHEMA.SESSION_VARIABLES 110WHERE VARIABLE_NAME='key_cache_block_size'; 111@@key_cache_block_size = VARIABLE_VALUE 1121 113'#---------------------FN_DYNVARS_057_07----------------------#' 114SET @@global.key_cache_block_size = TRUE; 115Warnings: 116Warning 1292 Truncated incorrect key_cache_block_size value: '1' 117SELECT @@global.key_cache_block_size; 118@@global.key_cache_block_size 119512 120SET @@global.key_cache_block_size = FALSE; 121Warnings: 122Warning 1292 Truncated incorrect key_cache_block_size value: '0' 123SELECT @@global.key_cache_block_size; 124@@global.key_cache_block_size 125512 126'#---------------------FN_DYNVARS_057_08----------------------#' 127SET @@global.key_cache_block_size = 1024; 128SELECT @@key_cache_block_size = @@global.key_cache_block_size; 129@@key_cache_block_size = @@global.key_cache_block_size 1301 131'#---------------------FN_DYNVARS_057_09----------------------#' 132SET key_cache_block_size = 8000; 133ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable and should be set with SET GLOBAL 134SELECT @@key_cache_block_size; 135@@key_cache_block_size 1361024 137SET local.key_cache_block_size = 10; 138ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.key_cache_block_size = 10' at line 1 139SELECT local.key_cache_block_size; 140ERROR 42S02: Unknown table 'local' in field list 141SET global.key_cache_block_size = 10; 142ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.key_cache_block_size = 10' at line 1 143SELECT global.key_cache_block_size; 144ERROR 42S02: Unknown table 'global' in field list 145SELECT key_cache_block_size = @@session.key_cache_block_size; 146ERROR 42S22: Unknown column 'key_cache_block_size' in 'field list' 147SET @@global.key_cache_block_size = @start_value; 148SELECT @@global.key_cache_block_size; 149@@global.key_cache_block_size 1501024 151