create database if not exists d1;
use d1;
drop table t1;
create table if not exists t1 (e enum('one', 'two'));
insert ignore into t1 values ('one');
drop table if exists t2;

create table t2 (e enum('one', 'two')) as select * from t1;
select * from t2;
select * from t2 union all select * from t2;

alter table t2 engine MyISAM;
select * from t2 union all select * from t2;
