1SET @start_value = @@global.sync_binlog; 2SELECT @start_value; 3@start_value 41 5'#--------------------FN_DYNVARS_168_01------------------------#' 6SET @@global.sync_binlog = 99; 7SET @@global.sync_binlog = DEFAULT; 8SELECT @@global.sync_binlog; 9@@global.sync_binlog 101 11'#---------------------FN_DYNVARS_168_02-------------------------#' 12SET @@global.sync_binlog = @start_value; 13SELECT @@global.sync_binlog = 1; 14@@global.sync_binlog = 1 151 16'#--------------------FN_DYNVARS_168_03------------------------#' 17SET @@global.sync_binlog = 0; 18SELECT @@global.sync_binlog; 19@@global.sync_binlog 200 21SET @@global.sync_binlog = 1; 22SELECT @@global.sync_binlog; 23@@global.sync_binlog 241 25SET @@global.sync_binlog = 4294967295; 26SELECT @@global.sync_binlog; 27@@global.sync_binlog 284294967295 29SET @@global.sync_binlog = 4294967294; 30SELECT @@global.sync_binlog; 31@@global.sync_binlog 324294967294 33SET @@global.sync_binlog = 65536; 34SELECT @@global.sync_binlog; 35@@global.sync_binlog 3665536 37'#--------------------FN_DYNVARS_168_04-------------------------#' 38SET @@global.sync_binlog = -1; 39Warnings: 40Warning 1292 Truncated incorrect sync_binlog value: '-1' 41SELECT @@global.sync_binlog; 42@@global.sync_binlog 430 44SET @@global.sync_binlog = 4294967296; 45Warnings: 46Warning 1292 Truncated incorrect sync_binlog value: '4294967296' 47SELECT @@global.sync_binlog; 48@@global.sync_binlog 494294967295 50SET @@global.sync_binlog = 10240022115; 51Warnings: 52Warning 1292 Truncated incorrect sync_binlog value: '10240022115' 53SELECT @@global.sync_binlog; 54@@global.sync_binlog 554294967295 56SET @@global.sync_binlog = 10000.01; 57ERROR 42000: Incorrect argument type to variable 'sync_binlog' 58SELECT @@global.sync_binlog; 59@@global.sync_binlog 604294967295 61SET @@global.sync_binlog = -1024; 62Warnings: 63Warning 1292 Truncated incorrect sync_binlog value: '-1024' 64SELECT @@global.sync_binlog; 65@@global.sync_binlog 660 67SET @@global.sync_binlog = 42949672950; 68Warnings: 69Warning 1292 Truncated incorrect sync_binlog value: '42949672950' 70SELECT @@global.sync_binlog; 71@@global.sync_binlog 724294967295 73SET @@global.sync_binlog = ON; 74ERROR 42000: Incorrect argument type to variable 'sync_binlog' 75SELECT @@global.sync_binlog; 76@@global.sync_binlog 774294967295 78SET @@global.sync_binlog = 'test'; 79ERROR 42000: Incorrect argument type to variable 'sync_binlog' 80SELECT @@global.sync_binlog; 81@@global.sync_binlog 824294967295 83'#-------------------FN_DYNVARS_168_05----------------------------#' 84SET @@session.sync_binlog = 0; 85ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL 86SELECT @@sync_binlog; 87@@sync_binlog 884294967295 89'#----------------------FN_DYNVARS_168_06------------------------#' 90SELECT @@global.sync_binlog = VARIABLE_VALUE 91FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 92WHERE VARIABLE_NAME='sync_binlog'; 93@@global.sync_binlog = VARIABLE_VALUE 941 95'#---------------------FN_DYNVARS_168_07----------------------#' 96SET sync_binlog = 1; 97ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL 98SELECT @@sync_binlog; 99@@sync_binlog 1004294967295 101SET local.sync_binlog = 1; 102ERROR 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 'local.sync_binlog = 1' at line 1 103SELECT local.sync_binlog; 104ERROR 42S02: Unknown table 'local' in field list 105SET global.sync_binlog = 1; 106ERROR 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_binlog = 1' at line 1 107SELECT global.sync_binlog; 108ERROR 42S02: Unknown table 'global' in field list 109SELECT sync_binlog = @@session.sync_binlog; 110ERROR 42S22: Unknown column 'sync_binlog' in 'field list' 111SET @@global.sync_binlog = @start_value; 112SELECT @@global.sync_binlog; 113@@global.sync_binlog 1141 115