1SET @start_value = @@global.key_cache_age_threshold; 2SELECT @start_value; 3@start_value 4300 5'#--------------------FN_DYNVARS_056_01------------------------#' 6SET @@global.key_cache_age_threshold = DEFAULT; 7SELECT @@global.key_cache_age_threshold; 8@@global.key_cache_age_threshold 9300 10'#---------------------FN_DYNVARS_056_02-------------------------#' 11SET @@global.key_cache_age_threshold = @start_value; 12SELECT @@global.key_cache_age_threshold = 300; 13@@global.key_cache_age_threshold = 300 141 15'#--------------------FN_DYNVARS_056_03------------------------#' 16SET @@global.key_cache_age_threshold = 100; 17SELECT @@global.key_cache_age_threshold; 18@@global.key_cache_age_threshold 19100 20SET @@global.key_cache_age_threshold = 4294967295; 21Warnings: 22Warning 1292 Truncated incorrect key_cache_age_threshold value: '4294967295' 23SELECT @@global.key_cache_age_threshold; 24@@global.key_cache_age_threshold 254294967200 26SET @@global.key_cache_age_threshold = 1800; 27SELECT @@global.key_cache_age_threshold; 28@@global.key_cache_age_threshold 291800 30SET @@global.key_cache_age_threshold = 65535; 31Warnings: 32Warning 1292 Truncated incorrect key_cache_age_threshold value: '65535' 33SELECT @@global.key_cache_age_threshold; 34@@global.key_cache_age_threshold 3565500 36'#--------------------FN_DYNVARS_056_04-------------------------#' 37SET @@global.key_cache_age_threshold = -1; 38Warnings: 39Warning 1292 Truncated incorrect key_cache_age_threshold value: '-1' 40SELECT @@global.key_cache_age_threshold; 41@@global.key_cache_age_threshold 42100 43SET @@global.key_cache_age_threshold = 42949672951; 44Warnings: 45Warning 1292 Truncated incorrect key_cache_age_threshold value: '42949672951' 46SELECT @@global.key_cache_age_threshold; 47@@global.key_cache_age_threshold 484294967200 49SET @@global.key_cache_age_threshold = 10000.01; 50ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold' 51SELECT @@global.key_cache_age_threshold; 52@@global.key_cache_age_threshold 534294967200 54SET @@global.key_cache_age_threshold = -1024; 55Warnings: 56Warning 1292 Truncated incorrect key_cache_age_threshold value: '-1024' 57SELECT @@global.key_cache_age_threshold; 58@@global.key_cache_age_threshold 59100 60SET @@global.key_cache_age_threshold = 99; 61Warnings: 62Warning 1292 Truncated incorrect key_cache_age_threshold value: '99' 63SELECT @@global.key_cache_age_threshold; 64@@global.key_cache_age_threshold 65100 66SET @@global.key_cache_age_threshold = ON; 67ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold' 68SELECT @@global.key_cache_age_threshold; 69@@global.key_cache_age_threshold 70100 71SET @@global.key_cache_age_threshold = 'test'; 72ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold' 73SELECT @@global.key_cache_age_threshold; 74@@global.key_cache_age_threshold 75100 76'#-------------------FN_DYNVARS_056_05----------------------------#' 77SET @@session.key_cache_age_threshold = 0; 78ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL 79SELECT @@session.key_cache_age_threshold; 80ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable 81'#----------------------FN_DYNVARS_056_06------------------------#' 82SELECT @@global.key_cache_age_threshold = VARIABLE_VALUE 83FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 84WHERE VARIABLE_NAME='key_cache_age_threshold'; 85@@global.key_cache_age_threshold = VARIABLE_VALUE 861 87SELECT @@key_cache_age_threshold = VARIABLE_VALUE 88FROM INFORMATION_SCHEMA.SESSION_VARIABLES 89WHERE VARIABLE_NAME='key_cache_age_threshold'; 90@@key_cache_age_threshold = VARIABLE_VALUE 911 92'#---------------------FN_DYNVARS_056_07----------------------#' 93SET @@global.key_cache_age_threshold = TRUE; 94Warnings: 95Warning 1292 Truncated incorrect key_cache_age_threshold value: '1' 96SELECT @@global.key_cache_age_threshold; 97@@global.key_cache_age_threshold 98100 99SET @@global.key_cache_age_threshold = FALSE; 100Warnings: 101Warning 1292 Truncated incorrect key_cache_age_threshold value: '0' 102SELECT @@global.key_cache_age_threshold; 103@@global.key_cache_age_threshold 104100 105'#---------------------FN_DYNVARS_056_08----------------------#' 106SET @@global.key_cache_age_threshold = 101; 107Warnings: 108Warning 1292 Truncated incorrect key_cache_age_threshold value: '101' 109SELECT @@key_cache_age_threshold = @@global.key_cache_age_threshold; 110@@key_cache_age_threshold = @@global.key_cache_age_threshold 1111 112'#---------------------FN_DYNVARS_056_09----------------------#' 113SET key_cache_age_threshold = 8000; 114ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL 115SELECT @@key_cache_age_threshold; 116@@key_cache_age_threshold 117100 118SELECT local.key_cache_age_threshold; 119ERROR 42S02: Unknown table 'local' in field list 120SELECT global.key_cache_age_threshold; 121ERROR 42S02: Unknown table 'global' in field list 122SELECT key_cache_age_threshold = @@session.key_cache_age_threshold; 123ERROR 42S22: Unknown column 'key_cache_age_threshold' in 'field list' 124SET @@global.key_cache_age_threshold = @start_value; 125SELECT @@global.key_cache_age_threshold; 126@@global.key_cache_age_threshold 127300 128