1SET @start_value = @@global.sync_frm; 2Warnings: 3Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 4SELECT @start_value; 5@start_value 61 7'#--------------------FN_DYNVARS_169_01------------------------#' 8SET @@global.sync_frm = FALSE; 9Warnings: 10Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 11SET @@global.sync_frm = DEFAULT; 12Warnings: 13Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 14SELECT @@global.sync_frm; 15@@global.sync_frm 161 17Warnings: 18Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 19'#---------------------FN_DYNVARS_169_02-------------------------#' 20SET @@global.sync_frm = DEFAULT; 21Warnings: 22Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 23SELECT @@global.sync_frm = TRUE; 24@@global.sync_frm = TRUE 251 26Warnings: 27Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 28'#--------------------FN_DYNVARS_169_03------------------------#' 29SET @@global.sync_frm = ON; 30Warnings: 31Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 32SELECT @@global.sync_frm; 33@@global.sync_frm 341 35Warnings: 36Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 37SET @@global.sync_frm = OFF; 38Warnings: 39Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 40SELECT @@global.sync_frm; 41@@global.sync_frm 420 43Warnings: 44Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 45SET @@global.sync_frm = 0; 46Warnings: 47Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 48SELECT @@global.sync_frm; 49@@global.sync_frm 500 51Warnings: 52Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 53SET @@global.sync_frm = 1; 54Warnings: 55Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 56SELECT @@global.sync_frm; 57@@global.sync_frm 581 59Warnings: 60Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 61SET @@global.sync_frm = TRUE; 62Warnings: 63Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 64SELECT @@global.sync_frm; 65@@global.sync_frm 661 67Warnings: 68Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 69SET @@global.sync_frm = FALSE; 70Warnings: 71Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 72SELECT @@global.sync_frm; 73@@global.sync_frm 740 75Warnings: 76Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 77'#--------------------FN_DYNVARS_169_04-------------------------#' 78SET @@global.sync_frm = 2; 79ERROR 42000: Variable 'sync_frm' can't be set to the value of '2' 80SET @@global.sync_frm = -1; 81ERROR 42000: Variable 'sync_frm' can't be set to the value of '-1' 82SET @@global.sync_frm = TRUEF; 83ERROR 42000: Variable 'sync_frm' can't be set to the value of 'TRUEF' 84SET @@global.sync_frm = TRUE_F; 85ERROR 42000: Variable 'sync_frm' can't be set to the value of 'TRUE_F' 86SET @@global.sync_frm = FALSE0; 87ERROR 42000: Variable 'sync_frm' can't be set to the value of 'FALSE0' 88SET @@global.sync_frm = OON; 89ERROR 42000: Variable 'sync_frm' can't be set to the value of 'OON' 90SET @@global.sync_frm = ONN; 91ERROR 42000: Variable 'sync_frm' can't be set to the value of 'ONN' 92SET @@global.sync_frm = OOFF; 93ERROR 42000: Variable 'sync_frm' can't be set to the value of 'OOFF' 94SET @@global.sync_frm = 0FF; 95ERROR 42000: Variable 'sync_frm' can't be set to the value of '0FF' 96SET @@global.sync_frm = ' '; 97ERROR 42000: Variable 'sync_frm' can't be set to the value of ' ' 98SET @@global.sync_frm = " "; 99ERROR 42000: Variable 'sync_frm' can't be set to the value of ' ' 100SET @@global.sync_frm = ''; 101ERROR 42000: Variable 'sync_frm' can't be set to the value of '' 102'#-------------------FN_DYNVARS_169_05----------------------------#' 103SET @@session.sync_frm = 1; 104ERROR HY000: Variable 'sync_frm' is a GLOBAL variable and should be set with SET GLOBAL 105SELECT @@session.sync_frm; 106ERROR HY000: Variable 'sync_frm' is a GLOBAL variable 107'#----------------------FN_DYNVARS_169_06------------------------#' 108SELECT IF(@@global.sync_frm, "ON", "OFF") = VARIABLE_VALUE 109FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 110WHERE VARIABLE_NAME='sync_frm'; 111IF(@@global.sync_frm, "ON", "OFF") = VARIABLE_VALUE 1121 113'#---------------------FN_DYNVARS_169_07----------------------#' 114SET @@global.sync_frm = 1; 115Warnings: 116Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 117SELECT @@sync_frm = @@global.sync_frm; 118@@sync_frm = @@global.sync_frm 1191 120Warnings: 121Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 122Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 123'#---------------------FN_DYNVARS_169_08----------------------#' 124SET sync_frm = 1; 125ERROR HY000: Variable 'sync_frm' is a GLOBAL variable and should be set with SET GLOBAL 126SELECT @@sync_frm; 127@@sync_frm 1281 129Warnings: 130Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 131SET global.sync_frm = 1; 132ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.sync_frm = 1' at line 1 133SELECT global.sync_frm; 134ERROR 42S02: Unknown table 'global' in field list 135SELECT sync_frm = @@session.sync_frm; 136ERROR 42S22: Unknown column 'sync_frm' in 'field list' 137SET @@global.sync_frm = @start_value; 138Warnings: 139Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 140SELECT @@global.sync_frm; 141@@global.sync_frm 1421 143Warnings: 144Warning 1287 '@@sync_frm' is deprecated and will be removed in a future release. 145