Debian Codegraph @

mysql-test/suite/sys_vars/inc/bulk_insert_buffer_size_basic.inc

raw
1 ############### mysql-test\t\bulk_insert_buffer_size_basic.test ##################
2 # #
3 # Variable Name: bulk_insert_buffer_size #
4 # Scope: GLOBAL & SESSION #
5 # Access Type: Dynamic #
6 # Data Type: Numeric #
7 # Default Value: 8388608 #
8 # Range: 0 - 4294967295/18446744073709551615 #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author: Salman Rawala #
13 # #
14 # Description: Test Cases of Dynamic System Variable "bulk_insert_buffer_size" #
15 # that checks behavior of this variable in the following ways #
16 # * Default Value #
17 # * Valid & Invalid values #
18 # * Scope & Access method #
19 # * Data Integrity #
20 # #
21 # Modified: Pavan Naik, 2015-11-24 #
22 # Added boundary value test cases according to the type of the #
23 # server binary. #
24 # #
25 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
26 # server-system-variables.html#option_mysqld_bulk_insert_buffer_size #
27 # #
28 ##################################################################################
29
30 --source include/load_sysvars.inc
31
32 #######################################################################
33 # START OF bulk_insert_buffer_size TESTS #
34 #######################################################################
35
36 #############################################################
37 # Save initial value #
38 #############################################################
39
40 SET @start_global_value = @@global.bulk_insert_buffer_size;
41 SELECT @start_global_value;
42 SET @start_session_value = @@session.bulk_insert_buffer_size;
43 SELECT @start_session_value;
44
45 --echo '#--------------------FN_DYNVARS_007_01-------------------------#'
46 #######################################################################
47 # Display the DEFAULT value of bulk_insert_buffer_size #
48 #######################################################################
49
50 SET @@global.bulk_insert_buffer_size = 100;
51 SET @@global.bulk_insert_buffer_size = DEFAULT;
52 SELECT @@global.bulk_insert_buffer_size;
53
54 SET @@session.bulk_insert_buffer_size = 200;
55 SET @@session.bulk_insert_buffer_size = DEFAULT;
56 SELECT @@session.bulk_insert_buffer_size;
57
58
59 --echo '#--------------------FN_DYNVARS_007_02-------------------------#'
60 #######################################################################
61 # Check the DEFAULT value of bulk_insert_buffer_size #
62 #######################################################################
63
64 SET @@global.bulk_insert_buffer_size = @start_global_value;
65 SELECT @@global.bulk_insert_buffer_size = 8388608;
66
67 SET @@session.bulk_insert_buffer_size = @start_session_value;
68 SELECT @@session.bulk_insert_buffer_size = 8388608;
69
70
71 --echo '#--------------------FN_DYNVARS_007_03-------------------------#'
72 ###############################################################################
73 #Change the value of bulk_insert_buffer_size to valid values for GLOBAL Scope #
74 ###############################################################################
75
76 SET @@global.bulk_insert_buffer_size = 0;
77 SELECT @@global.bulk_insert_buffer_size;
78 SET @@global.bulk_insert_buffer_size = 1;
79 SELECT @@global.bulk_insert_buffer_size;
80 SET @@global.bulk_insert_buffer_size = 4294967295;
81 SELECT @@global.bulk_insert_buffer_size;
82 SET @@global.bulk_insert_buffer_size = 429496;
83 SELECT @@global.bulk_insert_buffer_size;
84
85 # Test cases for 64-bit machines
86 if($mach64)
87 {
88 --disable_warnings
89 SET @@global.bulk_insert_buffer_size = 18446744073709551615;
90 --enable_warnings
91
92 # Bug#11752618 - 64-BIT WINDOWS VARIABLES LIMITED TO DIFFERENT VALUES THAN 64-BIT LINUX/SO
93 let $machine_name = `SELECT CONVERT(@@version_compile_os using latin1) IN ("Win64", "Windows")`;
94
95 if($machine_name)
96 {
97 --replace_result 4294967295 18446744073709551615
98 }
99 SELECT @@global.bulk_insert_buffer_size;
100 }
101
102 --echo '#--------------------FN_DYNVARS_007_04-------------------------#'
103 ###############################################################################
104 #Change the value of bulk_insert_buffer_size to valid values for SESSION Scope#
105 ###############################################################################
106
107 SET @@session.bulk_insert_buffer_size = 0;
108 SELECT @@session.bulk_insert_buffer_size;
109 SET @@session.bulk_insert_buffer_size = 1;
110 SELECT @@session.bulk_insert_buffer_size;
111 SET @@session.bulk_insert_buffer_size = 4294967295;
112 SELECT @@session.bulk_insert_buffer_size;
113 SET @@session.bulk_insert_buffer_size = 429496;
114 SELECT @@session.bulk_insert_buffer_size;
115
116 # Test cases for 64-bit machines
117 if($mach64)
118 {
119 --disable_warnings
120 SET @@session.bulk_insert_buffer_size = 18446744073709551615;
121 --enable_warnings
122
123 # Bug#11752618 - 64-BIT WINDOWS VARIABLES LIMITED TO DIFFERENT VALUES THAN 64-BIT LINUX/SO
124 if($machine_name)
125 {
126 --replace_result 4294967295 18446744073709551615
127 }
128 SELECT @@session.bulk_insert_buffer_size;
129 }
130
131 --echo '#------------------FN_DYNVARS_007_05-----------------------#'
132 ###################################################################
133 # Change the value of bulk_insert_buffer_size to an invalid value #
134 ###################################################################
135
136 SET @@global.bulk_insert_buffer_size = -1024;
137 SELECT @@global.bulk_insert_buffer_size;
138
139 --Error ER_WRONG_TYPE_FOR_VAR
140 SET @@global.bulk_insert_buffer_size = test;
141 --Error ER_WRONG_TYPE_FOR_VAR
142 SET @@global.bulk_insert_buffer_size = ON;
143 --Error ER_WRONG_TYPE_FOR_VAR
144 SET @@global.bulk_insert_buffer_size = 429496.10;
145
146 if($mach32)
147 {
148 SET @@global.bulk_insert_buffer_size = 4294967296;
149 SELECT @@global.bulk_insert_buffer_size;
150
151 SET @@global.bulk_insert_buffer_size = 42949672950;
152 SELECT @@global.bulk_insert_buffer_size;
153 }
154
155 if($mach64)
156 {
157 --error ER_WRONG_TYPE_FOR_VAR
158 SET @@global.bulk_insert_buffer_size = 18446744073709551616;
159 SELECT @@global.bulk_insert_buffer_size;
160 }
161
162 SET @@session.bulk_insert_buffer_size = -2;
163 SELECT @@session.bulk_insert_buffer_size;
164
165 --Error ER_WRONG_TYPE_FOR_VAR
166 SET @@session.bulk_insert_buffer_size = test;
167 --Error ER_WRONG_TYPE_FOR_VAR
168 SET @@session.bulk_insert_buffer_size = 429496.10;
169
170 if($mach32)
171 {
172 SET @@session.bulk_insert_buffer_size = 4294967296;
173 SELECT @@session.bulk_insert_buffer_size;
174
175 SET @@session.bulk_insert_buffer_size = 42949672950;
176 SELECT @@session.bulk_insert_buffer_size;
177 }
178
179 if($mach64)
180 {
181 --error ER_WRONG_TYPE_FOR_VAR
182 SET @@session.bulk_insert_buffer_size = 18446744073709551616;
183 SELECT @@session.bulk_insert_buffer_size;
184 }
185
186 --echo '#------------------FN_DYNVARS_007_06-----------------------#'
187 ####################################################################
188 # Check if the value in GLOBAL Table matches value in variable #
189 ####################################################################
190
191 --disable_warnings
192 SELECT @@global.bulk_insert_buffer_size = VARIABLE_VALUE
193 FROM performance_schema.global_variables
194 WHERE VARIABLE_NAME='bulk_insert_buffer_size';
195 --enable_warnings
196
197 --echo '#------------------FN_DYNVARS_007_07-----------------------#'
198 ####################################################################
199 # Check if the value in SESSION Table matches value in variable #
200 ####################################################################
201
202 --disable_warnings
203 SELECT @@session.bulk_insert_buffer_size = VARIABLE_VALUE
204 FROM performance_schema.session_variables
205 WHERE VARIABLE_NAME='bulk_insert_buffer_size';
206 --enable_warnings
207
208
209 --echo '#------------------FN_DYNVARS_007_08-----------------------#'
210 ####################################################################
211 # Check if TRUE and FALSE values can be used on variable #
212 ####################################################################
213
214 SET @@global.bulk_insert_buffer_size = TRUE;
215 SELECT @@global.bulk_insert_buffer_size;
216 SET @@global.bulk_insert_buffer_size = FALSE;
217 SELECT @@global.bulk_insert_buffer_size;
218
219 SET @@session.bulk_insert_buffer_size = TRUE;
220 SELECT @@session.bulk_insert_buffer_size;
221 SET @@session.bulk_insert_buffer_size = FALSE;
222 SELECT @@session.bulk_insert_buffer_size;
223
224
225 --echo '#---------------------FN_DYNVARS_007_09----------------------#'
226 ##############################################################################
227 # Check if accessing variable with SESSION,LOCAL and without SCOPE points #
228 # to same session variable #
229 ##############################################################################
230
231 SET @@bulk_insert_buffer_size = 100;
232 SELECT @@bulk_insert_buffer_size = @@local.bulk_insert_buffer_size;
233 SELECT @@local.bulk_insert_buffer_size = @@session.bulk_insert_buffer_size;
234
235
236 --echo '#---------------------FN_DYNVARS_007_10----------------------#'
237 ###############################################################################
238 # Check if bulk_insert_buffer_size can be accessed with and without @@ sign #
239 ###############################################################################
240
241 SET bulk_insert_buffer_size = 1;
242 SELECT @@bulk_insert_buffer_size;
243 --Error ER_PARSE_ERROR
244 SET local.bulk_insert_buffer_size = 1;
245 --Error ER_UNKNOWN_TABLE
246 SELECT local.bulk_insert_buffer_size;
247 --Error ER_PARSE_ERROR
248 SET session.bulk_insert_buffer_size = 1;
249 --Error ER_UNKNOWN_TABLE
250 SELECT session.bulk_insert_buffer_size;
251 --Error ER_BAD_FIELD_ERROR
252 SELECT bulk_insert_buffer_size = @@session.bulk_insert_buffer_size;
253
254
255 ####################################
256 # Restore initial value #
257 ####################################
258
259 SET @@global.bulk_insert_buffer_size = @start_global_value;
260 SELECT @@global.bulk_insert_buffer_size;
261 SET @@session.bulk_insert_buffer_size = @start_session_value;
262 SELECT @@session.bulk_insert_buffer_size;
263
264
265 ####################################################
266 # END OF bulk_insert_buffer_size TESTS #
267 ####################################################