1SET @start_value = @@global.key_cache_division_limit; 2SELECT @start_value; 3@start_value 4100 5'#--------------------FN_DYNVARS_058_01------------------------#' 6SET @@global.key_cache_division_limit = DEFAULT; 7SELECT @@global.key_cache_division_limit; 8@@global.key_cache_division_limit 9100 10'#---------------------FN_DYNVARS_058_02-------------------------#' 11SET @@global.key_cache_division_limit = @start_value; 12SELECT @@global.key_cache_division_limit = 100; 13@@global.key_cache_division_limit = 100 141 15'#--------------------FN_DYNVARS_058_03------------------------#' 16SET @@global.key_cache_division_limit = 1; 17SELECT @@global.key_cache_division_limit; 18@@global.key_cache_division_limit 191 20SET @@global.key_cache_division_limit = 50; 21SELECT @@global.key_cache_division_limit; 22@@global.key_cache_division_limit 2350 24SET @@global.key_cache_division_limit = 99; 25SELECT @@global.key_cache_division_limit; 26@@global.key_cache_division_limit 2799 28SET @@global.key_cache_division_limit = 2; 29SELECT @@global.key_cache_division_limit; 30@@global.key_cache_division_limit 312 32'#--------------------FN_DYNVARS_058_04-------------------------#' 33SET @@global.key_cache_division_limit = -1; 34Warnings: 35Warning 1292 Truncated incorrect key_cache_division_limit value: '-1' 36SELECT @@global.key_cache_division_limit; 37@@global.key_cache_division_limit 381 39SET @@global.key_cache_division_limit = 101; 40Warnings: 41Warning 1292 Truncated incorrect key_cache_division_limit value: '101' 42SELECT @@global.key_cache_division_limit; 43@@global.key_cache_division_limit 44100 45SET @@global.key_cache_division_limit = 10000.01; 46ERROR 42000: Incorrect argument type to variable 'key_cache_division_limit' 47SELECT @@global.key_cache_division_limit; 48@@global.key_cache_division_limit 49100 50SET @@global.key_cache_division_limit = -1024; 51Warnings: 52Warning 1292 Truncated incorrect key_cache_division_limit value: '-1024' 53SELECT @@global.key_cache_division_limit; 54@@global.key_cache_division_limit 551 56SET @@global.key_cache_division_limit = 0; 57Warnings: 58Warning 1292 Truncated incorrect key_cache_division_limit value: '0' 59SELECT @@global.key_cache_division_limit; 60@@global.key_cache_division_limit 611 62SET @@global.key_cache_division_limit = 200; 63Warnings: 64Warning 1292 Truncated incorrect key_cache_division_limit value: '200' 65SELECT @@global.key_cache_division_limit; 66@@global.key_cache_division_limit 67100 68SET @@global.key_cache_division_limit = 65535; 69Warnings: 70Warning 1292 Truncated incorrect key_cache_division_limit value: '65535' 71SELECT @@global.key_cache_division_limit; 72@@global.key_cache_division_limit 73100 74SET @@global.key_cache_division_limit = ON; 75ERROR 42000: Incorrect argument type to variable 'key_cache_division_limit' 76SELECT @@global.key_cache_division_limit; 77@@global.key_cache_division_limit 78100 79SET @@global.key_cache_division_limit = 'test'; 80ERROR 42000: Incorrect argument type to variable 'key_cache_division_limit' 81SELECT @@global.key_cache_division_limit; 82@@global.key_cache_division_limit 83100 84'#-------------------FN_DYNVARS_058_05----------------------------#' 85SET @@session.key_cache_division_limit = 0; 86ERROR HY000: Variable 'key_cache_division_limit' is a GLOBAL variable and should be set with SET GLOBAL 87SELECT @@session.key_cache_division_limit; 88ERROR HY000: Variable 'key_cache_division_limit' is a GLOBAL variable 89'#----------------------FN_DYNVARS_058_06------------------------#' 90SELECT @@global.key_cache_division_limit = VARIABLE_VALUE 91FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 92WHERE VARIABLE_NAME='key_cache_division_limit'; 93@@global.key_cache_division_limit = VARIABLE_VALUE 941 95SELECT @@key_cache_division_limit = VARIABLE_VALUE 96FROM INFORMATION_SCHEMA.SESSION_VARIABLES 97WHERE VARIABLE_NAME='key_cache_division_limit'; 98@@key_cache_division_limit = VARIABLE_VALUE 991 100'#---------------------FN_DYNVARS_058_07----------------------#' 101SET @@global.key_cache_division_limit = TRUE; 102SELECT @@global.key_cache_division_limit; 103@@global.key_cache_division_limit 1041 105SET @@global.key_cache_division_limit = FALSE; 106Warnings: 107Warning 1292 Truncated incorrect key_cache_division_limit value: '0' 108SELECT @@global.key_cache_division_limit; 109@@global.key_cache_division_limit 1101 111'#---------------------FN_DYNVARS_058_08----------------------#' 112SET @@global.key_cache_division_limit = 90; 113SELECT @@key_cache_division_limit = @@global.key_cache_division_limit; 114@@key_cache_division_limit = @@global.key_cache_division_limit 1151 116'#---------------------FN_DYNVARS_058_09----------------------#' 117SET key_cache_division_limit = 80; 118ERROR HY000: Variable 'key_cache_division_limit' is a GLOBAL variable and should be set with SET GLOBAL 119SELECT @@key_cache_division_limit; 120@@key_cache_division_limit 12190 122SELECT local.key_cache_division_limit; 123ERROR 42S02: Unknown table 'local' in field list 124SELECT global.key_cache_division_limit; 125ERROR 42S02: Unknown table 'global' in field list 126SELECT key_cache_division_limit = @@session.key_cache_division_limit; 127ERROR 42S22: Unknown column 'key_cache_division_limit' in 'field list' 128SET @@global.key_cache_division_limit = @start_value; 129SELECT @@global.key_cache_division_limit; 130@@global.key_cache_division_limit 131100 132