973
973
# Live checksum feature available + enabled
974
eval create $temp table t1 (a int, b varchar(200), c text not null) checksum=1 engine=$other_live_chks_engine_type;
974
eval create $temp table t1 (a int, b varchar(200), c text not null) engine=$other_live_chks_engine_type;
975
975
# Live checksum feature available + disabled
976
eval create $temp table t2 (a int, b varchar(200), c text not null) checksum=0 engine=$other_live_chks_engine_type;
976
eval create $temp table t2 (a int, b varchar(200), c text not null) engine=$other_live_chks_engine_type;
978
978
# Live checksum feature not available + enabled
979
eval create $temp table t3 (a int, b varchar(200), c varchar(200) not null) checksum=1 engine=$other_non_live_chks_engine_type;
979
eval create $temp table t3 (a int, b varchar(200), c varchar(200) not null) engine=$other_non_live_chks_engine_type;
980
980
# Live checksum feature not available + disabled
981
eval create $temp table t4 (a int, b varchar(200), c varchar(200) not null) checksum=0 engine=$other_non_live_chks_engine_type;
981
eval create $temp table t4 (a int, b varchar(200), c varchar(200) not null) engine=$other_non_live_chks_engine_type;
983
983
# Live checksum feature probably available + enabled
984
eval create $temp table t5 (a int, b varchar(200), c text not null) checksum=1 engine=$engine_type;
984
eval create $temp table t5 (a int, b varchar(200), c text not null) engine=$engine_type;
985
985
# Live checksum feature probably available + disabled
986
eval create $temp table t6 (a int, b varchar(200), c text not null) checksum=0 engine=$engine_type;
986
eval create $temp table t6 (a int, b varchar(200), c text not null) engine=$engine_type;
988
988
insert t1 values (1, "aaa", "bbb"), (NULL, "", "ccccc"), (0, NULL, "");
989
989
insert t2 select * from t1;
added
removed
tests/include/mix2.inc
