1SET @start_value = @@global.relay_log_purge; 2SELECT @start_value; 3@start_value 41 5'#--------------------FN_DYNVARS_141_01------------------------#' 6SET @@global.relay_log_purge = FALSE; 7SET @@global.relay_log_purge = DEFAULT; 8SELECT @@global.relay_log_purge; 9@@global.relay_log_purge 101 11'#---------------------FN_DYNVARS_141_02-------------------------#' 12SET @@global.relay_log_purge = @start_value; 13SELECT @@global.relay_log_purge = TRUE; 14@@global.relay_log_purge = TRUE 151 16'#--------------------FN_DYNVARS_141_03------------------------#' 17SET @@global.relay_log_purge = ON; 18SELECT @@global.relay_log_purge; 19@@global.relay_log_purge 201 21SET @@global.relay_log_purge = OFF; 22SELECT @@global.relay_log_purge; 23@@global.relay_log_purge 240 25SET @@global.relay_log_purge = 0; 26SELECT @@global.relay_log_purge; 27@@global.relay_log_purge 280 29SET @@global.relay_log_purge = 1; 30SELECT @@global.relay_log_purge; 31@@global.relay_log_purge 321 33SET @@global.relay_log_purge = TRUE; 34SELECT @@global.relay_log_purge; 35@@global.relay_log_purge 361 37SET @@global.relay_log_purge = FALSE; 38SELECT @@global.relay_log_purge; 39@@global.relay_log_purge 400 41'#--------------------FN_DYNVARS_141_04-------------------------#' 42SET @@global.relay_log_purge = 2; 43ERROR 42000: Variable 'relay_log_purge' can't be set to the value of '2' 44SET @@global.relay_log_purge = -1; 45ERROR 42000: Variable 'relay_log_purge' can't be set to the value of '-1' 46SET @@global.relay_log_purge = TRUEF; 47ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'TRUEF' 48SET @@global.relay_log_purge = TRUE_F; 49ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'TRUE_F' 50SET @@global.relay_log_purge = FALSE0; 51ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'FALSE0' 52SET @@global.relay_log_purge = OON; 53ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'OON' 54SET @@global.relay_log_purge = ONN; 55ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'ONN' 56SET @@global.relay_log_purge = OOFF; 57ERROR 42000: Variable 'relay_log_purge' can't be set to the value of 'OOFF' 58SET @@global.relay_log_purge = 0FF; 59ERROR 42000: Variable 'relay_log_purge' can't be set to the value of '0FF' 60SET @@global.relay_log_purge = ' '; 61ERROR 42000: Variable 'relay_log_purge' can't be set to the value of ' ' 62SET @@global.relay_log_purge = " "; 63ERROR 42000: Variable 'relay_log_purge' can't be set to the value of ' ' 64SET @@global.relay_log_purge = ''; 65ERROR 42000: Variable 'relay_log_purge' can't be set to the value of '' 66'#-------------------FN_DYNVARS_141_05----------------------------#' 67SET @@session.relay_log_purge = 1; 68ERROR HY000: Variable 'relay_log_purge' is a GLOBAL variable and should be set with SET GLOBAL 69SELECT @@session.relay_log_purge; 70ERROR HY000: Variable 'relay_log_purge' is a GLOBAL variable 71'#----------------------FN_DYNVARS_141_06------------------------#' 72SELECT IF(@@global.relay_log_purge, "ON", "OFF") = VARIABLE_VALUE 73FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 74WHERE VARIABLE_NAME='relay_log_purge'; 75IF(@@global.relay_log_purge, "ON", "OFF") = VARIABLE_VALUE 761 77'#---------------------FN_DYNVARS_141_07----------------------#' 78SET @@global.relay_log_purge = 1; 79SELECT @@relay_log_purge = @@global.relay_log_purge; 80@@relay_log_purge = @@global.relay_log_purge 811 82'#---------------------FN_DYNVARS_141_08----------------------#' 83SET relay_log_purge = 1; 84ERROR HY000: Variable 'relay_log_purge' is a GLOBAL variable and should be set with SET GLOBAL 85SELECT global.relay_log_purge; 86ERROR 42S02: Unknown table 'global' in field list 87SELECT relay_log_purge = @@session.relay_log_purge; 88ERROR 42S22: Unknown column 'relay_log_purge' in 'field list' 89SET @@global.relay_log_purge = @start_value; 90SELECT @@global.relay_log_purge; 91@@global.relay_log_purge 921 93