1SET @global_start_value = @@global.innodb_purge_rseg_truncate_frequency; 2SELECT @global_start_value; 3@global_start_value 4128 5'#--------------------FN_DYNVARS_046_01------------------------#' 6SET @@global.innodb_purge_rseg_truncate_frequency = 1; 7SET @@global.innodb_purge_rseg_truncate_frequency = DEFAULT; 8SELECT @@global.innodb_purge_rseg_truncate_frequency; 9@@global.innodb_purge_rseg_truncate_frequency 10128 11'#---------------------FN_DYNVARS_046_02-------------------------#' 12SET innodb_purge_rseg_truncate_frequency = 1; 13ERROR HY000: Variable 'innodb_purge_rseg_truncate_frequency' is a GLOBAL variable and should be set with SET GLOBAL 14SELECT @@innodb_purge_rseg_truncate_frequency; 15@@innodb_purge_rseg_truncate_frequency 16128 17SELECT local.innodb_purge_rseg_truncate_frequency; 18ERROR 42S02: Unknown table 'local' in field list 19SET global innodb_purge_rseg_truncate_frequency = 1; 20SELECT @@global.innodb_purge_rseg_truncate_frequency; 21@@global.innodb_purge_rseg_truncate_frequency 221 23'#--------------------FN_DYNVARS_046_03------------------------#' 24SET @@global.innodb_purge_rseg_truncate_frequency = 1; 25SELECT @@global.innodb_purge_rseg_truncate_frequency; 26@@global.innodb_purge_rseg_truncate_frequency 271 28SET @@global.innodb_purge_rseg_truncate_frequency = 1; 29SELECT @@global.innodb_purge_rseg_truncate_frequency; 30@@global.innodb_purge_rseg_truncate_frequency 311 32SET @@global.innodb_purge_rseg_truncate_frequency = 128; 33SELECT @@global.innodb_purge_rseg_truncate_frequency; 34@@global.innodb_purge_rseg_truncate_frequency 35128 36'#--------------------FN_DYNVARS_046_05-------------------------#' 37SET @@global.innodb_purge_rseg_truncate_frequency = -1; 38Warnings: 39Warning 1292 Truncated incorrect innodb_purge_rseg_truncate_fr... value: '-1' 40SELECT @@global.innodb_purge_rseg_truncate_frequency; 41@@global.innodb_purge_rseg_truncate_frequency 421 43SET @@global.innodb_purge_rseg_truncate_frequency = -1024; 44Warnings: 45Warning 1292 Truncated incorrect innodb_purge_rseg_truncate_fr... value: '-1024' 46SELECT @@global.innodb_purge_rseg_truncate_frequency; 47@@global.innodb_purge_rseg_truncate_frequency 481 49SET @@global.innodb_purge_rseg_truncate_frequency = "T"; 50ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency' 51SELECT @@global.innodb_purge_rseg_truncate_frequency; 52@@global.innodb_purge_rseg_truncate_frequency 531 54SET @@global.innodb_purge_rseg_truncate_frequency = "Y"; 55ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency' 56SELECT @@global.innodb_purge_rseg_truncate_frequency; 57@@global.innodb_purge_rseg_truncate_frequency 581 59SET @@global.innodb_purge_rseg_truncate_frequency = 1.1; 60ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency' 61SELECT @@global.innodb_purge_rseg_truncate_frequency; 62@@global.innodb_purge_rseg_truncate_frequency 631 64SET @@global.innodb_purge_rseg_truncate_frequency = ' '; 65ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency' 66SELECT @@global.innodb_purge_rseg_truncate_frequency; 67@@global.innodb_purge_rseg_truncate_frequency 681 69SET @@global.innodb_purge_rseg_truncate_frequency = " "; 70ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency' 71SELECT @@global.innodb_purge_rseg_truncate_frequency; 72@@global.innodb_purge_rseg_truncate_frequency 731 74'#----------------------FN_DYNVARS_046_06------------------------#' 75SELECT @@global.innodb_purge_rseg_truncate_frequency = 76VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 77WHERE VARIABLE_NAME='innodb_purge_rseg_truncate_frequency'; 78@@global.innodb_purge_rseg_truncate_frequency = 79VARIABLE_VALUE 801 81SELECT @@global.innodb_purge_rseg_truncate_frequency; 82@@global.innodb_purge_rseg_truncate_frequency 831 84SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 85WHERE VARIABLE_NAME='innodb_purge_rseg_truncate_frequency'; 86VARIABLE_VALUE 871 88'#---------------------FN_DYNVARS_046_07-------------------------#' 89SET @@global.innodb_purge_rseg_truncate_frequency = OFF; 90ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency' 91SELECT @@global.innodb_purge_rseg_truncate_frequency; 92@@global.innodb_purge_rseg_truncate_frequency 931 94SET @@global.innodb_purge_rseg_truncate_frequency = ON; 95ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency' 96SELECT @@global.innodb_purge_rseg_truncate_frequency; 97@@global.innodb_purge_rseg_truncate_frequency 981 99'#---------------------FN_DYNVARS_046_08----------------------#' 100SET @@global.innodb_purge_rseg_truncate_frequency = TRUE; 101SELECT @@global.innodb_purge_rseg_truncate_frequency; 102@@global.innodb_purge_rseg_truncate_frequency 1031 104SET @@global.innodb_purge_rseg_truncate_frequency = FALSE; 105Warnings: 106Warning 1292 Truncated incorrect innodb_purge_rseg_truncate_fr... value: '0' 107SELECT @@global.innodb_purge_rseg_truncate_frequency; 108@@global.innodb_purge_rseg_truncate_frequency 1091 110SET @@global.innodb_purge_rseg_truncate_frequency = @global_start_value; 111SELECT @@global.innodb_purge_rseg_truncate_frequency; 112@@global.innodb_purge_rseg_truncate_frequency 113128 114