USE tpch1;
drop table if exists mcol829a;
drop table if exists mcol829b;
drop procedure if exists mcol829;
create table mcol829a (a int, b int) engine=columnstore;
create table mcol829b (a int, b int) engine=columnstore;
insert into mcol829a values (1,1),(2,2),(3,3);
create procedure mcol829() begin insert into mcol829b select * from mcol829a; end//
call mcol829();
select * from mcol829b;
a	b
1	1
2	2
3	3
drop procedure mcol829;
drop table mcol829a;
drop table mcol829b;