select @@global.maria_page_checksum;

--echo # iteration 1
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 2
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 3
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 4
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 5
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 6
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 7
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 8
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 9
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 10
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 11
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 12
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 13
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 14
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 15
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 16
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 17
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 18
set global maria_page_checksum = 0 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 19
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 20
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 21
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 22
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 23
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 24
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 25
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 26
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 27
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 28
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 29
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 30
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 31
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 32
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 33
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 0 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 34
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 engine=maria  ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 35
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=0 ;
show create table t1 /* expecting PAGE_CHECKSUM=0 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;

--echo # iteration 36
set global maria_page_checksum = 1 ;
create table t1(a int) engine=maria PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
set global maria_page_checksum = 1 ;
alter table t1 PAGE_CHECKSUM=1 ;
show create table t1 /* expecting PAGE_CHECKSUM=1 */ ;
--exec $MARIA_CHK -dv $MYSQLTEST_VARDIR/master-data/test/t1 >$MYSQLTEST_VARDIR/tmp/mariachk.txt
perl;
    use strict;
    use warnings;
    my $fname= "$ENV{'MYSQLTEST_VARDIR'}/tmp/mariachk.txt";
    open(FILE, "<", $fname) or die;
    my @content= grep(/Page checksums are used/, <FILE>);
    print @content ? $content[0] : "Page checksums are not used\n";
    close FILE;
EOF
drop table t1;