# -------------------------------------------------------------- # # 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; #