1
SET @start_value = @@global.sync_binlog;
5
'#--------------------FN_DYNVARS_168_01------------------------#'
6
SET @@global.sync_binlog = 99;
7
SET @@global.sync_binlog = DEFAULT;
8
SELECT @@global.sync_binlog;
11
'#---------------------FN_DYNVARS_168_02-------------------------#'
12
SET @@global.sync_binlog = @start_value;
13
SELECT @@global.sync_binlog = 0;
14
@@global.sync_binlog = 0
16
'#--------------------FN_DYNVARS_168_03------------------------#'
17
SET @@global.sync_binlog = 0;
18
SELECT @@global.sync_binlog;
21
SET @@global.sync_binlog = 1;
22
SELECT @@global.sync_binlog;
25
SET @@global.sync_binlog = 4294967295;
26
SELECT @@global.sync_binlog;
29
SET @@global.sync_binlog = 4294967294;
30
SELECT @@global.sync_binlog;
33
SET @@global.sync_binlog = 65536;
34
SELECT @@global.sync_binlog;
37
'#--------------------FN_DYNVARS_168_04-------------------------#'
38
SET @@global.sync_binlog = -1;
39
SELECT @@global.sync_binlog;
42
SET @@global.sync_binlog = 4294967296;
43
SELECT @@global.sync_binlog;
46
SET @@global.sync_binlog = 10240022115;
47
SELECT @@global.sync_binlog;
50
SET @@global.sync_binlog = 10000.01;
51
ERROR 42000: Incorrect argument type to variable 'sync_binlog'
52
SELECT @@global.sync_binlog;
55
SET @@global.sync_binlog = -1024;
56
SELECT @@global.sync_binlog;
59
SET @@global.sync_binlog = 42949672950;
60
SELECT @@global.sync_binlog;
63
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
64
SET @@global.sync_binlog = ON;
65
ERROR 42000: Incorrect argument type to variable 'sync_binlog'
66
SELECT @@global.sync_binlog;
69
SET @@global.sync_binlog = 'test';
70
ERROR 42000: Incorrect argument type to variable 'sync_binlog'
71
SELECT @@global.sync_binlog;
74
'#-------------------FN_DYNVARS_168_05----------------------------#'
75
SET @@session.sync_binlog = 0;
76
ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL
80
'#----------------------FN_DYNVARS_168_06------------------------#'
81
SELECT @@global.sync_binlog = VARIABLE_VALUE
82
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
83
WHERE VARIABLE_NAME='sync_binlog';
84
@@global.sync_binlog = VARIABLE_VALUE
86
'#---------------------FN_DYNVARS_168_07----------------------#'
88
ERROR HY000: Variable 'sync_binlog' is a GLOBAL variable and should be set with SET GLOBAL
92
SET local.sync_binlog = 1;
93
ERROR 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 'sync_binlog = 1' at line 1
94
SELECT local.sync_binlog;
95
ERROR 42S02: Unknown table 'local' in field list
96
SET global.sync_binlog = 1;
97
ERROR 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 'sync_binlog = 1' at line 1
98
SELECT global.sync_binlog;
99
ERROR 42S02: Unknown table 'global' in field list
100
SELECT sync_binlog = @@session.sync_binlog;
101
ERROR 42S22: Unknown column 'sync_binlog' in 'field list'
102
SET @@global.sync_binlog = @start_value;
103
SELECT @@global.sync_binlog;