5
-- source include/have_innodb.inc
6
-- source include/have_maria.inc
9
drop table if exists t1;
12
create table t1 (a int null, v varchar(100)) engine=myisam checksum=0;
13
insert into t1 values(null, null), (1, "hello");
15
checksum table t1 quick;
16
checksum table t1 extended;
17
drop table if exists t1;
18
create table t1 (a int null, v varchar(100)) engine=myisam checksum=1;
19
insert into t1 values(null, null), (1, "hello");
21
checksum table t1 quick;
22
checksum table t1 extended;
23
drop table if exists t1;
25
create table t1 (a int null, v varchar(100)) engine=innodb checksum=0;
26
insert into t1 values(null, null), (1, "hello");
28
checksum table t1 quick;
29
checksum table t1 extended;
32
create table t1 (a int null, v varchar(100)) engine=maria checksum=0;
33
insert into t1 values(null, null), (1, "hello");
35
checksum table t1 quick;
36
checksum table t1 extended;
38
create table t1 (a int null, v varchar(100)) engine=maria checksum=1;
39
insert into t1 values(null, null), (1, "hello");
41
checksum table t1 quick;
42
checksum table t1 extended;
47
# These checksums will be different prefixes fixed sizes rows with one extra
50
create table t1 (a int null, v varchar(100)) engine=myisam checksum=1 row_format=fixed;
51
insert into t1 values(null, null), (1, "hello");
53
checksum table t1 quick;
54
checksum table t1 extended;
55
drop table if exists t1;
57
create table t1 (a int null, v varchar(100)) engine=innodb checksum=0 row_format=fixed;
58
insert into t1 values(null, null), (1, "hello");
60
checksum table t1 quick;
61
checksum table t1 extended;