You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by hz...@apache.org on 2016/01/22 02:08:21 UTC
[02/15] incubator-trafodion git commit: First commit for advanced
predicate pushdown feature (also known as pushdown V2) associated JIRA
TRAFODION-1662 Predicate push down revisited (V2). The JIRA contains a
blueprint document, useful to understand what
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>