You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by ji...@apache.org on 2015/11/18 13:12:59 UTC
[4/8] tajo git commit: TAJO-1981: Invalid nulls sort order in
VectorizedSorter.
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan
index b3f04c8..5b37e92 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(13)(INNER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)
@@ -62,7 +62,7 @@ Block Id: eb_0000000000000_0000_000007 [LEAF]
2: type=Broadcast, tables=default.supplier
SORT(21)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(13)(INNER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)
@@ -106,7 +106,7 @@ Block Id: eb_0000000000000_0000_000008 [ROOT]
0: sorted input=eb_0000000000000_0000_000007
SORT(5)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
SCAN(22) on eb_0000000000000_0000_000007
=> out schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
=> in schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan
index b195e34..ba3164b 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(13)(INNER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)
@@ -167,7 +167,7 @@ Block Id: eb_0000000000000_0000_000007 [INTERMEDIATE]
[q_0000000000000_0000] 7 => 8 (type=RANGE_SHUFFLE, key=default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT), num=32)
SORT(21)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(13)(INNER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)
@@ -191,7 +191,7 @@ Block Id: eb_0000000000000_0000_000008 [ROOT]
0: sorted input=eb_0000000000000_0000_000007
SORT(5)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
SCAN(22) on eb_0000000000000_0000_000007
=> out schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
=> in schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan
index b3f04c8..5b37e92 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(13)(INNER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)
@@ -62,7 +62,7 @@ Block Id: eb_0000000000000_0000_000007 [LEAF]
2: type=Broadcast, tables=default.supplier
SORT(21)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(13)(INNER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)
@@ -106,7 +106,7 @@ Block Id: eb_0000000000000_0000_000008 [ROOT]
0: sorted input=eb_0000000000000_0000_000007
SORT(5)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
SCAN(22) on eb_0000000000000_0000_000007
=> out schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
=> in schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan
index b195e34..ba3164b 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinQuery/testWhereClauseJoin6.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(13)(INNER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)
@@ -167,7 +167,7 @@ Block Id: eb_0000000000000_0000_000007 [INTERMEDIATE]
[q_0000000000000_0000] 7 => 8 (type=RANGE_SHUFFLE, key=default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT), num=32)
SORT(21)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
JOIN(13)(INNER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)
@@ -191,7 +191,7 @@ Block Id: eb_0000000000000_0000_000008 [ROOT]
0: sorted input=eb_0000000000000_0000_000007
SORT(5)
- => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc),default.supplier.s_name (TEXT) (asc),default.part.p_partkey (INT4) (asc),default.nation.n_name (TEXT) (asc)
+ => Sort Keys: default.supplier.s_acctbal (FLOAT8) (asc, nulls last),default.supplier.s_name (TEXT) (asc, nulls last),default.part.p_partkey (INT4) (asc, nulls last),default.nation.n_name (TEXT) (asc, nulls last)
SCAN(22) on eb_0000000000000_0000_000007
=> out schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
=> in schema: {(4) default.nation.n_name (TEXT), default.part.p_partkey (INT4), default.supplier.s_acctbal (FLOAT8), default.supplier.s_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan
index 714ab21..7935c18 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(6)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
JOIN(12)(INNER)
=> Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4)
=> target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)
@@ -56,7 +56,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF]
1: type=Broadcast, tables=default.part
SORT(18)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
JOIN(12)(INNER)
=> Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4)
=> target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(6)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000005
=> out schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)}
=> in schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan
index 7ab1815..e7a3684 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(6)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
JOIN(12)(INNER)
=> Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4)
=> target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)
@@ -131,7 +131,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT), num=32)
SORT(18)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
JOIN(12)(INNER)
=> Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4)
=> target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)
@@ -155,7 +155,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(6)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000005
=> out schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)}
=> in schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan
index 714ab21..7935c18 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(6)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
JOIN(12)(INNER)
=> Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4)
=> target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)
@@ -56,7 +56,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF]
1: type=Broadcast, tables=default.part
SORT(18)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
JOIN(12)(INNER)
=> Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4)
=> target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(6)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000005
=> out schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)}
=> in schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan
index 7ab1815..e7a3684 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testBroadcastSubquery.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(6)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
JOIN(12)(INNER)
=> Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4)
=> target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)
@@ -131,7 +131,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT), num=32)
SORT(18)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
JOIN(12)(INNER)
=> Join Cond: default.lineitem.l_orderkey (INT4) = default.a.o_orderkey (INT4)
=> target list: default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)
@@ -155,7 +155,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(6)
- => Sort Keys: default.lineitem.l_orderkey (INT4) (asc),default.a.o_custkey (INT4) (asc),default.part.p_name (TEXT) (asc)
+ => Sort Keys: default.lineitem.l_orderkey (INT4) (asc, nulls last),default.a.o_custkey (INT4) (asc, nulls last),default.part.p_name (TEXT) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000005
=> out schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)}
=> in schema: {(3) default.a.o_custkey (INT4), default.lineitem.l_orderkey (INT4), default.part.p_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan
index 7263d03..e2704f9 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(8)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -46,7 +46,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.small_nation
SORT(12)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(8)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -80,7 +80,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(5)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(13) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
=> in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan
index f8ce426..8e9e7f1 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(8)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -83,7 +83,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), num=32)
SORT(12)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(8)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -107,7 +107,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(5)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(13) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
=> in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan
index 7263d03..e2704f9 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(8)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -46,7 +46,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
0: type=Broadcast, tables=default.small_nation
SORT(12)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(8)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -80,7 +80,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(5)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(13) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
=> in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan
index f8ce426..8e9e7f1 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition5.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(8)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -83,7 +83,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), num=32)
SORT(12)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(8)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -107,7 +107,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(5)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(13) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
=> in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan
index 2b307d7..5b34211 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -60,7 +60,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
1: type=Broadcast, tables=default.nation
SORT(18)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
=> in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan
index 15a4a6b..7f26e0c 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 5 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), num=32)
SORT(18)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -135,7 +135,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
=> in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan
index 2b307d7..5b34211 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -60,7 +60,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
1: type=Broadcast, tables=default.nation
SORT(18)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
=> in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan
index 15a4a6b..7f26e0c 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition6.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 5 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), num=32)
SORT(18)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: name1 (TEXT) = name2 (TEXT)
=> target list: default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)
@@ -135,7 +135,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
=> in schema: {(3) default.n1.n_nationkey (INT4), name1 (TEXT), name2 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan
index 280b4f8..16eaa34 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -60,7 +60,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
1: type=Broadcast, tables=default.nation
SORT(18)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)}
=> in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan
index cd716a4..3b0fdb3 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 5 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), default.n2.n_name (TEXT), num=32)
SORT(18)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -135,7 +135,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)}
=> in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan
index 280b4f8..16eaa34 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -60,7 +60,7 @@ Block Id: eb_0000000000000_0000_000003 [LEAF]
1: type=Broadcast, tables=default.nation
SORT(18)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)}
=> in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan
index cd716a4..3b0fdb3 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testComplexJoinCondition7.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -111,7 +111,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 5 (type=RANGE_SHUFFLE, key=default.n1.n_nationkey (INT4), default.n2.n_name (TEXT), num=32)
SORT(18)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: ?substr_1 (TEXT) = ?substr_2 (TEXT)
=> target list: default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)
@@ -135,7 +135,7 @@ Block Id: eb_0000000000000_0000_000005 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(8)
- => Sort Keys: default.n1.n_nationkey (INT4) (asc),default.n2.n_name (TEXT) (asc)
+ => Sort Keys: default.n1.n_nationkey (INT4) (asc, nulls last),default.n2.n_name (TEXT) (asc, nulls last)
SCAN(19) on eb_0000000000000_0000_000003
=> out schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)}
=> in schema: {(3) default.n1.n_name (TEXT), default.n1.n_nationkey (INT4), default.n2.n_name (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan
index cf59edb..0653638 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SELECTION(11)
=> Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8)
JOIN(13)(INNER)
@@ -96,7 +96,7 @@ Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE]
0: type=Broadcast, tables=default.n
SORT(21)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SELECTION(11)
=> Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8)
JOIN(13)(INNER)
@@ -136,7 +136,7 @@ Block Id: eb_0000000000000_0000_000007 [ROOT]
0: sorted input=eb_0000000000000_0000_000006
SORT(8)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SCAN(22) on eb_0000000000000_0000_000006
=> out schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)}
=> in schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan
index d2d5617..c036ecf 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SELECTION(11)
=> Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8)
JOIN(13)(INNER)
@@ -164,7 +164,7 @@ Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE]
[q_0000000000000_0000] 6 => 7 (type=RANGE_SHUFFLE, key=default.n.n_nationkey (INT4), num=32)
SORT(21)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SELECTION(11)
=> Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8)
JOIN(13)(INNER)
@@ -190,7 +190,7 @@ Block Id: eb_0000000000000_0000_000007 [ROOT]
0: sorted input=eb_0000000000000_0000_000006
SORT(8)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SCAN(22) on eb_0000000000000_0000_000006
=> out schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)}
=> in schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan
index cf59edb..0653638 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SELECTION(11)
=> Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8)
JOIN(13)(INNER)
@@ -96,7 +96,7 @@ Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE]
0: type=Broadcast, tables=default.n
SORT(21)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SELECTION(11)
=> Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8)
JOIN(13)(INNER)
@@ -136,7 +136,7 @@ Block Id: eb_0000000000000_0000_000007 [ROOT]
0: sorted input=eb_0000000000000_0000_000006
SORT(8)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SCAN(22) on eb_0000000000000_0000_000006
=> out schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)}
=> in schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan
index d2d5617..c036ecf 100644
--- a/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestInnerJoinWithSubQuery/testThetaJoinKeyPairs.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(8)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SELECTION(11)
=> Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8)
JOIN(13)(INNER)
@@ -164,7 +164,7 @@ Block Id: eb_0000000000000_0000_000006 [INTERMEDIATE]
[q_0000000000000_0000] 6 => 7 (type=RANGE_SHUFFLE, key=default.n.n_nationkey (INT4), num=32)
SORT(21)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SELECTION(11)
=> Search Cond: CAST (default.n.n_nationkey (INT4) AS INT8) > default.t.cnt (INT8)
JOIN(13)(INNER)
@@ -190,7 +190,7 @@ Block Id: eb_0000000000000_0000_000007 [ROOT]
0: sorted input=eb_0000000000000_0000_000006
SORT(8)
- => Sort Keys: default.n.n_nationkey (INT4) (asc)
+ => Sort Keys: default.n.n_nationkey (INT4) (asc, nulls last)
SCAN(22) on eb_0000000000000_0000_000006
=> out schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)}
=> in schema: {(4) default.n.n_name (TEXT), default.n.n_nationkey (INT4), default.n.n_regionkey (INT4), default.t.cnt (INT8)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan
index 6bec7f2..63ac101 100644
--- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(9)(LEFT_OUTER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT)
@@ -52,7 +52,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF]
1: type=Broadcast, tables=default.supplier
SORT(15)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(9)(LEFT_OUTER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT)
@@ -87,7 +87,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(5)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
SCAN(16) on eb_0000000000000_0000_000005
=> out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
=> in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan
index 5cba003..2216605 100644
--- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(9)(LEFT_OUTER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT)
@@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.region.r_name (TEXT), s1 (TEXT), num=32)
SORT(15)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(9)(LEFT_OUTER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT)
@@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(5)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
SCAN(16) on eb_0000000000000_0000_000005
=> out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
=> in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan
index 6bec7f2..63ac101 100644
--- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(9)(LEFT_OUTER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT)
@@ -52,7 +52,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF]
1: type=Broadcast, tables=default.supplier
SORT(15)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(9)(LEFT_OUTER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT)
@@ -87,7 +87,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(5)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
SCAN(16) on eb_0000000000000_0000_000005
=> out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
=> in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan
index 5cba003..2216605 100644
--- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(9)(LEFT_OUTER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT)
@@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.region.r_name (TEXT), s1 (TEXT), num=32)
SORT(15)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(9)(LEFT_OUTER)
=> Join Cond: default.supplier.s_nationkey (INT4) = default.nation.n_nationkey (INT4)
=> target list: CASE WHEN default.supplier.s_name (TEXT) IS NULL THEN N/O ELSE default.supplier.s_name (TEXT) END as s1, default.region.r_name (TEXT)
@@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(5)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
SCAN(16) on eb_0000000000000_0000_000005
=> out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
=> in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan
index 8622663..894197b 100644
--- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(7)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4)
=> target list: default.region.r_name (TEXT), s1 (TEXT)
@@ -56,7 +56,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF]
1: type=Broadcast, tables=default.supplier
SORT(17)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4)
=> target list: default.region.r_name (TEXT), s1 (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(7)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
SCAN(18) on eb_0000000000000_0000_000005
=> out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
=> in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan
index af9b3a5..791b296 100644
--- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(7)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4)
=> target list: default.region.r_name (TEXT), s1 (TEXT)
@@ -131,7 +131,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.region.r_name (TEXT), s1 (TEXT), num=32)
SORT(17)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4)
=> target list: default.region.r_name (TEXT), s1 (TEXT)
@@ -155,7 +155,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(7)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
SCAN(18) on eb_0000000000000_0000_000005
=> out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
=> in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan
index 8622663..894197b 100644
--- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(7)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4)
=> target list: default.region.r_name (TEXT), s1 (TEXT)
@@ -56,7 +56,7 @@ Block Id: eb_0000000000000_0000_000005 [LEAF]
1: type=Broadcast, tables=default.supplier
SORT(17)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4)
=> target list: default.region.r_name (TEXT), s1 (TEXT)
@@ -99,7 +99,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(7)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
SCAN(18) on eb_0000000000000_0000_000005
=> out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
=> in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan
index af9b3a5..791b296 100644
--- a/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestMultipleJoinTypes/testComplexJoinsWithCaseWhen2.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(7)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4)
=> target list: default.region.r_name (TEXT), s1 (TEXT)
@@ -131,7 +131,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.region.r_name (TEXT), s1 (TEXT), num=32)
SORT(17)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
JOIN(11)(INNER)
=> Join Cond: default.t.n_regionkey (INT4) = default.region.r_regionkey (INT4)
=> target list: default.region.r_name (TEXT), s1 (TEXT)
@@ -155,7 +155,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(7)
- => Sort Keys: default.region.r_name (TEXT) (asc),s1 (TEXT) (asc)
+ => Sort Keys: default.region.r_name (TEXT) (asc, nulls last),s1 (TEXT) (asc, nulls last)
SCAN(18) on eb_0000000000000_0000_000005
=> out schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
=> in schema: {(2) default.region.r_name (TEXT), s1 (TEXT)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan
index eab9940..8c98e69 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan
index eab9940..8c98e69 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan
index eab9940..8c98e69 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan
index eab9940..8c98e69 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoin1.Sort_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)
@@ -71,7 +71,7 @@ Block Id: eb_0000000000000_0000_000003 [INTERMEDIATE]
[q_0000000000000_0000] 3 => 4 (type=RANGE_SHUFFLE, key=default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4), num=32)
SORT(10)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
JOIN(6)(FULL_OUTER)
=> Join Cond: default.customer.c_custkey (INT4) = default.orders.o_orderkey (INT4)
=> target list: default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)
@@ -95,7 +95,7 @@ Block Id: eb_0000000000000_0000_000004 [ROOT]
0: sorted input=eb_0000000000000_0000_000003
SORT(3)
- => Sort Keys: default.customer.c_custkey (INT4) (asc),default.orders.o_orderkey (INT4) (asc)
+ => Sort Keys: default.customer.c_custkey (INT4) (asc, nulls last),default.orders.o_orderkey (INT4) (asc, nulls last)
SCAN(11) on eb_0000000000000_0000_000003
=> out schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
=> in schema: {(2) default.customer.c_custkey (INT4), default.orders.o_orderkey (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan
index 25f5eeb..8d16168 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
JOIN(9)(FULL_OUTER)
=> Join Cond: default.t1.id (INT4) = default.t3.id (INT4)
=> target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)
@@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t4.id (INT4), num=32)
SORT(15)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
JOIN(9)(FULL_OUTER)
=> Join Cond: default.t1.id (INT4) = default.t3.id (INT4)
=> target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)
@@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(5)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
SCAN(16) on eb_0000000000000_0000_000005
=> out schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)}
=> in schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan
index 25f5eeb..8d16168 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Hash_NoBroadcast.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
JOIN(9)(FULL_OUTER)
=> Join Cond: default.t1.id (INT4) = default.t3.id (INT4)
=> target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)
@@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t4.id (INT4), num=32)
SORT(15)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
JOIN(9)(FULL_OUTER)
=> Join Cond: default.t1.id (INT4) = default.t3.id (INT4)
=> target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)
@@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(5)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
SCAN(16) on eb_0000000000000_0000_000005
=> out schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)}
=> in schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)}
http://git-wip-us.apache.org/repos/asf/tajo/blob/090ce171/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan
index 25f5eeb..8d16168 100644
--- a/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan
+++ b/tajo-core-tests/src/test/resources/results/TestOuterJoinQuery/testFullOuterJoinPredicationCaseByCase1.1.Sort.plan
@@ -1,7 +1,7 @@
explain
-------------------------------
SORT(5)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
JOIN(9)(FULL_OUTER)
=> Join Cond: default.t1.id (INT4) = default.t3.id (INT4)
=> target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)
@@ -119,7 +119,7 @@ Block Id: eb_0000000000000_0000_000005 [INTERMEDIATE]
[q_0000000000000_0000] 5 => 6 (type=RANGE_SHUFFLE, key=default.t4.id (INT4), num=32)
SORT(15)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
JOIN(9)(FULL_OUTER)
=> Join Cond: default.t1.id (INT4) = default.t3.id (INT4)
=> target list: default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)
@@ -143,7 +143,7 @@ Block Id: eb_0000000000000_0000_000006 [ROOT]
0: sorted input=eb_0000000000000_0000_000005
SORT(5)
- => Sort Keys: default.t4.id (INT4) (asc)
+ => Sort Keys: default.t4.id (INT4) (asc, nulls last)
SCAN(16) on eb_0000000000000_0000_000005
=> out schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)}
=> in schema: {(4) default.t1.id (INT4), default.t1.name (TEXT), default.t3.id (INT4), default.t4.id (INT4)}