1SET @global_start_value = @@global.innodb_max_purge_lag; 2SELECT @global_start_value; 3@global_start_value 40 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_max_purge_lag = 0; 7SET @@global.innodb_max_purge_lag = DEFAULT; 8SELECT @@global.innodb_max_purge_lag; 9@@global.innodb_max_purge_lag 100 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_max_purge_lag = 1; 13ERROR HY000: Variable 'innodb_max_purge_lag' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_max_purge_lag; 15@@innodb_max_purge_lag 160 17SELECT local.innodb_max_purge_lag; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_max_purge_lag = 0; 20SELECT @@global.innodb_max_purge_lag; 21@@global.innodb_max_purge_lag 220 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_max_purge_lag = 0; 25SELECT @@global.innodb_max_purge_lag; 26@@global.innodb_max_purge_lag 270 28SET @@global.innodb_max_purge_lag = 1; 29SELECT @@global.innodb_max_purge_lag; 30@@global.innodb_max_purge_lag 311 32SET @@global.innodb_max_purge_lag = 4294967295; 33SELECT @@global.innodb_max_purge_lag; 34@@global.innodb_max_purge_lag 354294967295 36'#--------------------FN_DYNVARS_046_04------------------------#' 37SET @@global.innodb_max_purge_lag = 4294967296; 38SELECT @@global.innodb_max_purge_lag IN (4294967296,4294967295); 39@@global.innodb_max_purge_lag IN (4294967296,4294967295) 401 41SET @@global.innodb_max_purge_lag = 12345678901; 42SELECT @@global.innodb_max_purge_lag IN (12345678901,4294967295); 43@@global.innodb_max_purge_lag IN (12345678901,4294967295) 441 45SET @@global.innodb_max_purge_lag = 18446744073709551615; 46SELECT @@global.innodb_max_purge_lag IN (18446744073709551615,4294967295); 47@@global.innodb_max_purge_lag IN (18446744073709551615,4294967295) 481 49'#--------------------FN_DYNVARS_046_05-------------------------#' 50SET @@global.innodb_max_purge_lag = -1; 51Warnings: 52Warning 1292 Truncated incorrect innodb_max_purge_lag value: '-1' 53SELECT @@global.innodb_max_purge_lag; 54@@global.innodb_max_purge_lag 550 56SET @@global.innodb_max_purge_lag = -1024; 57Warnings: 58Warning 1292 Truncated incorrect innodb_max_purge_lag value: '-1024' 59SELECT @@global.innodb_max_purge_lag; 60@@global.innodb_max_purge_lag 610 62SET @@global.innodb_max_purge_lag = "T"; 63ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag' 64SELECT @@global.innodb_max_purge_lag; 65@@global.innodb_max_purge_lag 660 67SET @@global.innodb_max_purge_lag = "Y"; 68ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag' 69SELECT @@global.innodb_max_purge_lag; 70@@global.innodb_max_purge_lag 710 72SET @@global.innodb_max_purge_lag = 1.1; 73ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag' 74SELECT @@global.innodb_max_purge_lag; 75@@global.innodb_max_purge_lag 760 77SET @@global.innodb_max_purge_lag = ' '; 78ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag' 79SELECT @@global.innodb_max_purge_lag; 80@@global.innodb_max_purge_lag 810 82SET @@global.innodb_max_purge_lag = " "; 83ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag' 84SELECT @@global.innodb_max_purge_lag; 85@@global.innodb_max_purge_lag 860 87'#----------------------FN_DYNVARS_046_06------------------------#' 88SELECT @@global.innodb_max_purge_lag = 89VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 90WHERE VARIABLE_NAME='innodb_max_purge_lag'; 91@@global.innodb_max_purge_lag = 92VARIABLE_VALUE 931 94SELECT @@global.innodb_max_purge_lag; 95@@global.innodb_max_purge_lag 960 97SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 98WHERE VARIABLE_NAME='innodb_max_purge_lag'; 99VARIABLE_VALUE 1000 101'#---------------------FN_DYNVARS_046_07-------------------------#' 102SET @@global.innodb_max_purge_lag = OFF; 103ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag' 104SELECT @@global.innodb_max_purge_lag; 105@@global.innodb_max_purge_lag 1060 107SET @@global.innodb_max_purge_lag = ON; 108ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag' 109SELECT @@global.innodb_max_purge_lag; 110@@global.innodb_max_purge_lag 1110 112'#---------------------FN_DYNVARS_046_08----------------------#' 113SET @@global.innodb_max_purge_lag = TRUE; 114SELECT @@global.innodb_max_purge_lag; 115@@global.innodb_max_purge_lag 1161 117SET @@global.innodb_max_purge_lag = FALSE; 118SELECT @@global.innodb_max_purge_lag; 119@@global.innodb_max_purge_lag 1200 121SET @@global.innodb_max_purge_lag = @global_start_value; 122SELECT @@global.innodb_max_purge_lag; 123@@global.innodb_max_purge_lag 1240 125