You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by cw...@apache.org on 2012/01/27 02:41:37 UTC
svn commit: r1236489 [3/7] - in /hive/trunk/ql/src/test:
queries/clientpositive/ results/clientpositive/
Modified: hive/trunk/ql/src/test/results/clientpositive/join_1to1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_1to1.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_1to1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_1to1.q.out Fri Jan 27 01:41:35 2012
@@ -20,12 +20,12 @@ PREHOOK: Output: default@join_1to1_2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in6.txt' INTO TABLE join_1to1_2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@join_1to1_2
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
@@ -39,15 +39,15 @@ POSTHOOK: Input: default@join_1to1_2
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -60,22 +60,22 @@ POSTHOOK: Input: default@join_1to1_2
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
@@ -85,15 +85,15 @@ NULL NULL NULL 10 10010 66
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -106,25 +106,27 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL 10050 66 NULL NULL NULL
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 25 10025 66
+NULL NULL NULL 80 10040 66
+NULL NULL NULL 80 10040 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
-NULL NULL NULL 25 10025 66
30 10030 66 NULL NULL NULL
40 10040 66 40 10040 66
50 10050 66 50 10050 66
@@ -135,24 +137,22 @@ NULL NULL NULL 25 10025 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
70 10040 66 NULL NULL NULL
-NULL NULL NULL 80 10040 66
-NULL NULL NULL 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
@@ -162,15 +162,15 @@ NULL NULL NULL 10 10010 66
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -183,25 +183,27 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 25 10025 66
+NULL NULL NULL 80 10040 66
+NULL NULL NULL 80 10040 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
-NULL NULL NULL 25 10025 66
30 10030 66 NULL NULL NULL
40 10040 66 40 10040 66
50 10050 66 50 10050 66
@@ -212,14 +214,12 @@ NULL NULL NULL 25 10025 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
70 10040 66 NULL NULL NULL
-NULL NULL NULL 80 10040 66
-NULL NULL NULL 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
@@ -233,15 +233,15 @@ POSTHOOK: Input: default@join_1to1_2
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -254,22 +254,22 @@ POSTHOOK: Input: default@join_1to1_2
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
@@ -279,15 +279,15 @@ NULL NULL NULL 10 10010 66
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -300,25 +300,27 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL 10050 66 NULL NULL NULL
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 25 10025 66
+NULL NULL NULL 80 10040 66
+NULL NULL NULL 80 10040 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
-NULL NULL NULL 25 10025 66
30 10030 66 NULL NULL NULL
40 10040 66 40 10040 66
50 10050 66 50 10050 66
@@ -329,24 +331,22 @@ NULL NULL NULL 25 10025 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
70 10040 66 NULL NULL NULL
-NULL NULL NULL 80 10040 66
-NULL NULL NULL 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
@@ -356,15 +356,15 @@ NULL NULL NULL 10 10010 66
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -377,25 +377,27 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 25 10025 66
+NULL NULL NULL 80 10040 66
+NULL NULL NULL 80 10040 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
-NULL NULL NULL 25 10025 66
30 10030 66 NULL NULL NULL
40 10040 66 40 10040 66
50 10050 66 50 10050 66
@@ -406,14 +408,12 @@ NULL NULL NULL 25 10025 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
70 10040 66 NULL NULL NULL
-NULL NULL NULL 80 10040 66
-NULL NULL NULL 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
@@ -424,18 +424,18 @@ POSTHOOK: Input: default@join_1to1_2
30 10030 66 30 10030 88
35 10035 88 35 10035 88
40 10040 66 40 10040 66
-40 10040 88 40 10040 66
40 10040 66 40 10040 88
+40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
-50 10050 88 50 10050 88
-50 10050 88 50 10050 88
50 10050 66 50 10050 66
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -448,40 +448,40 @@ POSTHOOK: Input: default@join_1to1_2
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
30 10030 66 30 10030 88
35 10035 88 35 10035 88
40 10040 66 40 10040 66
-40 10040 88 40 10040 66
40 10040 66 40 10040 88
+40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
-50 10050 88 50 10050 88
-50 10050 88 50 10050 88
50 10050 66 50 10050 66
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -494,25 +494,27 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL 10050 66 NULL NULL NULL
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 25 10025 66
+NULL NULL NULL 80 10040 66
+NULL NULL NULL 80 10040 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
-NULL NULL NULL 25 10025 66
30 10030 66 NULL NULL NULL
40 10040 66 40 10040 66
50 10050 66 50 10050 66
@@ -523,42 +525,40 @@ NULL NULL NULL 25 10025 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
70 10040 66 NULL NULL NULL
-NULL NULL NULL 80 10040 66
-NULL NULL NULL 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
30 10030 66 30 10030 88
35 10035 88 35 10035 88
40 10040 66 40 10040 66
-40 10040 88 40 10040 66
40 10040 66 40 10040 88
+40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
-50 10050 88 50 10050 88
-50 10050 88 50 10050 88
50 10050 66 50 10050 66
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -571,25 +571,27 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 25 10025 66
+NULL NULL NULL 80 10040 66
+NULL NULL NULL 80 10040 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
-NULL NULL NULL 25 10025 66
30 10030 66 NULL NULL NULL
40 10040 66 40 10040 66
50 10050 66 50 10050 66
@@ -600,14 +602,12 @@ NULL NULL NULL 25 10025 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
70 10040 66 NULL NULL NULL
-NULL NULL NULL 80 10040 66
-NULL NULL NULL 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
@@ -621,15 +621,15 @@ POSTHOOK: Input: default@join_1to1_2
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -642,22 +642,22 @@ POSTHOOK: Input: default@join_1to1_2
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
@@ -667,15 +667,15 @@ NULL NULL NULL 10 10010 66
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -688,45 +688,49 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 30 10030 88
+NULL NULL NULL 35 10035 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 NULL NULL NULL
30 10030 66 NULL NULL NULL
-NULL NULL NULL 30 10030 88
35 10035 88 NULL NULL NULL
-NULL NULL NULL 35 10035 88
-40 10040 66 40 10040 66
40 10040 66 NULL NULL NULL
-NULL NULL NULL 40 10040 88
+40 10040 66 40 10040 66
40 10040 88 NULL NULL NULL
40 10040 88 NULL NULL NULL
-NULL NULL NULL 40 10040 88
50 10050 66 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 66 50 10050 66
50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
60 10040 66 60 10040 66
@@ -734,33 +738,29 @@ NULL NULL NULL 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
@@ -770,15 +770,15 @@ NULL NULL NULL 10 10010 66
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -791,45 +791,49 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 30 10030 88
+NULL NULL NULL 35 10035 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 NULL NULL NULL
30 10030 66 NULL NULL NULL
-NULL NULL NULL 30 10030 88
35 10035 88 NULL NULL NULL
-NULL NULL NULL 35 10035 88
-40 10040 66 40 10040 66
40 10040 66 NULL NULL NULL
-NULL NULL NULL 40 10040 88
+40 10040 66 40 10040 66
40 10040 88 NULL NULL NULL
40 10040 88 NULL NULL NULL
-NULL NULL NULL 40 10040 88
50 10050 66 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 66 50 10050 66
50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
60 10040 66 60 10040 66
@@ -837,23 +841,19 @@ NULL NULL NULL 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
@@ -867,15 +867,15 @@ POSTHOOK: Input: default@join_1to1_2
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -888,22 +888,22 @@ POSTHOOK: Input: default@join_1to1_2
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
@@ -913,15 +913,15 @@ NULL NULL NULL 10 10010 66
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -934,45 +934,49 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 30 10030 88
+NULL NULL NULL 35 10035 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 NULL NULL NULL
30 10030 66 NULL NULL NULL
-NULL NULL NULL 30 10030 88
35 10035 88 NULL NULL NULL
-NULL NULL NULL 35 10035 88
-40 10040 66 40 10040 66
40 10040 66 NULL NULL NULL
-NULL NULL NULL 40 10040 88
+40 10040 66 40 10040 66
40 10040 88 NULL NULL NULL
40 10040 88 NULL NULL NULL
-NULL NULL NULL 40 10040 88
50 10050 66 NULL NULL NULL
-NULL NULL NULL 50 10050 88
+50 10050 66 50 10050 66
50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
-50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
60 10040 66 60 10040 66
@@ -980,33 +984,29 @@ NULL NULL NULL 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
@@ -1016,15 +1016,15 @@ NULL NULL NULL 10 10010 66
40 10040 66 40 10040 88
40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
50 10050 66 50 10050 66
-50 10050 88 50 10050 88
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
-50 10050 88 50 10050 88
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -1037,45 +1037,49 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 30 10030 88
+NULL NULL NULL 35 10035 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 NULL NULL NULL
30 10030 66 NULL NULL NULL
-NULL NULL NULL 30 10030 88
35 10035 88 NULL NULL NULL
-NULL NULL NULL 35 10035 88
-40 10040 66 40 10040 66
40 10040 66 NULL NULL NULL
-NULL NULL NULL 40 10040 88
+40 10040 66 40 10040 66
40 10040 88 NULL NULL NULL
40 10040 88 NULL NULL NULL
-NULL NULL NULL 40 10040 88
50 10050 66 NULL NULL NULL
-NULL NULL NULL 50 10050 88
+50 10050 66 50 10050 66
50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
-50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
60 10040 66 60 10040 66
@@ -1083,23 +1087,19 @@ NULL NULL NULL 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
@@ -1110,18 +1110,18 @@ POSTHOOK: Input: default@join_1to1_2
30 10030 66 30 10030 88
35 10035 88 35 10035 88
40 10040 66 40 10040 66
-40 10040 88 40 10040 66
40 10040 66 40 10040 88
+40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
-50 10050 88 50 10050 88
-50 10050 88 50 10050 88
50 10050 66 50 10050 66
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -1134,40 +1134,40 @@ POSTHOOK: Input: default@join_1to1_2
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
30 10030 66 30 10030 88
35 10035 88 35 10035 88
40 10040 66 40 10040 66
-40 10040 88 40 10040 66
40 10040 66 40 10040 88
+40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
-50 10050 88 50 10050 88
-50 10050 88 50 10050 88
50 10050 66 50 10050 66
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -1180,45 +1180,49 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 30 10030 88
+NULL NULL NULL 35 10035 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 NULL NULL NULL
30 10030 66 NULL NULL NULL
-NULL NULL NULL 30 10030 88
35 10035 88 NULL NULL NULL
-NULL NULL NULL 35 10035 88
+40 10040 66 NULL NULL NULL
40 10040 66 40 10040 66
40 10040 88 NULL NULL NULL
-40 10040 66 NULL NULL NULL
-NULL NULL NULL 40 10040 88
40 10040 88 NULL NULL NULL
-NULL NULL NULL 40 10040 88
50 10050 66 NULL NULL NULL
-NULL NULL NULL 50 10050 88
+50 10050 66 50 10050 66
+50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
-50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
-50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
60 10040 66 60 10040 66
@@ -1226,51 +1230,47 @@ NULL NULL NULL 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 25 10025 66
30 10030 66 30 10030 88
35 10035 88 35 10035 88
40 10040 66 40 10040 66
-40 10040 88 40 10040 66
40 10040 66 40 10040 88
+40 10040 88 40 10040 66
40 10040 88 40 10040 88
-50 10050 66 50 10050 88
-50 10050 88 50 10050 88
-50 10050 88 50 10050 88
50 10050 66 50 10050 66
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
50 10050 88 50 10050 66
50 10050 88 50 10050 66
-50 10050 66 50 10050 66
50 10050 88 50 10050 66
50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 60 10040 66
@@ -1283,45 +1283,49 @@ NULL NULL NULL 10 10010 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
80 10040 88 80 10040 66
-PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+PREHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@join_1to1_1
PREHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66
+POSTHOOK: query: SELECT * FROM join_1to1_1 a full outer join join_1to1_2 b on a.key1 = b.key1 and a.key2 = b.key2 and a.value = 66 and b.value = 66 ORDER BY a.key1 ASC, a.key2 ASC, a.value ASC, b.key1 ASC, b.key2 ASC, b.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@join_1to1_1
POSTHOOK: Input: default@join_1to1_2
#### A masked pattern was here ####
-NULL NULL 66 NULL NULL NULL
NULL NULL NULL NULL NULL 66
-NULL 10050 66 NULL NULL NULL
NULL NULL NULL NULL 10050 66
-5 10005 66 5 10005 66
NULL NULL NULL 10 10010 66
+NULL NULL NULL 30 10030 88
+NULL NULL NULL 35 10035 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 40 10040 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 50 10050 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL NULL 70 10040 88
+NULL NULL 66 NULL NULL NULL
+NULL 10050 66 NULL NULL NULL
+5 10005 66 5 10005 66
15 10015 66 NULL NULL NULL
20 10020 66 20 10020 66
25 10025 88 NULL NULL NULL
30 10030 66 NULL NULL NULL
-NULL NULL NULL 30 10030 88
35 10035 88 NULL NULL NULL
-NULL NULL NULL 35 10035 88
+40 10040 66 NULL NULL NULL
40 10040 66 40 10040 66
40 10040 88 NULL NULL NULL
-40 10040 66 NULL NULL NULL
-NULL NULL NULL 40 10040 88
40 10040 88 NULL NULL NULL
-NULL NULL NULL 40 10040 88
50 10050 66 NULL NULL NULL
-NULL NULL NULL 50 10050 88
+50 10050 66 50 10050 66
+50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
50 10050 88 NULL NULL NULL
-NULL NULL NULL 50 10050 88
-50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
-50 10050 66 50 10050 66
50 10050 88 NULL NULL NULL
50 10050 88 NULL NULL NULL
60 10040 66 60 10040 66
@@ -1329,13 +1333,9 @@ NULL NULL NULL 50 10050 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
70 10040 66 NULL NULL NULL
-NULL NULL NULL 70 10040 88
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
80 10040 88 NULL NULL NULL
Modified: hive/trunk/ql/src/test/results/clientpositive/join_casesensitive.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_casesensitive.q.out?rev=1236489&r1=1236488&r2=1236489&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_casesensitive.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_casesensitive.q.out Fri Jan 27 01:41:35 2012
@@ -20,98 +20,98 @@ PREHOOK: Output: default@jointwo
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/in6.txt' INTO TABLE joinTwo
POSTHOOK: type: LOAD
POSTHOOK: Output: default@jointwo
-PREHOOK: query: SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2)
+PREHOOK: query: SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2) ORDER BY joinone.key1 ASC, joinone.key2 ASC, joinone.value ASC, joinTwo.key1 ASC, joinTwo.key2 ASC, joinTwo.value ASC
PREHOOK: type: QUERY
PREHOOK: Input: default@joinone
PREHOOK: Input: default@jointwo
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2)
+POSTHOOK: query: SELECT * FROM joinone JOIN joinTwo ON(joinone.key2=joinTwo.key2) ORDER BY joinone.key1 ASC, joinone.key2 ASC, joinone.value ASC, joinTwo.key1 ASC, joinTwo.key2 ASC, joinTwo.value ASC
POSTHOOK: type: QUERY
POSTHOOK: Input: default@joinone
POSTHOOK: Input: default@jointwo
#### A masked pattern was here ####
+NULL 10050 66 NULL 10050 66
+NULL 10050 66 50 10050 66
+NULL 10050 66 50 10050 66
+NULL 10050 66 50 10050 88
5 10005 66 5 10005 66
20 10020 66 20 10020 66
25 10025 88 25 10025 66
30 10030 66 30 10030 88
35 10035 88 35 10035 88
-80 10040 88 80 10040 66
-80 10040 88 80 10040 66
-80 10040 88 40 10040 66
-80 10040 88 40 10040 88
-80 10040 88 60 10040 66
-80 10040 88 60 10040 66
-80 10040 88 70 10040 88
-80 10040 88 70 10040 88
-80 10040 88 80 10040 66
-80 10040 88 80 10040 66
-80 10040 88 40 10040 66
-80 10040 88 40 10040 88
-80 10040 88 60 10040 66
-80 10040 88 60 10040 66
-80 10040 88 70 10040 88
-80 10040 88 70 10040 88
-40 10040 66 80 10040 66
-40 10040 66 80 10040 66
40 10040 66 40 10040 66
40 10040 66 40 10040 88
40 10040 66 60 10040 66
40 10040 66 60 10040 66
40 10040 66 70 10040 88
40 10040 66 70 10040 88
-40 10040 88 80 10040 66
-40 10040 88 80 10040 66
+40 10040 66 80 10040 66
+40 10040 66 80 10040 66
40 10040 88 40 10040 66
40 10040 88 40 10040 88
40 10040 88 60 10040 66
40 10040 88 60 10040 66
40 10040 88 70 10040 88
40 10040 88 70 10040 88
-60 10040 66 80 10040 66
-60 10040 66 80 10040 66
+40 10040 88 80 10040 66
+40 10040 88 80 10040 66
+50 10050 66 NULL 10050 66
+50 10050 66 50 10050 66
+50 10050 66 50 10050 66
+50 10050 66 50 10050 88
+50 10050 88 NULL 10050 66
+50 10050 88 NULL 10050 66
+50 10050 88 50 10050 66
+50 10050 88 50 10050 66
+50 10050 88 50 10050 66
+50 10050 88 50 10050 66
+50 10050 88 50 10050 88
+50 10050 88 50 10050 88
+60 10040 66 40 10040 66
60 10040 66 40 10040 66
60 10040 66 40 10040 88
+60 10040 66 40 10040 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
-60 10040 66 70 10040 88
-60 10040 66 70 10040 88
-60 10040 66 80 10040 66
-60 10040 66 80 10040 66
-60 10040 66 40 10040 66
-60 10040 66 40 10040 88
60 10040 66 60 10040 66
60 10040 66 60 10040 66
60 10040 66 70 10040 88
60 10040 66 70 10040 88
-70 10040 66 80 10040 66
-70 10040 66 80 10040 66
+60 10040 66 70 10040 88
+60 10040 66 70 10040 88
+60 10040 66 80 10040 66
+60 10040 66 80 10040 66
+60 10040 66 80 10040 66
+60 10040 66 80 10040 66
+70 10040 66 40 10040 66
70 10040 66 40 10040 66
70 10040 66 40 10040 88
+70 10040 66 40 10040 88
70 10040 66 60 10040 66
70 10040 66 60 10040 66
-70 10040 66 70 10040 88
-70 10040 66 70 10040 88
-70 10040 66 80 10040 66
-70 10040 66 80 10040 66
-70 10040 66 40 10040 66
-70 10040 66 40 10040 88
70 10040 66 60 10040 66
70 10040 66 60 10040 66
70 10040 66 70 10040 88
70 10040 66 70 10040 88
-50 10050 88 50 10050 66
-50 10050 88 50 10050 66
-50 10050 88 NULL 10050 66
-50 10050 88 50 10050 88
-50 10050 88 50 10050 66
-50 10050 88 50 10050 66
-50 10050 88 NULL 10050 66
-50 10050 88 50 10050 88
-NULL 10050 66 50 10050 66
-NULL 10050 66 50 10050 66
-NULL 10050 66 NULL 10050 66
-NULL 10050 66 50 10050 88
-50 10050 66 50 10050 66
-50 10050 66 50 10050 66
-50 10050 66 NULL 10050 66
-50 10050 66 50 10050 88
+70 10040 66 70 10040 88
+70 10040 66 70 10040 88
+70 10040 66 80 10040 66
+70 10040 66 80 10040 66
+70 10040 66 80 10040 66
+70 10040 66 80 10040 66
+80 10040 88 40 10040 66
+80 10040 88 40 10040 66
+80 10040 88 40 10040 88
+80 10040 88 40 10040 88
+80 10040 88 60 10040 66
+80 10040 88 60 10040 66
+80 10040 88 60 10040 66
+80 10040 88 60 10040 66
+80 10040 88 70 10040 88
+80 10040 88 70 10040 88
+80 10040 88 70 10040 88
+80 10040 88 70 10040 88
+80 10040 88 80 10040 66
+80 10040 88 80 10040 66
+80 10040 88 80 10040 66
+80 10040 88 80 10040 66