1
SET @start_global_value = @@global.preload_buffer_size;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.preload_buffer_size;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_129_01-------------------------#'
10
SET @@global.preload_buffer_size = 10000;
11
SET @@global.preload_buffer_size = DEFAULT;
12
SELECT @@global.preload_buffer_size;
13
@@global.preload_buffer_size
15
SET @@session.preload_buffer_size = 20000;
16
SET @@session.preload_buffer_size = DEFAULT;
17
SELECT @@session.preload_buffer_size;
18
@@session.preload_buffer_size
20
'#--------------------FN_DYNVARS_129_02-------------------------#'
21
SET @@global.preload_buffer_size = DEFAULT;
22
SELECT @@global.preload_buffer_size = 32768;
23
@@global.preload_buffer_size = 32768
25
SET @@session.preload_buffer_size = DEFAULT;
26
SELECT @@session.preload_buffer_size = 32768;
27
@@session.preload_buffer_size = 32768
29
'#--------------------FN_DYNVARS_129_03-------------------------#'
30
SET @@global.preload_buffer_size = 1024;
31
SELECT @@global.preload_buffer_size;
32
@@global.preload_buffer_size
34
SET @@global.preload_buffer_size = 1025;
35
SELECT @@global.preload_buffer_size;
36
@@global.preload_buffer_size
38
SET @@global.preload_buffer_size = 1073741824;
39
SELECT @@global.preload_buffer_size;
40
@@global.preload_buffer_size
42
SET @@global.preload_buffer_size = 1073741823;
43
SELECT @@global.preload_buffer_size;
44
@@global.preload_buffer_size
46
SET @@global.preload_buffer_size = 65536;
47
SELECT @@global.preload_buffer_size;
48
@@global.preload_buffer_size
50
'#--------------------FN_DYNVARS_129_04-------------------------#'
51
SET @@session.preload_buffer_size = 1024;
52
SELECT @@session.preload_buffer_size;
53
@@session.preload_buffer_size
55
SET @@session.preload_buffer_size = 1025;
56
SELECT @@session.preload_buffer_size;
57
@@session.preload_buffer_size
59
SET @@session.preload_buffer_size = 1073741824;
60
SELECT @@session.preload_buffer_size;
61
@@session.preload_buffer_size
63
SET @@session.preload_buffer_size = 1073741823;
64
SELECT @@session.preload_buffer_size;
65
@@session.preload_buffer_size
67
SET @@session.preload_buffer_size = 655536;
68
SELECT @@session.preload_buffer_size;
69
@@session.preload_buffer_size
71
'#------------------FN_DYNVARS_129_05-----------------------#'
72
SET @@global.preload_buffer_size = 64;
74
Warning 1292 Truncated incorrect preload_buffer_size value: '64'
75
SELECT @@global.preload_buffer_size;
76
@@global.preload_buffer_size
78
SET @@global.preload_buffer_size = -1;
80
Warning 1292 Truncated incorrect preload_buffer_size value: '0'
81
SELECT @@global.preload_buffer_size;
82
@@global.preload_buffer_size
84
SET @@global.preload_buffer_size = 1023;
86
Warning 1292 Truncated incorrect preload_buffer_size value: '1023'
87
SELECT @@global.preload_buffer_size;
88
@@global.preload_buffer_size
90
SET @@global.preload_buffer_size = 1073741825;
92
Warning 1292 Truncated incorrect preload_buffer_size value: '1073741825'
93
SELECT @@global.preload_buffer_size;
94
@@global.preload_buffer_size
96
SET @@global.preload_buffer_size = 65530.34.;
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 '.' at line 1
98
SELECT @@global.preload_buffer_size;
99
@@global.preload_buffer_size
101
SET @@global.preload_buffer_size = test;
102
ERROR 42000: Incorrect argument type to variable 'preload_buffer_size'
103
SELECT @@global.preload_buffer_size;
104
@@global.preload_buffer_size
106
SET @@session.preload_buffer_size = 64;
108
Warning 1292 Truncated incorrect preload_buffer_size value: '64'
109
SELECT @@session.preload_buffer_size;
110
@@session.preload_buffer_size
112
SET @@session.preload_buffer_size = -2;
114
Warning 1292 Truncated incorrect preload_buffer_size value: '0'
115
SELECT @@session.preload_buffer_size;
116
@@session.preload_buffer_size
118
SET @@session.preload_buffer_size = 65530.34.;
119
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
120
SET @@session.preload_buffer_size = 1023;
122
Warning 1292 Truncated incorrect preload_buffer_size value: '1023'
123
SELECT @@session.preload_buffer_size;
124
@@session.preload_buffer_size
126
SET @@session.preload_buffer_size = 1073741825;
128
Warning 1292 Truncated incorrect preload_buffer_size value: '1073741825'
129
SELECT @@session.preload_buffer_size;
130
@@session.preload_buffer_size
132
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
133
SET @@session.preload_buffer_size = test;
134
ERROR 42000: Incorrect argument type to variable 'preload_buffer_size'
135
SELECT @@session.preload_buffer_size;
136
@@session.preload_buffer_size
138
'#------------------FN_DYNVARS_129_06-----------------------#'
139
SELECT @@global.preload_buffer_size = VARIABLE_VALUE
140
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
141
WHERE VARIABLE_NAME='preload_buffer_size';
142
@@global.preload_buffer_size = VARIABLE_VALUE
144
'#------------------FN_DYNVARS_129_07-----------------------#'
145
SELECT @@session.preload_buffer_size = VARIABLE_VALUE
146
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
147
WHERE VARIABLE_NAME='preload_buffer_size';
148
@@session.preload_buffer_size = VARIABLE_VALUE
150
'#------------------FN_DYNVARS_129_08-----------------------#'
151
SET @@global.preload_buffer_size = TRUE;
153
Warning 1292 Truncated incorrect preload_buffer_size value: '1'
154
SELECT @@global.preload_buffer_size;
155
@@global.preload_buffer_size
157
SET @@global.preload_buffer_size = FALSE;
159
Warning 1292 Truncated incorrect preload_buffer_size value: '0'
160
SELECT @@global.preload_buffer_size;
161
@@global.preload_buffer_size
163
'#---------------------FN_DYNVARS_129_09----------------------#'
164
SET @@global.preload_buffer_size = 2048;
165
SELECT @@preload_buffer_size = @@global.preload_buffer_size;
166
@@preload_buffer_size = @@global.preload_buffer_size
168
'#---------------------FN_DYNVARS_129_10----------------------#'
169
SET @@preload_buffer_size = 5000;
170
SELECT @@preload_buffer_size = @@local.preload_buffer_size;
171
@@preload_buffer_size = @@local.preload_buffer_size
173
SELECT @@local.preload_buffer_size = @@session.preload_buffer_size;
174
@@local.preload_buffer_size = @@session.preload_buffer_size
176
'#---------------------FN_DYNVARS_129_11----------------------#'
177
SET preload_buffer_size = 1024;
178
SELECT @@preload_buffer_size;
179
@@preload_buffer_size
181
SELECT local.preload_buffer_size;
182
ERROR 42S02: Unknown table 'local' in field list
183
SELECT session.preload_buffer_size;
184
ERROR 42S02: Unknown table 'session' in field list
185
SELECT preload_buffer_size = @@session.preload_buffer_size;
186
ERROR 42S22: Unknown column 'preload_buffer_size' in 'field list'
187
SET @@global.preload_buffer_size = @start_global_value;
188
SELECT @@global.preload_buffer_size;
189
@@global.preload_buffer_size
191
SET @@session.preload_buffer_size = @start_session_value;
192
SELECT @@session.preload_buffer_size;
193
@@session.preload_buffer_size