912
912
drop table t1,t2;
913
create TEMPORARY table t1 (a int, b varchar(200), c text not null) checksum=1 engine=MyISAM;
914
create TEMPORARY table t2 (a int, b varchar(200), c text not null) checksum=0 engine=MyISAM;
915
create TEMPORARY table t3 (a int, b varchar(200), c varchar(200) not null) checksum=1 engine=MEMORY;
916
create TEMPORARY table t4 (a int, b varchar(200), c varchar(200) not null) checksum=0 engine=MEMORY;
917
create TEMPORARY table t5 (a int, b varchar(200), c text not null) checksum=1 engine=MyISAM;
918
create TEMPORARY table t6 (a int, b varchar(200), c text not null) checksum=0 engine=MyISAM;
913
create TEMPORARY table t1 (a int, b varchar(200), c text not null) engine=MyISAM;
914
create TEMPORARY table t2 (a int, b varchar(200), c text not null) engine=MyISAM;
915
create TEMPORARY table t3 (a int, b varchar(200), c varchar(200) not null) engine=MEMORY;
916
create TEMPORARY table t4 (a int, b varchar(200), c varchar(200) not null) engine=MEMORY;
917
create TEMPORARY table t5 (a int, b varchar(200), c text not null) engine=MyISAM;
918
create TEMPORARY table t6 (a int, b varchar(200), c text not null) engine=MyISAM;
919
919
insert t1 values (1, "aaa", "bbb"), (NULL, "", "ccccc"), (0, NULL, "");
920
920
insert t2 select * from t1;
921
921
insert t3 select * from t1;
924
924
insert t6 select * from t1;
925
925
checksum table t1, t2, t3, t4, t5, t6, t7 quick;