# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug3167.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
select n_name from ((select n_name, n_regionkey from nation) union all
(select n_name, n_regionkey from nation)) as a order by 1;

select n_name from ((select n_name, n_regionkey from nation) union
(select n_name, n_regionkey from nation)) as a order by 1;

select a_name from ((select n_name as a_name from nation) union (select
n_name as a_name from nation)) as a order by 1;      

select name1 from ((select n_name as name1, n_regionkey from nation)
union all (select n_name as name1, n_regionkey from nation)) as a order by 1;

select a.a_name, a.regionkey from ((select n_name as a_name, n_regionkey
as regionkey from nation) union (select n_name as a_name, n_regionkey as
regionkey from nation)) as a order by 1, 2;

select a_name from ((select n_name as a_name from nation) union all (select
n_name as a_name from nation)) as a order by 1;

select a.a_name, a.regionkey from ((select n_name as a_name, n_regionkey
as regionkey from nation) union all (select n_name as a_name, n_regionkey as
regionkey from nation)) as a order by 1, 2;

#