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 2016/05/04 09:04:11 UTC
[5/8] tajo git commit: TAJO-2135: Invalid join result when join key
columns contain nulls.
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOftwoSmallTables.1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOftwoSmallTables.1.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOftwoSmallTables.1.result
index d2b414a..5731f27 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOftwoSmallTables.1.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOftwoSmallTables.1.result
@@ -5,23 +5,62 @@ l_orderkey,l_partkey,l_suppkey,l_linenumber,l_quantity,l_extendedprice,l_discoun
1,1,7706,1,17.0,21168.23,0.04,0.02,N,O,1996-03-13,1996-02-12,1996-03-22,DELIVER IN PERSON,TRUCK,egular courts above the,2,ASIA,ges. thinly even pinto beans ca
1,1,7706,1,17.0,21168.23,0.04,0.02,N,O,1996-03-13,1996-02-12,1996-03-22,DELIVER IN PERSON,TRUCK,egular courts above the,3,EUROPE,ly final courts cajole furiously final excuse
1,1,7706,1,17.0,21168.23,0.04,0.02,N,O,1996-03-13,1996-02-12,1996-03-22,DELIVER IN PERSON,TRUCK,egular courts above the,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+1,1,7706,1,17.0,21168.23,0.04,0.02,N,O,1996-03-13,1996-02-12,1996-03-22,DELIVER IN PERSON,TRUCK,egular courts above the,null,null,for null test
+1,1,7706,1,17.0,21168.23,0.04,0.02,N,O,1996-03-13,1996-02-12,1996-03-22,DELIVER IN PERSON,TRUCK,egular courts above the,null,null,for null test2
+1,1,7706,1,17.0,21168.23,0.04,0.02,N,O,1996-03-13,1996-02-12,1996-03-22,DELIVER IN PERSON,TRUCK,egular courts above the,null,null,for null test3
1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,1,AMERICA,hs use ironic, even requests. s
1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,2,ASIA,ges. thinly even pinto beans ca
1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,3,EUROPE,ly final courts cajole furiously final excuse
1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,null,null,for null test
+1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,null,null,for null test2
+1,1,7311,2,36.0,45983.16,0.09,0.06,N,O,1996-04-12,1996-02-28,1996-04-20,TAKE BACK RETURN,MAIL,ly final dependencies: slyly bold ,null,null,for null test3
2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,1,AMERICA,hs use ironic, even requests. s
2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,2,ASIA,ges. thinly even pinto beans ca
2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,3,EUROPE,ly final courts cajole furiously final excuse
2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,null,null,for null test
+2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,null,null,for null test2
+2,2,1191,1,38.0,44694.46,0.0,0.05,N,O,1997-01-28,1997-01-14,1997-02-02,TAKE BACK RETURN,RAIL,ven requests. deposits breach a,null,null,for null test3
3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,1,AMERICA,hs use ironic, even requests. s
3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,2,ASIA,ges. thinly even pinto beans ca
3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,3,EUROPE,ly final courts cajole furiously final excuse
3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,null,null,for null test
+3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,null,null,for null test2
+3,2,1798,1,45.0,54058.05,0.06,0.0,R,F,1994-02-02,1994-01-04,1994-02-23,NONE,AIR,ongside of the furiously brave acco,null,null,for null test3
3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,1,AMERICA,hs use ironic, even requests. s
3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,2,ASIA,ges. thinly even pinto beans ca
3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,3,EUROPE,ly final courts cajole furiously final excuse
3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,null,null,for null test
+3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,null,null,for null test2
+3,3,6540,2,49.0,46796.47,0.1,0.0,R,F,1993-11-09,1993-12-20,1993-11-24,TAKE BACK RETURN,RAIL, unusual accounts. eve,null,null,for null test3
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,1,AMERICA,hs use ironic, even requests. s
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,3,EUROPE,ly final courts cajole furiously final excuse
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,null,null,for null test
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,null,null,for null test2
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test,null,null,for null test3
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,1,AMERICA,hs use ironic, even requests. s
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,3,EUROPE,ly final courts cajole furiously final excuse
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,null,null,for null test
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,null,null,for null test2
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test2,null,null,for null test3
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,1,AMERICA,hs use ironic, even requests. s
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,3,EUROPE,ly final courts cajole furiously final excuse
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,null,null,for null test
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,null,null,for null test2
+null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,for null test3,null,null,for null test3
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk1.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk1.result
index 304b867..1724274 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk1.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk1.result
@@ -5,23 +5,62 @@ r_regionkey,r_name,r_comment,c_custkey,c_name,c_address,c_nationkey,c_phone,c_ac
0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null,null,null,null,null,null,null,for null test
+0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null,null,null,null,null,null,null,for null test2
+0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null,null,null,null,null,null,null,for null test3
1,AMERICA,hs use ironic, even requests. s,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
1,AMERICA,hs use ironic, even requests. s,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
1,AMERICA,hs use ironic, even requests. s,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
1,AMERICA,hs use ironic, even requests. s,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
1,AMERICA,hs use ironic, even requests. s,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+1,AMERICA,hs use ironic, even requests. s,null,null,null,null,null,null,null,for null test
+1,AMERICA,hs use ironic, even requests. s,null,null,null,null,null,null,null,for null test2
+1,AMERICA,hs use ironic, even requests. s,null,null,null,null,null,null,null,for null test3
2,ASIA,ges. thinly even pinto beans ca,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
2,ASIA,ges. thinly even pinto beans ca,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
2,ASIA,ges. thinly even pinto beans ca,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
2,ASIA,ges. thinly even pinto beans ca,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
2,ASIA,ges. thinly even pinto beans ca,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+2,ASIA,ges. thinly even pinto beans ca,null,null,null,null,null,null,null,for null test
+2,ASIA,ges. thinly even pinto beans ca,null,null,null,null,null,null,null,for null test2
+2,ASIA,ges. thinly even pinto beans ca,null,null,null,null,null,null,null,for null test3
3,EUROPE,ly final courts cajole furiously final excuse,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
3,EUROPE,ly final courts cajole furiously final excuse,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
3,EUROPE,ly final courts cajole furiously final excuse,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
3,EUROPE,ly final courts cajole furiously final excuse,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
3,EUROPE,ly final courts cajole furiously final excuse,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+3,EUROPE,ly final courts cajole furiously final excuse,null,null,null,null,null,null,null,for null test
+3,EUROPE,ly final courts cajole furiously final excuse,null,null,null,null,null,null,null,for null test2
+3,EUROPE,ly final courts cajole furiously final excuse,null,null,null,null,null,null,null,for null test3
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null,null,null,null,null,null,null,for null test
+4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null,null,null,null,null,null,null,for null test2
+4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null,null,null,null,null,null,null,for null test3
+null,null,for null test,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
+null,null,for null test2,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
+null,null,for null test3,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
+null,null,for null test,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
+null,null,for null test2,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
+null,null,for null test3,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
+null,null,for null test,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
+null,null,for null test2,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
+null,null,for null test3,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
+null,null,for null test,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
+null,null,for null test2,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
+null,null,for null test3,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
+null,null,for null test,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+null,null,for null test2,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+null,null,for null test3,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+null,null,for null test,null,null,null,null,null,null,null,for null test
+null,null,for null test2,null,null,null,null,null,null,null,for null test
+null,null,for null test3,null,null,null,null,null,null,null,for null test
+null,null,for null test,null,null,null,null,null,null,null,for null test2
+null,null,for null test2,null,null,null,null,null,null,null,for null test2
+null,null,for null test3,null,null,null,null,null,null,null,for null test2
+null,null,for null test,null,null,null,null,null,null,null,for null test3
+null,null,for null test2,null,null,null,null,null,null,null,for null test3
+null,null,for null test3,null,null,null,null,null,null,null,for null test3
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk2.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk2.result
index 304b867..1724274 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk2.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk2.result
@@ -5,23 +5,62 @@ r_regionkey,r_name,r_comment,c_custkey,c_name,c_address,c_nationkey,c_phone,c_ac
0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null,null,null,null,null,null,null,for null test
+0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null,null,null,null,null,null,null,for null test2
+0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null,null,null,null,null,null,null,for null test3
1,AMERICA,hs use ironic, even requests. s,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
1,AMERICA,hs use ironic, even requests. s,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
1,AMERICA,hs use ironic, even requests. s,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
1,AMERICA,hs use ironic, even requests. s,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
1,AMERICA,hs use ironic, even requests. s,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+1,AMERICA,hs use ironic, even requests. s,null,null,null,null,null,null,null,for null test
+1,AMERICA,hs use ironic, even requests. s,null,null,null,null,null,null,null,for null test2
+1,AMERICA,hs use ironic, even requests. s,null,null,null,null,null,null,null,for null test3
2,ASIA,ges. thinly even pinto beans ca,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
2,ASIA,ges. thinly even pinto beans ca,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
2,ASIA,ges. thinly even pinto beans ca,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
2,ASIA,ges. thinly even pinto beans ca,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
2,ASIA,ges. thinly even pinto beans ca,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+2,ASIA,ges. thinly even pinto beans ca,null,null,null,null,null,null,null,for null test
+2,ASIA,ges. thinly even pinto beans ca,null,null,null,null,null,null,null,for null test2
+2,ASIA,ges. thinly even pinto beans ca,null,null,null,null,null,null,null,for null test3
3,EUROPE,ly final courts cajole furiously final excuse,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
3,EUROPE,ly final courts cajole furiously final excuse,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
3,EUROPE,ly final courts cajole furiously final excuse,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
3,EUROPE,ly final courts cajole furiously final excuse,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
3,EUROPE,ly final courts cajole furiously final excuse,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+3,EUROPE,ly final courts cajole furiously final excuse,null,null,null,null,null,null,null,for null test
+3,EUROPE,ly final courts cajole furiously final excuse,null,null,null,null,null,null,null,for null test2
+3,EUROPE,ly final courts cajole furiously final excuse,null,null,null,null,null,null,null,for null test3
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null,null,null,null,null,null,null,for null test
+4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null,null,null,null,null,null,null,for null test2
+4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null,null,null,null,null,null,null,for null test3
+null,null,for null test,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
+null,null,for null test2,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
+null,null,for null test3,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e
+null,null,for null test,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
+null,null,for null test2,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
+null,null,for null test3,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref
+null,null,for null test,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
+null,null,for null test2,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
+null,null,for null test3,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov
+null,null,for null test,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
+null,null,for null test2,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
+null,null,for null test3,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
+null,null,for null test,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+null,null,for null test2,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+null,null,for null test3,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor
+null,null,for null test,null,null,null,null,null,null,null,for null test
+null,null,for null test2,null,null,null,null,null,null,null,for null test
+null,null,for null test3,null,null,null,null,null,null,null,for null test
+null,null,for null test,null,null,null,null,null,null,null,for null test2
+null,null,for null test2,null,null,null,null,null,null,null,for null test2
+null,null,for null test3,null,null,null,null,null,null,null,for null test2
+null,null,for null test,null,null,null,null,null,null,null,for null test3
+null,null,for null test2,null,null,null,null,null,null,null,for null test3
+null,null,for null test3,null,null,null,null,null,null,null,for null test3
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk3.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk3.result
index a7dd7b5..f9c0f46 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk3.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk3.result
@@ -5,23 +5,62 @@ c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment,
1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,2,ASIA,ges. thinly even pinto beans ca
1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,3,EUROPE,ly final courts cajole furiously final excuse
1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,null,null,for null test
+1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,null,null,for null test2
+1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,null,null,for null test3
2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,1,AMERICA,hs use ironic, even requests. s
2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,2,ASIA,ges. thinly even pinto beans ca
2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,3,EUROPE,ly final courts cajole furiously final excuse
2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,null,null,for null test
+2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,null,null,for null test2
+2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,null,null,for null test3
3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,1,AMERICA,hs use ironic, even requests. s
3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,2,ASIA,ges. thinly even pinto beans ca
3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,3,EUROPE,ly final courts cajole furiously final excuse
3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,null,null,for null test
+3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,null,null,for null test2
+3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,null,null,for null test3
4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,1,AMERICA,hs use ironic, even requests. s
4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,2,ASIA,ges. thinly even pinto beans ca
4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,3,EUROPE,ly final courts cajole furiously final excuse
4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,null,null,for null test
+4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,null,null,for null test2
+4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,null,null,for null test3
5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,1,AMERICA,hs use ironic, even requests. s
5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,2,ASIA,ges. thinly even pinto beans ca
5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,3,EUROPE,ly final courts cajole furiously final excuse
5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,null,null,for null test
+5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,null,null,for null test2
+5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,null,null,for null test3
+null,null,null,null,null,null,null,for null test,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
+null,null,null,null,null,null,null,for null test2,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
+null,null,null,null,null,null,null,for null test3,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
+null,null,null,null,null,null,null,for null test,1,AMERICA,hs use ironic, even requests. s
+null,null,null,null,null,null,null,for null test2,1,AMERICA,hs use ironic, even requests. s
+null,null,null,null,null,null,null,for null test3,1,AMERICA,hs use ironic, even requests. s
+null,null,null,null,null,null,null,for null test,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,null,null,null,null,for null test2,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,null,null,null,null,for null test3,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,null,null,null,null,for null test,3,EUROPE,ly final courts cajole furiously final excuse
+null,null,null,null,null,null,null,for null test2,3,EUROPE,ly final courts cajole furiously final excuse
+null,null,null,null,null,null,null,for null test3,3,EUROPE,ly final courts cajole furiously final excuse
+null,null,null,null,null,null,null,for null test,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+null,null,null,null,null,null,null,for null test2,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+null,null,null,null,null,null,null,for null test3,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+null,null,null,null,null,null,null,for null test,null,null,for null test
+null,null,null,null,null,null,null,for null test,null,null,for null test2
+null,null,null,null,null,null,null,for null test,null,null,for null test3
+null,null,null,null,null,null,null,for null test2,null,null,for null test
+null,null,null,null,null,null,null,for null test2,null,null,for null test2
+null,null,null,null,null,null,null,for null test2,null,null,for null test3
+null,null,null,null,null,null,null,for null test3,null,null,for null test
+null,null,null,null,null,null,null,for null test3,null,null,for null test2
+null,null,null,null,null,null,null,for null test3,null,null,for null test3
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk4.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk4.result
index 8e08403..257c107 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk4.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinWithAsterisk4.result
@@ -1,27 +1,66 @@
len,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comment,r_regionkey,r_name,r_comment,?multiply
-------------------------------
+13,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,null,null,for null test,10
+13,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,null,null,for null test,20
+13,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,null,null,for null test,30
+13,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,null,null,for null test,40
+13,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,null,null,for null test,50
+13,null,null,null,null,null,null,null,for null test,null,null,for null test,null
+13,null,null,null,null,null,null,null,for null test2,null,null,for null test,null
+13,null,null,null,null,null,null,null,for null test3,null,null,for null test,null
+14,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,null,null,for null test2,10
+14,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,null,null,for null test3,10
+14,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,null,null,for null test2,20
+14,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,null,null,for null test3,20
+14,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,null,null,for null test2,30
+14,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,null,null,for null test3,30
+14,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,null,null,for null test2,40
+14,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,null,null,for null test3,40
+14,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,null,null,for null test2,50
+14,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,null,null,for null test3,50
+14,null,null,null,null,null,null,null,for null test,null,null,for null test2,null
+14,null,null,null,null,null,null,null,for null test,null,null,for null test3,null
+14,null,null,null,null,null,null,null,for null test2,null,null,for null test2,null
+14,null,null,null,null,null,null,null,for null test2,null,null,for null test3,null
+14,null,null,null,null,null,null,null,for null test3,null,null,for null test2,null
+14,null,null,null,null,null,null,null,for null test3,null,null,for null test3,null
31,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,1,AMERICA,hs use ironic, even requests. s,10
31,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,1,AMERICA,hs use ironic, even requests. s,20
31,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,1,AMERICA,hs use ironic, even requests. s,30
31,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,1,AMERICA,hs use ironic, even requests. s,40
31,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,1,AMERICA,hs use ironic, even requests. s,50
+31,null,null,null,null,null,null,null,for null test,1,AMERICA,hs use ironic, even requests. s,null
+31,null,null,null,null,null,null,null,for null test2,1,AMERICA,hs use ironic, even requests. s,null
+31,null,null,null,null,null,null,null,for null test3,1,AMERICA,hs use ironic, even requests. s,null
31,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,2,ASIA,ges. thinly even pinto beans ca,10
31,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,2,ASIA,ges. thinly even pinto beans ca,20
31,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,2,ASIA,ges. thinly even pinto beans ca,30
31,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,2,ASIA,ges. thinly even pinto beans ca,40
31,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,2,ASIA,ges. thinly even pinto beans ca,50
+31,null,null,null,null,null,null,null,for null test,2,ASIA,ges. thinly even pinto beans ca,null
+31,null,null,null,null,null,null,null,for null test2,2,ASIA,ges. thinly even pinto beans ca,null
+31,null,null,null,null,null,null,null,for null test3,2,ASIA,ges. thinly even pinto beans ca,null
45,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,3,EUROPE,ly final courts cajole furiously final excuse,10
45,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,3,EUROPE,ly final courts cajole furiously final excuse,20
45,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,3,EUROPE,ly final courts cajole furiously final excuse,30
45,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,3,EUROPE,ly final courts cajole furiously final excuse,40
45,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,3,EUROPE,ly final courts cajole furiously final excuse,50
+45,null,null,null,null,null,null,null,for null test,3,EUROPE,ly final courts cajole furiously final excuse,null
+45,null,null,null,null,null,null,null,for null test2,3,EUROPE,ly final courts cajole furiously final excuse,null
+45,null,null,null,null,null,null,null,for null test3,3,EUROPE,ly final courts cajole furiously final excuse,null
108,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,10
108,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,20
108,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,30
108,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,40
108,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,50
+108,null,null,null,null,null,null,null,for null test,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null
+108,null,null,null,null,null,null,null,for null test2,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null
+108,null,null,null,null,null,null,null,for null test3,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl,null
115,1,Customer#000000001,IVhzIApeRb ot,c,E,15,25-989-741-2988,711.56,BUILDING,to the even, regular platelets. regular, ironic epitaphs nag e,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,10
115,2,Customer#000000002,XSTf4,NCwDVaWNe6tEgvwfmRchLXak,13,23-768-687-3665,121.65,AUTOMOBILE,l accounts. blithely ironic theodolites integrate boldly: caref,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,20
115,3,Customer#000000003,MG9kdTD2WBHm,1,11-719-748-3364,7498.12,AUTOMOBILE, deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,30
115,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,40
115,5,Customer#000000005,KvpyuHCplrB84WgAiGV6sYpZq7Tj,3,13-750-942-6364,794.47,HOUSEHOLD,n accounts will have to unwind. foxes cajole accor,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,50
+115,null,null,null,null,null,null,null,for null test,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null
+115,null,null,null,null,null,null,null,for null test2,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null
+115,null,null,null,null,null,null,null,for null test3,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to ,null
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
index 6ee9cb5..b586a1b 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameter2.result
@@ -1,3 +1,3 @@
merged
-------------------------------
-8
\ No newline at end of file
+11
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
index 59e09fe..946270f 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testComplexParameterWithSubQuery.result
@@ -1,3 +1,3 @@
total
-------------------------------
-10
\ No newline at end of file
+16
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.result
index f2ad32a..e26817c 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation1.result
@@ -2,4 +2,5 @@ l_orderkey,maximum,unique_key
-------------------------------
1,1,2
2,2,1
-3,3,2
\ No newline at end of file
+3,3,2
+null,null,0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.result
index 9164120..46cd099 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation2.result
@@ -2,4 +2,5 @@ l_orderkey,cnt,unique_key
-------------------------------
1,2,2
2,1,1
-3,2,2
\ No newline at end of file
+3,2,2
+null,3,0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result
index 5600470..4e458e9 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation3.result
@@ -1,3 +1,3 @@
?count,?count_1,?sum_2
-------------------------------
-5,3,6
\ No newline at end of file
+8,3,6
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result
index 72b4e8e..d73599f 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation4.result
@@ -1,4 +1,5 @@
l_linenumber,?count,?count_1,?sum_2
-------------------------------
1,3,3,6
-2,2,2,4
\ No newline at end of file
+2,2,2,4
+null,3,0,0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result
index 229a279..2af19f7 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation5.result
@@ -1,4 +1,5 @@
?sum,l_linenumber,?count_1,?count_2
-------------------------------
6,1,3,3
-4,2,2,2
\ No newline at end of file
+4,2,2,2
+0,null,0,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result
index cd59b8f..ec24ef8 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation6.result
@@ -2,4 +2,5 @@ v0,v1,v2,v4
-------------------------------
1,2,3,2
1,2,1,1
-1,6,3,2
\ No newline at end of file
+1,6,3,2
+0,null,null,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result
index 4173b04..c89de2f 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation7.result
@@ -1,3 +1,3 @@
?count,?count_1,?count_2
-------------------------------
-5,5,4
\ No newline at end of file
+8,5,4
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result
index 519390d..f07c356 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation8.result
@@ -4,4 +4,5 @@
2,1,N,O,1997-01-28,1,2
3,1,R,F,1994-02-02,1,3
1,2,N,O,1996-04-12,1,1
-3,2,R,F,1993-11-09,1,3
\ No newline at end of file
+3,2,R,F,1993-11-09,1,3
+0,null,null,null,null,0,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result
index 16c5524..5defa0a 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregationWithUnion1.result
@@ -1,4 +1,5 @@
?sum,l_linenumber,?count_1,total
-------------------------------
6,1,3,6
-4,2,2,4
\ No newline at end of file
+4,2,2,4
+0,null,0,2
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result
index 9296346..24f5749 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case1.result
@@ -1,4 +1,5 @@
quantity,suppkey,l_returnflag
-------------------------------
91.0,3,N
-94.0,2,R
\ No newline at end of file
+94.0,2,R
+null,0,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result
index 7af127f..a87952a 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case2.result
@@ -1,4 +1,5 @@
quantity,partkey,suppkey,l_returnflag
-------------------------------
91.0,2,3,N
-94.0,2,2,R
\ No newline at end of file
+94.0,2,2,R
+null,0,0,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result
index 31905fa..0f34869 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case3.result
@@ -1,4 +1,5 @@
quantity,partkey,?count,?max_1,l_returnflag
-------------------------------
91.0,2,3,38.0,N
-94.0,2,2,49.0,R
\ No newline at end of file
+94.0,2,2,49.0,R
+null,0,0,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result
index 8afda65..8d9d239 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case4.result
@@ -2,4 +2,5 @@ l_orderkey,quantity,partkey,?count,?max_1,l_returnflag
-------------------------------
1,53.0,1,2,36.0,N
2,38.0,1,1,38.0,N
-3,94.0,2,2,49.0,R
\ No newline at end of file
+3,94.0,2,2,49.0,R
+null,null,0,0,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result
index 8afda65..8d9d239 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case5.result
@@ -2,4 +2,5 @@ l_orderkey,quantity,partkey,?count,?max_1,l_returnflag
-------------------------------
1,53.0,1,2,36.0,N
2,38.0,1,1,38.0,N
-3,94.0,2,2,49.0,R
\ No newline at end of file
+3,94.0,2,2,49.0,R
+null,null,0,0,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result
index 8afda65..8d9d239 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case6.result
@@ -2,4 +2,5 @@ l_orderkey,quantity,partkey,?count,?max_1,l_returnflag
-------------------------------
1,53.0,1,2,36.0,N
2,38.0,1,1,38.0,N
-3,94.0,2,2,49.0,R
\ No newline at end of file
+3,94.0,2,2,49.0,R
+null,null,0,0,null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result
index 03cdf1e..351664c 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case7.result
@@ -2,4 +2,5 @@
-------------------------------
1,53.0,1,2,36.0
1,38.0,1,1,38.0
-1,94.0,2,2,49.0
\ No newline at end of file
+1,94.0,2,2,49.0
+0,null,0,0,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result
index e234896..20b3e89 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case8.result
@@ -3,4 +3,5 @@ l_orderkey,l_partkey,cnt1,cnt2,sum1
1,1,1,2,53.0
2,2,1,1,38.0
3,2,1,1,45.0
-3,3,1,1,49.0
\ No newline at end of file
+3,3,1,1,49.0
+null,null,0,0,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result
index 506eea0..fdf694a 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testDistinctAggregation_case9.result
@@ -3,4 +3,5 @@ l_orderkey,cnt1,value2,l_partkey,avg1,cnt2
1,1,28.0,1,26.5,2
2,1,39.0,2,38.0,1
3,1,46.0,2,45.0,1
-3,1,51.0,3,49.0,1
\ No newline at end of file
+3,1,51.0,3,49.0,1
+null,0,null,null,null,0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy.result
index 385d0de..00a3ee8 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy.result
@@ -1,3 +1,3 @@
unique_key
-------------------------------
-5
\ No newline at end of file
+8
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
index 1fda90c..1a148dc 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy2.result
@@ -2,3 +2,4 @@ unique_key
-------------------------------
2
3
+3
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
index c956d65..e62d55f 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy3.result
@@ -2,4 +2,5 @@ gkey
-------------------------------
1
2
-3
\ No newline at end of file
+3
+null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
index 22c6664..705a804 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy4.result
@@ -2,4 +2,5 @@ gkey,unique_key
-------------------------------
1,2
2,1
-3,2
\ No newline at end of file
+3,2
+null,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result
index abf0e45..83e2dae 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupBy5.result
@@ -2,4 +2,5 @@ gkey,const_val
-------------------------------
1,00
2,00
-3,00
\ No newline at end of file
+3,00
+null,00
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result
index 788a084..98bfbc9 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested1.result
@@ -3,4 +3,5 @@ unique_key
2
4
5
-6
\ No newline at end of file
+6
+null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result
index 8656add..65148dd 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByNested2.result
@@ -3,4 +3,5 @@ total
4
4
5
-6
\ No newline at end of file
+6
+null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result
index 2c04315..c17c5ac 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys1.result
@@ -1,3 +1,3 @@
key,total
-------------------------------
-123,5
\ No newline at end of file
+123,8
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result
index 776db3c..9b1ffa3 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys2.result
@@ -2,4 +2,5 @@ a,b,c,d
-------------------------------
1,2014-07-07 04:28:31.561,##,2
2,2014-07-07 04:28:31.561,##,2
-3,2014-07-07 04:28:31.561,##,1
\ No newline at end of file
+3,2014-07-07 04:28:31.561,##,1
+null,2014-07-07 04:28:31.561,##,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result
index 3285621..3db05ce 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys3.result
@@ -1,3 +1,3 @@
b,c,d
-------------------------------
-2014-07-07 04:28:31.561,##,5
\ No newline at end of file
+2014-07-07 04:28:31.561,##,8
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result
index 69560d5..19fb0cc 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys4.result
@@ -2,4 +2,5 @@
-------------------------------
day,1,2
day,2,1
-day,3,2
\ No newline at end of file
+day,3,2
+day,null,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result
index 30ba1de..9bc7496 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithConstantKeys5.result
@@ -2,4 +2,5 @@
-------------------------------
day,day,1,2
day,day,2,1
-day,day,3,2
\ No newline at end of file
+day,day,3,2
+day,day,null,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result
index d1f1282..7bee234 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys1.result
@@ -2,4 +2,5 @@ key,total
-------------------------------
1,2
2,1
-3,2
\ No newline at end of file
+3,2
+null,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result
index d1f1282..7bee234 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithExpressionKeys2.result
@@ -2,4 +2,5 @@ key,total
-------------------------------
1,2
2,1
-3,2
\ No newline at end of file
+3,2
+null,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result
index a8fbe00..15fc269 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameConstantKeys1.result
@@ -2,4 +2,5 @@ a,b,c,d
-------------------------------
1,##,##,2
2,##,##,2
-3,##,##,1
\ No newline at end of file
+3,##,##,1
+null,##,##,3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result
index c7db60e..354c7c7 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs1.result
@@ -3,4 +3,5 @@ total
4
4
6
-6
\ No newline at end of file
+6
+null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result
index c2b2851..ad93d2a 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupByWithSameExprs2.result
@@ -3,4 +3,5 @@ total1,total2
2,2
2,2
3,3
-3,3
\ No newline at end of file
+3,3
+null,null
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result
index 1413e41..0b3229d 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testGroupbyWithPythonFunc2.result
@@ -5,3 +5,4 @@ n_regionkey,cnt
2,5
3,5
4,5
+null,3
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result
index e1ba22d..1eb7767 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf.result
@@ -1,3 +1,3 @@
?avgpy,?avg_1,?countpy_2
-------------------------------
-12.0,12.0,25
\ No newline at end of file
+12.0,12.0,28
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result
index c2a8888..4b76df6 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf2.result
@@ -2,3 +2,4 @@
-------------------------------
2,2
3,3
+3,3
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result
index 7338988..7eeaa0b 100644
--- a/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result
+++ b/tajo-core-tests/src/test/resources/results/TestGroupByQuery/testPythonUdaf3.result
@@ -3,3 +3,4 @@
173665.47,1,173665.47,1
193846.25,1,193846.25,1
46929.18,1,46929.18,1
+null,3,null,3
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestInSubquery/testInSubQuery2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestInSubquery/testInSubQuery2.result b/tajo-core-tests/src/test/resources/results/TestInSubquery/testInSubQuery2.result
index fbab93d..1cbaf34 100644
--- a/tajo-core-tests/src/test/resources/results/TestInSubquery/testInSubQuery2.result
+++ b/tajo-core-tests/src/test/resources/results/TestInSubquery/testInSubQuery2.result
@@ -1,3 +1,3 @@
n_name
-------------------------------
-ETHIOPIA
+INDIA