hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject svn commit: r1606278 [2/2] - in /hive/branches/cbo: itests/qtest/testconfiguration.properties ql/src/test/queries/clientpositive/cbo_correctness.q ql/src/test/results/clientpositive/tez/cbo_correctness.q.out
Date Sat, 28 Jun 2014 01:11:08 GMT
Added: hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out?rev=1606278&view=auto
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out (added)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/cbo_correctness.q.out Sat Jun 28 01:11:07 2014
@@ -0,0 +1,15697 @@
+PREHOOK: query: drop table if exists t1
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists t1
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table if exists t2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists t2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table if exists t3
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists t3
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table if exists t4
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists t4
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table t1(key string, value string, c_int int, c_float float, c_boolean boolean)  row format delimited fields terminated by ',' STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+POSTHOOK: query: create table t1(key string, value string, c_int int, c_float float, c_boolean boolean)  row format delimited fields terminated by ',' STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t1
+PREHOOK: query: create table t2(key string, value string, c_int int, c_float float, c_boolean boolean)  row format delimited fields terminated by ',' STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+POSTHOOK: query: create table t2(key string, value string, c_int int, c_float float, c_boolean boolean)  row format delimited fields terminated by ',' STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t2
+PREHOOK: query: create table t3(key string, value string, c_int int, c_float float, c_boolean boolean)  row format delimited fields terminated by ',' STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+POSTHOOK: query: create table t3(key string, value string, c_int int, c_float float, c_boolean boolean)  row format delimited fields terminated by ',' STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t3
+PREHOOK: query: create table t4(key string, value string, c_int int, c_float float, c_boolean boolean)  row format delimited fields terminated by ',' STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+POSTHOOK: query: create table t4(key string, value string, c_int int, c_float float, c_boolean boolean)  row format delimited fields terminated by ',' STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@t4
+PREHOOK: query: load data local inpath '../../data/files/cbo_t1.txt' into table t1
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@t1
+POSTHOOK: query: load data local inpath '../../data/files/cbo_t1.txt' into table t1
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@t1
+PREHOOK: query: load data local inpath '../../data/files/cbo_t2.txt' into table t2
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@t2
+POSTHOOK: query: load data local inpath '../../data/files/cbo_t2.txt' into table t2
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@t2
+PREHOOK: query: load data local inpath '../../data/files/cbo_t3.txt' into table t3
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@t3
+POSTHOOK: query: load data local inpath '../../data/files/cbo_t3.txt' into table t3
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@t3
+PREHOOK: query: load data local inpath '../../data/files/cbo_t4.txt' into table t4
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@t4
+POSTHOOK: query: load data local inpath '../../data/files/cbo_t4.txt' into table t4
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@t4
+PREHOOK: query: analyze table t1 compute statistics
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Output: default@t1
+POSTHOOK: query: analyze table t1 compute statistics
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Output: default@t1
+PREHOOK: query: analyze table t1 compute statistics for columns key, value, c_int, c_float, c_boolean
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: analyze table t1 compute statistics for columns key, value, c_int, c_float, c_boolean
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+PREHOOK: query: analyze table t2 compute statistics
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t2
+PREHOOK: Output: default@t2
+POSTHOOK: query: analyze table t2 compute statistics
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t2
+POSTHOOK: Output: default@t2
+PREHOOK: query: analyze table t2 compute statistics for columns key, value, c_int, c_float, c_boolean
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: analyze table t2 compute statistics for columns key, value, c_int, c_float, c_boolean
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
+PREHOOK: query: analyze table t3 compute statistics
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t3
+PREHOOK: Output: default@t3
+POSTHOOK: query: analyze table t3 compute statistics
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t3
+POSTHOOK: Output: default@t3
+PREHOOK: query: analyze table t3 compute statistics for columns key, value, c_int, c_float, c_boolean
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: analyze table t3 compute statistics for columns key, value, c_int, c_float, c_boolean
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t3
+#### A masked pattern was here ####
+PREHOOK: query: analyze table t4 compute statistics
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t4
+PREHOOK: Output: default@t4
+POSTHOOK: query: analyze table t4 compute statistics
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t4
+POSTHOOK: Output: default@t4
+PREHOOK: query: analyze table t4 compute statistics for columns key, value, c_int, c_float, c_boolean
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t4
+#### A masked pattern was here ####
+POSTHOOK: query: analyze table t4 compute statistics for columns key, value, c_int, c_float, c_boolean
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t4
+#### A masked pattern was here ####
+PREHOOK: query: -- 1. Test Select + TS
+select * from t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 1. Test Select + TS
+select * from t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+null	null	NULL	NULL	NULL
+null	null	NULL	NULL	NULL
+PREHOOK: query: select * from t1 as t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from t1 as t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+null	null	NULL	NULL	NULL
+null	null	NULL	NULL	NULL
+PREHOOK: query: select * from t1 as t2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from t1 as t2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+null	null	NULL	NULL	NULL
+null	null	NULL	NULL	NULL
+PREHOOK: query: select t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+ 1	1	25.0
+ 1	1	25.0
+ 1 	1	25.0
+ 1 	1	25.0
+1 	1	25.0
+1 	1	25.0
+1	1	25.0
+1	1	25.0
+null	NULL	NULL
+null	NULL	NULL
+PREHOOK: query: -- 2. Test Select + TS + FIL
+select * from t1 where t1.c_int >= 0
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 2. Test Select + TS + FIL
+select * from t1 where t1.c_int >= 0
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select * from t1 as t1  where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from t1 as t1  where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2  where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2  where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+ 1	1	25.0
+ 1	1	25.0
+ 1 	1	25.0
+ 1 	1	25.0
+1 	1	25.0
+1 	1	25.0
+1	1	25.0
+1	1	25.0
+PREHOOK: query: -- 3 Test Select + Select + TS + FIL
+select * from (select * from t1 where t1.c_int >= 0) as t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: -- 3 Test Select + Select + TS + FIL
+select * from (select * from t1 where t1.c_int >= 0) as t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select * from (select * from t1 as t1  where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select * from t1 as t1  where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select * from (select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select * from (select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2  where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2  where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+ 1	1	25.0
+ 1	1	25.0
+ 1 	1	25.0
+ 1 	1	25.0
+1 	1	25.0
+1 	1	25.0
+1	1	25.0
+1	1	25.0
+PREHOOK: query: select * from (select * from t1 where t1.c_int >= 0) as t1 where t1.c_int >= 0
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select * from t1 where t1.c_int >= 0) as t1 where t1.c_int >= 0
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select * from (select * from t1 as t1  where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1  where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select * from t1 as t1  where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1  where t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select * from (select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select * from t1 as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t2 where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+1	1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1	 1	1	1.0	true
+ 1 	 1 	1	1.0	true
+ 1 	 1 	1	1.0	true
+1 	1 	1	1.0	true
+1 	1 	1	1.0	true
+1	1	1	1.0	false
+1	1	1	1.0	false
+PREHOOK: query: select * from (select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2  where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1 where t1.c_int >= 0 and y+c_int >= 0 or x <= 100
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from t1 as t2  where t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as t1 where t1.c_int >= 0 and y+c_int >= 0 or x <= 100
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+1	1	25.0
+ 1	1	25.0
+ 1	1	25.0
+ 1 	1	25.0
+ 1 	1	25.0
+1 	1	25.0
+1 	1	25.0
+1	1	25.0
+1	1	25.0
+PREHOOK: query: select t1.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from t1 where t1.c_int >= 0) as t1 where t1.c_int >= 0
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from t1 where t1.c_int >= 0) as t1 where t1.c_int >= 0
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+PREHOOK: query: select t2.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from t1 where t1.c_int >= 0) as t2 where t2.c_int >= 0
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select t2.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from t1 where t1.c_int >= 0) as t2 where t2.c_int >= 0
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+2.0	1	25.0
+PREHOOK: query: -- 4. Test Select + Join + TS
+select t1.c_int, t2.c_int from t1 join             t2 on t1.key=t2.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: -- 4. Test Select + Join + TS
+select t1.c_int, t2.c_int from t1 join             t2 on t1.key=t2.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### 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
+NULL	NULL
+NULL	NULL
+PREHOOK: query: select t1.c_int           from t1 left semi join   t2 on t1.key=t2.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.c_int           from t1 left semi join   t2 on t1.key=t2.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+NULL
+NULL
+PREHOOK: query: select t1.c_int, t2.c_int from t1 left outer join  t2 on t1.key=t2.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.c_int, t2.c_int from t1 left outer join  t2 on t1.key=t2.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### 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
+NULL	NULL
+NULL	NULL
+PREHOOK: query: select t1.c_int, t2.c_int from t1 right outer join t2 on t1.key=t2.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.c_int, t2.c_int from t1 right outer join t2 on t1.key=t2.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### 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 t1.c_int, t2.c_int from t1 full outer join  t2 on t1.key=t2.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select t1.c_int, t2.c_int from t1 full outer join  t2 on t1.key=t2.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+#### 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, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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
+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 key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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 a, t1.b, key, t2.c_int, t3.p from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2  on t1.a=key join (select key as p, c_int as q, t3.c_float as r from t3)t3 on t1.a=t3.p
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select a, t1.b, key, t2.c_int, t3.p from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2  on t1.a=key join (select key as p, c_int as q, t3.c_float as r from t3)t3 on t1.a=t3.p
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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 
+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 b, t1.c, t2.c_int, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=t2.key join t3 on t1.a=t3.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select b, t1.c, t2.c_int, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=t2.key join t3 on t1.a=t3.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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
+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 t3.c_int, b, t2.c_int, t1.c from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=t2.key join t3 on t1.a=t3.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select t3.c_int, b, t2.c_int, t1.c from (select key as a, c_int as b, t1.c_float as c from t1) t1 join t2 on t1.a=t2.key join t3 on t1.a=t3.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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
+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, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 left outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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
+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 key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p left outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p left outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 right outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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
+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 key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p right outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select key, t1.c_int, t2.p, q from t1 join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.key=p right outer join (select key as a, c_int as b, t3.c_float as c from t3)t3 on t1.key=a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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
+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, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+PREHOOK: Input: default@t2
+PREHOOK: Input: default@t3
+#### A masked pattern was here ####
+POSTHOOK: query: select b, t1.c, t2.p, q, t3.c_int from (select key as a, c_int as b, t1.c_float as c from t1) t1 full outer join (select t2.key as p, t2.c_int as q, c_float as r from t2) t2 on t1.a=p join t3 on t1.a=key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+POSTHOOK: Input: default@t2
+POSTHOOK: Input: default@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

[... 9306 lines stripped ...]


Mime
View raw message