[31/54] [partial] hive git commit: HIVE-17550: Remove unreferenced q.out-s (Zoltan Haindrich, reviewed by Ashutosh Chauhan)

[kgyrtkirk]

http://git-wip-us.apache.org/repos/asf/hive/blob/6f5c1135/ql/src/test/results/clientpositive/cbo_join.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/cbo_join.q.out 
b/ql/src/test/results/clientpositive/cbo_join.q.out
deleted file mode 100644
index c5e9858..0000000
--- a/ql/src/test/results/clientpositive/cbo_join.q.out
+++ /dev/null
@@ -1,15028 +0,0 @@
-PREHOOK: query: -- SORT_QUERY_RESULTS
--- 4. Test Select + Join + TS
-select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 join             cbo_t2 on 
cbo_t1.key=cbo_t2.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: -- SORT_QUERY_RESULTS
--- 4. Test Select + Join + TS
-select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 join             cbo_t2 on 
cbo_t1.key=cbo_t2.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-PREHOOK: query: select cbo_t1.key from cbo_t1 join cbo_t3
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t1.key from cbo_t1 join cbo_t3
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
- 1 
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-1 
-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
-NULL
-NULL
-NULL
-NULL
-PREHOOK: query: select cbo_t1.key from cbo_t1 join cbo_t3 where 
cbo_t1.key=cbo_t3.key and cbo_t1.key >= 1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t1.key from cbo_t1 join cbo_t3 where 
cbo_t1.key=cbo_t3.key and cbo_t1.key >= 1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
- 1
- 1
- 1
- 1
- 1 
- 1 
- 1 
- 1 
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1 
-1 
-1 
-1 
-PREHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 left outer join  
cbo_t2 on cbo_t1.key=cbo_t2.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 left outer join 
 cbo_t2 on cbo_t1.key=cbo_t2.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-NULL   NULL
-NULL   NULL
-PREHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 right outer join 
cbo_t2 on cbo_t1.key=cbo_t2.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 right outer 
join cbo_t2 on cbo_t1.key=cbo_t2.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-NULL   2
-NULL   2
-NULL   2
-NULL   2
-NULL   2
-NULL   NULL
-NULL   NULL
-PREHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full outer join  
cbo_t2 on cbo_t1.key=cbo_t2.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full outer join 
 cbo_t2 on cbo_t1.key=cbo_t2.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-NULL   2
-NULL   2
-NULL   2
-NULL   2
-NULL   2
-NULL   NULL
-NULL   NULL
-NULL   NULL
-NULL   NULL
-PREHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select key 
as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join (select 
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join (select 
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-PREHOOK: query: select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join (select 
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.key=p join (select key as a, c_int as b, cbo_t3.c_float as c from 
cbo_t3)cbo_t3 on cbo_t1.key=a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.key=p join (select key as a, c_int as b, cbo_t3.c_float as c from 
cbo_t3)cbo_t3 on cbo_t1.key=a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-PREHOOK: query: select a, cbo_t1.b, key, cbo_t2.c_int, cbo_t3.p from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join cbo_t2  on 
cbo_t1.a=key join (select key as p, c_int as q, cbo_t3.c_float as r from 
cbo_t3)cbo_t3 on cbo_t1.a=cbo_t3.p
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select a, cbo_t1.b, key, cbo_t2.c_int, cbo_t3.p from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join cbo_t2  on 
cbo_t1.a=key join (select key as p, c_int as q, cbo_t3.c_float as r from 
cbo_t3)cbo_t3 on cbo_t1.a=cbo_t3.p
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
- 1     1        1      1        1
- 1     1        1      1        1
- 1     1        1      1        1
- 1     1        1      1        1
- 1     1        1      1        1
- 1     1        1      1        1
- 1     1        1      1        1
- 1     1        1      1        1
- 1     1        1      1        1 
- 1     1        1      1        1 
- 1     1        1      1        1 
- 1     1        1      1        1 
- 1     1        1      1        1 
- 1     1        1      1        1 
- 1     1        1      1        1 
- 1     1        1      1        1 
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1
-1      1       1       1       1 
-1      1       1       1       1 
-1      1       1       1       1 
-1      1       1       1       1 
-1      1       1       1       1 
-1      1       1       1       1 
-1      1       1       1       1 
-1      1       1       1       1 
-PREHOOK: query: select b, cbo_t1.c, cbo_t2.c_int, cbo_t3.c_int from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join cbo_t2 on 
cbo_t1.a=cbo_t2.key join cbo_t3 on cbo_t1.a=cbo_t3.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select b, cbo_t1.c, cbo_t2.c_int, cbo_t3.c_int from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join cbo_t2 on 
cbo_t1.a=cbo_t2.key join cbo_t3 on cbo_t1.a=cbo_t3.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-1      1.0     1       1
-PREHOOK: query: select cbo_t3.c_int, b, cbo_t2.c_int, cbo_t1.c from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join cbo_t2 on 
cbo_t1.a=cbo_t2.key join cbo_t3 on cbo_t1.a=cbo_t3.key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t3.c_int, b, cbo_t2.c_int, cbo_t1.c from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 join cbo_t2 on 
cbo_t1.a=cbo_t2.key join cbo_t3 on cbo_t1.a=cbo_t3.key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-1      1       1       1.0
-PREHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select key 
as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 left outer join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 left outer join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-PREHOOK: query: select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join (select 
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.key=p left outer join (select key as a, c_int as b, cbo_t3.c_float as c 
from cbo_t3)cbo_t3 on cbo_t1.key=a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.key=p left outer join (select key as a, c_int as b, cbo_t3.c_float as c 
from cbo_t3)cbo_t3 on cbo_t1.key=a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-PREHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select key 
as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 right outer join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 right outer join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-PREHOOK: query: select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join (select 
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.key=p right outer join (select key as a, c_int as b, cbo_t3.c_float as c 
from cbo_t3)cbo_t3 on cbo_t1.key=a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.key=p right outer join (select key as a, c_int as b, cbo_t3.c_float as c 
from cbo_t3)cbo_t3 on cbo_t1.key=a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-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
-PREHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select key 
as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 full outer join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select 
key as a, c_int as b, cbo_t1.c_float as c from cbo_t1) cbo_t1 full outer join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.a=p join cbo_t3 on cbo_t1.a=key
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0      1      1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-1      1.0     1       1       1
-PREHOOK: query: select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join (select 
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.key=p full outer join (select key as a, c_int as b, cbo_t3.c_float as c 
from cbo_t3)cbo_t3 on cbo_t1.key=a
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select key, cbo_t1.c_int, cbo_t2.p, q from cbo_t1 join 
(select cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2) cbo_t2 on 
cbo_t1.key=p full outer join (select key as a, c_int as b, cbo_t3.c_float as c 
from cbo_t3)cbo_t3 on cbo_t1.key=a
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-POSTHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
- 1     1        1      1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-1      1       1       1
-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
-PREHOOK: query: -- 5. Test Select + Join + FIL + TS
-select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 join cbo_t2 on 
cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + cbo_t2.c_int == 2) and 
(cbo_t1.c_int > 0 or cbo_t2.c_float >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: -- 5. Test Select + Join + FIL + TS
-select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 join cbo_t2 on 
cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + cbo_t2.c_int == 2) and 
(cbo_t1.c_int > 0 or cbo_t2.c_float >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-PREHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 left outer join  
cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + cbo_t2.c_int == 2) and 
(cbo_t1.c_int > 0 or cbo_t2.c_float >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 left outer join 
 cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + cbo_t2.c_int == 2) and 
(cbo_t1.c_int > 0 or cbo_t2.c_float >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-PREHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 right outer join 
cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + cbo_t2.c_int == 2) and 
(cbo_t1.c_int > 0 or cbo_t2.c_float >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 right outer 
join cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + cbo_t2.c_int == 2) 
and (cbo_t1.c_int > 0 or cbo_t2.c_float >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-PREHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full outer join  
cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + cbo_t2.c_int == 2) and 
(cbo_t1.c_int > 0 or cbo_t2.c_float >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-POSTHOOK: query: select cbo_t1.c_int, cbo_t2.c_int from cbo_t1 full outer join 
 cbo_t2 on cbo_t1.key=cbo_t2.key where (cbo_t1.c_int + cbo_t2.c_int == 2) and 
(cbo_t1.c_int > 0 or cbo_t2.c_float >= 0)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@cbo_t1
-POSTHOOK: Input: default@cbo_t1@dt=2014
-POSTHOOK: Input: default@cbo_t2
-POSTHOOK: Input: default@cbo_t2@dt=2014
-#### A masked pattern was here ####
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-1      1
-PREHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (select key 
as a, c_int as b, cbo_t1.c_float as c from cbo_t1  where (cbo_t1.c_int + 1 == 
2) and (cbo_t1.c_int > 0 or cbo_t1.c_float >= 0)) cbo_t1 join (select 
cbo_t2.key as p, cbo_t2.c_int as q, c_float as r from cbo_t2  where 
(cbo_t2.c_int + 1 == 2) and (cbo_t2.c_int > 0 or cbo_t2.c_float >= 0)) cbo_t2 
on cbo_t1.a=p join cbo_t3 on cbo_t1.a=key where (b + cbo_t2.q == 2) and (b > 0 
or cbo_t2.q >= 0)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@cbo_t1
-PREHOOK: Input: default@cbo_t1@dt=2014
-PREHOOK: Input: default@cbo_t2
-PREHOOK: Input: default@cbo_t2@dt=2014
-PREHOOK: Input: default@cbo_t3
-#### A masked pattern was here ####
-POSTHOOK: query: select b, cbo_t1.c, cbo_t2.p, q, cbo_t3.c_int from (s

<TRUNCATED>