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:12 UTC
[6/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/testCrossJoin.1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.1.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.1.result
index 7d5a2f5..42d8ad8 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.1.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.1.result
@@ -5,123 +5,222 @@ ALGERIA,AMERICA,0,1
ALGERIA,ASIA,0,2
ALGERIA,EUROPE,0,3
ALGERIA,MIDDLE EAST,0,4
+ALGERIA,null,0,null
+ALGERIA,null,0,null
+ALGERIA,null,0,null
ARGENTINA,AFRICA,1,0
ARGENTINA,AMERICA,1,1
ARGENTINA,ASIA,1,2
ARGENTINA,EUROPE,1,3
ARGENTINA,MIDDLE EAST,1,4
+ARGENTINA,null,1,null
+ARGENTINA,null,1,null
+ARGENTINA,null,1,null
BRAZIL,AFRICA,1,0
BRAZIL,AMERICA,1,1
BRAZIL,ASIA,1,2
BRAZIL,EUROPE,1,3
BRAZIL,MIDDLE EAST,1,4
+BRAZIL,null,1,null
+BRAZIL,null,1,null
+BRAZIL,null,1,null
CANADA,AFRICA,1,0
CANADA,AMERICA,1,1
CANADA,ASIA,1,2
CANADA,EUROPE,1,3
CANADA,MIDDLE EAST,1,4
+CANADA,null,1,null
+CANADA,null,1,null
+CANADA,null,1,null
CHINA,AFRICA,2,0
CHINA,AMERICA,2,1
CHINA,ASIA,2,2
CHINA,EUROPE,2,3
CHINA,MIDDLE EAST,2,4
+CHINA,null,2,null
+CHINA,null,2,null
+CHINA,null,2,null
EGYPT,AFRICA,4,0
EGYPT,AMERICA,4,1
EGYPT,ASIA,4,2
EGYPT,EUROPE,4,3
EGYPT,MIDDLE EAST,4,4
+EGYPT,null,4,null
+EGYPT,null,4,null
+EGYPT,null,4,null
ETHIOPIA,AFRICA,0,0
ETHIOPIA,AMERICA,0,1
ETHIOPIA,ASIA,0,2
ETHIOPIA,EUROPE,0,3
ETHIOPIA,MIDDLE EAST,0,4
+ETHIOPIA,null,0,null
+ETHIOPIA,null,0,null
+ETHIOPIA,null,0,null
FRANCE,AFRICA,3,0
FRANCE,AMERICA,3,1
FRANCE,ASIA,3,2
FRANCE,EUROPE,3,3
FRANCE,MIDDLE EAST,3,4
+FRANCE,null,3,null
+FRANCE,null,3,null
+FRANCE,null,3,null
GERMANY,AFRICA,3,0
GERMANY,AMERICA,3,1
GERMANY,ASIA,3,2
GERMANY,EUROPE,3,3
GERMANY,MIDDLE EAST,3,4
+GERMANY,null,3,null
+GERMANY,null,3,null
+GERMANY,null,3,null
INDIA,AFRICA,2,0
INDIA,AMERICA,2,1
INDIA,ASIA,2,2
INDIA,EUROPE,2,3
INDIA,MIDDLE EAST,2,4
+INDIA,null,2,null
+INDIA,null,2,null
+INDIA,null,2,null
INDONESIA,AFRICA,2,0
INDONESIA,AMERICA,2,1
INDONESIA,ASIA,2,2
INDONESIA,EUROPE,2,3
INDONESIA,MIDDLE EAST,2,4
+INDONESIA,null,2,null
+INDONESIA,null,2,null
+INDONESIA,null,2,null
IRAN,AFRICA,4,0
IRAN,AMERICA,4,1
IRAN,ASIA,4,2
IRAN,EUROPE,4,3
IRAN,MIDDLE EAST,4,4
+IRAN,null,4,null
+IRAN,null,4,null
+IRAN,null,4,null
IRAQ,AFRICA,4,0
IRAQ,AMERICA,4,1
IRAQ,ASIA,4,2
IRAQ,EUROPE,4,3
IRAQ,MIDDLE EAST,4,4
+IRAQ,null,4,null
+IRAQ,null,4,null
+IRAQ,null,4,null
JAPAN,AFRICA,2,0
JAPAN,AMERICA,2,1
JAPAN,ASIA,2,2
JAPAN,EUROPE,2,3
JAPAN,MIDDLE EAST,2,4
+JAPAN,null,2,null
+JAPAN,null,2,null
+JAPAN,null,2,null
JORDAN,AFRICA,4,0
JORDAN,AMERICA,4,1
JORDAN,ASIA,4,2
JORDAN,EUROPE,4,3
JORDAN,MIDDLE EAST,4,4
+JORDAN,null,4,null
+JORDAN,null,4,null
+JORDAN,null,4,null
KENYA,AFRICA,0,0
KENYA,AMERICA,0,1
KENYA,ASIA,0,2
KENYA,EUROPE,0,3
KENYA,MIDDLE EAST,0,4
+KENYA,null,0,null
+KENYA,null,0,null
+KENYA,null,0,null
MOROCCO,AFRICA,0,0
MOROCCO,AMERICA,0,1
MOROCCO,ASIA,0,2
MOROCCO,EUROPE,0,3
MOROCCO,MIDDLE EAST,0,4
+MOROCCO,null,0,null
+MOROCCO,null,0,null
+MOROCCO,null,0,null
MOZAMBIQUE,AFRICA,0,0
MOZAMBIQUE,AMERICA,0,1
MOZAMBIQUE,ASIA,0,2
MOZAMBIQUE,EUROPE,0,3
MOZAMBIQUE,MIDDLE EAST,0,4
+MOZAMBIQUE,null,0,null
+MOZAMBIQUE,null,0,null
+MOZAMBIQUE,null,0,null
PERU,AFRICA,1,0
PERU,AMERICA,1,1
PERU,ASIA,1,2
PERU,EUROPE,1,3
PERU,MIDDLE EAST,1,4
+PERU,null,1,null
+PERU,null,1,null
+PERU,null,1,null
ROMANIA,AFRICA,3,0
ROMANIA,AMERICA,3,1
ROMANIA,ASIA,3,2
ROMANIA,EUROPE,3,3
ROMANIA,MIDDLE EAST,3,4
+ROMANIA,null,3,null
+ROMANIA,null,3,null
+ROMANIA,null,3,null
RUSSIA,AFRICA,3,0
RUSSIA,AMERICA,3,1
RUSSIA,ASIA,3,2
RUSSIA,EUROPE,3,3
RUSSIA,MIDDLE EAST,3,4
+RUSSIA,null,3,null
+RUSSIA,null,3,null
+RUSSIA,null,3,null
SAUDI ARABIA,AFRICA,4,0
SAUDI ARABIA,AMERICA,4,1
SAUDI ARABIA,ASIA,4,2
SAUDI ARABIA,EUROPE,4,3
SAUDI ARABIA,MIDDLE EAST,4,4
+SAUDI ARABIA,null,4,null
+SAUDI ARABIA,null,4,null
+SAUDI ARABIA,null,4,null
UNITED KINGDOM,AFRICA,3,0
UNITED KINGDOM,AMERICA,3,1
UNITED KINGDOM,ASIA,3,2
UNITED KINGDOM,EUROPE,3,3
UNITED KINGDOM,MIDDLE EAST,3,4
+UNITED KINGDOM,null,3,null
+UNITED KINGDOM,null,3,null
+UNITED KINGDOM,null,3,null
UNITED STATES,AFRICA,1,0
UNITED STATES,AMERICA,1,1
UNITED STATES,ASIA,1,2
UNITED STATES,EUROPE,1,3
UNITED STATES,MIDDLE EAST,1,4
+UNITED STATES,null,1,null
+UNITED STATES,null,1,null
+UNITED STATES,null,1,null
VIETNAM,AFRICA,2,0
VIETNAM,AMERICA,2,1
VIETNAM,ASIA,2,2
VIETNAM,EUROPE,2,3
VIETNAM,MIDDLE EAST,2,4
+VIETNAM,null,2,null
+VIETNAM,null,2,null
+VIETNAM,null,2,null
+null,AFRICA,null,0
+null,AFRICA,null,0
+null,AFRICA,null,0
+null,AMERICA,null,1
+null,AMERICA,null,1
+null,AMERICA,null,1
+null,ASIA,null,2
+null,ASIA,null,2
+null,ASIA,null,2
+null,EUROPE,null,3
+null,EUROPE,null,3
+null,EUROPE,null,3
+null,MIDDLE EAST,null,4
+null,MIDDLE EAST,null,4
+null,MIDDLE EAST,null,4
+null,null,null,null
+null,null,null,null
+null,null,null,null
+null,null,null,null
+null,null,null,null
+null,null,null,null
+null,null,null,null
+null,null,null,null
+null,null,null,null
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.2.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.2.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.2.result
index 304b867..f95d10c 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.2.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.2.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 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 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 test,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 test,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 test,null,null,null,null,null,null,null,for null test3
+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 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 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 test2,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
+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 test2,null,null,null,null,null,null,null,for null test
+null,null,for null test2,null,null,null,null,null,null,null,for null test2
+null,null,for null test2,null,null,null,null,null,null,null,for null test3
+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 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 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 test3,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
+null,null,for null test3,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 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/testCrossJoin.3.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.3.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.3.result
index 304b867..f95d10c 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.3.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.3.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 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 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 test,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 test,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 test,null,null,null,null,null,null,null,for null test3
+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 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 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 test2,4,Customer#000000004,XxVSJsLAGtn,4,14-128-190-5944,2866.83,MACHINERY, requests. final, regular ideas sleep final accou
+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 test2,null,null,null,null,null,null,null,for null test
+null,null,for null test2,null,null,null,null,null,null,null,for null test2
+null,null,for null test2,null,null,null,null,null,null,null,for null test3
+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 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 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 test3,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
+null,null,for null test3,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 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/testCrossJoin.4.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.4.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.4.result
index a7dd7b5..067ec18 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.4.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.4.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 test,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 test,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 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,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,1,AMERICA,hs use ironic, even requests. s
+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 test2,3,EUROPE,ly final courts cajole furiously final excuse
+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 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,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
+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 test3,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
+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/testCrossJoin.5.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.5.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.5.result
index 89720e0..f26f232 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.5.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoin.5.result
@@ -5,11 +5,41 @@ len,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comm
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
+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,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,1,AMERICA,hs use ironic, even requests. s,20
@@ -20,8 +50,17 @@ len,c_custkey,c_name,c_address,c_nationkey,c_phone,c_acctbal,c_mktsegment,c_comm
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,1,AMERICA,hs use ironic, even requests. s,50
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,1,AMERICA,hs use ironic, even requests. s,null
+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,1,AMERICA,hs use ironic, even requests. s,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,1,AMERICA,hs use ironic, even requests. s,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
http://git-wip-us.apache.org/repos/asf/tajo/blob/c156e5c9/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOfOneSmallTable.1.result
----------------------------------------------------------------------
diff --git a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOfOneSmallTable.1.result b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOfOneSmallTable.1.result
index d3bd041..cd6a8bc 100644
--- a/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOfOneSmallTable.1.result
+++ b/tajo-core-tests/src/test/resources/results/TestCrossJoin/testCrossJoinOfOneSmallTable.1.result
@@ -5,123 +5,222 @@ n_nationkey,n_name,n_regionkey,n_comment,r_regionkey,r_name,r_comment
0,ALGERIA,0, haggle. carefully final deposits detect slyly agai,2,ASIA,ges. thinly even pinto beans ca
0,ALGERIA,0, haggle. carefully final deposits detect slyly agai,3,EUROPE,ly final courts cajole furiously final excuse
0,ALGERIA,0, haggle. carefully final deposits detect slyly agai,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+0,ALGERIA,0, haggle. carefully final deposits detect slyly agai,null,null,for null test
+0,ALGERIA,0, haggle. carefully final deposits detect slyly agai,null,null,for null test2
+0,ALGERIA,0, haggle. carefully final deposits detect slyly agai,null,null,for null test3
1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,1,AMERICA,hs use ironic, even requests. s
1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,2,ASIA,ges. thinly even pinto beans ca
1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,3,EUROPE,ly final courts cajole furiously final excuse
1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,null,null,for null test
+1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,null,null,for null test2
+1,ARGENTINA,1,al foxes promise slyly according to the regular accounts. bold requests alon,null,null,for null test3
2,BRAZIL,1,y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special ,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
2,BRAZIL,1,y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special ,1,AMERICA,hs use ironic, even requests. s
2,BRAZIL,1,y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special ,2,ASIA,ges. thinly even pinto beans ca
2,BRAZIL,1,y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special ,3,EUROPE,ly final courts cajole furiously final excuse
2,BRAZIL,1,y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special ,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+2,BRAZIL,1,y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special ,null,null,for null test
+2,BRAZIL,1,y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special ,null,null,for null test2
+2,BRAZIL,1,y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special ,null,null,for null test3
3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,1,AMERICA,hs use ironic, even requests. s
3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,2,ASIA,ges. thinly even pinto beans ca
3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,3,EUROPE,ly final courts cajole furiously final excuse
3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,null,null,for null test
+3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,null,null,for null test2
+3,CANADA,1,eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold,null,null,for null test3
4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,1,AMERICA,hs use ironic, even requests. s
4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,2,ASIA,ges. thinly even pinto beans ca
4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,3,EUROPE,ly final courts cajole furiously final excuse
4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,null,null,for null test
+4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,null,null,for null test2
+4,EGYPT,4,y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d,null,null,for null test3
5,ETHIOPIA,0,ven packages wake quickly. regu,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
5,ETHIOPIA,0,ven packages wake quickly. regu,1,AMERICA,hs use ironic, even requests. s
5,ETHIOPIA,0,ven packages wake quickly. regu,2,ASIA,ges. thinly even pinto beans ca
5,ETHIOPIA,0,ven packages wake quickly. regu,3,EUROPE,ly final courts cajole furiously final excuse
5,ETHIOPIA,0,ven packages wake quickly. regu,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+5,ETHIOPIA,0,ven packages wake quickly. regu,null,null,for null test
+5,ETHIOPIA,0,ven packages wake quickly. regu,null,null,for null test2
+5,ETHIOPIA,0,ven packages wake quickly. regu,null,null,for null test3
6,FRANCE,3,refully final requests. regular, ironi,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
6,FRANCE,3,refully final requests. regular, ironi,1,AMERICA,hs use ironic, even requests. s
6,FRANCE,3,refully final requests. regular, ironi,2,ASIA,ges. thinly even pinto beans ca
6,FRANCE,3,refully final requests. regular, ironi,3,EUROPE,ly final courts cajole furiously final excuse
6,FRANCE,3,refully final requests. regular, ironi,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+6,FRANCE,3,refully final requests. regular, ironi,null,null,for null test
+6,FRANCE,3,refully final requests. regular, ironi,null,null,for null test2
+6,FRANCE,3,refully final requests. regular, ironi,null,null,for null test3
7,GERMANY,3,l platelets. regular accounts x-ray: unusual, regular acco,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
7,GERMANY,3,l platelets. regular accounts x-ray: unusual, regular acco,1,AMERICA,hs use ironic, even requests. s
7,GERMANY,3,l platelets. regular accounts x-ray: unusual, regular acco,2,ASIA,ges. thinly even pinto beans ca
7,GERMANY,3,l platelets. regular accounts x-ray: unusual, regular acco,3,EUROPE,ly final courts cajole furiously final excuse
7,GERMANY,3,l platelets. regular accounts x-ray: unusual, regular acco,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+7,GERMANY,3,l platelets. regular accounts x-ray: unusual, regular acco,null,null,for null test
+7,GERMANY,3,l platelets. regular accounts x-ray: unusual, regular acco,null,null,for null test2
+7,GERMANY,3,l platelets. regular accounts x-ray: unusual, regular acco,null,null,for null test3
8,INDIA,2,ss excuses cajole slyly across the packages. deposits print aroun,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
8,INDIA,2,ss excuses cajole slyly across the packages. deposits print aroun,1,AMERICA,hs use ironic, even requests. s
8,INDIA,2,ss excuses cajole slyly across the packages. deposits print aroun,2,ASIA,ges. thinly even pinto beans ca
8,INDIA,2,ss excuses cajole slyly across the packages. deposits print aroun,3,EUROPE,ly final courts cajole furiously final excuse
8,INDIA,2,ss excuses cajole slyly across the packages. deposits print aroun,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+8,INDIA,2,ss excuses cajole slyly across the packages. deposits print aroun,null,null,for null test
+8,INDIA,2,ss excuses cajole slyly across the packages. deposits print aroun,null,null,for null test2
+8,INDIA,2,ss excuses cajole slyly across the packages. deposits print aroun,null,null,for null test3
9,INDONESIA,2, slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
9,INDONESIA,2, slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull,1,AMERICA,hs use ironic, even requests. s
9,INDONESIA,2, slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull,2,ASIA,ges. thinly even pinto beans ca
9,INDONESIA,2, slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull,3,EUROPE,ly final courts cajole furiously final excuse
9,INDONESIA,2, slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+9,INDONESIA,2, slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull,null,null,for null test
+9,INDONESIA,2, slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull,null,null,for null test2
+9,INDONESIA,2, slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull,null,null,for null test3
10,IRAN,4,efully alongside of the slyly final dependencies. ,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
10,IRAN,4,efully alongside of the slyly final dependencies. ,1,AMERICA,hs use ironic, even requests. s
10,IRAN,4,efully alongside of the slyly final dependencies. ,2,ASIA,ges. thinly even pinto beans ca
10,IRAN,4,efully alongside of the slyly final dependencies. ,3,EUROPE,ly final courts cajole furiously final excuse
10,IRAN,4,efully alongside of the slyly final dependencies. ,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+10,IRAN,4,efully alongside of the slyly final dependencies. ,null,null,for null test
+10,IRAN,4,efully alongside of the slyly final dependencies. ,null,null,for null test2
+10,IRAN,4,efully alongside of the slyly final dependencies. ,null,null,for null test3
11,IRAQ,4,nic deposits boost atop the quickly final requests? quickly regula,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
11,IRAQ,4,nic deposits boost atop the quickly final requests? quickly regula,1,AMERICA,hs use ironic, even requests. s
11,IRAQ,4,nic deposits boost atop the quickly final requests? quickly regula,2,ASIA,ges. thinly even pinto beans ca
11,IRAQ,4,nic deposits boost atop the quickly final requests? quickly regula,3,EUROPE,ly final courts cajole furiously final excuse
11,IRAQ,4,nic deposits boost atop the quickly final requests? quickly regula,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+11,IRAQ,4,nic deposits boost atop the quickly final requests? quickly regula,null,null,for null test
+11,IRAQ,4,nic deposits boost atop the quickly final requests? quickly regula,null,null,for null test2
+11,IRAQ,4,nic deposits boost atop the quickly final requests? quickly regula,null,null,for null test3
12,JAPAN,2,ously. final, express gifts cajole a,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
12,JAPAN,2,ously. final, express gifts cajole a,1,AMERICA,hs use ironic, even requests. s
12,JAPAN,2,ously. final, express gifts cajole a,2,ASIA,ges. thinly even pinto beans ca
12,JAPAN,2,ously. final, express gifts cajole a,3,EUROPE,ly final courts cajole furiously final excuse
12,JAPAN,2,ously. final, express gifts cajole a,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+12,JAPAN,2,ously. final, express gifts cajole a,null,null,for null test
+12,JAPAN,2,ously. final, express gifts cajole a,null,null,for null test2
+12,JAPAN,2,ously. final, express gifts cajole a,null,null,for null test3
13,JORDAN,4,ic deposits are blithely about the carefully regular pa,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
13,JORDAN,4,ic deposits are blithely about the carefully regular pa,1,AMERICA,hs use ironic, even requests. s
13,JORDAN,4,ic deposits are blithely about the carefully regular pa,2,ASIA,ges. thinly even pinto beans ca
13,JORDAN,4,ic deposits are blithely about the carefully regular pa,3,EUROPE,ly final courts cajole furiously final excuse
13,JORDAN,4,ic deposits are blithely about the carefully regular pa,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+13,JORDAN,4,ic deposits are blithely about the carefully regular pa,null,null,for null test
+13,JORDAN,4,ic deposits are blithely about the carefully regular pa,null,null,for null test2
+13,JORDAN,4,ic deposits are blithely about the carefully regular pa,null,null,for null test3
14,KENYA,0, pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
14,KENYA,0, pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t,1,AMERICA,hs use ironic, even requests. s
14,KENYA,0, pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t,2,ASIA,ges. thinly even pinto beans ca
14,KENYA,0, pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t,3,EUROPE,ly final courts cajole furiously final excuse
14,KENYA,0, pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+14,KENYA,0, pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t,null,null,for null test
+14,KENYA,0, pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t,null,null,for null test2
+14,KENYA,0, pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t,null,null,for null test3
15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,1,AMERICA,hs use ironic, even requests. s
15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,2,ASIA,ges. thinly even pinto beans ca
15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,3,EUROPE,ly final courts cajole furiously final excuse
15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,null,null,for null test
+15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,null,null,for null test2
+15,MOROCCO,0,rns. blithely bold courts among the closely regular packages use furiously bold platelets?,null,null,for null test3
16,MOZAMBIQUE,0,s. ironic, unusual asymptotes wake blithely r,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
16,MOZAMBIQUE,0,s. ironic, unusual asymptotes wake blithely r,1,AMERICA,hs use ironic, even requests. s
16,MOZAMBIQUE,0,s. ironic, unusual asymptotes wake blithely r,2,ASIA,ges. thinly even pinto beans ca
16,MOZAMBIQUE,0,s. ironic, unusual asymptotes wake blithely r,3,EUROPE,ly final courts cajole furiously final excuse
16,MOZAMBIQUE,0,s. ironic, unusual asymptotes wake blithely r,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+16,MOZAMBIQUE,0,s. ironic, unusual asymptotes wake blithely r,null,null,for null test
+16,MOZAMBIQUE,0,s. ironic, unusual asymptotes wake blithely r,null,null,for null test2
+16,MOZAMBIQUE,0,s. ironic, unusual asymptotes wake blithely r,null,null,for null test3
17,PERU,1,platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
17,PERU,1,platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun,1,AMERICA,hs use ironic, even requests. s
17,PERU,1,platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun,2,ASIA,ges. thinly even pinto beans ca
17,PERU,1,platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun,3,EUROPE,ly final courts cajole furiously final excuse
17,PERU,1,platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+17,PERU,1,platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun,null,null,for null test
+17,PERU,1,platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun,null,null,for null test2
+17,PERU,1,platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun,null,null,for null test3
18,CHINA,2,c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
18,CHINA,2,c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos,1,AMERICA,hs use ironic, even requests. s
18,CHINA,2,c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos,2,ASIA,ges. thinly even pinto beans ca
18,CHINA,2,c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos,3,EUROPE,ly final courts cajole furiously final excuse
18,CHINA,2,c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+18,CHINA,2,c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos,null,null,for null test
+18,CHINA,2,c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos,null,null,for null test2
+18,CHINA,2,c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos,null,null,for null test3
19,ROMANIA,3,ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
19,ROMANIA,3,ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account,1,AMERICA,hs use ironic, even requests. s
19,ROMANIA,3,ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account,2,ASIA,ges. thinly even pinto beans ca
19,ROMANIA,3,ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account,3,EUROPE,ly final courts cajole furiously final excuse
19,ROMANIA,3,ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+19,ROMANIA,3,ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account,null,null,for null test
+19,ROMANIA,3,ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account,null,null,for null test2
+19,ROMANIA,3,ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account,null,null,for null test3
20,SAUDI ARABIA,4,ts. silent requests haggle. closely express packages sleep across the blithely,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
20,SAUDI ARABIA,4,ts. silent requests haggle. closely express packages sleep across the blithely,1,AMERICA,hs use ironic, even requests. s
20,SAUDI ARABIA,4,ts. silent requests haggle. closely express packages sleep across the blithely,2,ASIA,ges. thinly even pinto beans ca
20,SAUDI ARABIA,4,ts. silent requests haggle. closely express packages sleep across the blithely,3,EUROPE,ly final courts cajole furiously final excuse
20,SAUDI ARABIA,4,ts. silent requests haggle. closely express packages sleep across the blithely,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+20,SAUDI ARABIA,4,ts. silent requests haggle. closely express packages sleep across the blithely,null,null,for null test
+20,SAUDI ARABIA,4,ts. silent requests haggle. closely express packages sleep across the blithely,null,null,for null test2
+20,SAUDI ARABIA,4,ts. silent requests haggle. closely express packages sleep across the blithely,null,null,for null test3
21,VIETNAM,2,hely enticingly express accounts. even, final ,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
21,VIETNAM,2,hely enticingly express accounts. even, final ,1,AMERICA,hs use ironic, even requests. s
21,VIETNAM,2,hely enticingly express accounts. even, final ,2,ASIA,ges. thinly even pinto beans ca
21,VIETNAM,2,hely enticingly express accounts. even, final ,3,EUROPE,ly final courts cajole furiously final excuse
21,VIETNAM,2,hely enticingly express accounts. even, final ,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+21,VIETNAM,2,hely enticingly express accounts. even, final ,null,null,for null test
+21,VIETNAM,2,hely enticingly express accounts. even, final ,null,null,for null test2
+21,VIETNAM,2,hely enticingly express accounts. even, final ,null,null,for null test3
22,RUSSIA,3, requests against the platelets use never according to the quickly regular pint,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
22,RUSSIA,3, requests against the platelets use never according to the quickly regular pint,1,AMERICA,hs use ironic, even requests. s
22,RUSSIA,3, requests against the platelets use never according to the quickly regular pint,2,ASIA,ges. thinly even pinto beans ca
22,RUSSIA,3, requests against the platelets use never according to the quickly regular pint,3,EUROPE,ly final courts cajole furiously final excuse
22,RUSSIA,3, requests against the platelets use never according to the quickly regular pint,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+22,RUSSIA,3, requests against the platelets use never according to the quickly regular pint,null,null,for null test
+22,RUSSIA,3, requests against the platelets use never according to the quickly regular pint,null,null,for null test2
+22,RUSSIA,3, requests against the platelets use never according to the quickly regular pint,null,null,for null test3
23,UNITED KINGDOM,3,eans boost carefully special requests. accounts are. carefull,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
23,UNITED KINGDOM,3,eans boost carefully special requests. accounts are. carefull,1,AMERICA,hs use ironic, even requests. s
23,UNITED KINGDOM,3,eans boost carefully special requests. accounts are. carefull,2,ASIA,ges. thinly even pinto beans ca
23,UNITED KINGDOM,3,eans boost carefully special requests. accounts are. carefull,3,EUROPE,ly final courts cajole furiously final excuse
23,UNITED KINGDOM,3,eans boost carefully special requests. accounts are. carefull,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+23,UNITED KINGDOM,3,eans boost carefully special requests. accounts are. carefull,null,null,for null test
+23,UNITED KINGDOM,3,eans boost carefully special requests. accounts are. carefull,null,null,for null test2
+23,UNITED KINGDOM,3,eans boost carefully special requests. accounts are. carefull,null,null,for null test3
24,UNITED STATES,1,y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be,0,AFRICA,lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to
24,UNITED STATES,1,y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be,1,AMERICA,hs use ironic, even requests. s
24,UNITED STATES,1,y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be,2,ASIA,ges. thinly even pinto beans ca
24,UNITED STATES,1,y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be,3,EUROPE,ly final courts cajole furiously final excuse
24,UNITED STATES,1,y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be,4,MIDDLE EAST,uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl
+24,UNITED STATES,1,y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be,null,null,for null test
+24,UNITED STATES,1,y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be,null,null,for null test2
+24,UNITED STATES,1,y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be,null,null,for null test3
+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,for null test,1,AMERICA,hs use ironic, even requests. s
+null,null,null,for null test,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,for null test,3,EUROPE,ly final courts cajole furiously final excuse
+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,for null test,null,null,for null test
+null,null,null,for null test,null,null,for null test2
+null,null,null,for null test,null,null,for null test3
+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,for null test2,1,AMERICA,hs use ironic, even requests. s
+null,null,null,for null test2,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,for null test2,3,EUROPE,ly final courts cajole furiously final excuse
+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,for null test2,null,null,for null test
+null,null,null,for null test2,null,null,for null test2
+null,null,null,for null test2,null,null,for null test3
+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,for null test3,1,AMERICA,hs use ironic, even requests. s
+null,null,null,for null test3,2,ASIA,ges. thinly even pinto beans ca
+null,null,null,for null test3,3,EUROPE,ly final courts cajole furiously final excuse
+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,for null test3,null,null,for null test
+null,null,null,for null test3,null,null,for null test2
+null,null,null,for null test3,null,null,for null test3