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