# -------------------------------------------------------------- #
# Test case migrated from Autopilot outer join test suite
#
# Author: Daniel Lee, daniel.lee@mariadb.com
# -------------------------------------------------------------- #
#
--source ../include/have_columnstore.inc
#
USE outerjoin;
#
sorted_result;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 join nation n2 on n1.n_nationkey = n2.n_nationkey;
sorted_result;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 left  join nation n2 on n1.n_nationkey = n2.n_nationkey;
sorted_result;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 right join nation n2 on n1.n_nationkey = n2.n_nationkey;
#
sorted_result;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 join nation n2 on n1.n_nationkey = n2.n_nationkey where n1.n_nationkey >= 0;
sorted_result;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 left  join nation n2 on n1.n_nationkey = n2.n_nationkey where n1.n_nationkey >= 0;
sorted_result;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 left  join nation n2 on n1.n_nationkey = n2.n_nationkey where n2.n_nationkey >= 0;
sorted_result;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 right join nation n2 on n1.n_nationkey = n2.n_nationkey where n1.n_nationkey >= 0;
sorted_result;
select n1.n_nationkey, n2.n_nationkey, n1.*, n2.* from nation n1 right join nation n2 on n1.n_nationkey = n2.n_nationkey where n2.n_nationkey >= 0;
#