drop table varchar_union1_vc1;
drop table varchar_union1_vc2;
drop table varchar_union1_str;

create table  varchar_union1_vc1 (
  c1 int,
  c2 varchar(10)
);

create table  varchar_union1_vc2 (
  c1 int,
  c2 varchar(20)
);

create table  varchar_union1_str (
  c1 int,
  c2 string
);

load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc1;
load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc2;
load data local inpath '../../data/files/vc1.txt' into table varchar_union1_str;

-- union varchar with same length varchar
select * from (
  select * from varchar_union1_vc1
  union all
  select * from varchar_union1_vc1 limit 1
) q1 sort by c1;

-- union varchar with different length varchar
select * from (
  select * from varchar_union1_vc1
  union all
  select * from varchar_union1_vc2 limit 1
) q1 sort by c1;

-- union varchar with string
select * from (
  select * from varchar_union1_vc1
  union all
  select * from varchar_union1_str limit 1
) q1 sort by c1;

drop table varchar_union1_vc1;
drop table varchar_union1_vc2;
drop table varchar_union1_str;