| PREHOOK: query: select * from cbo_t1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from cbo_t1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| NULL NULL NULL NULL NULL 2014 |
| NULL NULL NULL NULL NULL 2014 |
| PREHOOK: query: select * from cbo_t1 as cbo_t1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from cbo_t1 as cbo_t1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| NULL NULL NULL NULL NULL 2014 |
| NULL NULL NULL NULL NULL 2014 |
| PREHOOK: query: select * from cbo_t1 as cbo_t2 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from cbo_t1 as cbo_t2 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| NULL NULL NULL NULL NULL 2014 |
| NULL NULL NULL NULL NULL 2014 |
| PREHOOK: query: select cbo_t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cbo_t1.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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: select * from cbo_t1 where (((key=1) and (c_float=10)) and (c_int=20)) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from cbo_t1 where (((key=1) and (c_float=10)) and (c_int=20)) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| PREHOOK: query: select * from cbo_t1 where cbo_t1.c_int >= 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from cbo_t1 where cbo_t1.c_int >= 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from cbo_t1 as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from cbo_t1 as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select cbo_t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cbo_t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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 cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select * from cbo_t1 as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select * from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select cbo_t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select cbo_t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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 cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 where cbo_t1.c_int >= 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 where cbo_t1.c_int >= 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select * from cbo_t1 as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select * from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select cbo_t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 where cbo_t1.c_int >= 0 and y+c_int >= 0 or x <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select cbo_t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 where cbo_t1.c_int >= 0 and y+c_int >= 0 or x <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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 cbo_t1.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 where cbo_t1.c_int >= 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cbo_t1.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 where cbo_t1.c_int >= 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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 cbo_t2.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t2 where cbo_t2.c_int >= 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cbo_t2.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t2 where cbo_t2.c_int >= 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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 * from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 where cbo_t1.c_int >= 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 where cbo_t1.c_int >= 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select * from cbo_t1 as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 where cbo_t1.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select * from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select * from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 true 2014 |
| 1 1 1 1.0 false 2014 |
| 1 1 1 1.0 false 2014 |
| PREHOOK: query: select * from (select cbo_t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 where cbo_t1.c_int >= 0 and y+c_int >= 0 or x <= 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select * from (select cbo_t2.key as x, c_int as c_int, (((c_int+c_float)*10)+5) as y from cbo_t1 as cbo_t2 where cbo_t2.c_int >= 0 and c_float+c_int >= 0 or c_float <= 100) as cbo_t1 where cbo_t1.c_int >= 0 and y+c_int >= 0 or x <= 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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 cbo_t1.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 where cbo_t1.c_int >= 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cbo_t1.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t1 where cbo_t1.c_int >= 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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 cbo_t2.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t2 where cbo_t2.c_int >= 0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select cbo_t2.c_int+c_float as x , c_int as c_int, (((c_int+c_float)*10)+5) as y from (select * from cbo_t1 where cbo_t1.c_int >= 0) as cbo_t2 where cbo_t2.c_int >= 0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### 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 null from cbo_t3 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select null from cbo_t3 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t3 |
| #### A masked pattern was here #### |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| PREHOOK: query: select key from cbo_t1 where c_int = -6 or c_int = +6 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t1 |
| PREHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: select key from cbo_t1 where c_int = -6 or c_int = +6 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t1 |
| POSTHOOK: Input: default@cbo_t1@dt=2014 |
| #### A masked pattern was here #### |
| PREHOOK: query: select count(cbo_t1.dt) from cbo_t1 join cbo_t2 on cbo_t1.dt = cbo_t2.dt where cbo_t1.dt = '2014' |
| 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 count(cbo_t1.dt) from cbo_t1 join cbo_t2 on cbo_t1.dt = cbo_t2.dt where cbo_t1.dt = '2014' |
| 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 #### |
| 400 |
| PREHOOK: query: EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: cbo_t2 |
| filterExpr: c_int is not null (type: boolean) |
| Filter Operator |
| predicate: c_int is not null (type: boolean) |
| Select Operator |
| expressions: key (type: string), value (type: string), c_int (type: int), c_float (type: float), c_boolean (type: boolean), dt (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| ListSink |
| |
| PREHOOK: query: -- c_int is not null |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (2*cbo_t2.c_int) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- c_int is not null |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (2*cbo_t2.c_int) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: cbo_t2 |
| filterExpr: (c_int = (2 * c_int)) (type: boolean) |
| Filter Operator |
| predicate: (c_int = (2 * c_int)) (type: boolean) |
| Select Operator |
| expressions: key (type: string), value (type: string), c_int (type: int), c_float (type: float), c_boolean (type: boolean), dt (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| ListSink |
| |
| PREHOOK: query: -- c_int is 0 |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) = (cbo_t2.c_int) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- c_int is 0 |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) = (cbo_t2.c_int) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: cbo_t2 |
| filterExpr: c_int is not null (type: boolean) |
| Filter Operator |
| predicate: c_int is not null (type: boolean) |
| Select Operator |
| expressions: key (type: string), value (type: string), c_int (type: int), c_float (type: float), c_boolean (type: boolean), dt (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| ListSink |
| |
| PREHOOK: query: -- c_int is not null |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (NULL) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- c_int is not null |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (NULL) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: 0 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: -- rewrite to NULL |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 2*cbo_t2.c_int) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- rewrite to NULL |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 2*cbo_t2.c_int) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: cbo_t2 |
| filterExpr: (c_int is not null or (c_int = (2 * c_int))) (type: boolean) |
| Filter Operator |
| predicate: (c_int is not null or (c_int = (2 * c_int))) (type: boolean) |
| Select Operator |
| expressions: key (type: string), value (type: string), c_int (type: int), c_float (type: float), c_boolean (type: boolean), dt (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| ListSink |
| |
| PREHOOK: query: -- no rewrite |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 0) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- no rewrite |
| EXPLAIN select * from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 0) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-0 is a root stage |
| |
| STAGE PLANS: |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| TableScan |
| alias: cbo_t2 |
| filterExpr: (c_int is not null or (c_int = 0)) (type: boolean) |
| Filter Operator |
| predicate: (c_int is not null or (c_int = 0)) (type: boolean) |
| Select Operator |
| expressions: key (type: string), value (type: string), c_int (type: int), c_float (type: float), c_boolean (type: boolean), dt (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 |
| ListSink |
| |
| PREHOOK: query: -- no rewrite |
| |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- no rewrite |
| |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| 18 |
| PREHOOK: query: -- c_int is not null |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (2*cbo_t2.c_int) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- c_int is not null |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (2*cbo_t2.c_int) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| 0 |
| PREHOOK: query: -- c_int is 0 |
| select count(*) from cbo_t2 where (cbo_t2.c_int) = (cbo_t2.c_int) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- c_int is 0 |
| select count(*) from cbo_t2 where (cbo_t2.c_int) = (cbo_t2.c_int) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| 18 |
| PREHOOK: query: -- c_int is not null |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (NULL) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- c_int is not null |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (NULL) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| 0 |
| PREHOOK: query: -- rewrite to NULL |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 2*cbo_t2.c_int) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- rewrite to NULL |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 2*cbo_t2.c_int) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| 18 |
| PREHOOK: query: -- no rewrite |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 0) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@cbo_t2 |
| PREHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- no rewrite |
| select count(*) from cbo_t2 where (cbo_t2.c_int) IN (cbo_t2.c_int, 0) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@cbo_t2 |
| POSTHOOK: Input: default@cbo_t2@dt=2014 |
| #### A masked pattern was here #### |
| 18 |