1
SET @start_value = @@global.max_binlog_cache_size;
5
'#--------------------FN_DYNVARS_072_01------------------------#'
6
SET @@global.max_binlog_cache_size = 5000;
7
SET @@global.max_binlog_cache_size = DEFAULT;
8
SELECT @@global.max_binlog_cache_size;
9
@@global.max_binlog_cache_size
11
'#---------------------FN_DYNVARS_072_02-------------------------#'
12
SET @@global.max_binlog_cache_size = @start_value;
13
SELECT @@global.max_binlog_cache_size = 4294967295;
14
@@global.max_binlog_cache_size = 4294967295
16
'Bug# 34876: Incorrect Default Value is assigned to variable';
17
'#--------------------FN_DYNVARS_072_03------------------------#'
18
SET @@global.max_binlog_cache_size = 4096;
19
SELECT @@global.max_binlog_cache_size;
20
@@global.max_binlog_cache_size
22
SET @@global.max_binlog_cache_size = 4294967295;
23
SELECT @@global.max_binlog_cache_size;
24
@@global.max_binlog_cache_size
26
SET @@global.max_binlog_cache_size = 4294967294;
27
SELECT @@global.max_binlog_cache_size;
28
@@global.max_binlog_cache_size
30
SET @@global.max_binlog_cache_size = 4097;
31
SELECT @@global.max_binlog_cache_size;
32
@@global.max_binlog_cache_size
34
SET @@global.max_binlog_cache_size = 65535;
35
SELECT @@global.max_binlog_cache_size;
36
@@global.max_binlog_cache_size
38
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
39
'#--------------------FN_DYNVARS_072_04-------------------------#'
40
SET @@global.max_binlog_cache_size = -1;
42
Warning 1292 Truncated incorrect max_binlog_cache_size value: '0'
43
SELECT @@global.max_binlog_cache_size;
44
@@global.max_binlog_cache_size
46
SET @@global.max_binlog_cache_size = 100000000000;
48
Warning 1292 Truncated incorrect max_binlog_cache_size value: '100000000000'
49
SELECT @@global.max_binlog_cache_size;
50
@@global.max_binlog_cache_size
52
SET @@global.max_binlog_cache_size = 10000.01;
53
ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
54
SELECT @@global.max_binlog_cache_size;
55
@@global.max_binlog_cache_size
57
SET @@global.max_binlog_cache_size = -1024;
59
Warning 1292 Truncated incorrect max_binlog_cache_size value: '0'
60
SELECT @@global.max_binlog_cache_size;
61
@@global.max_binlog_cache_size
63
SET @@global.max_binlog_cache_size = 1024;
65
Warning 1292 Truncated incorrect max_binlog_cache_size value: '1024'
66
SELECT @@global.max_binlog_cache_size;
67
@@global.max_binlog_cache_size
69
SET @@global.max_binlog_cache_size = 4294967296;
71
Warning 1292 Truncated incorrect max_binlog_cache_size value: '4294967296'
72
SELECT @@global.max_binlog_cache_size;
73
@@global.max_binlog_cache_size
75
SET @@global.max_binlog_cache_size = 4095;
77
Warning 1292 Truncated incorrect max_binlog_cache_size value: '4095'
78
SELECT @@global.max_binlog_cache_size;
79
@@global.max_binlog_cache_size
81
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
82
SET @@global.max_binlog_cache_size = ON;
83
ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
84
SELECT @@global.max_binlog_cache_size;
85
@@global.max_binlog_cache_size
87
SET @@global.max_binlog_cache_size = 'test';
88
ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
89
SELECT @@global.max_binlog_cache_size;
90
@@global.max_binlog_cache_size
92
'#-------------------FN_DYNVARS_072_05----------------------------#'
93
SET @@session.max_binlog_cache_size = 4096;
94
ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
95
SELECT @@session.max_binlog_cache_size;
96
ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable
97
'#----------------------FN_DYNVARS_072_06------------------------#'
98
SELECT @@global.max_binlog_cache_size = VARIABLE_VALUE
99
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
100
WHERE VARIABLE_NAME='max_binlog_cache_size';
101
@@global.max_binlog_cache_size = VARIABLE_VALUE
103
SELECT @@max_binlog_cache_size = VARIABLE_VALUE
104
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
105
WHERE VARIABLE_NAME='max_binlog_cache_size';
106
@@max_binlog_cache_size = VARIABLE_VALUE
108
'#---------------------FN_DYNVARS_072_07----------------------#'
109
SET @@global.max_binlog_cache_size = TRUE;
111
Warning 1292 Truncated incorrect max_binlog_cache_size value: '1'
112
SELECT @@global.max_binlog_cache_size;
113
@@global.max_binlog_cache_size
115
SET @@global.max_binlog_cache_size = FALSE;
117
Warning 1292 Truncated incorrect max_binlog_cache_size value: '0'
118
SELECT @@global.max_binlog_cache_size;
119
@@global.max_binlog_cache_size
121
'#---------------------FN_DYNVARS_072_08----------------------#'
122
SET @@global.max_binlog_cache_size = 5000;
123
SELECT @@max_binlog_cache_size = @@global.max_binlog_cache_size;
124
@@max_binlog_cache_size = @@global.max_binlog_cache_size
126
'#---------------------FN_DYNVARS_072_09----------------------#'
127
SET max_binlog_cache_size = 6000;
128
ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
129
SELECT @@max_binlog_cache_size;
130
@@max_binlog_cache_size
132
SET local.max_binlog_cache_size = 7000;
133
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 'max_binlog_cache_size = 7000' at line 1
134
SELECT local.max_binlog_cache_size;
135
ERROR 42S02: Unknown table 'local' in field list
136
SET global.max_binlog_cache_size = 8000;
137
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 'max_binlog_cache_size = 8000' at line 1
138
SELECT global.max_binlog_cache_size;
139
ERROR 42S02: Unknown table 'global' in field list
140
SELECT max_binlog_cache_size = @@session.max_binlog_cache_size;
141
ERROR 42S22: Unknown column 'max_binlog_cache_size' in 'field list'
142
SET @@global.max_binlog_cache_size = @start_value;
143
SELECT @@global.max_binlog_cache_size;
144
@@global.max_binlog_cache_size