http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/1c5f243f/core/sql/regress/seabase/EXPECTED010 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED010 b/core/sql/regress/seabase/EXPECTED010 index b4cbf66..c2b70df 100644 --- a/core/sql/regress/seabase/EXPECTED010 +++ b/core/sql/regress/seabase/EXPECTED010 @@ -55,7 +55,7 @@ >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Fri Oct 2 02:42:10 2015 +-- Definition current Wed Jan 6 21:04:43 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -67,7 +67,7 @@ >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:42:10 2015 +-- Definition current Wed Jan 6 21:04:44 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -85,7 +85,7 @@ >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:42:10 2015 +-- Definition current Wed Jan 6 21:04:44 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -201,7 +201,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513732264091 +PLAN_ID .................. 212318874285284804 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -242,7 +242,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060482 + ObjectUIDs ............. 7719819453060518502 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -265,6 +265,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... ((A = 1) or (B = '1')) @@ -280,7 +281,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513732374292 +PLAN_ID .................. 212318874285343869 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -322,7 +323,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060482 + ObjectUIDs ............. 7719819453060518502 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -343,6 +344,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = %('1')) begin_key .............. (A = %(1)) @@ -359,7 +361,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513732486422 +PLAN_ID .................. 212318874285406527 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -400,7 +402,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060482 + ObjectUIDs ............. 7719819453060518502 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -424,6 +426,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = %('1')) @@ -438,7 +441,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513731929457 +PLAN_ID .................. 212318874285042640 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -480,7 +483,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060482 + ObjectUIDs ............. 7719819453060518502 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -501,6 +504,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A begin_key .............. (A = %(2)) end_key ................ (A = %(2)) @@ -741,7 +745,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212310513735952434 +PLAN_ID .................. 212318874288628482 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -784,7 +788,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -807,6 +811,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... ((A = 1) or (A = 4)) and (B = %('a')) and (C = %(1)) @@ -816,7 +821,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212310513736055675 +PLAN_ID .................. 212318874288780330 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -860,7 +865,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -883,6 +888,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and (B = %('a')) and (((C = 1) or (C = 3)) or (C >= 5)) @@ -893,7 +899,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212310513736141791 +PLAN_ID .................. 212318874288991348 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -936,7 +942,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -959,6 +965,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) and (B = %('a')) @@ -969,7 +976,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212310513736226438 +PLAN_ID .................. 212318874289146696 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -1012,7 +1019,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 input_variables ........ %('a') @@ -1063,6 +1070,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 key_columns ............ A, B, C executor_predicates .... (B = %('a')) mdam_disjunct .......... (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C @@ -1074,7 +1082,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212310513736390545 +PLAN_ID .................. 212318874289526999 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -1119,7 +1127,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 input_variables ........ %('upd'), %(4) @@ -1146,7 +1154,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212310513736490371 +PLAN_ID .................. 212318874289662379 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1190,7 +1198,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -1213,6 +1221,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... ((A = 1) or (A = 4)) and (B = %('a')) and (C = %(1)) @@ -1222,7 +1231,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212310513736582508 +PLAN_ID .................. 212318874289724661 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1267,7 +1276,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1290,6 +1299,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and (B = %('a')) and (((C = 1) or (C = 3)) or (C >= 5)) @@ -1300,7 +1310,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212310513736695111 +PLAN_ID .................. 212318874289854294 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1344,7 +1354,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1367,6 +1377,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) and (B = %('a')) @@ -1377,7 +1388,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212310513736805348 +PLAN_ID .................. 212318874289957418 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -1421,7 +1432,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 input_variables ........ %('a') @@ -1472,6 +1483,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 key_columns ............ A, B, C executor_predicates .... (B = %('a')) mdam_disjunct .......... (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C @@ -1483,7 +1495,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212310513736999794 +PLAN_ID .................. 212318874290144298 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -1529,7 +1541,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747060577 + ObjectUIDs ............. 7719819453060518648 input_variables ........ %('uuu'), %(4) @@ -1706,7 +1718,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Fri Oct 2 02:42:35 2015 +-- Definition current Wed Jan 6 21:05:19 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1718,7 +1730,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:42:35 2015 +-- Definition current Wed Jan 6 21:05:19 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1736,7 +1748,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:42:35 2015 +-- Definition current Wed Jan 6 21:05:19 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1852,7 +1864,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513756188559 +PLAN_ID .................. 212318874320281864 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -1893,7 +1905,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063047 + ObjectUIDs ............. 7719819453060522343 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -1916,6 +1928,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... ((A = 1) or (B = '1')) @@ -1931,7 +1944,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513756298280 +PLAN_ID .................. 212318874320335949 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -1973,7 +1986,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063047 + ObjectUIDs ............. 7719819453060522343 select_list ............ 1, '1' @@ -1995,6 +2008,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = '1') @@ -2009,7 +2023,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513756359313 +PLAN_ID .................. 212318874320397570 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -2050,7 +2064,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063047 + ObjectUIDs ............. 7719819453060522343 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -2073,6 +2087,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = '1') @@ -2087,7 +2102,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513756428751 +PLAN_ID .................. 212318874320470692 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -2129,7 +2144,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063047 + ObjectUIDs ............. 7719819453060522343 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -2151,6 +2166,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A --- SQL operation complete. @@ -2389,7 +2405,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212310513760348742 +PLAN_ID .................. 212318874324046576 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2432,7 +2448,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -2456,6 +2472,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C --- SQL operation complete. @@ -2464,7 +2481,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212310513760389029 +PLAN_ID .................. 212318874324102414 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2508,7 +2525,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2545,6 +2562,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C --- SQL operation complete. @@ -2553,7 +2571,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212310513760464086 +PLAN_ID .................. 212318874324151162 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2596,7 +2614,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2624,6 +2642,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C --- SQL operation complete. @@ -2632,7 +2651,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212310513760502217 +PLAN_ID .................. 212318874324187381 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -2675,7 +2694,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -2731,6 +2750,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 key_columns ............ A, B, C executor_predicates .... (B = 'a') @@ -2740,7 +2760,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212310513760616099 +PLAN_ID .................. 212318874324276743 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -2785,7 +2805,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -2815,7 +2835,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212310513760713299 +PLAN_ID .................. 212318874324374385 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2859,7 +2879,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -2883,6 +2903,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = 'a') and (C = 1) and ((A = 1) or (A = 4)) @@ -2892,7 +2913,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212310513760785318 +PLAN_ID .................. 212318874324448681 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2937,7 +2958,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2961,6 +2982,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = 'a') and (((A = 1) or (A = 2)) or (A = 4)) and (((C = 1) or (C = 3)) or (C >= 5)) @@ -2971,7 +2993,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212310513760868007 +PLAN_ID .................. 212318874324491981 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3015,7 +3037,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3039,6 +3061,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = 'a') and (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) @@ -3049,7 +3072,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212310513760917388 +PLAN_ID .................. 212318874324536927 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -3093,7 +3116,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -3145,6 +3168,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 key_columns ............ A, B, C executor_predicates .... (B = 'a') and (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C = 3)) @@ -3155,7 +3179,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212310513760991469 +PLAN_ID .................. 212318874324635793 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -3201,7 +3225,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747063117 + ObjectUIDs ............. 7719819453060522478 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -3378,7 +3402,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Fri Oct 2 02:43:08 2015 +-- Definition current Wed Jan 6 21:05:48 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -3390,7 +3414,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:43:08 2015 +-- Definition current Wed Jan 6 21:05:48 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3408,7 +3432,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:43:08 2015 +-- Definition current Wed Jan 6 21:05:48 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3524,7 +3548,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513788767709 +PLAN_ID .................. 212318874349133784 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -3565,7 +3589,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066296 + ObjectUIDs ............. 7719819453060525244 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -3588,6 +3612,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... ((A = 1) or (B = '1')) @@ -3603,7 +3628,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513788874756 +PLAN_ID .................. 212318874349208872 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -3645,7 +3670,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066296 + ObjectUIDs ............. 7719819453060525244 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -3666,6 +3691,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = %('1')) begin_key .............. (A = %(1)) @@ -3682,7 +3708,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513788982793 +PLAN_ID .................. 212318874349271303 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -3723,7 +3749,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066296 + ObjectUIDs ............. 7719819453060525244 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -3747,6 +3773,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = %('1')) @@ -3761,7 +3788,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513788478091 +PLAN_ID .................. 212318874348941590 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -3803,7 +3830,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066296 + ObjectUIDs ............. 7719819453060525244 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -3824,6 +3851,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A begin_key .............. (A = %(2)) end_key ................ (A = %(2)) @@ -4064,7 +4092,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212310513792864137 +PLAN_ID .................. 212318874352330474 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4107,7 +4135,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4129,6 +4157,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = %('a')) and (C = %(1)) and ((A = 1) or (A = 4)) begin_key .............. (A = <min>), (B = %('a')), (C = %(1)) @@ -4140,7 +4169,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212310513792910445 +PLAN_ID .................. 212318874352372978 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4184,7 +4213,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4206,6 +4235,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = %('a')) and (((A = 1) or (A = 2)) or (A = 4)) and (((C = 1) or (C = 3)) or (C >= 5)) @@ -4218,7 +4248,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212310513792992192 +PLAN_ID .................. 212318874352413168 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4261,7 +4291,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4283,6 +4313,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = %('a')) and (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) @@ -4295,7 +4326,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212310513793072848 +PLAN_ID .................. 212318874352451216 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4338,7 +4369,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 input_variables ........ %('a') @@ -4388,6 +4419,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 key_columns ............ A, B, C executor_predicates .... (B = %('a')) and (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C = 3)) @@ -4400,7 +4432,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212310513793186582 +PLAN_ID .................. 212318874352536749 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -4445,7 +4477,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 input_variables ........ %('upd'), %(4) @@ -4472,7 +4504,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212310513793287927 +PLAN_ID .................. 212318874352606320 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4516,7 +4548,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4538,6 +4570,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = %('a')) and (C = %(1)) and ((A = 1) or (A = 4)) begin_key .............. (A = <min>), (B = %('a')), (C = %(1)) @@ -4549,7 +4582,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212310513793331269 +PLAN_ID .................. 212318874352650694 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4594,7 +4627,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4616,6 +4649,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = %('a')) and (((A = 1) or (A = 2)) or (A = 4)) and (((C = 1) or (C = 3)) or (C >= 5)) @@ -4628,7 +4662,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212310513793373442 +PLAN_ID .................. 212318874352687942 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4672,7 +4706,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4694,6 +4728,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C executor_predicates .... (B = %('a')) and (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) @@ -4706,7 +4741,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212310513793466330 +PLAN_ID .................. 212318874352731143 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4750,7 +4785,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 input_variables ........ %('a') @@ -4800,6 +4835,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 key_columns ............ A, B, C executor_predicates .... (B = %('a')) and (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C = 3)) @@ -4812,7 +4848,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212310513793553347 +PLAN_ID .................. 212318874352809680 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -4858,7 +4894,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747066363 + ObjectUIDs ............. 7719819453060525374 input_variables ........ %('uuu'), %(4) @@ -5035,7 +5071,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Fri Oct 2 02:43:34 2015 +-- Definition current Wed Jan 6 21:06:17 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -5047,7 +5083,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:43:34 2015 +-- Definition current Wed Jan 6 21:06:17 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5065,7 +5101,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:43:34 2015 +-- Definition current Wed Jan 6 21:06:17 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5181,7 +5217,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513815202331 +PLAN_ID .................. 212318874378406498 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -5222,7 +5258,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747068966 + ObjectUIDs ............. 7719819453060528243 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -5245,6 +5281,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... ((A = 1) or (B = '1')) @@ -5260,7 +5297,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513815306295 +PLAN_ID .................. 212318874378464788 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -5302,7 +5339,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747068966 + ObjectUIDs ............. 7719819453060528243 select_list ............ 1, '1' @@ -5324,6 +5361,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = '1') @@ -5338,7 +5376,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513815416478 +PLAN_ID .................. 212318874378515848 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -5379,7 +5417,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747068966 + ObjectUIDs ............. 7719819453060528243 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -5402,6 +5440,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = '1') @@ -5416,7 +5455,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513815557852 +PLAN_ID .................. 212318874378567911 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -5458,7 +5497,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747068966 + ObjectUIDs ............. 7719819453060528243 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -5480,6 +5519,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A --- SQL operation complete. @@ -5718,7 +5758,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212310513819343102 +PLAN_ID .................. 212318874381351368 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -5761,7 +5801,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -5783,6 +5823,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... ((A = 1) or (A = 4)) and (B = 'a') and (C = 1) @@ -5792,7 +5833,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212310513819407284 +PLAN_ID .................. 212318874381444643 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -5836,7 +5877,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -5858,6 +5899,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and (B = 'a') and (((C = 1) or (C = 3)) or (C >= 5)) @@ -5868,7 +5910,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212310513819518185 +PLAN_ID .................. 212318874381563530 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -5911,7 +5953,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -5933,6 +5975,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) and (B = 'a') @@ -5943,7 +5986,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212310513819623401 +PLAN_ID .................. 212318874381698436 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -5986,7 +6029,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6036,6 +6079,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 key_columns ............ A, B, C executor_predicates .... (B = 'a') mdam_disjunct .......... (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C @@ -6047,7 +6091,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212310513819757908 +PLAN_ID .................. 212318874381896399 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -6092,7 +6136,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -6122,7 +6166,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212310513819822716 +PLAN_ID .................. 212318874381991717 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6166,7 +6210,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -6188,6 +6232,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... ((A = 1) or (A = 4)) and (B = 'a') and (C = 1) @@ -6197,7 +6242,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212310513819881090 +PLAN_ID .................. 212318874382088609 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6242,7 +6287,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6264,6 +6309,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and (B = 'a') and (((C = 1) or (C = 3)) or (C >= 5)) @@ -6274,7 +6320,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212310513819992584 +PLAN_ID .................. 212318874382208839 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6318,7 +6364,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6340,6 +6386,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) and (B = 'a') @@ -6350,7 +6397,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212310513820093872 +PLAN_ID .................. 212318874382311891 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -6394,7 +6441,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6444,6 +6491,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 key_columns ............ A, B, C executor_predicates .... (B = 'a') mdam_disjunct .......... (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C @@ -6455,7 +6503,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212310513820222930 +PLAN_ID .................. 212318874382520166 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -6501,7 +6549,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747069044 + ObjectUIDs ............. 7719819453060528314 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -6698,7 +6746,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Fri Oct 2 02:44:03 2015 +-- Definition current Wed Jan 6 21:06:48 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -6710,7 +6758,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:44:03 2015 +-- Definition current Wed Jan 6 21:06:48 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -6728,7 +6776,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:44:03 2015 +-- Definition current Wed Jan 6 21:06:48 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -6844,7 +6892,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513844427155 +PLAN_ID .................. 212318874409186628 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -6885,7 +6933,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071764 + ObjectUIDs ............. 7719819453060531285 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -6908,6 +6956,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... ((A = 1) or (B = '1')) @@ -6923,7 +6972,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513844489870 +PLAN_ID .................. 212318874409240395 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -6965,7 +7014,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071764 + ObjectUIDs ............. 7719819453060531285 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -6986,6 +7035,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = %('1')) begin_key .............. (A = %(1)) @@ -7002,7 +7052,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513844593137 +PLAN_ID .................. 212318874409289487 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -7043,7 +7093,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071764 + ObjectUIDs ............. 7719819453060531285 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -7067,6 +7117,8 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 + pushed_down_rpn ........ (#1:2=?) key_columns ............ A executor_predicates .... (B = %('1')) @@ -7081,7 +7133,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513844152547 +PLAN_ID .................. 212318874408994668 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -7123,7 +7175,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071764 + ObjectUIDs ............. 7719819453060531285 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -7144,6 +7196,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A begin_key .............. (A = %(2)) end_key ................ (A = %(2)) @@ -7384,7 +7437,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212310513848209819 +PLAN_ID .................. 212318874412114296 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7427,7 +7480,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -7450,6 +7503,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... ((A = 1) or (A = 4)) and (B = %('a')) and (C = %(1)) @@ -7459,7 +7513,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212310513848280174 +PLAN_ID .................. 212318874412204500 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7503,7 +7557,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7526,6 +7580,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and (B = %('a')) and (((C = 1) or (C = 3)) or (C >= 5)) @@ -7536,7 +7591,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212310513848397450 +PLAN_ID .................. 212318874412313075 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7579,7 +7634,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7602,6 +7657,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) and (B = %('a')) @@ -7612,7 +7668,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212310513848471519 +PLAN_ID .................. 212318874412426844 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -7655,7 +7711,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 input_variables ........ %('a') @@ -7706,6 +7762,8 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 + pushed_down_rpn ........ (#1:2=?) key_columns ............ A, B, C mdam_disjunct .......... (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C = 3)) and (B = %('a')) @@ -7716,7 +7774,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212310513848661826 +PLAN_ID .................. 212318874412662185 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -7761,7 +7819,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 input_variables ........ %('upd'), %(4) @@ -7788,7 +7846,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212310513848764428 +PLAN_ID .................. 212318874412740210 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7832,7 +7890,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -7855,6 +7913,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... ((A = 1) or (A = 4)) and (B = %('a')) and (C = %(1)) @@ -7864,7 +7923,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212310513848822595 +PLAN_ID .................. 212318874412804242 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7909,7 +7968,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7932,6 +7991,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and (B = %('a')) and (((C = 1) or (C = 3)) or (C >= 5)) @@ -7942,7 +8002,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212310513848914740 +PLAN_ID .................. 212318874412915886 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7986,7 +8046,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8009,6 +8069,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) and (B = %('a')) @@ -8019,7 +8080,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212310513848998849 +PLAN_ID .................. 212318874413003180 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -8063,7 +8124,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 input_variables ........ %('a') @@ -8114,6 +8175,8 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 + pushed_down_rpn ........ (#1:2=?) key_columns ............ A, B, C mdam_disjunct .......... (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C = 3)) and (B = %('a')) @@ -8124,7 +8187,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212310513849172111 +PLAN_ID .................. 212318874413150463 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -8170,7 +8233,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747071838 + ObjectUIDs ............. 7719819453060531409 input_variables ........ %('uuu'), %(4) @@ -8347,7 +8410,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Fri Oct 2 02:44:30 2015 +-- Definition current Wed Jan 6 21:07:15 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -8359,7 +8422,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:44:30 2015 +-- Definition current Wed Jan 6 21:07:15 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8377,7 +8440,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Fri Oct 2 02:44:30 2015 +-- Definition current Wed Jan 6 21:07:15 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8493,7 +8556,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513871161210 +PLAN_ID .................. 212318874436228767 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -8534,7 +8597,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074546 + ObjectUIDs ............. 7719819453060533978 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -8557,6 +8620,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... ((A = 1) or (B = '1')) @@ -8572,7 +8636,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513871229608 +PLAN_ID .................. 212318874436299112 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -8614,7 +8678,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074546 + ObjectUIDs ............. 7719819453060533978 select_list ............ 1, '1' @@ -8636,6 +8700,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A executor_predicates .... (B = '1') @@ -8650,7 +8715,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513871292416 +PLAN_ID .................. 212318874436377734 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -8691,7 +8756,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074546 + ObjectUIDs ............. 7719819453060533978 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -8714,6 +8779,8 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2 + pushed_down_rpn ........ (#1:2=?) key_columns ............ A executor_predicates .... (B = '1') @@ -8728,7 +8795,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212310513871374116 +PLAN_ID .................. 212318874436456984 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -8770,7 +8837,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074546 + ObjectUIDs ............. 7719819453060533978 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -8792,6 +8859,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed .......... 1 + column_retrieved ....... #1:1,#1:2 key_columns ............ A --- SQL operation complete. @@ -9030,7 +9098,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212310513875099390 +PLAN_ID .................. 212318874439283976 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9073,7 +9141,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -9095,6 +9163,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... ((A = 1) or (A = 4)) and (B = 'a') and (C = 1) @@ -9104,7 +9173,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212310513875176036 +PLAN_ID .................. 212318874439371513 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9148,7 +9217,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9170,6 +9239,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and (B = 'a') and (((C = 1) or (C = 3)) or (C >= 5)) @@ -9180,7 +9250,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212310513875251519 +PLAN_ID .................. 212318874439493898 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9223,7 +9293,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9245,6 +9315,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) and (B = 'a') @@ -9255,7 +9326,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212310513875364400 +PLAN_ID .................. 212318874439608663 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -9298,7 +9369,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -9348,6 +9419,8 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 + pushed_down_rpn ........ (#1:2=?) key_columns ............ A, B, C mdam_disjunct .......... (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C = 3)) and (B = 'a') @@ -9358,7 +9431,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212310513875516964 +PLAN_ID .................. 212318874439813315 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -9403,7 +9476,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -9433,7 +9506,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212310513875603180 +PLAN_ID .................. 212318874439901610 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9477,7 +9550,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -9499,6 +9572,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... ((A = 1) or (A = 4)) and (B = 'a') and (C = 1) @@ -9508,7 +9582,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212310513875660047 +PLAN_ID .................. 212318874439981773 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9553,7 +9627,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9575,6 +9649,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and (B = 'a') and (((C = 1) or (C = 3)) or (C >= 5)) @@ -9585,7 +9660,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212310513875767814 +PLAN_ID .................. 212318874440090497 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9629,7 +9704,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9651,6 +9726,7 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C mdam_disjunct .......... (((A = 1) or (A = 2)) or (A = 4)) and ((C = 1) or (C = 3)) and (B = 'a') @@ -9661,7 +9737,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212310513875872389 +PLAN_ID .................. 212318874440208476 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -9705,7 +9781,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ............. 7719819453060534104 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -9755,6 +9831,8 @@ DESCRIPTION cache_size ........... 100 probes ................. 1 rows_accessed ........ 100 + column_retrieved ....... #1:1,#1:2,#1:3 + pushed_down_rpn ........ (#1:2=?) key_columns ............ A, B, C mdam_disjunct .......... (((A = 2) or (A = 4)) or (A = 6)) and ((C = 1) or (C = 3)) and (B = 'a') @@ -9765,7 +9843,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212310513875999537 +PLAN_ID .................. 212318874440393270 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -9811,7 +9889,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5009770016747074618 + ObjectUIDs ..
<TRUNCATED>
