# -------------------------------------------------------------- #
# Test case migrated from regression test suite: bug4848.sql
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE tpch1;
#
select max(K), count(*) from (select n_nationkey K from nation limit 1) a;
select n_nationkey K from nation limit 1;
(select n_nationkey K from nation limit 1) union (select n_nationkey K from nation limit 2) order by 1;
(select n_nationkey K from nation limit 1) union all (select n_nationkey K from nation limit 1);
(select n_nationkey K from nation limit 1) union all (select n_nationkey K from nation limit 2) limit 1;
#