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