Debian Codegraph @

mysql-test/suite/maria/maria-page-checksum.result

raw
1 drop table if exists t1;
2 select @@global.aria_page_checksum;
3 @@global.aria_page_checksum
4 1
5 # iteration 1a
6 set global aria_page_checksum = 0 ;
7 create table t1(a int) engine=aria ;
8 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
9 Table Create Table
10 t1 CREATE TABLE `t1` (
11 `a` int(11) DEFAULT NULL
12 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
13 Page checksums are not used
14 set global aria_page_checksum = 0 ;
15 alter table t1 engine=aria ;
16 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `a` int(11) DEFAULT NULL
20 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
21 Page checksums are not used
22 drop table t1;
23 # iteration 2a
24 set global aria_page_checksum = 0 ;
25 create table t1(a int) engine=aria ;
26 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
27 Table Create Table
28 t1 CREATE TABLE `t1` (
29 `a` int(11) DEFAULT NULL
30 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
31 Page checksums are not used
32 set global aria_page_checksum = 0 ;
33 alter table t1 PAGE_CHECKSUM=0 ;
34 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
35 Table Create Table
36 t1 CREATE TABLE `t1` (
37 `a` int(11) DEFAULT NULL
38 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
39 Page checksums are not used
40 drop table t1;
41 # iteration 3a
42 set global aria_page_checksum = 0 ;
43 create table t1(a int) engine=aria ;
44 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
45 Table Create Table
46 t1 CREATE TABLE `t1` (
47 `a` int(11) DEFAULT NULL
48 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
49 Page checksums are not used
50 set global aria_page_checksum = 0 ;
51 alter table t1 PAGE_CHECKSUM=1 ;
52 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
53 Table Create Table
54 t1 CREATE TABLE `t1` (
55 `a` int(11) DEFAULT NULL
56 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
57 Page checksums are used
58 drop table t1;
59 # iteration 4a
60 set global aria_page_checksum = 0 ;
61 create table t1(a int) engine=aria ;
62 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
63 Table Create Table
64 t1 CREATE TABLE `t1` (
65 `a` int(11) DEFAULT NULL
66 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
67 Page checksums are not used
68 set global aria_page_checksum = 1 ;
69 alter table t1 engine=aria ;
70 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
71 Table Create Table
72 t1 CREATE TABLE `t1` (
73 `a` int(11) DEFAULT NULL
74 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
75 Page checksums are not used
76 drop table t1;
77 # iteration 5a
78 set global aria_page_checksum = 0 ;
79 create table t1(a int) engine=aria ;
80 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
81 Table Create Table
82 t1 CREATE TABLE `t1` (
83 `a` int(11) DEFAULT NULL
84 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
85 Page checksums are not used
86 set global aria_page_checksum = 1 ;
87 alter table t1 PAGE_CHECKSUM=0 ;
88 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
89 Table Create Table
90 t1 CREATE TABLE `t1` (
91 `a` int(11) DEFAULT NULL
92 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
93 Page checksums are not used
94 drop table t1;
95 # iteration 6a
96 set global aria_page_checksum = 0 ;
97 create table t1(a int) engine=aria ;
98 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
99 Table Create Table
100 t1 CREATE TABLE `t1` (
101 `a` int(11) DEFAULT NULL
102 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
103 Page checksums are not used
104 set global aria_page_checksum = 1 ;
105 alter table t1 PAGE_CHECKSUM=1 ;
106 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
107 Table Create Table
108 t1 CREATE TABLE `t1` (
109 `a` int(11) DEFAULT NULL
110 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
111 Page checksums are used
112 drop table t1;
113 # iteration 7a
114 set global aria_page_checksum = 0 ;
115 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
116 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
117 Table Create Table
118 t1 CREATE TABLE `t1` (
119 `a` int(11) DEFAULT NULL
120 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
121 Page checksums are not used
122 set global aria_page_checksum = 0 ;
123 alter table t1 engine=aria ;
124 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
125 Table Create Table
126 t1 CREATE TABLE `t1` (
127 `a` int(11) DEFAULT NULL
128 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
129 Page checksums are not used
130 drop table t1;
131 # iteration 8a
132 set global aria_page_checksum = 0 ;
133 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
134 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
135 Table Create Table
136 t1 CREATE TABLE `t1` (
137 `a` int(11) DEFAULT NULL
138 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
139 Page checksums are not used
140 set global aria_page_checksum = 0 ;
141 alter table t1 PAGE_CHECKSUM=0 ;
142 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
143 Table Create Table
144 t1 CREATE TABLE `t1` (
145 `a` int(11) DEFAULT NULL
146 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
147 Page checksums are not used
148 drop table t1;
149 # iteration 9a
150 set global aria_page_checksum = 0 ;
151 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
152 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
153 Table Create Table
154 t1 CREATE TABLE `t1` (
155 `a` int(11) DEFAULT NULL
156 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
157 Page checksums are not used
158 set global aria_page_checksum = 0 ;
159 alter table t1 PAGE_CHECKSUM=1 ;
160 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
161 Table Create Table
162 t1 CREATE TABLE `t1` (
163 `a` int(11) DEFAULT NULL
164 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
165 Page checksums are used
166 drop table t1;
167 # iteration 10a
168 set global aria_page_checksum = 0 ;
169 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
170 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
171 Table Create Table
172 t1 CREATE TABLE `t1` (
173 `a` int(11) DEFAULT NULL
174 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
175 Page checksums are not used
176 set global aria_page_checksum = 1 ;
177 alter table t1 engine=aria ;
178 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
179 Table Create Table
180 t1 CREATE TABLE `t1` (
181 `a` int(11) DEFAULT NULL
182 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
183 Page checksums are not used
184 drop table t1;
185 # iteration 11a
186 set global aria_page_checksum = 0 ;
187 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
188 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
189 Table Create Table
190 t1 CREATE TABLE `t1` (
191 `a` int(11) DEFAULT NULL
192 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
193 Page checksums are not used
194 set global aria_page_checksum = 1 ;
195 alter table t1 PAGE_CHECKSUM=0 ;
196 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
197 Table Create Table
198 t1 CREATE TABLE `t1` (
199 `a` int(11) DEFAULT NULL
200 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
201 Page checksums are not used
202 drop table t1;
203 # iteration 12a
204 set global aria_page_checksum = 0 ;
205 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
206 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
207 Table Create Table
208 t1 CREATE TABLE `t1` (
209 `a` int(11) DEFAULT NULL
210 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
211 Page checksums are not used
212 set global aria_page_checksum = 1 ;
213 alter table t1 PAGE_CHECKSUM=1 ;
214 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
215 Table Create Table
216 t1 CREATE TABLE `t1` (
217 `a` int(11) DEFAULT NULL
218 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
219 Page checksums are used
220 drop table t1;
221 # iteration 13a
222 set global aria_page_checksum = 0 ;
223 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
224 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
225 Table Create Table
226 t1 CREATE TABLE `t1` (
227 `a` int(11) DEFAULT NULL
228 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
229 Page checksums are used
230 set global aria_page_checksum = 0 ;
231 alter table t1 engine=aria ;
232 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
233 Table Create Table
234 t1 CREATE TABLE `t1` (
235 `a` int(11) DEFAULT NULL
236 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
237 Page checksums are used
238 drop table t1;
239 # iteration 14a
240 set global aria_page_checksum = 0 ;
241 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
242 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
243 Table Create Table
244 t1 CREATE TABLE `t1` (
245 `a` int(11) DEFAULT NULL
246 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
247 Page checksums are used
248 set global aria_page_checksum = 0 ;
249 alter table t1 PAGE_CHECKSUM=0 ;
250 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
251 Table Create Table
252 t1 CREATE TABLE `t1` (
253 `a` int(11) DEFAULT NULL
254 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
255 Page checksums are not used
256 drop table t1;
257 # iteration 15a
258 set global aria_page_checksum = 0 ;
259 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
260 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
261 Table Create Table
262 t1 CREATE TABLE `t1` (
263 `a` int(11) DEFAULT NULL
264 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
265 Page checksums are used
266 set global aria_page_checksum = 0 ;
267 alter table t1 PAGE_CHECKSUM=1 ;
268 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
269 Table Create Table
270 t1 CREATE TABLE `t1` (
271 `a` int(11) DEFAULT NULL
272 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
273 Page checksums are used
274 drop table t1;
275 # iteration 16a
276 set global aria_page_checksum = 0 ;
277 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
278 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
279 Table Create Table
280 t1 CREATE TABLE `t1` (
281 `a` int(11) DEFAULT NULL
282 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
283 Page checksums are used
284 set global aria_page_checksum = 1 ;
285 alter table t1 engine=aria ;
286 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
287 Table Create Table
288 t1 CREATE TABLE `t1` (
289 `a` int(11) DEFAULT NULL
290 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
291 Page checksums are used
292 drop table t1;
293 # iteration 17a
294 set global aria_page_checksum = 0 ;
295 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
296 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
297 Table Create Table
298 t1 CREATE TABLE `t1` (
299 `a` int(11) DEFAULT NULL
300 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
301 Page checksums are used
302 set global aria_page_checksum = 1 ;
303 alter table t1 PAGE_CHECKSUM=0 ;
304 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
305 Table Create Table
306 t1 CREATE TABLE `t1` (
307 `a` int(11) DEFAULT NULL
308 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
309 Page checksums are not used
310 drop table t1;
311 # iteration 18a
312 set global aria_page_checksum = 0 ;
313 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
314 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
315 Table Create Table
316 t1 CREATE TABLE `t1` (
317 `a` int(11) DEFAULT NULL
318 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
319 Page checksums are used
320 set global aria_page_checksum = 1 ;
321 alter table t1 PAGE_CHECKSUM=1 ;
322 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
323 Table Create Table
324 t1 CREATE TABLE `t1` (
325 `a` int(11) DEFAULT NULL
326 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
327 Page checksums are used
328 drop table t1;
329 # iteration 19a
330 set global aria_page_checksum = 1 ;
331 create table t1(a int) engine=aria ;
332 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
333 Table Create Table
334 t1 CREATE TABLE `t1` (
335 `a` int(11) DEFAULT NULL
336 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
337 Page checksums are used
338 set global aria_page_checksum = 0 ;
339 alter table t1 engine=aria ;
340 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
341 Table Create Table
342 t1 CREATE TABLE `t1` (
343 `a` int(11) DEFAULT NULL
344 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
345 Page checksums are used
346 drop table t1;
347 # iteration 20a
348 set global aria_page_checksum = 1 ;
349 create table t1(a int) engine=aria ;
350 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
351 Table Create Table
352 t1 CREATE TABLE `t1` (
353 `a` int(11) DEFAULT NULL
354 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
355 Page checksums are used
356 set global aria_page_checksum = 0 ;
357 alter table t1 PAGE_CHECKSUM=0 ;
358 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
359 Table Create Table
360 t1 CREATE TABLE `t1` (
361 `a` int(11) DEFAULT NULL
362 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
363 Page checksums are not used
364 drop table t1;
365 # iteration 21a
366 set global aria_page_checksum = 1 ;
367 create table t1(a int) engine=aria ;
368 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
369 Table Create Table
370 t1 CREATE TABLE `t1` (
371 `a` int(11) DEFAULT NULL
372 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
373 Page checksums are used
374 set global aria_page_checksum = 0 ;
375 alter table t1 PAGE_CHECKSUM=1 ;
376 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
377 Table Create Table
378 t1 CREATE TABLE `t1` (
379 `a` int(11) DEFAULT NULL
380 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
381 Page checksums are used
382 drop table t1;
383 # iteration 22a
384 set global aria_page_checksum = 1 ;
385 create table t1(a int) engine=aria ;
386 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
387 Table Create Table
388 t1 CREATE TABLE `t1` (
389 `a` int(11) DEFAULT NULL
390 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
391 Page checksums are used
392 set global aria_page_checksum = 1 ;
393 alter table t1 engine=aria ;
394 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
395 Table Create Table
396 t1 CREATE TABLE `t1` (
397 `a` int(11) DEFAULT NULL
398 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
399 Page checksums are used
400 drop table t1;
401 # iteration 23a
402 set global aria_page_checksum = 1 ;
403 create table t1(a int) engine=aria ;
404 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
405 Table Create Table
406 t1 CREATE TABLE `t1` (
407 `a` int(11) DEFAULT NULL
408 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
409 Page checksums are used
410 set global aria_page_checksum = 1 ;
411 alter table t1 PAGE_CHECKSUM=0 ;
412 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
413 Table Create Table
414 t1 CREATE TABLE `t1` (
415 `a` int(11) DEFAULT NULL
416 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
417 Page checksums are not used
418 drop table t1;
419 # iteration 24a
420 set global aria_page_checksum = 1 ;
421 create table t1(a int) engine=aria ;
422 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
423 Table Create Table
424 t1 CREATE TABLE `t1` (
425 `a` int(11) DEFAULT NULL
426 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
427 Page checksums are used
428 set global aria_page_checksum = 1 ;
429 alter table t1 PAGE_CHECKSUM=1 ;
430 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
431 Table Create Table
432 t1 CREATE TABLE `t1` (
433 `a` int(11) DEFAULT NULL
434 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
435 Page checksums are used
436 drop table t1;
437 # iteration 25a
438 set global aria_page_checksum = 1 ;
439 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
440 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
441 Table Create Table
442 t1 CREATE TABLE `t1` (
443 `a` int(11) DEFAULT NULL
444 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
445 Page checksums are not used
446 set global aria_page_checksum = 0 ;
447 alter table t1 engine=aria ;
448 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
449 Table Create Table
450 t1 CREATE TABLE `t1` (
451 `a` int(11) DEFAULT NULL
452 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
453 Page checksums are not used
454 drop table t1;
455 # iteration 26a
456 set global aria_page_checksum = 1 ;
457 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
458 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
459 Table Create Table
460 t1 CREATE TABLE `t1` (
461 `a` int(11) DEFAULT NULL
462 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
463 Page checksums are not used
464 set global aria_page_checksum = 0 ;
465 alter table t1 PAGE_CHECKSUM=0 ;
466 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
467 Table Create Table
468 t1 CREATE TABLE `t1` (
469 `a` int(11) DEFAULT NULL
470 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
471 Page checksums are not used
472 drop table t1;
473 # iteration 27a
474 set global aria_page_checksum = 1 ;
475 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
476 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
477 Table Create Table
478 t1 CREATE TABLE `t1` (
479 `a` int(11) DEFAULT NULL
480 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
481 Page checksums are not used
482 set global aria_page_checksum = 0 ;
483 alter table t1 PAGE_CHECKSUM=1 ;
484 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
485 Table Create Table
486 t1 CREATE TABLE `t1` (
487 `a` int(11) DEFAULT NULL
488 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
489 Page checksums are used
490 drop table t1;
491 # iteration 28a
492 set global aria_page_checksum = 1 ;
493 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
494 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
495 Table Create Table
496 t1 CREATE TABLE `t1` (
497 `a` int(11) DEFAULT NULL
498 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
499 Page checksums are not used
500 set global aria_page_checksum = 1 ;
501 alter table t1 engine=aria ;
502 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
503 Table Create Table
504 t1 CREATE TABLE `t1` (
505 `a` int(11) DEFAULT NULL
506 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
507 Page checksums are not used
508 drop table t1;
509 # iteration 29a
510 set global aria_page_checksum = 1 ;
511 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
512 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
513 Table Create Table
514 t1 CREATE TABLE `t1` (
515 `a` int(11) DEFAULT NULL
516 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
517 Page checksums are not used
518 set global aria_page_checksum = 1 ;
519 alter table t1 PAGE_CHECKSUM=0 ;
520 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
521 Table Create Table
522 t1 CREATE TABLE `t1` (
523 `a` int(11) DEFAULT NULL
524 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
525 Page checksums are not used
526 drop table t1;
527 # iteration 30a
528 set global aria_page_checksum = 1 ;
529 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
530 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
531 Table Create Table
532 t1 CREATE TABLE `t1` (
533 `a` int(11) DEFAULT NULL
534 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
535 Page checksums are not used
536 set global aria_page_checksum = 1 ;
537 alter table t1 PAGE_CHECKSUM=1 ;
538 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
539 Table Create Table
540 t1 CREATE TABLE `t1` (
541 `a` int(11) DEFAULT NULL
542 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
543 Page checksums are used
544 drop table t1;
545 # iteration 31a
546 set global aria_page_checksum = 1 ;
547 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
548 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
549 Table Create Table
550 t1 CREATE TABLE `t1` (
551 `a` int(11) DEFAULT NULL
552 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
553 Page checksums are used
554 set global aria_page_checksum = 0 ;
555 alter table t1 engine=aria ;
556 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
557 Table Create Table
558 t1 CREATE TABLE `t1` (
559 `a` int(11) DEFAULT NULL
560 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
561 Page checksums are used
562 drop table t1;
563 # iteration 32a
564 set global aria_page_checksum = 1 ;
565 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
566 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
567 Table Create Table
568 t1 CREATE TABLE `t1` (
569 `a` int(11) DEFAULT NULL
570 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
571 Page checksums are used
572 set global aria_page_checksum = 0 ;
573 alter table t1 PAGE_CHECKSUM=0 ;
574 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
575 Table Create Table
576 t1 CREATE TABLE `t1` (
577 `a` int(11) DEFAULT NULL
578 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
579 Page checksums are not used
580 drop table t1;
581 # iteration 33a
582 set global aria_page_checksum = 1 ;
583 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
584 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
585 Table Create Table
586 t1 CREATE TABLE `t1` (
587 `a` int(11) DEFAULT NULL
588 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
589 Page checksums are used
590 set global aria_page_checksum = 0 ;
591 alter table t1 PAGE_CHECKSUM=1 ;
592 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
593 Table Create Table
594 t1 CREATE TABLE `t1` (
595 `a` int(11) DEFAULT NULL
596 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
597 Page checksums are used
598 drop table t1;
599 # iteration 34a
600 set global aria_page_checksum = 1 ;
601 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
602 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
603 Table Create Table
604 t1 CREATE TABLE `t1` (
605 `a` int(11) DEFAULT NULL
606 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
607 Page checksums are used
608 set global aria_page_checksum = 1 ;
609 alter table t1 engine=aria ;
610 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
611 Table Create Table
612 t1 CREATE TABLE `t1` (
613 `a` int(11) DEFAULT NULL
614 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
615 Page checksums are used
616 drop table t1;
617 # iteration 35a
618 set global aria_page_checksum = 1 ;
619 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
620 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
621 Table Create Table
622 t1 CREATE TABLE `t1` (
623 `a` int(11) DEFAULT NULL
624 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
625 Page checksums are used
626 set global aria_page_checksum = 1 ;
627 alter table t1 PAGE_CHECKSUM=0 ;
628 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
629 Table Create Table
630 t1 CREATE TABLE `t1` (
631 `a` int(11) DEFAULT NULL
632 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=0
633 Page checksums are not used
634 drop table t1;
635 # iteration 36a
636 set global aria_page_checksum = 1 ;
637 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
638 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
639 Table Create Table
640 t1 CREATE TABLE `t1` (
641 `a` int(11) DEFAULT NULL
642 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
643 Page checksums are used
644 set global aria_page_checksum = 1 ;
645 alter table t1 PAGE_CHECKSUM=1 ;
646 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
647 Table Create Table
648 t1 CREATE TABLE `t1` (
649 `a` int(11) DEFAULT NULL
650 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
651 Page checksums are used
652 drop table t1;
653 # iteration 1b
654 create table t1(a int) engine=aria ;
655 show create table t1;
656 Table Create Table
657 t1 CREATE TABLE `t1` (
658 `a` int(11) DEFAULT NULL
659 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
660 Crashsafe: yes
661 alter table t1 modify a bigint ;
662 show create table t1;
663 Table Create Table
664 t1 CREATE TABLE `t1` (
665 `a` bigint(20) DEFAULT NULL
666 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
667 Crashsafe: yes
668 drop table t1;
669 # iteration 2b
670 create table t1(a int) engine=aria ;
671 show create table t1;
672 Table Create Table
673 t1 CREATE TABLE `t1` (
674 `a` int(11) DEFAULT NULL
675 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
676 Crashsafe: yes
677 alter table t1 transactional=0 ;
678 show create table t1;
679 Table Create Table
680 t1 CREATE TABLE `t1` (
681 `a` int(11) DEFAULT NULL
682 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
683 Crashsafe: no
684 drop table t1;
685 # iteration 3b
686 create table t1(a int) engine=aria ;
687 show create table t1;
688 Table Create Table
689 t1 CREATE TABLE `t1` (
690 `a` int(11) DEFAULT NULL
691 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
692 Crashsafe: yes
693 alter table t1 transactional=1 ;
694 show create table t1;
695 Table Create Table
696 t1 CREATE TABLE `t1` (
697 `a` int(11) DEFAULT NULL
698 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
699 Crashsafe: yes
700 drop table t1;
701 # iteration 4b
702 create table t1(a int) engine=aria ;
703 show create table t1;
704 Table Create Table
705 t1 CREATE TABLE `t1` (
706 `a` int(11) DEFAULT NULL
707 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
708 Crashsafe: yes
709 alter table t1 engine=aria ;
710 show create table t1;
711 Table Create Table
712 t1 CREATE TABLE `t1` (
713 `a` int(11) DEFAULT NULL
714 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
715 Crashsafe: yes
716 drop table t1;
717 # iteration 5b
718 create table t1(a int) engine=aria ;
719 show create table t1;
720 Table Create Table
721 t1 CREATE TABLE `t1` (
722 `a` int(11) DEFAULT NULL
723 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
724 Crashsafe: yes
725 alter table t1 engine=aria transactional=0 ;
726 show create table t1;
727 Table Create Table
728 t1 CREATE TABLE `t1` (
729 `a` int(11) DEFAULT NULL
730 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
731 Crashsafe: no
732 drop table t1;
733 # iteration 6b
734 create table t1(a int) engine=aria ;
735 show create table t1;
736 Table Create Table
737 t1 CREATE TABLE `t1` (
738 `a` int(11) DEFAULT NULL
739 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
740 Crashsafe: yes
741 alter table t1 engine=aria transactional=1 ;
742 show create table t1;
743 Table Create Table
744 t1 CREATE TABLE `t1` (
745 `a` int(11) DEFAULT NULL
746 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
747 Crashsafe: yes
748 drop table t1;
749 # iteration 7b
750 create table t1(a int) engine=aria transactional=0 ;
751 show create table t1;
752 Table Create Table
753 t1 CREATE TABLE `t1` (
754 `a` int(11) DEFAULT NULL
755 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
756 Crashsafe: no
757 alter table t1 modify a bigint ;
758 show create table t1;
759 Table Create Table
760 t1 CREATE TABLE `t1` (
761 `a` bigint(20) DEFAULT NULL
762 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
763 Crashsafe: no
764 drop table t1;
765 # iteration 8b
766 create table t1(a int) engine=aria transactional=0 ;
767 show create table t1;
768 Table Create Table
769 t1 CREATE TABLE `t1` (
770 `a` int(11) DEFAULT NULL
771 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
772 Crashsafe: no
773 alter table t1 transactional=0 ;
774 show create table t1;
775 Table Create Table
776 t1 CREATE TABLE `t1` (
777 `a` int(11) DEFAULT NULL
778 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
779 Crashsafe: no
780 drop table t1;
781 # iteration 9b
782 create table t1(a int) engine=aria transactional=0 ;
783 show create table t1;
784 Table Create Table
785 t1 CREATE TABLE `t1` (
786 `a` int(11) DEFAULT NULL
787 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
788 Crashsafe: no
789 alter table t1 transactional=1 ;
790 show create table t1;
791 Table Create Table
792 t1 CREATE TABLE `t1` (
793 `a` int(11) DEFAULT NULL
794 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
795 Crashsafe: yes
796 drop table t1;
797 # iteration 10b
798 create table t1(a int) engine=aria transactional=0 ;
799 show create table t1;
800 Table Create Table
801 t1 CREATE TABLE `t1` (
802 `a` int(11) DEFAULT NULL
803 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
804 Crashsafe: no
805 alter table t1 engine=aria ;
806 show create table t1;
807 Table Create Table
808 t1 CREATE TABLE `t1` (
809 `a` int(11) DEFAULT NULL
810 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
811 Crashsafe: no
812 drop table t1;
813 # iteration 11b
814 create table t1(a int) engine=aria transactional=0 ;
815 show create table t1;
816 Table Create Table
817 t1 CREATE TABLE `t1` (
818 `a` int(11) DEFAULT NULL
819 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
820 Crashsafe: no
821 alter table t1 engine=aria transactional=0 ;
822 show create table t1;
823 Table Create Table
824 t1 CREATE TABLE `t1` (
825 `a` int(11) DEFAULT NULL
826 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
827 Crashsafe: no
828 drop table t1;
829 # iteration 12b
830 create table t1(a int) engine=aria transactional=0 ;
831 show create table t1;
832 Table Create Table
833 t1 CREATE TABLE `t1` (
834 `a` int(11) DEFAULT NULL
835 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
836 Crashsafe: no
837 alter table t1 engine=aria transactional=1 ;
838 show create table t1;
839 Table Create Table
840 t1 CREATE TABLE `t1` (
841 `a` int(11) DEFAULT NULL
842 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
843 Crashsafe: yes
844 drop table t1;
845 # iteration 13b
846 create table t1(a int) engine=aria transactional=1 ;
847 show create table t1;
848 Table Create Table
849 t1 CREATE TABLE `t1` (
850 `a` int(11) DEFAULT NULL
851 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
852 Crashsafe: yes
853 alter table t1 modify a bigint ;
854 show create table t1;
855 Table Create Table
856 t1 CREATE TABLE `t1` (
857 `a` bigint(20) DEFAULT NULL
858 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
859 Crashsafe: yes
860 drop table t1;
861 # iteration 14b
862 create table t1(a int) engine=aria transactional=1 ;
863 show create table t1;
864 Table Create Table
865 t1 CREATE TABLE `t1` (
866 `a` int(11) DEFAULT NULL
867 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
868 Crashsafe: yes
869 alter table t1 transactional=0 ;
870 show create table t1;
871 Table Create Table
872 t1 CREATE TABLE `t1` (
873 `a` int(11) DEFAULT NULL
874 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
875 Crashsafe: no
876 drop table t1;
877 # iteration 15b
878 create table t1(a int) engine=aria transactional=1 ;
879 show create table t1;
880 Table Create Table
881 t1 CREATE TABLE `t1` (
882 `a` int(11) DEFAULT NULL
883 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
884 Crashsafe: yes
885 alter table t1 transactional=1 ;
886 show create table t1;
887 Table Create Table
888 t1 CREATE TABLE `t1` (
889 `a` int(11) DEFAULT NULL
890 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
891 Crashsafe: yes
892 drop table t1;
893 # iteration 16b
894 create table t1(a int) engine=aria transactional=1 ;
895 show create table t1;
896 Table Create Table
897 t1 CREATE TABLE `t1` (
898 `a` int(11) DEFAULT NULL
899 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
900 Crashsafe: yes
901 alter table t1 engine=aria ;
902 show create table t1;
903 Table Create Table
904 t1 CREATE TABLE `t1` (
905 `a` int(11) DEFAULT NULL
906 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
907 Crashsafe: yes
908 drop table t1;
909 # iteration 17b
910 create table t1(a int) engine=aria transactional=1 ;
911 show create table t1;
912 Table Create Table
913 t1 CREATE TABLE `t1` (
914 `a` int(11) DEFAULT NULL
915 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
916 Crashsafe: yes
917 alter table t1 engine=aria transactional=0 ;
918 show create table t1;
919 Table Create Table
920 t1 CREATE TABLE `t1` (
921 `a` int(11) DEFAULT NULL
922 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=0
923 Crashsafe: no
924 drop table t1;
925 # iteration 18b
926 create table t1(a int) engine=aria transactional=1 ;
927 show create table t1;
928 Table Create Table
929 t1 CREATE TABLE `t1` (
930 `a` int(11) DEFAULT NULL
931 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
932 Crashsafe: yes
933 alter table t1 engine=aria transactional=1 ;
934 show create table t1;
935 Table Create Table
936 t1 CREATE TABLE `t1` (
937 `a` int(11) DEFAULT NULL
938 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1
939 Crashsafe: yes
940 drop table t1;