--
-- ### Insert by select check
--


create table t1 (  primary a int not null, b string(5) );

insert into t1 values ( 1, 'alpha' );
insert into t1 values ( 2, 'beta' );
insert into t1 values ( 3, 'gamme' );


create table t2 (  primary a int not null, b string(5) );


insert into t2 select a, b from t1;

select * from t2;

drop table t1;
drop table t2;



