Debian Codegraph @

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

raw
1 ############### mysql-test\t\myisam_repair_threads_basic.test ###################
2 # #
3 # Variable Name: myisam_repair_threads #
4 # Scope: GLOBAL | SESSION #
5 # Access Type: Dynamic #
6 # Data Type: numeric #
7 # Default Value: 1 #
8 # Range: 1 - 4294967295/18446744073709551615 #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author: Sharique Abdullah #
13 # #
14 # Description: Test Cases of Dynamic System Variable myisam_repair_threads #
15 # that checks the 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 #
27 # #
28 #################################################################################
29
30 --source include/load_sysvars.inc
31
32 ######################################################################
33 # START OF myisam_repair_threads TESTS #
34 ######################################################################
35
36
37 #############################################################
38 # Save initial value #
39 #############################################################
40
41 SET @start_global_value = @@global.myisam_repair_threads;
42 SELECT @start_global_value;
43 SET @start_session_value = @@session.myisam_repair_threads;
44 SELECT @start_session_value;
45
46
47 --echo '#--------------------FN_DYNVARS_005_01-------------------------#'
48 #################################################################
49 # Display the DEFAULT value of myisam_block_size #
50 #################################################################
51
52 SET @@global.myisam_repair_threads = 100;
53 SET @@global.myisam_repair_threads = DEFAULT;
54 SELECT @@global.myisam_repair_threads ;
55
56 SET @@session.myisam_repair_threads = 200;
57 SET @@session.myisam_repair_threads = DEFAULT;
58 SELECT @@session.myisam_repair_threads ;
59
60
61 --echo '#--------------------FN_DYNVARS_005_02-------------------------#'
62 ######################################################################
63 # Check the DEFAULT value of myisam_repair_threads #
64 ######################################################################
65
66 SET @@global.myisam_repair_threads = DEFAULT;
67 SELECT @@global.myisam_repair_threads = 1;
68
69 SET @@session.myisam_repair_threads = DEFAULT;
70 SELECT @@session.myisam_repair_threads = 1;
71
72
73 --echo '#--------------------FN_DYNVARS_005_03-------------------------#'
74 ###############################################################################
75 # Change the value of myisam_repair_threads to a valid value for GLOBAL Scope#
76 ###############################################################################
77
78 SET @@global.myisam_repair_threads = 1;
79 SELECT @@global.myisam_repair_threads ;
80
81 SET @@global.myisam_repair_threads = 4294967295;
82 SELECT @@global.myisam_repair_threads ;
83
84 SET @@global.myisam_repair_threads = 655354;
85 SELECT @@global.myisam_repair_threads ;
86
87 # Test cases for 64-bit machines
88 if($mach64)
89 {
90 --disable_warnings
91 SET @@global.myisam_repair_threads = 18446744073709551615;
92 --enable_warnings
93
94 # Bug#11752618 - 64-BIT WINDOWS VARIABLES LIMITED TO DIFFERENT VALUES THAN 64-BIT LINUX/SO
95 let $machine_name = `SELECT CONVERT(@@version_compile_os using latin1) IN ("Win64", "Windows")`;
96
97 if($machine_name)
98 {
99 --replace_result 4294967295 18446744073709551615
100 }
101 SELECT @@global.myisam_repair_threads ;
102 }
103
104 --echo '#--------------------FN_DYNVARS_005_04-------------------------#'
105 ###############################################################################
106 # Change the value of myisam_repair_threads to a valid value for SESSION
107 # Scope
108 ###############################################################################
109
110 SET @@session.myisam_repair_threads = 1;
111 SELECT @@session.myisam_repair_threads ;
112
113 SET @@session.myisam_repair_threads = 4294967295;
114 SELECT @@session.myisam_repair_threads ;
115
116 SET @@session.myisam_repair_threads = 655345;
117 SELECT @@session.myisam_repair_threads ;
118
119 # Test cases for 64-bit machines
120 if($mach64)
121 {
122 --disable_warnings
123 SET @@session.myisam_repair_threads = 18446744073709551615;
124 --enable_warnings
125
126 # Bug#11752618 - 64-BIT WINDOWS VARIABLES LIMITED TO DIFFERENT VALUES THAN 64-BIT LINUX/SO
127 if($machine_name)
128 {
129 --replace_result 4294967295 18446744073709551615
130 }
131 SELECT @@session.myisam_repair_threads ;
132 }
133
134 --echo '#------------------FN_DYNVARS_005_05-----------------------#'
135 ##################################################################
136 # Change the value of myisam_repair_threads to an invalid value #
137 ##################################################################
138
139 SET @@global.myisam_repair_threads = 0;
140 SELECT @@global.myisam_repair_threads ;
141
142 SET @@global.myisam_repair_threads = -1024;
143 SELECT @@global.myisam_repair_threads ;
144
145 --Error ER_WRONG_TYPE_FOR_VAR
146 SET @@global.myisam_repair_threads = 65530.34;
147 SELECT @@global.myisam_repair_threads ;
148
149 --Error ER_WRONG_TYPE_FOR_VAR
150 SET @@global.myisam_repair_threads = test;
151 SELECT @@global.myisam_repair_threads ;
152
153 --Error ER_WRONG_TYPE_FOR_VAR
154 SET @@global.myisam_repair_threads = "test";
155 SELECT @@global.myisam_repair_threads ;
156
157 --Error ER_WRONG_TYPE_FOR_VAR
158 SET @@global.myisam_repair_threads = 'test';
159 SELECT @@global.myisam_repair_threads ;
160
161 --Error ER_WRONG_TYPE_FOR_VAR
162 SET @@global.myisam_repair_threads = ON;
163 SELECT @@global.myisam_repair_threads ;
164
165 if($mach32)
166 {
167 SET @@global.myisam_repair_threads = 4294967296;
168 SELECT @@global.myisam_repair_threads ;
169
170 SET @@global.myisam_repair_threads = 42949672950;
171 SELECT @@global.myisam_repair_threads ;
172 }
173
174 if($mach64)
175 {
176 --error ER_WRONG_TYPE_FOR_VAR
177 SET @@global.myisam_repair_threads = 18446744073709551616;
178 SELECT @@global.myisam_repair_threads ;
179 }
180
181 SET @@session.myisam_repair_threads = 0;
182 SELECT @@session.myisam_repair_threads ;
183
184 SET @@session.myisam_repair_threads = -2;
185 SELECT @@session.myisam_repair_threads ;
186
187 --Error ER_WRONG_TYPE_FOR_VAR
188 SET @@session.myisam_repair_threads = 65530.34;
189 SELECT @@session.myisam_repair_threads ;
190
191
192 --Error ER_WRONG_TYPE_FOR_VAR
193 SET @@session.myisam_repair_threads = test;
194 SELECT @@session.myisam_repair_threads ;
195
196 --Error ER_WRONG_TYPE_FOR_VAR
197 SET @@session.myisam_repair_threads = "test";
198 SELECT @@session.myisam_repair_threads ;
199
200 if($mach32)
201 {
202 SET @@session.myisam_repair_threads = 4294967296;
203 SELECT @@session.myisam_repair_threads ;
204
205 SET @@session.myisam_repair_threads = 42949672950;
206 SELECT @@session.myisam_repair_threads ;
207 }
208
209 if($mach64)
210 {
211 --error ER_WRONG_TYPE_FOR_VAR
212 SET @@session.myisam_repair_threads = 18446744073709551616;
213 SELECT @@session.myisam_repair_threads ;
214 }
215
216 --echo '#------------------FN_DYNVARS_005_06-----------------------#'
217 ####################################################################
218 # Check if the value in GLOBAL Table matches value in variable #
219 ####################################################################
220
221 --disable_warnings
222 SELECT @@global.myisam_repair_threads = VARIABLE_VALUE
223 FROM performance_schema.global_variables
224 WHERE VARIABLE_NAME='myisam_repair_threads';
225 --enable_warnings
226
227 --echo '#------------------FN_DYNVARS_005_07-----------------------#'
228 ####################################################################
229 # Check if the value in SESSION Table matches value in variable #
230 ####################################################################
231
232 --disable_warnings
233 SELECT @@session.myisam_repair_threads = VARIABLE_VALUE
234 FROM performance_schema.session_variables
235 WHERE VARIABLE_NAME='myisam_repair_threads';
236 --enable_warnings
237
238
239 --echo '#------------------FN_DYNVARS_005_08-----------------------#'
240 ####################################################################
241 # Check if TRUE and FALSE values can be used on variable #
242 ####################################################################
243
244 SET @@global.myisam_repair_threads = TRUE;
245 SELECT @@global.myisam_repair_threads ;
246 SET @@global.myisam_repair_threads = FALSE;
247 SELECT @@global.myisam_repair_threads ;
248
249
250
251 --echo '#---------------------FN_DYNVARS_001_09----------------------#'
252 ###############################################################################
253 # Check if accessing variable with and without GLOBAL point to same variable #
254 ###############################################################################
255
256 SET @@global.myisam_repair_threads = 10;
257 SELECT @@myisam_repair_threads = @@global.myisam_repair_threads ;
258
259
260 --echo '#---------------------FN_DYNVARS_001_10----------------------#'
261 ########################################################################################################
262 # Check if accessing variable with SESSION,LOCAL and without SCOPE points to
263 # same session variable #
264 ########################################################################################################
265
266 SET @@myisam_repair_threads = 100;
267 SELECT @@myisam_repair_threads = @@local.myisam_repair_threads ;
268 SELECT @@local.myisam_repair_threads = @@session.myisam_repair_threads ;
269
270
271 --echo '#---------------------FN_DYNVARS_001_11----------------------#'
272 ###################################################################################
273 # Check if myisam_repair_threads can be accessed with and without @@ sign #
274 ###################################################################################
275
276 SET myisam_repair_threads = 1;
277 SELECT @@myisam_repair_threads ;
278 --Error ER_UNKNOWN_TABLE
279
280 SELECT local.myisam_repair_threads ;
281
282 --Error ER_UNKNOWN_TABLE
283 SELECT session.myisam_repair_threads ;
284
285 --Error ER_BAD_FIELD_ERROR
286 SELECT myisam_repair_threads = @@session.myisam_repair_threads ;
287
288
289 ####################################
290 # Restore initial value #
291 ####################################
292
293 SET @@global.myisam_repair_threads = @start_global_value;
294 SELECT @@global.myisam_repair_threads ;
295 SET @@session.myisam_repair_threads = @start_session_value;
296 SELECT @@session.myisam_repair_threads ;
297
298
299 #############################################################
300 # END OF myisam_repair_threads TESTS #
301 #############################################################
302