1SET @start_max_binlog_cache_size = @@global.max_binlog_cache_size;
2SELECT @start_max_binlog_cache_size;
3@start_max_binlog_cache_size
418446744073709547520
5SET @start_binlog_cache_size = @@global.binlog_cache_size;
6SELECT @start_binlog_cache_size;
7@start_binlog_cache_size
832768
9'#--------------------FN_DYNVARS_072_01------------------------#'
10SET @@global.max_binlog_cache_size = 5000;
11Warnings:
12Warning	1292	Truncated incorrect max_binlog_cache_size value: '5000'
13Warning	1738	Option binlog_cache_size (32768) is greater than max_binlog_cache_size (4096); setting binlog_cache_size equal to max_binlog_cache_size.
14SET @@global.max_binlog_cache_size = DEFAULT;
15SELECT @@global.max_binlog_cache_size;
16@@global.max_binlog_cache_size
1718446744073709547520
18'#---------------------FN_DYNVARS_072_02-------------------------#'
19SET @@global.max_binlog_cache_size = @start_max_binlog_cache_size;
20SELECT @@global.max_binlog_cache_size = 4294967295;
21@@global.max_binlog_cache_size = 4294967295
220
23'#--------------------FN_DYNVARS_072_03------------------------#'
24SET @@global.max_binlog_cache_size = 4096;
25SELECT @@global.max_binlog_cache_size;
26@@global.max_binlog_cache_size
274096
28SET @@global.max_binlog_cache_size = 4294967295;
29Warnings:
30Warning	1292	Truncated incorrect max_binlog_cache_size value: '4294967295'
31SELECT @@global.max_binlog_cache_size;
32@@global.max_binlog_cache_size
334294963200
34SET @@global.max_binlog_cache_size = 4294967294;
35Warnings:
36Warning	1292	Truncated incorrect max_binlog_cache_size value: '4294967294'
37SELECT @@global.max_binlog_cache_size;
38@@global.max_binlog_cache_size
394294963200
40SET @@global.max_binlog_cache_size = 4097;
41Warnings:
42Warning	1292	Truncated incorrect max_binlog_cache_size value: '4097'
43SELECT @@global.max_binlog_cache_size;
44@@global.max_binlog_cache_size
454096
46SET @@global.max_binlog_cache_size = 65535;
47Warnings:
48Warning	1292	Truncated incorrect max_binlog_cache_size value: '65535'
49SELECT @@global.max_binlog_cache_size;
50@@global.max_binlog_cache_size
5161440
52'#--------------------FN_DYNVARS_072_04-------------------------#'
53SET @@global.max_binlog_cache_size = -1;
54Warnings:
55Warning	1292	Truncated incorrect max_binlog_cache_size value: '-1'
56SELECT @@global.max_binlog_cache_size;
57@@global.max_binlog_cache_size
584096
59SET @@global.max_binlog_cache_size = 100000000000;
60Warnings:
61Warning	1292	Truncated incorrect max_binlog_cache_size value: '100000000000'
62SELECT @@global.max_binlog_cache_size;
63@@global.max_binlog_cache_size
6499999997952
65SET @@global.max_binlog_cache_size = 10000.01;
66ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
67SELECT @@global.max_binlog_cache_size;
68@@global.max_binlog_cache_size
6999999997952
70SET @@global.max_binlog_cache_size = -1024;
71Warnings:
72Warning	1292	Truncated incorrect max_binlog_cache_size value: '-1024'
73SELECT @@global.max_binlog_cache_size;
74@@global.max_binlog_cache_size
754096
76SET @@global.max_binlog_cache_size = 1024;
77Warnings:
78Warning	1292	Truncated incorrect max_binlog_cache_size value: '1024'
79SELECT @@global.max_binlog_cache_size;
80@@global.max_binlog_cache_size
814096
82SET @@global.max_binlog_cache_size = 4294967296;
83SELECT @@global.max_binlog_cache_size;
84@@global.max_binlog_cache_size
854294967296
86SET @@global.max_binlog_cache_size = 4095;
87Warnings:
88Warning	1292	Truncated incorrect max_binlog_cache_size value: '4095'
89SELECT @@global.max_binlog_cache_size;
90@@global.max_binlog_cache_size
914096
92SET @@global.max_binlog_cache_size = ON;
93ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
94SELECT @@global.max_binlog_cache_size;
95@@global.max_binlog_cache_size
964096
97SET @@global.max_binlog_cache_size = 'test';
98ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
99SELECT @@global.max_binlog_cache_size;
100@@global.max_binlog_cache_size
1014096
102SET @@global.max_binlog_cache_size = ' ';
103ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
104SELECT @@global.max_binlog_cache_size;
105@@global.max_binlog_cache_size
1064096
107'#-------------------FN_DYNVARS_072_05----------------------------#'
108SET @@session.max_binlog_cache_size = 4096;
109ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
110SELECT @@session.max_binlog_cache_size;
111ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable
112'#----------------------FN_DYNVARS_072_06------------------------#'
113SELECT @@global.max_binlog_cache_size = VARIABLE_VALUE
114FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
115WHERE VARIABLE_NAME='max_binlog_cache_size';
116@@global.max_binlog_cache_size = VARIABLE_VALUE
1171
118SELECT @@max_binlog_cache_size = VARIABLE_VALUE
119FROM INFORMATION_SCHEMA.SESSION_VARIABLES
120WHERE VARIABLE_NAME='max_binlog_cache_size';
121@@max_binlog_cache_size = VARIABLE_VALUE
1221
123'#---------------------FN_DYNVARS_072_07----------------------#'
124SET @@global.max_binlog_cache_size = TRUE;
125Warnings:
126Warning	1292	Truncated incorrect max_binlog_cache_size value: '1'
127SELECT @@global.max_binlog_cache_size;
128@@global.max_binlog_cache_size
1294096
130SET @@global.max_binlog_cache_size = FALSE;
131Warnings:
132Warning	1292	Truncated incorrect max_binlog_cache_size value: '0'
133SELECT @@global.max_binlog_cache_size;
134@@global.max_binlog_cache_size
1354096
136'#---------------------FN_DYNVARS_072_08----------------------#'
137SET @@global.max_binlog_cache_size = 5000;
138Warnings:
139Warning	1292	Truncated incorrect max_binlog_cache_size value: '5000'
140SELECT @@max_binlog_cache_size = @@global.max_binlog_cache_size;
141@@max_binlog_cache_size = @@global.max_binlog_cache_size
1421
143'#---------------------FN_DYNVARS_072_09----------------------#'
144SET max_binlog_cache_size = 6000;
145ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
146SELECT @@max_binlog_cache_size;
147@@max_binlog_cache_size
1484096
149SET local.max_binlog_cache_size = 7000;
150ERROR 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.max_binlog_cache_size = 7000' at line 1
151SELECT local.max_binlog_cache_size;
152ERROR 42S02: Unknown table 'local' in field list
153SET global.max_binlog_cache_size = 8000;
154ERROR 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.max_binlog_cache_size = 8000' at line 1
155SELECT global.max_binlog_cache_size;
156ERROR 42S02: Unknown table 'global' in field list
157SELECT max_binlog_cache_size = @@session.max_binlog_cache_size;
158ERROR 42S22: Unknown column 'max_binlog_cache_size' in 'field list'
159SET @@global.max_binlog_cache_size = @start_max_binlog_cache_size;
160SELECT @@global.max_binlog_cache_size;
161@@global.max_binlog_cache_size
16218446744073709547520
163SET @@global.binlog_cache_size= @start_binlog_cache_size;
164SELECT @@global.binlog_cache_size;
165@@global.binlog_cache_size
16632768
167