Debian Codegraph @

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

raw
1 # Tests for two bugs related to ALTER TABLE and aria-specific alter
2 # options (PAGE_CHECKSUM and TRANSACTIONAL).
3
4 -- source include/have_maria.inc
5
6 --disable_warnings
7 drop table if exists t1;
8 --enable_warnings
9
10 #
11 # Test for BUG#35441 "Cannot change PAGE_CHECKSUM table option"
12 #
13
14 let $MYSQLD_DATADIR= `select @@datadir`;
15
16 select @@global.aria_page_checksum;
17
18 # we scan through combinations in the cartesian product of
19 # (first value of aria_page_checksum) x (clauses in CREATE TABLE) x
20 # (second value of aria_page_checksum) x (clauses in ALTER TABLE).
21
22 --echo # iteration 1a
23 set global aria_page_checksum = 0 ;
24 create table t1(a int) engine=aria ;
25 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
26 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
27 perl;
28 use strict;
29 use warnings;
30 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
31 open(FILE, "<", $fname) or die;
32 my @content= grep(/Page checksums are used/, <FILE>);
33 print @content ? $content[0] : "Page checksums are not used\n";
34 close FILE;
35 EOF
36 set global aria_page_checksum = 0 ;
37 alter table t1 engine=aria ;
38 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
39 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
40 perl;
41 use strict;
42 use warnings;
43 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
44 open(FILE, "<", $fname) or die;
45 my @content= grep(/Page checksums are used/, <FILE>);
46 print @content ? $content[0] : "Page checksums are not used\n";
47 close FILE;
48 EOF
49 drop table t1;
50
51 --echo # iteration 2a
52 set global aria_page_checksum = 0 ;
53 create table t1(a int) engine=aria ;
54 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
55 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
56 perl;
57 use strict;
58 use warnings;
59 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
60 open(FILE, "<", $fname) or die;
61 my @content= grep(/Page checksums are used/, <FILE>);
62 print @content ? $content[0] : "Page checksums are not used\n";
63 close FILE;
64 EOF
65 set global aria_page_checksum = 0 ;
66 alter table t1 PAGE_CHECKSUM=0 ;
67 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
68 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
69 perl;
70 use strict;
71 use warnings;
72 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
73 open(FILE, "<", $fname) or die;
74 my @content= grep(/Page checksums are used/, <FILE>);
75 print @content ? $content[0] : "Page checksums are not used\n";
76 close FILE;
77 EOF
78 drop table t1;
79
80 --echo # iteration 3a
81 set global aria_page_checksum = 0 ;
82 create table t1(a int) engine=aria ;
83 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
84 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
85 perl;
86 use strict;
87 use warnings;
88 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
89 open(FILE, "<", $fname) or die;
90 my @content= grep(/Page checksums are used/, <FILE>);
91 print @content ? $content[0] : "Page checksums are not used\n";
92 close FILE;
93 EOF
94 set global aria_page_checksum = 0 ;
95 alter table t1 PAGE_CHECKSUM=1 ;
96 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
97 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
98 perl;
99 use strict;
100 use warnings;
101 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
102 open(FILE, "<", $fname) or die;
103 my @content= grep(/Page checksums are used/, <FILE>);
104 print @content ? $content[0] : "Page checksums are not used\n";
105 close FILE;
106 EOF
107 drop table t1;
108
109 --echo # iteration 4a
110 set global aria_page_checksum = 0 ;
111 create table t1(a int) engine=aria ;
112 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
113 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
114 perl;
115 use strict;
116 use warnings;
117 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
118 open(FILE, "<", $fname) or die;
119 my @content= grep(/Page checksums are used/, <FILE>);
120 print @content ? $content[0] : "Page checksums are not used\n";
121 close FILE;
122 EOF
123 set global aria_page_checksum = 1 ;
124 alter table t1 engine=aria ;
125 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
126 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
127 perl;
128 use strict;
129 use warnings;
130 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
131 open(FILE, "<", $fname) or die;
132 my @content= grep(/Page checksums are used/, <FILE>);
133 print @content ? $content[0] : "Page checksums are not used\n";
134 close FILE;
135 EOF
136 drop table t1;
137
138 --echo # iteration 5a
139 set global aria_page_checksum = 0 ;
140 create table t1(a int) engine=aria ;
141 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
142 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
143 perl;
144 use strict;
145 use warnings;
146 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
147 open(FILE, "<", $fname) or die;
148 my @content= grep(/Page checksums are used/, <FILE>);
149 print @content ? $content[0] : "Page checksums are not used\n";
150 close FILE;
151 EOF
152 set global aria_page_checksum = 1 ;
153 alter table t1 PAGE_CHECKSUM=0 ;
154 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
155 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
156 perl;
157 use strict;
158 use warnings;
159 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
160 open(FILE, "<", $fname) or die;
161 my @content= grep(/Page checksums are used/, <FILE>);
162 print @content ? $content[0] : "Page checksums are not used\n";
163 close FILE;
164 EOF
165 drop table t1;
166
167 --echo # iteration 6a
168 set global aria_page_checksum = 0 ;
169 create table t1(a int) engine=aria ;
170 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
171 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
172 perl;
173 use strict;
174 use warnings;
175 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
176 open(FILE, "<", $fname) or die;
177 my @content= grep(/Page checksums are used/, <FILE>);
178 print @content ? $content[0] : "Page checksums are not used\n";
179 close FILE;
180 EOF
181 set global aria_page_checksum = 1 ;
182 alter table t1 PAGE_CHECKSUM=1 ;
183 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
184 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
185 perl;
186 use strict;
187 use warnings;
188 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
189 open(FILE, "<", $fname) or die;
190 my @content= grep(/Page checksums are used/, <FILE>);
191 print @content ? $content[0] : "Page checksums are not used\n";
192 close FILE;
193 EOF
194 drop table t1;
195
196 --echo # iteration 7a
197 set global aria_page_checksum = 0 ;
198 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
199 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
200 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
201 perl;
202 use strict;
203 use warnings;
204 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
205 open(FILE, "<", $fname) or die;
206 my @content= grep(/Page checksums are used/, <FILE>);
207 print @content ? $content[0] : "Page checksums are not used\n";
208 close FILE;
209 EOF
210 set global aria_page_checksum = 0 ;
211 alter table t1 engine=aria ;
212 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
213 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
214 perl;
215 use strict;
216 use warnings;
217 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
218 open(FILE, "<", $fname) or die;
219 my @content= grep(/Page checksums are used/, <FILE>);
220 print @content ? $content[0] : "Page checksums are not used\n";
221 close FILE;
222 EOF
223 drop table t1;
224
225 --echo # iteration 8a
226 set global aria_page_checksum = 0 ;
227 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
228 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
229 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
230 perl;
231 use strict;
232 use warnings;
233 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
234 open(FILE, "<", $fname) or die;
235 my @content= grep(/Page checksums are used/, <FILE>);
236 print @content ? $content[0] : "Page checksums are not used\n";
237 close FILE;
238 EOF
239 set global aria_page_checksum = 0 ;
240 alter table t1 PAGE_CHECKSUM=0 ;
241 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
242 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
243 perl;
244 use strict;
245 use warnings;
246 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
247 open(FILE, "<", $fname) or die;
248 my @content= grep(/Page checksums are used/, <FILE>);
249 print @content ? $content[0] : "Page checksums are not used\n";
250 close FILE;
251 EOF
252 drop table t1;
253
254 --echo # iteration 9a
255 set global aria_page_checksum = 0 ;
256 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
257 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
258 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
259 perl;
260 use strict;
261 use warnings;
262 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
263 open(FILE, "<", $fname) or die;
264 my @content= grep(/Page checksums are used/, <FILE>);
265 print @content ? $content[0] : "Page checksums are not used\n";
266 close FILE;
267 EOF
268 set global aria_page_checksum = 0 ;
269 alter table t1 PAGE_CHECKSUM=1 ;
270 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
271 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
272 perl;
273 use strict;
274 use warnings;
275 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
276 open(FILE, "<", $fname) or die;
277 my @content= grep(/Page checksums are used/, <FILE>);
278 print @content ? $content[0] : "Page checksums are not used\n";
279 close FILE;
280 EOF
281 drop table t1;
282
283 --echo # iteration 10a
284 set global aria_page_checksum = 0 ;
285 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
286 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
287 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
288 perl;
289 use strict;
290 use warnings;
291 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
292 open(FILE, "<", $fname) or die;
293 my @content= grep(/Page checksums are used/, <FILE>);
294 print @content ? $content[0] : "Page checksums are not used\n";
295 close FILE;
296 EOF
297 set global aria_page_checksum = 1 ;
298 alter table t1 engine=aria ;
299 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
300 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
301 perl;
302 use strict;
303 use warnings;
304 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
305 open(FILE, "<", $fname) or die;
306 my @content= grep(/Page checksums are used/, <FILE>);
307 print @content ? $content[0] : "Page checksums are not used\n";
308 close FILE;
309 EOF
310 drop table t1;
311
312 --echo # iteration 11a
313 set global aria_page_checksum = 0 ;
314 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
315 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
316 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
317 perl;
318 use strict;
319 use warnings;
320 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
321 open(FILE, "<", $fname) or die;
322 my @content= grep(/Page checksums are used/, <FILE>);
323 print @content ? $content[0] : "Page checksums are not used\n";
324 close FILE;
325 EOF
326 set global aria_page_checksum = 1 ;
327 alter table t1 PAGE_CHECKSUM=0 ;
328 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
329 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
330 perl;
331 use strict;
332 use warnings;
333 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
334 open(FILE, "<", $fname) or die;
335 my @content= grep(/Page checksums are used/, <FILE>);
336 print @content ? $content[0] : "Page checksums are not used\n";
337 close FILE;
338 EOF
339 drop table t1;
340
341 --echo # iteration 12a
342 set global aria_page_checksum = 0 ;
343 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
344 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
345 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
346 perl;
347 use strict;
348 use warnings;
349 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
350 open(FILE, "<", $fname) or die;
351 my @content= grep(/Page checksums are used/, <FILE>);
352 print @content ? $content[0] : "Page checksums are not used\n";
353 close FILE;
354 EOF
355 set global aria_page_checksum = 1 ;
356 alter table t1 PAGE_CHECKSUM=1 ;
357 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
358 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
359 perl;
360 use strict;
361 use warnings;
362 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
363 open(FILE, "<", $fname) or die;
364 my @content= grep(/Page checksums are used/, <FILE>);
365 print @content ? $content[0] : "Page checksums are not used\n";
366 close FILE;
367 EOF
368 drop table t1;
369
370 --echo # iteration 13a
371 set global aria_page_checksum = 0 ;
372 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
373 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
374 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
375 perl;
376 use strict;
377 use warnings;
378 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
379 open(FILE, "<", $fname) or die;
380 my @content= grep(/Page checksums are used/, <FILE>);
381 print @content ? $content[0] : "Page checksums are not used\n";
382 close FILE;
383 EOF
384 set global aria_page_checksum = 0 ;
385 alter table t1 engine=aria ;
386 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
387 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
388 perl;
389 use strict;
390 use warnings;
391 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
392 open(FILE, "<", $fname) or die;
393 my @content= grep(/Page checksums are used/, <FILE>);
394 print @content ? $content[0] : "Page checksums are not used\n";
395 close FILE;
396 EOF
397 drop table t1;
398
399 --echo # iteration 14a
400 set global aria_page_checksum = 0 ;
401 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
402 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
403 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
404 perl;
405 use strict;
406 use warnings;
407 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
408 open(FILE, "<", $fname) or die;
409 my @content= grep(/Page checksums are used/, <FILE>);
410 print @content ? $content[0] : "Page checksums are not used\n";
411 close FILE;
412 EOF
413 set global aria_page_checksum = 0 ;
414 alter table t1 PAGE_CHECKSUM=0 ;
415 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
416 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
417 perl;
418 use strict;
419 use warnings;
420 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
421 open(FILE, "<", $fname) or die;
422 my @content= grep(/Page checksums are used/, <FILE>);
423 print @content ? $content[0] : "Page checksums are not used\n";
424 close FILE;
425 EOF
426 drop table t1;
427
428 --echo # iteration 15a
429 set global aria_page_checksum = 0 ;
430 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
431 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
432 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
433 perl;
434 use strict;
435 use warnings;
436 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
437 open(FILE, "<", $fname) or die;
438 my @content= grep(/Page checksums are used/, <FILE>);
439 print @content ? $content[0] : "Page checksums are not used\n";
440 close FILE;
441 EOF
442 set global aria_page_checksum = 0 ;
443 alter table t1 PAGE_CHECKSUM=1 ;
444 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
445 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
446 perl;
447 use strict;
448 use warnings;
449 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
450 open(FILE, "<", $fname) or die;
451 my @content= grep(/Page checksums are used/, <FILE>);
452 print @content ? $content[0] : "Page checksums are not used\n";
453 close FILE;
454 EOF
455 drop table t1;
456
457 --echo # iteration 16a
458 set global aria_page_checksum = 0 ;
459 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
460 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
461 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
462 perl;
463 use strict;
464 use warnings;
465 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
466 open(FILE, "<", $fname) or die;
467 my @content= grep(/Page checksums are used/, <FILE>);
468 print @content ? $content[0] : "Page checksums are not used\n";
469 close FILE;
470 EOF
471 set global aria_page_checksum = 1 ;
472 alter table t1 engine=aria ;
473 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
474 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
475 perl;
476 use strict;
477 use warnings;
478 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
479 open(FILE, "<", $fname) or die;
480 my @content= grep(/Page checksums are used/, <FILE>);
481 print @content ? $content[0] : "Page checksums are not used\n";
482 close FILE;
483 EOF
484 drop table t1;
485
486 --echo # iteration 17a
487 set global aria_page_checksum = 0 ;
488 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
489 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
490 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
491 perl;
492 use strict;
493 use warnings;
494 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
495 open(FILE, "<", $fname) or die;
496 my @content= grep(/Page checksums are used/, <FILE>);
497 print @content ? $content[0] : "Page checksums are not used\n";
498 close FILE;
499 EOF
500 set global aria_page_checksum = 1 ;
501 alter table t1 PAGE_CHECKSUM=0 ;
502 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
503 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
504 perl;
505 use strict;
506 use warnings;
507 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
508 open(FILE, "<", $fname) or die;
509 my @content= grep(/Page checksums are used/, <FILE>);
510 print @content ? $content[0] : "Page checksums are not used\n";
511 close FILE;
512 EOF
513 drop table t1;
514
515 --echo # iteration 18a
516 set global aria_page_checksum = 0 ;
517 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
518 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
519 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
520 perl;
521 use strict;
522 use warnings;
523 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
524 open(FILE, "<", $fname) or die;
525 my @content= grep(/Page checksums are used/, <FILE>);
526 print @content ? $content[0] : "Page checksums are not used\n";
527 close FILE;
528 EOF
529 set global aria_page_checksum = 1 ;
530 alter table t1 PAGE_CHECKSUM=1 ;
531 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
532 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
533 perl;
534 use strict;
535 use warnings;
536 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
537 open(FILE, "<", $fname) or die;
538 my @content= grep(/Page checksums are used/, <FILE>);
539 print @content ? $content[0] : "Page checksums are not used\n";
540 close FILE;
541 EOF
542 drop table t1;
543
544 --echo # iteration 19a
545 set global aria_page_checksum = 1 ;
546 create table t1(a int) engine=aria ;
547 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
548 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
549 perl;
550 use strict;
551 use warnings;
552 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
553 open(FILE, "<", $fname) or die;
554 my @content= grep(/Page checksums are used/, <FILE>);
555 print @content ? $content[0] : "Page checksums are not used\n";
556 close FILE;
557 EOF
558 set global aria_page_checksum = 0 ;
559 alter table t1 engine=aria ;
560 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
561 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
562 perl;
563 use strict;
564 use warnings;
565 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
566 open(FILE, "<", $fname) or die;
567 my @content= grep(/Page checksums are used/, <FILE>);
568 print @content ? $content[0] : "Page checksums are not used\n";
569 close FILE;
570 EOF
571 drop table t1;
572
573 --echo # iteration 20a
574 set global aria_page_checksum = 1 ;
575 create table t1(a int) engine=aria ;
576 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
577 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
578 perl;
579 use strict;
580 use warnings;
581 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
582 open(FILE, "<", $fname) or die;
583 my @content= grep(/Page checksums are used/, <FILE>);
584 print @content ? $content[0] : "Page checksums are not used\n";
585 close FILE;
586 EOF
587 set global aria_page_checksum = 0 ;
588 alter table t1 PAGE_CHECKSUM=0 ;
589 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
590 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
591 perl;
592 use strict;
593 use warnings;
594 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
595 open(FILE, "<", $fname) or die;
596 my @content= grep(/Page checksums are used/, <FILE>);
597 print @content ? $content[0] : "Page checksums are not used\n";
598 close FILE;
599 EOF
600 drop table t1;
601
602 --echo # iteration 21a
603 set global aria_page_checksum = 1 ;
604 create table t1(a int) engine=aria ;
605 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
606 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
607 perl;
608 use strict;
609 use warnings;
610 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
611 open(FILE, "<", $fname) or die;
612 my @content= grep(/Page checksums are used/, <FILE>);
613 print @content ? $content[0] : "Page checksums are not used\n";
614 close FILE;
615 EOF
616 set global aria_page_checksum = 0 ;
617 alter table t1 PAGE_CHECKSUM=1 ;
618 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
619 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
620 perl;
621 use strict;
622 use warnings;
623 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
624 open(FILE, "<", $fname) or die;
625 my @content= grep(/Page checksums are used/, <FILE>);
626 print @content ? $content[0] : "Page checksums are not used\n";
627 close FILE;
628 EOF
629 drop table t1;
630
631 --echo # iteration 22a
632 set global aria_page_checksum = 1 ;
633 create table t1(a int) engine=aria ;
634 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
635 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
636 perl;
637 use strict;
638 use warnings;
639 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
640 open(FILE, "<", $fname) or die;
641 my @content= grep(/Page checksums are used/, <FILE>);
642 print @content ? $content[0] : "Page checksums are not used\n";
643 close FILE;
644 EOF
645 set global aria_page_checksum = 1 ;
646 alter table t1 engine=aria ;
647 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
648 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
649 perl;
650 use strict;
651 use warnings;
652 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
653 open(FILE, "<", $fname) or die;
654 my @content= grep(/Page checksums are used/, <FILE>);
655 print @content ? $content[0] : "Page checksums are not used\n";
656 close FILE;
657 EOF
658 drop table t1;
659
660 --echo # iteration 23a
661 set global aria_page_checksum = 1 ;
662 create table t1(a int) engine=aria ;
663 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
664 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
665 perl;
666 use strict;
667 use warnings;
668 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
669 open(FILE, "<", $fname) or die;
670 my @content= grep(/Page checksums are used/, <FILE>);
671 print @content ? $content[0] : "Page checksums are not used\n";
672 close FILE;
673 EOF
674 set global aria_page_checksum = 1 ;
675 alter table t1 PAGE_CHECKSUM=0 ;
676 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
677 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
678 perl;
679 use strict;
680 use warnings;
681 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
682 open(FILE, "<", $fname) or die;
683 my @content= grep(/Page checksums are used/, <FILE>);
684 print @content ? $content[0] : "Page checksums are not used\n";
685 close FILE;
686 EOF
687 drop table t1;
688
689 --echo # iteration 24a
690 set global aria_page_checksum = 1 ;
691 create table t1(a int) engine=aria ;
692 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
693 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
694 perl;
695 use strict;
696 use warnings;
697 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
698 open(FILE, "<", $fname) or die;
699 my @content= grep(/Page checksums are used/, <FILE>);
700 print @content ? $content[0] : "Page checksums are not used\n";
701 close FILE;
702 EOF
703 set global aria_page_checksum = 1 ;
704 alter table t1 PAGE_CHECKSUM=1 ;
705 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
706 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
707 perl;
708 use strict;
709 use warnings;
710 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
711 open(FILE, "<", $fname) or die;
712 my @content= grep(/Page checksums are used/, <FILE>);
713 print @content ? $content[0] : "Page checksums are not used\n";
714 close FILE;
715 EOF
716 drop table t1;
717
718 --echo # iteration 25a
719 set global aria_page_checksum = 1 ;
720 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
721 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
722 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
723 perl;
724 use strict;
725 use warnings;
726 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
727 open(FILE, "<", $fname) or die;
728 my @content= grep(/Page checksums are used/, <FILE>);
729 print @content ? $content[0] : "Page checksums are not used\n";
730 close FILE;
731 EOF
732 set global aria_page_checksum = 0 ;
733 alter table t1 engine=aria ;
734 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
735 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
736 perl;
737 use strict;
738 use warnings;
739 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
740 open(FILE, "<", $fname) or die;
741 my @content= grep(/Page checksums are used/, <FILE>);
742 print @content ? $content[0] : "Page checksums are not used\n";
743 close FILE;
744 EOF
745 drop table t1;
746
747 --echo # iteration 26a
748 set global aria_page_checksum = 1 ;
749 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
750 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
751 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
752 perl;
753 use strict;
754 use warnings;
755 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
756 open(FILE, "<", $fname) or die;
757 my @content= grep(/Page checksums are used/, <FILE>);
758 print @content ? $content[0] : "Page checksums are not used\n";
759 close FILE;
760 EOF
761 set global aria_page_checksum = 0 ;
762 alter table t1 PAGE_CHECKSUM=0 ;
763 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
764 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
765 perl;
766 use strict;
767 use warnings;
768 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
769 open(FILE, "<", $fname) or die;
770 my @content= grep(/Page checksums are used/, <FILE>);
771 print @content ? $content[0] : "Page checksums are not used\n";
772 close FILE;
773 EOF
774 drop table t1;
775
776 --echo # iteration 27a
777 set global aria_page_checksum = 1 ;
778 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
779 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
780 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
781 perl;
782 use strict;
783 use warnings;
784 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
785 open(FILE, "<", $fname) or die;
786 my @content= grep(/Page checksums are used/, <FILE>);
787 print @content ? $content[0] : "Page checksums are not used\n";
788 close FILE;
789 EOF
790 set global aria_page_checksum = 0 ;
791 alter table t1 PAGE_CHECKSUM=1 ;
792 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
793 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
794 perl;
795 use strict;
796 use warnings;
797 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
798 open(FILE, "<", $fname) or die;
799 my @content= grep(/Page checksums are used/, <FILE>);
800 print @content ? $content[0] : "Page checksums are not used\n";
801 close FILE;
802 EOF
803 drop table t1;
804
805 --echo # iteration 28a
806 set global aria_page_checksum = 1 ;
807 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
808 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
809 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
810 perl;
811 use strict;
812 use warnings;
813 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
814 open(FILE, "<", $fname) or die;
815 my @content= grep(/Page checksums are used/, <FILE>);
816 print @content ? $content[0] : "Page checksums are not used\n";
817 close FILE;
818 EOF
819 set global aria_page_checksum = 1 ;
820 alter table t1 engine=aria ;
821 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
822 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
823 perl;
824 use strict;
825 use warnings;
826 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
827 open(FILE, "<", $fname) or die;
828 my @content= grep(/Page checksums are used/, <FILE>);
829 print @content ? $content[0] : "Page checksums are not used\n";
830 close FILE;
831 EOF
832 drop table t1;
833
834 --echo # iteration 29a
835 set global aria_page_checksum = 1 ;
836 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
837 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
838 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
839 perl;
840 use strict;
841 use warnings;
842 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
843 open(FILE, "<", $fname) or die;
844 my @content= grep(/Page checksums are used/, <FILE>);
845 print @content ? $content[0] : "Page checksums are not used\n";
846 close FILE;
847 EOF
848 set global aria_page_checksum = 1 ;
849 alter table t1 PAGE_CHECKSUM=0 ;
850 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
851 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
852 perl;
853 use strict;
854 use warnings;
855 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
856 open(FILE, "<", $fname) or die;
857 my @content= grep(/Page checksums are used/, <FILE>);
858 print @content ? $content[0] : "Page checksums are not used\n";
859 close FILE;
860 EOF
861 drop table t1;
862
863 --echo # iteration 30a
864 set global aria_page_checksum = 1 ;
865 create table t1(a int) engine=aria PAGE_CHECKSUM=0 ;
866 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
867 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
868 perl;
869 use strict;
870 use warnings;
871 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
872 open(FILE, "<", $fname) or die;
873 my @content= grep(/Page checksums are used/, <FILE>);
874 print @content ? $content[0] : "Page checksums are not used\n";
875 close FILE;
876 EOF
877 set global aria_page_checksum = 1 ;
878 alter table t1 PAGE_CHECKSUM=1 ;
879 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
880 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
881 perl;
882 use strict;
883 use warnings;
884 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
885 open(FILE, "<", $fname) or die;
886 my @content= grep(/Page checksums are used/, <FILE>);
887 print @content ? $content[0] : "Page checksums are not used\n";
888 close FILE;
889 EOF
890 drop table t1;
891
892 --echo # iteration 31a
893 set global aria_page_checksum = 1 ;
894 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
895 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
896 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
897 perl;
898 use strict;
899 use warnings;
900 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
901 open(FILE, "<", $fname) or die;
902 my @content= grep(/Page checksums are used/, <FILE>);
903 print @content ? $content[0] : "Page checksums are not used\n";
904 close FILE;
905 EOF
906 set global aria_page_checksum = 0 ;
907 alter table t1 engine=aria ;
908 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
909 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
910 perl;
911 use strict;
912 use warnings;
913 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
914 open(FILE, "<", $fname) or die;
915 my @content= grep(/Page checksums are used/, <FILE>);
916 print @content ? $content[0] : "Page checksums are not used\n";
917 close FILE;
918 EOF
919 drop table t1;
920
921 --echo # iteration 32a
922 set global aria_page_checksum = 1 ;
923 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
924 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
925 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
926 perl;
927 use strict;
928 use warnings;
929 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
930 open(FILE, "<", $fname) or die;
931 my @content= grep(/Page checksums are used/, <FILE>);
932 print @content ? $content[0] : "Page checksums are not used\n";
933 close FILE;
934 EOF
935 set global aria_page_checksum = 0 ;
936 alter table t1 PAGE_CHECKSUM=0 ;
937 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
938 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
939 perl;
940 use strict;
941 use warnings;
942 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
943 open(FILE, "<", $fname) or die;
944 my @content= grep(/Page checksums are used/, <FILE>);
945 print @content ? $content[0] : "Page checksums are not used\n";
946 close FILE;
947 EOF
948 drop table t1;
949
950 --echo # iteration 33a
951 set global aria_page_checksum = 1 ;
952 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
953 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
954 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
955 perl;
956 use strict;
957 use warnings;
958 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
959 open(FILE, "<", $fname) or die;
960 my @content= grep(/Page checksums are used/, <FILE>);
961 print @content ? $content[0] : "Page checksums are not used\n";
962 close FILE;
963 EOF
964 set global aria_page_checksum = 0 ;
965 alter table t1 PAGE_CHECKSUM=1 ;
966 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
967 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
968 perl;
969 use strict;
970 use warnings;
971 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
972 open(FILE, "<", $fname) or die;
973 my @content= grep(/Page checksums are used/, <FILE>);
974 print @content ? $content[0] : "Page checksums are not used\n";
975 close FILE;
976 EOF
977 drop table t1;
978
979 --echo # iteration 34a
980 set global aria_page_checksum = 1 ;
981 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
982 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
983 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
984 perl;
985 use strict;
986 use warnings;
987 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
988 open(FILE, "<", $fname) or die;
989 my @content= grep(/Page checksums are used/, <FILE>);
990 print @content ? $content[0] : "Page checksums are not used\n";
991 close FILE;
992 EOF
993 set global aria_page_checksum = 1 ;
994 alter table t1 engine=aria ;
995 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
996 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
997 perl;
998 use strict;
999 use warnings;
1000 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1001 open(FILE, "<", $fname) or die;
1002 my @content= grep(/Page checksums are used/, <FILE>);
1003 print @content ? $content[0] : "Page checksums are not used\n";
1004 close FILE;
1005 EOF
1006 drop table t1;
1007
1008 --echo # iteration 35a
1009 set global aria_page_checksum = 1 ;
1010 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
1011 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
1012 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1013 perl;
1014 use strict;
1015 use warnings;
1016 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1017 open(FILE, "<", $fname) or die;
1018 my @content= grep(/Page checksums are used/, <FILE>);
1019 print @content ? $content[0] : "Page checksums are not used\n";
1020 close FILE;
1021 EOF
1022 set global aria_page_checksum = 1 ;
1023 alter table t1 PAGE_CHECKSUM=0 ;
1024 show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
1025 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1026 perl;
1027 use strict;
1028 use warnings;
1029 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1030 open(FILE, "<", $fname) or die;
1031 my @content= grep(/Page checksums are used/, <FILE>);
1032 print @content ? $content[0] : "Page checksums are not used\n";
1033 close FILE;
1034 EOF
1035 drop table t1;
1036
1037 --echo # iteration 36a
1038 set global aria_page_checksum = 1 ;
1039 create table t1(a int) engine=aria PAGE_CHECKSUM=1 ;
1040 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
1041 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1042 perl;
1043 use strict;
1044 use warnings;
1045 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1046 open(FILE, "<", $fname) or die;
1047 my @content= grep(/Page checksums are used/, <FILE>);
1048 print @content ? $content[0] : "Page checksums are not used\n";
1049 close FILE;
1050 EOF
1051 set global aria_page_checksum = 1 ;
1052 alter table t1 PAGE_CHECKSUM=1 ;
1053 show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
1054 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1055 perl;
1056 use strict;
1057 use warnings;
1058 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1059 open(FILE, "<", $fname) or die;
1060 my @content= grep(/Page checksums are used/, <FILE>);
1061 print @content ? $content[0] : "Page checksums are not used\n";
1062 close FILE;
1063 EOF
1064 drop table t1;
1065
1066 #
1067 # Test for BUG#37005
1068 # "Aria: ALTER TABLE TRANSACTIONAL=0 leaves table transactional inside Aria"
1069 #
1070
1071 # we scan through combinations in the cartesian product of
1072 # (clauses in CREATE TABLE) x (clauses in ALTER TABLE).
1073
1074 --echo # iteration 1b
1075 create table t1(a int) engine=aria ;
1076 show create table t1;
1077 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1078 perl;
1079 use strict;
1080 use warnings;
1081 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1082 open(FILE, "<", $fname) or die;
1083 print grep(/Crashsafe/, <FILE>);
1084 close FILE;
1085 EOF
1086
1087 alter table t1 modify a bigint ;
1088 show create table t1;
1089 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1090 perl;
1091 use strict;
1092 use warnings;
1093 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1094 open(FILE, "<", $fname) or die;
1095 print grep(/Crashsafe/, <FILE>);
1096 close FILE;
1097 EOF
1098 drop table t1;
1099
1100
1101 --echo # iteration 2b
1102 create table t1(a int) engine=aria ;
1103 show create table t1;
1104 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1105 perl;
1106 use strict;
1107 use warnings;
1108 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1109 open(FILE, "<", $fname) or die;
1110 print grep(/Crashsafe/, <FILE>);
1111 close FILE;
1112 EOF
1113
1114 alter table t1 transactional=0 ;
1115 show create table t1;
1116 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1117 perl;
1118 use strict;
1119 use warnings;
1120 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1121 open(FILE, "<", $fname) or die;
1122 print grep(/Crashsafe/, <FILE>);
1123 close FILE;
1124 EOF
1125 drop table t1;
1126
1127
1128 --echo # iteration 3b
1129 create table t1(a int) engine=aria ;
1130 show create table t1;
1131 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1132 perl;
1133 use strict;
1134 use warnings;
1135 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1136 open(FILE, "<", $fname) or die;
1137 print grep(/Crashsafe/, <FILE>);
1138 close FILE;
1139 EOF
1140
1141 alter table t1 transactional=1 ;
1142 show create table t1;
1143 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1144 perl;
1145 use strict;
1146 use warnings;
1147 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1148 open(FILE, "<", $fname) or die;
1149 print grep(/Crashsafe/, <FILE>);
1150 close FILE;
1151 EOF
1152 drop table t1;
1153
1154
1155 --echo # iteration 4b
1156 create table t1(a int) engine=aria ;
1157 show create table t1;
1158 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1159 perl;
1160 use strict;
1161 use warnings;
1162 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1163 open(FILE, "<", $fname) or die;
1164 print grep(/Crashsafe/, <FILE>);
1165 close FILE;
1166 EOF
1167
1168 alter table t1 engine=aria ;
1169 show create table t1;
1170 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1171 perl;
1172 use strict;
1173 use warnings;
1174 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1175 open(FILE, "<", $fname) or die;
1176 print grep(/Crashsafe/, <FILE>);
1177 close FILE;
1178 EOF
1179 drop table t1;
1180
1181
1182 --echo # iteration 5b
1183 create table t1(a int) engine=aria ;
1184 show create table t1;
1185 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1186 perl;
1187 use strict;
1188 use warnings;
1189 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1190 open(FILE, "<", $fname) or die;
1191 print grep(/Crashsafe/, <FILE>);
1192 close FILE;
1193 EOF
1194
1195 alter table t1 engine=aria transactional=0 ;
1196 show create table t1;
1197 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1198 perl;
1199 use strict;
1200 use warnings;
1201 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1202 open(FILE, "<", $fname) or die;
1203 print grep(/Crashsafe/, <FILE>);
1204 close FILE;
1205 EOF
1206 drop table t1;
1207
1208
1209 --echo # iteration 6b
1210 create table t1(a int) engine=aria ;
1211 show create table t1;
1212 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1213 perl;
1214 use strict;
1215 use warnings;
1216 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1217 open(FILE, "<", $fname) or die;
1218 print grep(/Crashsafe/, <FILE>);
1219 close FILE;
1220 EOF
1221
1222 alter table t1 engine=aria transactional=1 ;
1223 show create table t1;
1224 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1225 perl;
1226 use strict;
1227 use warnings;
1228 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1229 open(FILE, "<", $fname) or die;
1230 print grep(/Crashsafe/, <FILE>);
1231 close FILE;
1232 EOF
1233 drop table t1;
1234
1235
1236 --echo # iteration 7b
1237 create table t1(a int) engine=aria transactional=0 ;
1238 show create table t1;
1239 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1240 perl;
1241 use strict;
1242 use warnings;
1243 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1244 open(FILE, "<", $fname) or die;
1245 print grep(/Crashsafe/, <FILE>);
1246 close FILE;
1247 EOF
1248
1249 alter table t1 modify a bigint ;
1250 show create table t1;
1251 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1252 perl;
1253 use strict;
1254 use warnings;
1255 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1256 open(FILE, "<", $fname) or die;
1257 print grep(/Crashsafe/, <FILE>);
1258 close FILE;
1259 EOF
1260 drop table t1;
1261
1262
1263 --echo # iteration 8b
1264 create table t1(a int) engine=aria transactional=0 ;
1265 show create table t1;
1266 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1267 perl;
1268 use strict;
1269 use warnings;
1270 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1271 open(FILE, "<", $fname) or die;
1272 print grep(/Crashsafe/, <FILE>);
1273 close FILE;
1274 EOF
1275
1276 alter table t1 transactional=0 ;
1277 show create table t1;
1278 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1279 perl;
1280 use strict;
1281 use warnings;
1282 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1283 open(FILE, "<", $fname) or die;
1284 print grep(/Crashsafe/, <FILE>);
1285 close FILE;
1286 EOF
1287 drop table t1;
1288
1289
1290 --echo # iteration 9b
1291 create table t1(a int) engine=aria transactional=0 ;
1292 show create table t1;
1293 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1294 perl;
1295 use strict;
1296 use warnings;
1297 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1298 open(FILE, "<", $fname) or die;
1299 print grep(/Crashsafe/, <FILE>);
1300 close FILE;
1301 EOF
1302
1303 alter table t1 transactional=1 ;
1304 show create table t1;
1305 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1306 perl;
1307 use strict;
1308 use warnings;
1309 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1310 open(FILE, "<", $fname) or die;
1311 print grep(/Crashsafe/, <FILE>);
1312 close FILE;
1313 EOF
1314 drop table t1;
1315
1316
1317 --echo # iteration 10b
1318 create table t1(a int) engine=aria transactional=0 ;
1319 show create table t1;
1320 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1321 perl;
1322 use strict;
1323 use warnings;
1324 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1325 open(FILE, "<", $fname) or die;
1326 print grep(/Crashsafe/, <FILE>);
1327 close FILE;
1328 EOF
1329
1330 alter table t1 engine=aria ;
1331 show create table t1;
1332 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1333 perl;
1334 use strict;
1335 use warnings;
1336 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1337 open(FILE, "<", $fname) or die;
1338 print grep(/Crashsafe/, <FILE>);
1339 close FILE;
1340 EOF
1341 drop table t1;
1342
1343
1344 --echo # iteration 11b
1345 create table t1(a int) engine=aria transactional=0 ;
1346 show create table t1;
1347 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1348 perl;
1349 use strict;
1350 use warnings;
1351 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1352 open(FILE, "<", $fname) or die;
1353 print grep(/Crashsafe/, <FILE>);
1354 close FILE;
1355 EOF
1356
1357 alter table t1 engine=aria transactional=0 ;
1358 show create table t1;
1359 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1360 perl;
1361 use strict;
1362 use warnings;
1363 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1364 open(FILE, "<", $fname) or die;
1365 print grep(/Crashsafe/, <FILE>);
1366 close FILE;
1367 EOF
1368 drop table t1;
1369
1370
1371 --echo # iteration 12b
1372 create table t1(a int) engine=aria transactional=0 ;
1373 show create table t1;
1374 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1375 perl;
1376 use strict;
1377 use warnings;
1378 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1379 open(FILE, "<", $fname) or die;
1380 print grep(/Crashsafe/, <FILE>);
1381 close FILE;
1382 EOF
1383
1384 alter table t1 engine=aria transactional=1 ;
1385 show create table t1;
1386 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1387 perl;
1388 use strict;
1389 use warnings;
1390 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1391 open(FILE, "<", $fname) or die;
1392 print grep(/Crashsafe/, <FILE>);
1393 close FILE;
1394 EOF
1395 drop table t1;
1396
1397
1398 --echo # iteration 13b
1399 create table t1(a int) engine=aria transactional=1 ;
1400 show create table t1;
1401 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1402 perl;
1403 use strict;
1404 use warnings;
1405 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1406 open(FILE, "<", $fname) or die;
1407 print grep(/Crashsafe/, <FILE>);
1408 close FILE;
1409 EOF
1410
1411 alter table t1 modify a bigint ;
1412 show create table t1;
1413 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1414 perl;
1415 use strict;
1416 use warnings;
1417 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1418 open(FILE, "<", $fname) or die;
1419 print grep(/Crashsafe/, <FILE>);
1420 close FILE;
1421 EOF
1422 drop table t1;
1423
1424
1425 --echo # iteration 14b
1426 create table t1(a int) engine=aria transactional=1 ;
1427 show create table t1;
1428 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1429 perl;
1430 use strict;
1431 use warnings;
1432 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1433 open(FILE, "<", $fname) or die;
1434 print grep(/Crashsafe/, <FILE>);
1435 close FILE;
1436 EOF
1437
1438 alter table t1 transactional=0 ;
1439 show create table t1;
1440 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1441 perl;
1442 use strict;
1443 use warnings;
1444 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1445 open(FILE, "<", $fname) or die;
1446 print grep(/Crashsafe/, <FILE>);
1447 close FILE;
1448 EOF
1449 drop table t1;
1450
1451
1452 --echo # iteration 15b
1453 create table t1(a int) engine=aria transactional=1 ;
1454 show create table t1;
1455 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1456 perl;
1457 use strict;
1458 use warnings;
1459 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1460 open(FILE, "<", $fname) or die;
1461 print grep(/Crashsafe/, <FILE>);
1462 close FILE;
1463 EOF
1464
1465 alter table t1 transactional=1 ;
1466 show create table t1;
1467 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1468 perl;
1469 use strict;
1470 use warnings;
1471 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1472 open(FILE, "<", $fname) or die;
1473 print grep(/Crashsafe/, <FILE>);
1474 close FILE;
1475 EOF
1476 drop table t1;
1477
1478
1479 --echo # iteration 16b
1480 create table t1(a int) engine=aria transactional=1 ;
1481 show create table t1;
1482 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1483 perl;
1484 use strict;
1485 use warnings;
1486 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1487 open(FILE, "<", $fname) or die;
1488 print grep(/Crashsafe/, <FILE>);
1489 close FILE;
1490 EOF
1491
1492 alter table t1 engine=aria ;
1493 show create table t1;
1494 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1495 perl;
1496 use strict;
1497 use warnings;
1498 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1499 open(FILE, "<", $fname) or die;
1500 print grep(/Crashsafe/, <FILE>);
1501 close FILE;
1502 EOF
1503 drop table t1;
1504
1505
1506 --echo # iteration 17b
1507 create table t1(a int) engine=aria transactional=1 ;
1508 show create table t1;
1509 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1510 perl;
1511 use strict;
1512 use warnings;
1513 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1514 open(FILE, "<", $fname) or die;
1515 print grep(/Crashsafe/, <FILE>);
1516 close FILE;
1517 EOF
1518
1519 alter table t1 engine=aria transactional=0 ;
1520 show create table t1;
1521 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1522 perl;
1523 use strict;
1524 use warnings;
1525 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1526 open(FILE, "<", $fname) or die;
1527 print grep(/Crashsafe/, <FILE>);
1528 close FILE;
1529 EOF
1530 drop table t1;
1531
1532
1533 --echo # iteration 18b
1534 create table t1(a int) engine=aria transactional=1 ;
1535 show create table t1;
1536 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1537 perl;
1538 use strict;
1539 use warnings;
1540 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1541 open(FILE, "<", $fname) or die;
1542 print grep(/Crashsafe/, <FILE>);
1543 close FILE;
1544 EOF
1545
1546 alter table t1 engine=aria transactional=1 ;
1547 show create table t1;
1548 --exec $MARIA_CHK -dv $MYSQLD_DATADIR/test/t1 >$MYSQLTEST_VARDIR/tmp/ariachk.txt
1549 perl;
1550 use strict;
1551 use warnings;
1552 my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/ariachk.txt";
1553 open(FILE, "<", $fname) or die;
1554 print grep(/Crashsafe/, <FILE>);
1555 close FILE;
1556 EOF
1557 drop table t1;