1
SET @start_global_value = @@global.join_buffer_size;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.join_buffer_size;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_053_01-------------------------#'
10
SET @@global.join_buffer_size = 8200;
12
Warning 1292 Truncated incorrect join_buffer_size value: '8200'
13
SET @@global.join_buffer_size = DEFAULT;
14
SELECT @@global.join_buffer_size;
15
@@global.join_buffer_size
17
SET @@session.join_buffer_size = 8200;
19
Warning 1292 Truncated incorrect join_buffer_size value: '8200'
20
SET @@session.join_buffer_size = DEFAULT;
21
SELECT @@session.join_buffer_size;
22
@@session.join_buffer_size
24
'#--------------------FN_DYNVARS_053_02-------------------------#'
25
SET @@global.join_buffer_size = DEFAULT;
26
SELECT @@global.join_buffer_size = 131072;
27
@@global.join_buffer_size = 131072
29
SET @@session.join_buffer_size = DEFAULT;
30
SELECT @@session.join_buffer_size = 131072;
31
@@session.join_buffer_size = 131072
33
'#--------------------FN_DYNVARS_053_03-------------------------#'
34
SET @@global.join_buffer_size = 8200;
36
Warning 1292 Truncated incorrect join_buffer_size value: '8200'
37
SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
38
@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
40
SET @@global.join_buffer_size = 65536;
41
SELECT @@global.join_buffer_size;
42
@@global.join_buffer_size
44
SET @@global.join_buffer_size = 4294967295;
45
SELECT @@global.join_buffer_size;
46
@@global.join_buffer_size
48
'Bug # 34837: Errors are not coming on assigning invalid values to variable'
49
'#--------------------FN_DYNVARS_053_04-------------------------#'
50
SET @@session.join_buffer_size = 8200;
52
Warning 1292 Truncated incorrect join_buffer_size value: '8200'
53
SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228;
54
@@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228
56
SET @@session.join_buffer_size = 65536;
57
SELECT @@session.join_buffer_size;
58
@@session.join_buffer_size
60
SET @@session.join_buffer_size = 4294967295;
61
SELECT @@session.join_buffer_size;
62
@@session.join_buffer_size
64
'Bug # 34837: Errors are not coming on assigning invalid values to variable'
65
'#------------------FN_DYNVARS_053_05-----------------------#'
66
SET @@global.join_buffer_size = 0;
68
Warning 1292 Truncated incorrect join_buffer_size value: '0'
69
SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
70
@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
72
SET @@global.join_buffer_size = -1024;
74
Warning 1292 Truncated incorrect join_buffer_size value: '0'
75
SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
76
@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
78
SET @@global.join_buffer_size = 8199;
80
Warning 1292 Truncated incorrect join_buffer_size value: '8199'
81
SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
82
@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
84
SET @@global.join_buffer_size = 42949672951;
86
Warning 1292 Truncated incorrect join_buffer_size value: '42949672951'
87
SELECT @@global.join_buffer_size;
88
@@global.join_buffer_size
90
SET @@global.join_buffer_size = 65530.34.;
91
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 '.' at line 1
92
SELECT @@global.join_buffer_size;
93
@@global.join_buffer_size
95
SET @@global.join_buffer_size = test;
96
ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
97
SELECT @@global.join_buffer_size;
98
@@global.join_buffer_size
100
SET @@session.join_buffer_size = 0;
102
Warning 1292 Truncated incorrect join_buffer_size value: '0'
103
SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228;
104
@@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228
106
SET @@session.join_buffer_size = -2;
108
Warning 1292 Truncated incorrect join_buffer_size value: '0'
109
SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228;
110
@@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228
112
SET @@session.join_buffer_size = 8199;
114
Warning 1292 Truncated incorrect join_buffer_size value: '8199'
115
SELECT @@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228;
116
@@session.join_buffer_size=8200 OR @@session.join_buffer_size= 8228
118
SET @@session.join_buffer_size = 42949672951;
120
Warning 1292 Truncated incorrect join_buffer_size value: '42949672951'
121
SELECT @@session.join_buffer_size;
122
@@session.join_buffer_size
124
SET @@session.join_buffer_size = 65530.34.;
125
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 '.' at line 1
126
SELECT @@session.join_buffer_size;
127
@@session.join_buffer_size
129
'Bug # 34837: Errors are not coming on assigning invalid values to variable'
130
SET @@session.join_buffer_size = test;
131
ERROR 42000: Incorrect argument type to variable 'join_buffer_size'
132
SELECT @@session.join_buffer_size;
133
@@session.join_buffer_size
135
'#------------------FN_DYNVARS_053_06-----------------------#'
136
SELECT @@global.join_buffer_size = VARIABLE_VALUE
137
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
138
WHERE VARIABLE_NAME='join_buffer_size';
139
@@global.join_buffer_size = VARIABLE_VALUE
141
'#------------------FN_DYNVARS_053_07-----------------------#'
142
SELECT @@session.join_buffer_size = VARIABLE_VALUE
143
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
144
WHERE VARIABLE_NAME='join_buffer_size';
145
@@session.join_buffer_size = VARIABLE_VALUE
147
'#------------------FN_DYNVARS_053_08-----------------------#'
148
SET @@global.join_buffer_size = TRUE;
150
Warning 1292 Truncated incorrect join_buffer_size value: '1'
151
SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
152
@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
154
SET @@global.join_buffer_size = FALSE;
156
Warning 1292 Truncated incorrect join_buffer_size value: '0'
157
SELECT @@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228;
158
@@global.join_buffer_size=8200 OR @@global.join_buffer_size= 8228
160
'Bug: Errors are not coming on assigning TRUE/FALSE to variable';
161
'#---------------------FN_DYNVARS_001_09----------------------#'
162
SET @@global.join_buffer_size = 10;
164
Warning 1292 Truncated incorrect join_buffer_size value: '10'
165
SELECT @@join_buffer_size = @@global.join_buffer_size;
166
@@join_buffer_size = @@global.join_buffer_size
168
'#---------------------FN_DYNVARS_001_10----------------------#'
169
SET @@join_buffer_size = 100;
171
Warning 1292 Truncated incorrect join_buffer_size value: '100'
172
SELECT @@join_buffer_size = @@local.join_buffer_size;
173
@@join_buffer_size = @@local.join_buffer_size
175
SELECT @@local.join_buffer_size = @@session.join_buffer_size;
176
@@local.join_buffer_size = @@session.join_buffer_size
178
'#---------------------FN_DYNVARS_001_11----------------------#'
179
SET join_buffer_size = 1;
181
Warning 1292 Truncated incorrect join_buffer_size value: '1'
182
SELECT @@join_buffer_size=8200 OR @@join_buffer_size= 8228;
183
@@join_buffer_size=8200 OR @@join_buffer_size= 8228
185
SELECT local.join_buffer_size;
186
ERROR 42S02: Unknown table 'local' in field list
187
SELECT session.join_buffer_size;
188
ERROR 42S02: Unknown table 'session' in field list
189
SELECT join_buffer_size = @@session.join_buffer_size;
190
ERROR 42S22: Unknown column 'join_buffer_size' in 'field list'
191
SET @@global.join_buffer_size = @start_global_value;
192
SELECT @@global.join_buffer_size;
193
@@global.join_buffer_size
195
SET @@session.join_buffer_size = @start_session_value;
196
SELECT @@session.join_buffer_size;
197
@@session.join_buffer_size