Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_doublewrite_basic.test

raw
1 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
2 --echo 1 Expected
3
4 --Error ER_WRONG_ARGUMENTS
5 SET @@GLOBAL.innodb_doublewrite=off;
6 SET @@GLOBAL.innodb_doublewrite=on;
7
8 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
9 --echo 1 Expected
10
11 --disable_warnings
12 SELECT @@GLOBAL.innodb_doublewrite = VARIABLE_VALUE
13 FROM performance_schema.global_variables
14 WHERE VARIABLE_NAME='innodb_doublewrite';
15 --enable_warnings
16 --echo 1 Expected
17
18 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
19 --echo 1 Expected
20
21 --disable_warnings
22 SELECT COUNT(VARIABLE_VALUE)
23 FROM performance_schema.global_variables
24 WHERE VARIABLE_NAME='innodb_doublewrite';
25 --enable_warnings
26 --echo 1 Expected
27
28 SELECT @@innodb_doublewrite = @@GLOBAL.innodb_doublewrite;
29 --echo 1 Expected
30
31
32 SELECT COUNT(@@innodb_doublewrite);
33 --echo 1 Expected
34
35 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
36 SELECT COUNT(@@local.innodb_doublewrite);
37 --echo Expected error 'Variable is a GLOBAL variable'
38
39 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
40 SELECT COUNT(@@SESSION.innodb_doublewrite);
41 --echo Expected error 'Variable is a GLOBAL variable'
42
43 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
44 --echo 1 Expected
45
46 --echo "##############################################"
47 --let $restart_parameters = "restart: --innodb-doublewrite=ON"
48 --source include/restart_mysqld.inc
49 SELECT @@global.innodb_doublewrite;
50
51 --echo # doublewrite mode is OFF
52 --Error ER_WRONG_ARGUMENTS
53 SET @@GLOBAL.innodb_doublewrite=0;
54 SELECT @@global.innodb_doublewrite;
55
56 --echo # doublewrite mode is ON
57 SET @@GLOBAL.innodb_doublewrite=1;
58 SELECT @@global.innodb_doublewrite;
59
60 --echo # doublewrite mode is DETECT_ONLY
61 SET @@GLOBAL.innodb_doublewrite=2;
62 SELECT @@global.innodb_doublewrite;
63
64 --echo # doublewrite mode is DETECT_AND_RECOVER
65 SET @@GLOBAL.innodb_doublewrite=3;
66 SELECT @@global.innodb_doublewrite;
67
68 --echo # doublewrite mode is FALSE
69 --error ER_WRONG_ARGUMENTS
70 SET @@GLOBAL.innodb_doublewrite=4;
71 SELECT @@global.innodb_doublewrite;
72
73 --echo # doublewrite mode is TRUE
74 SET @@GLOBAL.innodb_doublewrite=5;
75 SELECT @@global.innodb_doublewrite;
76
77 --error ER_WRONG_VALUE_FOR_VAR
78 SET @@GLOBAL.innodb_doublewrite=6;
79 SELECT @@global.innodb_doublewrite;
80
81 --echo "##############################################"
82 --let $restart_parameters = "restart: --innodb-doublewrite=DETECT_AND_RECOVER"
83 --source include/restart_mysqld.inc
84 SELECT @@global.innodb_doublewrite;
85
86 --echo # doublewrite mode is OFF
87 --Error ER_WRONG_ARGUMENTS
88 SET @@GLOBAL.innodb_doublewrite=0;
89 SELECT @@global.innodb_doublewrite;
90
91 --echo # doublewrite mode is ON
92 SET @@GLOBAL.innodb_doublewrite=1;
93 SELECT @@global.innodb_doublewrite;
94
95 --echo # doublewrite mode is DETECT_ONLY
96 SET @@GLOBAL.innodb_doublewrite=2;
97 SELECT @@global.innodb_doublewrite;
98
99 --echo # doublewrite mode is DETECT_AND_RECOVER
100 SET @@GLOBAL.innodb_doublewrite=3;
101 SELECT @@global.innodb_doublewrite;
102
103 --echo # doublewrite mode is FALSE
104 --error ER_WRONG_ARGUMENTS
105 SET @@GLOBAL.innodb_doublewrite=4;
106 SELECT @@global.innodb_doublewrite;
107
108 --echo # doublewrite mode is TRUE
109 SET @@GLOBAL.innodb_doublewrite=5;
110 SELECT @@global.innodb_doublewrite;
111
112 --error ER_WRONG_VALUE_FOR_VAR
113 SET @@GLOBAL.innodb_doublewrite=6;
114 SELECT @@global.innodb_doublewrite;
115
116 --echo "##############################################"
117 --let $restart_parameters = "restart: --innodb-doublewrite=off"
118 --source include/restart_mysqld.inc
119 SELECT @@global.innodb_doublewrite;
120
121 --echo # doublewrite mode is OFF
122 SET @@GLOBAL.innodb_doublewrite=0;
123 SELECT @@global.innodb_doublewrite;
124
125 --echo # doublewrite mode is ON
126 --Error ER_WRONG_ARGUMENTS
127 SET @@GLOBAL.innodb_doublewrite=1;
128 SELECT @@global.innodb_doublewrite;
129
130 --echo # doublewrite mode is DETECT_ONLY
131 --Error ER_WRONG_ARGUMENTS
132 SET @@GLOBAL.innodb_doublewrite=2;
133 SELECT @@global.innodb_doublewrite;
134
135 --echo # doublewrite mode is DETECT_AND_RECOVER
136 --Error ER_WRONG_ARGUMENTS
137 SET @@GLOBAL.innodb_doublewrite=3;
138 SELECT @@global.innodb_doublewrite;
139
140 --echo # doublewrite mode is FALSE
141 SET @@GLOBAL.innodb_doublewrite=4;
142 SELECT @@global.innodb_doublewrite;
143
144 --echo # doublewrite mode is TRUE
145 --Error ER_WRONG_ARGUMENTS
146 SET @@GLOBAL.innodb_doublewrite=5;
147 SELECT @@global.innodb_doublewrite;
148
149 --error ER_WRONG_VALUE_FOR_VAR
150 SET @@GLOBAL.innodb_doublewrite=6;
151 SELECT @@global.innodb_doublewrite;
152
153 --echo "##############################################"
154 --let $restart_parameters = "restart: --innodb-doublewrite=FALSE"
155 --source include/restart_mysqld.inc
156 SELECT @@global.innodb_doublewrite;
157
158 --echo # doublewrite mode is OFF
159 SET @@GLOBAL.innodb_doublewrite=0;
160 SELECT @@global.innodb_doublewrite;
161
162 --echo # doublewrite mode is ON
163 --Error ER_WRONG_ARGUMENTS
164 SET @@GLOBAL.innodb_doublewrite=1;
165 SELECT @@global.innodb_doublewrite;
166
167 --echo # doublewrite mode is DETECT_ONLY
168 --Error ER_WRONG_ARGUMENTS
169 SET @@GLOBAL.innodb_doublewrite=2;
170 SELECT @@global.innodb_doublewrite;
171
172 --echo # doublewrite mode is DETECT_AND_RECOVER
173 --Error ER_WRONG_ARGUMENTS
174 SET @@GLOBAL.innodb_doublewrite=3;
175 SELECT @@global.innodb_doublewrite;
176
177 --echo # doublewrite mode is FALSE
178 SET @@GLOBAL.innodb_doublewrite=4;
179 SELECT @@global.innodb_doublewrite;
180
181 --echo # doublewrite mode is TRUE
182 --Error ER_WRONG_ARGUMENTS
183 SET @@GLOBAL.innodb_doublewrite=5;
184 SELECT @@global.innodb_doublewrite;
185
186 --error ER_WRONG_VALUE_FOR_VAR
187 SET @@GLOBAL.innodb_doublewrite=6;
188 SELECT @@global.innodb_doublewrite;
189
190
191 --echo "##############################################"
192 --let $restart_parameters = "restart: --innodb-doublewrite=DETECT_ONLY"
193 --source include/restart_mysqld.inc
194 SELECT @@global.innodb_doublewrite;
195
196 --Error ER_WRONG_ARGUMENTS
197 SET @@GLOBAL.innodb_doublewrite=off;
198 SELECT @@global.innodb_doublewrite;
199
200 --Error ER_WRONG_ARGUMENTS
201 SET @@GLOBAL.innodb_doublewrite=false;
202 SELECT @@global.innodb_doublewrite;
203
204 SET @@GLOBAL.innodb_doublewrite=on;
205 SELECT @@global.innodb_doublewrite;
206
207 SET @@GLOBAL.innodb_doublewrite=detect_only;
208 SELECT @@global.innodb_doublewrite;
209
210 SET @@GLOBAL.innodb_doublewrite=DETECT_AND_RECOVER;
211 SELECT @@global.innodb_doublewrite;
212
213 SET @@GLOBAL.innodb_doublewrite=true;
214 SELECT @@global.innodb_doublewrite;
215
216 --echo "##############################################"
217 --let $restart_parameters = "restart: --innodb-doublewrite"
218 --source include/restart_mysqld.inc
219 SELECT @@global.innodb_doublewrite;
220
221 --Error ER_WRONG_ARGUMENTS
222 SET @@GLOBAL.innodb_doublewrite=off;
223 SELECT @@global.innodb_doublewrite;
224
225 --Error ER_WRONG_ARGUMENTS
226 SET @@GLOBAL.innodb_doublewrite=false;
227 SELECT @@global.innodb_doublewrite;
228
229 SET @@GLOBAL.innodb_doublewrite=on;
230 SELECT @@global.innodb_doublewrite;
231
232 SET @@GLOBAL.innodb_doublewrite=detect_only;
233 SELECT @@global.innodb_doublewrite;
234
235 SET @@GLOBAL.innodb_doublewrite=true;
236 SELECT @@global.innodb_doublewrite;
237
238 SET @@GLOBAL.innodb_doublewrite=detect_and_recover;
239 SELECT @@global.innodb_doublewrite;
240
241 --echo "##############################################"
242 --let $restart_parameters = "restart: --innodb-doublewrite=0"
243 --source include/restart_mysqld.inc
244 SELECT @@global.innodb_doublewrite;
245
246 --echo # doublewrite mode is OFF
247 SET @@GLOBAL.innodb_doublewrite=0;
248 SELECT @@global.innodb_doublewrite;
249
250 --echo # doublewrite mode is ON
251 --Error ER_WRONG_ARGUMENTS
252 SET @@GLOBAL.innodb_doublewrite=1;
253 SELECT @@global.innodb_doublewrite;
254
255 --echo # doublewrite mode is DETECT_ONLY
256 --Error ER_WRONG_ARGUMENTS
257 SET @@GLOBAL.innodb_doublewrite=2;
258 SELECT @@global.innodb_doublewrite;
259
260 --echo # doublewrite mode is DETECT_AND_RECOVER
261 --Error ER_WRONG_ARGUMENTS
262 SET @@GLOBAL.innodb_doublewrite=3;
263 SELECT @@global.innodb_doublewrite;
264
265 --echo # doublewrite mode is FALSE
266 SET @@GLOBAL.innodb_doublewrite=4;
267 SELECT @@global.innodb_doublewrite;
268
269 --echo # doublewrite mode is TRUE
270 --Error ER_WRONG_ARGUMENTS
271 SET @@GLOBAL.innodb_doublewrite=5;
272 SELECT @@global.innodb_doublewrite;
273
274 --error ER_WRONG_VALUE_FOR_VAR
275 SET @@GLOBAL.innodb_doublewrite=6;
276 SELECT @@global.innodb_doublewrite;
277
278 --echo "##############################################"
279 --let $restart_parameters = "restart: --innodb-doublewrite=1"
280 --source include/restart_mysqld.inc
281 SELECT @@global.innodb_doublewrite;
282
283 --echo # doublewrite mode is OFF
284 --Error ER_WRONG_ARGUMENTS
285 SET @@GLOBAL.innodb_doublewrite=0;
286 SELECT @@global.innodb_doublewrite;
287
288 --echo # doublewrite mode is ON
289 SET @@GLOBAL.innodb_doublewrite=1;
290 SELECT @@global.innodb_doublewrite;
291
292 --echo # doublewrite mode is DETECT_ONLY
293 SET @@GLOBAL.innodb_doublewrite=2;
294 SELECT @@global.innodb_doublewrite;
295
296 --echo # doublewrite mode is DETECT_AND_RECOVER
297 SET @@GLOBAL.innodb_doublewrite=3;
298 SELECT @@global.innodb_doublewrite;
299
300 --echo # doublewrite mode is FALSE
301 --Error ER_WRONG_ARGUMENTS
302 SET @@GLOBAL.innodb_doublewrite=4;
303 SELECT @@global.innodb_doublewrite;
304
305 --echo # doublewrite mode is TRUE
306 SET @@GLOBAL.innodb_doublewrite=5;
307 SELECT @@global.innodb_doublewrite;
308
309 --error ER_WRONG_VALUE_FOR_VAR
310 SET @@GLOBAL.innodb_doublewrite=6;
311 SELECT @@global.innodb_doublewrite;
312
313 --echo "##############################################"
314 --let $restart_parameters = "restart: --innodb-doublewrite=3"
315 --source include/restart_mysqld.inc
316 SELECT @@global.innodb_doublewrite;
317
318 --echo # doublewrite mode is OFF
319 --Error ER_WRONG_ARGUMENTS
320 SET @@GLOBAL.innodb_doublewrite=0;
321 SELECT @@global.innodb_doublewrite;
322
323 --echo # doublewrite mode is ON
324 SET @@GLOBAL.innodb_doublewrite=1;
325 SELECT @@global.innodb_doublewrite;
326
327 --echo # doublewrite mode is DETECT_ONLY
328 SET @@GLOBAL.innodb_doublewrite=2;
329 SELECT @@global.innodb_doublewrite;
330
331 --echo # doublewrite mode is DETECT_AND_RECOVER
332 SET @@GLOBAL.innodb_doublewrite=3;
333 SELECT @@global.innodb_doublewrite;
334
335 --echo # doublewrite mode is FALSE
336 --Error ER_WRONG_ARGUMENTS
337 SET @@GLOBAL.innodb_doublewrite=4;
338 SELECT @@global.innodb_doublewrite;
339
340 --echo # doublewrite mode is TRUE
341 SET @@GLOBAL.innodb_doublewrite=5;
342 SELECT @@global.innodb_doublewrite;
343
344 --error ER_WRONG_VALUE_FOR_VAR
345 SET @@GLOBAL.innodb_doublewrite=6;
346 SELECT @@global.innodb_doublewrite;
347
348 --echo "##############################################"
349 --let $restart_parameters = "restart: --innodb-doublewrite=4"
350 --source include/restart_mysqld.inc
351 SELECT @@global.innodb_doublewrite;
352
353 --echo # doublewrite mode is OFF
354 SET @@GLOBAL.innodb_doublewrite=0;
355 SELECT @@global.innodb_doublewrite;
356
357 --echo # doublewrite mode is ON
358 --Error ER_WRONG_ARGUMENTS
359 SET @@GLOBAL.innodb_doublewrite=1;
360 SELECT @@global.innodb_doublewrite;
361
362 --echo # doublewrite mode is DETECT_ONLY
363 --Error ER_WRONG_ARGUMENTS
364 SET @@GLOBAL.innodb_doublewrite=2;
365 SELECT @@global.innodb_doublewrite;
366
367 --echo # doublewrite mode is DETECT_AND_RECOVER
368 --Error ER_WRONG_ARGUMENTS
369 SET @@GLOBAL.innodb_doublewrite=3;
370 SELECT @@global.innodb_doublewrite;
371
372 --echo # doublewrite mode is FALSE
373 SET @@GLOBAL.innodb_doublewrite=4;
374 SELECT @@global.innodb_doublewrite;
375
376 --echo # doublewrite mode is TRUE
377 --Error ER_WRONG_ARGUMENTS
378 SET @@GLOBAL.innodb_doublewrite=5;
379 SELECT @@global.innodb_doublewrite;
380
381 --error ER_WRONG_VALUE_FOR_VAR
382 SET @@GLOBAL.innodb_doublewrite=6;
383 SELECT @@global.innodb_doublewrite;
384
385 --echo "##############################################"
386 --let $restart_parameters = "restart: --innodb-doublewrite=5"
387 --source include/restart_mysqld.inc
388 SELECT @@global.innodb_doublewrite;
389
390 --echo # doublewrite mode is OFF
391 --Error ER_WRONG_ARGUMENTS
392 SET @@GLOBAL.innodb_doublewrite=0;
393 SELECT @@global.innodb_doublewrite;
394
395 --echo # doublewrite mode is ON
396 SET @@GLOBAL.innodb_doublewrite=1;
397 SELECT @@global.innodb_doublewrite;
398
399 --echo # doublewrite mode is DETECT_ONLY
400 SET @@GLOBAL.innodb_doublewrite=2;
401 SELECT @@global.innodb_doublewrite;
402
403 --echo # doublewrite mode is DETECT_AND_RECOVER
404 SET @@GLOBAL.innodb_doublewrite=3;
405 SELECT @@global.innodb_doublewrite;
406
407 --echo # doublewrite mode is FALSE
408 --Error ER_WRONG_ARGUMENTS
409 SET @@GLOBAL.innodb_doublewrite=4;
410 SELECT @@global.innodb_doublewrite;
411
412 --echo # doublewrite mode is TRUE
413 SET @@GLOBAL.innodb_doublewrite=5;
414 SELECT @@global.innodb_doublewrite;
415
416 --error ER_WRONG_VALUE_FOR_VAR
417 SET @@GLOBAL.innodb_doublewrite=6;
418 SELECT @@global.innodb_doublewrite;
419
420 --echo "##############################################"
421 --let $restart_parameters = "restart: --innodb-doublewrite=2"
422 --source include/restart_mysqld.inc
423 SELECT @@global.innodb_doublewrite;
424
425 --echo # doublewrite mode is OFF
426 --Error ER_WRONG_ARGUMENTS
427 SET @@GLOBAL.innodb_doublewrite=0;
428 SELECT @@global.innodb_doublewrite;
429
430 --echo # doublewrite mode is ON
431 SET @@GLOBAL.innodb_doublewrite=1;
432 SELECT @@global.innodb_doublewrite;
433
434 --echo # doublewrite mode is DETECT_ONLY
435 SET @@GLOBAL.innodb_doublewrite=2;
436 SELECT @@global.innodb_doublewrite;
437
438 --echo # doublewrite mode is DETECT_AND_RECOVER
439 SET @@GLOBAL.innodb_doublewrite=3;
440 SELECT @@global.innodb_doublewrite;
441
442 --echo # doublewrite mode is FALSE
443 --Error ER_WRONG_ARGUMENTS
444 SET @@GLOBAL.innodb_doublewrite=4;
445 SELECT @@global.innodb_doublewrite;
446
447 --echo # doublewrite mode is TRUE
448 SET @@GLOBAL.innodb_doublewrite=5;
449 SELECT @@global.innodb_doublewrite;
450
451 --error ER_WRONG_VALUE_FOR_VAR
452 SET @@GLOBAL.innodb_doublewrite=6;
453 SELECT @@global.innodb_doublewrite;
454
455 --let $restart_parameters =
456 --source include/restart_mysqld.inc
457
458 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
459 SET PERSIST innodb_doublewrite=ON;
460 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
461 SET PERSIST innodb_doublewrite=OFF;
462 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
463 SET PERSIST innodb_doublewrite=DETECT_ONLY;
464
465 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
466 SET PERSIST_ONLY innodb_doublewrite=ON;
467 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
468 SET PERSIST_ONLY innodb_doublewrite=OFF;
469 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
470 SET PERSIST_ONLY innodb_doublewrite=DETECT_ONLY;
471