1
SET @start_value = @@global.max_binlog_stmt_cache_size;
5
'#--------------------FN_DYNVARS_072_01------------------------#'
6
SET @@global.max_binlog_stmt_cache_size = 5000;
8
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '5000'
9
SET @@global.max_binlog_stmt_cache_size = DEFAULT;
10
SELECT @@global.max_binlog_stmt_cache_size;
11
@@global.max_binlog_stmt_cache_size
13
'#---------------------FN_DYNVARS_072_02-------------------------#'
14
SET @@global.max_binlog_stmt_cache_size = @start_value;
15
SELECT @@global.max_binlog_stmt_cache_size = 4294967295;
16
@@global.max_binlog_stmt_cache_size = 4294967295
18
'#--------------------FN_DYNVARS_072_03------------------------#'
19
SET @@global.max_binlog_stmt_cache_size = 4096;
20
SELECT @@global.max_binlog_stmt_cache_size;
21
@@global.max_binlog_stmt_cache_size
23
SET @@global.max_binlog_stmt_cache_size = 4294967295;
25
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4294967295'
26
SELECT @@global.max_binlog_stmt_cache_size;
27
@@global.max_binlog_stmt_cache_size
29
SET @@global.max_binlog_stmt_cache_size = 4294967294;
31
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4294967294'
32
SELECT @@global.max_binlog_stmt_cache_size;
33
@@global.max_binlog_stmt_cache_size
35
SET @@global.max_binlog_stmt_cache_size = 4097;
37
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4097'
38
SELECT @@global.max_binlog_stmt_cache_size;
39
@@global.max_binlog_stmt_cache_size
41
SET @@global.max_binlog_stmt_cache_size = 65535;
43
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '65535'
44
SELECT @@global.max_binlog_stmt_cache_size;
45
@@global.max_binlog_stmt_cache_size
47
'#--------------------FN_DYNVARS_072_04-------------------------#'
48
SET @@global.max_binlog_stmt_cache_size = -1;
50
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '-1'
51
SELECT @@global.max_binlog_stmt_cache_size;
52
@@global.max_binlog_stmt_cache_size
54
SET @@global.max_binlog_stmt_cache_size = 100000000000;
56
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '100000000000'
57
SELECT @@global.max_binlog_stmt_cache_size;
58
@@global.max_binlog_stmt_cache_size
60
SET @@global.max_binlog_stmt_cache_size = 10000.01;
61
ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size'
62
SELECT @@global.max_binlog_stmt_cache_size;
63
@@global.max_binlog_stmt_cache_size
65
SET @@global.max_binlog_stmt_cache_size = -1024;
67
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '-1024'
68
SELECT @@global.max_binlog_stmt_cache_size;
69
@@global.max_binlog_stmt_cache_size
71
SET @@global.max_binlog_stmt_cache_size = 1024;
73
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '1024'
74
SELECT @@global.max_binlog_stmt_cache_size;
75
@@global.max_binlog_stmt_cache_size
77
SET @@global.max_binlog_stmt_cache_size = 4294967296;
78
SELECT @@global.max_binlog_stmt_cache_size;
79
@@global.max_binlog_stmt_cache_size
81
SET @@global.max_binlog_stmt_cache_size = 4095;
83
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '4095'
84
SELECT @@global.max_binlog_stmt_cache_size;
85
@@global.max_binlog_stmt_cache_size
87
SET @@global.max_binlog_stmt_cache_size = ON;
88
ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size'
89
SELECT @@global.max_binlog_stmt_cache_size;
90
@@global.max_binlog_stmt_cache_size
92
SET @@global.max_binlog_stmt_cache_size = 'test';
93
ERROR 42000: Incorrect argument type to variable 'max_binlog_stmt_cache_size'
94
SELECT @@global.max_binlog_stmt_cache_size;
95
@@global.max_binlog_stmt_cache_size
97
'#-------------------FN_DYNVARS_072_05----------------------------#'
98
SET @@session.max_binlog_stmt_cache_size = 4096;
99
ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
100
SELECT @@session.max_binlog_stmt_cache_size;
101
ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable
102
'#----------------------FN_DYNVARS_072_06------------------------#'
103
SELECT @@global.max_binlog_stmt_cache_size = VARIABLE_VALUE
104
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
105
WHERE VARIABLE_NAME='max_binlog_stmt_cache_size';
106
@@global.max_binlog_stmt_cache_size = VARIABLE_VALUE
108
SELECT @@max_binlog_stmt_cache_size = VARIABLE_VALUE
109
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
110
WHERE VARIABLE_NAME='max_binlog_stmt_cache_size';
111
@@max_binlog_stmt_cache_size = VARIABLE_VALUE
113
'#---------------------FN_DYNVARS_072_07----------------------#'
114
SET @@global.max_binlog_stmt_cache_size = TRUE;
116
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '1'
117
SELECT @@global.max_binlog_stmt_cache_size;
118
@@global.max_binlog_stmt_cache_size
120
SET @@global.max_binlog_stmt_cache_size = FALSE;
122
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '0'
123
SELECT @@global.max_binlog_stmt_cache_size;
124
@@global.max_binlog_stmt_cache_size
126
'#---------------------FN_DYNVARS_072_08----------------------#'
127
SET @@global.max_binlog_stmt_cache_size = 5000;
129
Warning 1292 Truncated incorrect max_binlog_stmt_cache_size value: '5000'
130
SELECT @@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size;
131
@@max_binlog_stmt_cache_size = @@global.max_binlog_stmt_cache_size
133
'#---------------------FN_DYNVARS_072_09----------------------#'
134
SET max_binlog_stmt_cache_size = 6000;
135
ERROR HY000: Variable 'max_binlog_stmt_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
136
SELECT @@max_binlog_stmt_cache_size;
137
@@max_binlog_stmt_cache_size
139
SET local.max_binlog_stmt_cache_size = 7000;
140
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_stmt_cache_size = 7000' at line 1
141
SELECT local.max_binlog_stmt_cache_size;
142
ERROR 42S02: Unknown table 'local' in field list
143
SET global.max_binlog_stmt_cache_size = 8000;
144
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_stmt_cache_size = 8000' at line 1
145
SELECT global.max_binlog_stmt_cache_size;
146
ERROR 42S02: Unknown table 'global' in field list
147
SELECT max_binlog_stmt_cache_size = @@session.max_binlog_stmt_cache_size;
148
ERROR 42S22: Unknown column 'max_binlog_stmt_cache_size' in 'field list'
149
SET @@global.max_binlog_stmt_cache_size = @start_value;
150
SELECT @@global.max_binlog_stmt_cache_size;
151
@@global.max_binlog_stmt_cache_size