You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2017/12/08 22:25:05 UTC
[1/4] incubator-trafodion git commit: [TRAFODION-2827] Turn update
costing code on by default
Repository: incubator-trafodion
Updated Branches:
refs/heads/master b2b01f4d5 -> 14851367b
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b1498748/core/sql/regress/seabase/EXPECTED011
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED011 b/core/sql/regress/seabase/EXPECTED011
index 2a36907..7b54686 100644
--- a/core/sql/regress/seabase/EXPECTED011
+++ b/core/sql/regress/seabase/EXPECTED011
@@ -7,7 +7,7 @@
>>invoke T011T1;
-- Definition of Trafodion table TRAFODION.SCH.T011T1
--- Definition current Mon Sep 18 16:13:32 2017
+-- Definition current Wed Dec 6 19:43:45 2017
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -143,7 +143,7 @@ A B
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212372511214096121
+PLAN_ID .................. 212379349426943450
ROWS_OUT ................. 7
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t011t1 where a >= 3 and a < 5;
@@ -182,7 +182,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
TRAF_ALIGNED_ROW_FORMAT OFF
GENERATE_EXPLAIN ....... ON
- ObjectUIDs ............. 2068981457564705177
+ ObjectUIDs ............. 3014744217526141194
select_list ............ TRAFODION.SCH.T011T1.A, TRAFODION.SCH.T011T1.B
@@ -348,8 +348,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-1 . 2 root o x 2.00E+000
-. . 1 trafodion_update T011T1 2.00E+000
+3 . 4 root x 2.00E+000
+1 2 3 tuple_flow 2.00E+000
+. . 2 trafodion_vsbb_updat T011T1 1.00E+000
+. . 1 trafodion_scan T011T1 2.00E+000
--- SQL operation complete.
>>explain options 'f' update t011t1 set b = b || 'z' where a = 10;
@@ -366,8 +368,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-1 . 2 root o x 2.00E+000
-. . 1 trafodion_update T011T1 2.00E+000
+3 . 4 root x 2.00E+000
+1 2 3 tuple_flow 2.00E+000
+. . 2 trafodion_vsbb_updat T011T1 1.00E+000
+. . 1 trafodion_scan T011T1 2.00E+000
--- SQL operation complete.
>>explain options 'f' update t011t1 set b = 'z' where a = ?;
@@ -483,8 +487,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-1 . 2 root o x 2.00E+000
-. . 1 trafodion_update T011T1 2.00E+000
+3 . 4 root x 2.00E+000
+1 2 3 tuple_flow 2.00E+000
+. . 2 trafodion_vsbb_updat T011T1 1.00E+000
+. . 1 trafodion_scan T011T1 2.00E+000
--- SQL operation complete.
>>explain options 'f' update t011t1 set b = b || 'z' where a = 10;
@@ -501,8 +507,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-1 . 2 root o x 2.00E+000
-. . 1 trafodion_update T011T1 2.00E+000
+3 . 4 root x 2.00E+000
+1 2 3 tuple_flow 2.00E+000
+. . 2 trafodion_vsbb_updat T011T1 1.00E+000
+. . 1 trafodion_scan T011T1 2.00E+000
--- SQL operation complete.
>>explain options 'f' update t011t1 set b = 'z' where a = ?;
@@ -519,9 +527,11 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-4 . 5 root x 1.00E+001
-2 3 4 nested_join 1.00E+001
-. . 3 trafodion_vsbb_updat T011T1 1.00E+000
+6 . 7 root x 1.00E+001
+2 5 6 nested_join 1.00E+001
+3 4 5 tuple_flow 1.00E+000
+. . 4 trafodion_vsbb_updat T011T1 1.00E+000
+. . 3 trafodion_vsbb_scan T011T1 1.00E+000
1 . 2 unpack 1.00E+001
. . 1 values 1.00E+000
@@ -540,9 +550,11 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-4 . 5 root x 1.00E+001
-2 3 4 nested_join 1.00E+001
-. . 3 trafodion_update T011T1 1.00E+000
+6 . 7 root x 1.00E+001
+2 5 6 nested_join 1.00E+001
+3 4 5 tuple_flow 1.00E+000
+. . 4 trafodion_vsbb_updat T011T1 1.00E+000
+. . 3 trafodion_vsbb_scan T011T1 1.00E+000
1 . 2 unpack 1.00E+001
. . 1 values 1.00E+000
@@ -614,8 +626,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-1 . 2 root o x 2.00E+000
-. . 1 trafodion_update T011T1 2.00E+000
+3 . 4 root x 2.00E+000
+1 2 3 tuple_flow 2.00E+000
+. . 2 trafodion_update T011T1 1.00E+000
+. . 1 trafodion_scan T011T1 2.00E+000
--- SQL operation complete.
>>explain options 'f' update t011t1 set b = b || 'z' where a = 10;
@@ -632,8 +646,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-1 . 2 root o x 2.00E+000
-. . 1 trafodion_update T011T1 2.00E+000
+3 . 4 root x 2.00E+000
+1 2 3 tuple_flow 2.00E+000
+. . 2 trafodion_update T011T1 1.00E+000
+. . 1 trafodion_scan T011T1 2.00E+000
--- SQL operation complete.
>>explain options 'f' update t011t1 set b = 'z' where a = ?;
@@ -650,9 +666,11 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-4 . 5 root x 1.00E+001
-2 3 4 nested_join 1.00E+001
-. . 3 trafodion_update T011T1 1.00E+000
+6 . 7 root x 1.00E+001
+2 5 6 nested_join 1.00E+001
+3 4 5 tuple_flow 1.00E+000
+. . 4 trafodion_update T011T1 1.00E+000
+. . 3 trafodion_scan T011T1 1.00E+000
1 . 2 unpack 1.00E+001
. . 1 values 1.00E+000
@@ -671,9 +689,11 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-4 . 5 root x 1.00E+001
-2 3 4 nested_join 1.00E+001
-. . 3 trafodion_update T011T1 1.00E+000
+6 . 7 root x 1.00E+001
+2 5 6 nested_join 1.00E+001
+3 4 5 tuple_flow 1.00E+000
+. . 4 trafodion_update T011T1 1.00E+000
+. . 3 trafodion_scan T011T1 1.00E+000
1 . 2 unpack 1.00E+001
. . 1 values 1.00E+000
@@ -981,9 +1001,11 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-4 . 5 root x 1.00E+001
-2 3 4 nested_join 1.00E+001
-. . 3 trafodion_update T011T1 1.00E+000
+6 . 7 root x 1.00E+001
+2 5 6 nested_join 1.00E+001
+3 4 5 tuple_flow 1.00E+000
+. . 4 trafodion_update T011T1 1.00E+000
+. . 3 trafodion_scan T011T1 1.00E+000
1 . 2 unpack 1.00E+001
. . 1 values 1.00E+000
@@ -1060,8 +1082,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- -------------------- ---------
-1 . 2 root o x 2.00E+000
-. . 1 trafodion_update T011T1 2.00E+000
+3 . 4 root x 2.00E+000
+1 2 3 tuple_flow 2.00E+000
+. . 2 trafodion_update T011T1 1.00E+000
+. . 1 trafodion_scan T011T1 2.00E+000
--- SQL operation complete.
>>explain options 'f' insert into t011t1 select a,c from t011t3;
@@ -1276,7 +1300,7 @@ METRIC_TEXT_TABLE
>>invoke trafodion."_REPOS_".metric_query_table;
-- Definition of Trafodion table TRAFODION."_REPOS_".METRIC_QUERY_TABLE
--- Definition current Mon Sep 18 16:15:51 2017
+-- Definition current Wed Dec 6 19:46:03 2017
(
INSTANCE_ID INT UNSIGNED NO DEFAULT NOT NULL NOT
@@ -1464,7 +1488,7 @@ METRIC_TEXT_TABLE
>>-- get qid for the prepared stmt
>>get qid for statement explstmt;
-MXID11000003675212372511181547316000000000206U3333300_2377_EXPLSTMT
+MXID11000005355212379349395122217000000000206U3333300_2289_EXPLSTMT
--- SQL operation complete.
>>
@@ -1516,7 +1540,7 @@ SEQ_NUM OPERATOR
--- SQL command prepared.
>>get qid for statement explstmt2;
-MXID11000003675212372511181547316000000000206U3333300_2388_EXPLSTMT2
+MXID11000005355212379349395122217000000000206U3333300_2300_EXPLSTMT2
--- SQL operation complete.
>>set qid MXID123456 for explstmt2;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b1498748/core/sql/sqlcomp/nadefaults.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp
index 70c7036..f672de1 100644
--- a/core/sql/sqlcomp/nadefaults.cpp
+++ b/core/sql/sqlcomp/nadefaults.cpp
@@ -1483,11 +1483,8 @@ SDDkwd__(EXE_DIAGNOSTIC_EVENTS, "OFF"),
DDkwd__(HBASE_SQL_IUD_SEMANTICS, "ON"),
DDkwd__(HBASE_STATS_PARTITIONING, "ON"),
- // If set to 'OFF' we get a stub cost of 1 for update operations.
- // We can remove this once the delete costing code has broader
- // exposure. This is 'OFF' at the moment because the update code
- // is only partially written.
- DDkwd__(HBASE_UPDATE_COSTING, "OFF"),
+ // If set to 'OFF' we get a stub cost of 0 for update operations.
+ DDkwd__(HBASE_UPDATE_COSTING, "ON"),
DDkwd__(HBASE_UPDEL_CURSOR_OPT, "ON"),
DDui___(HBASE_USE_FAKED_REGIONS, "0"),
[4/4] incubator-trafodion git commit: Merge [TRAFODION-2827] PR 1326
Turn update costing on by default
Posted by db...@apache.org.
Merge [TRAFODION-2827] PR 1326 Turn update costing on by default
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/14851367
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/14851367
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/14851367
Branch: refs/heads/master
Commit: 14851367bd0067b820cff793de2926a1218df3e1
Parents: b2b01f4 b149874
Author: Dave Birdsall <db...@apache.org>
Authored: Fri Dec 8 22:24:02 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Fri Dec 8 22:24:02 2017 +0000
----------------------------------------------------------------------
core/sql/regress/compGeneral/EXPECTED013.SB | 12 +-
core/sql/regress/compGeneral/EXPECTED071 | 5 +-
core/sql/regress/core/EXPECTED020.SB | 19 +-
core/sql/regress/seabase/EXPECTED010 | 1107 +++++++++++++++-------
core/sql/regress/seabase/EXPECTED011 | 94 +-
core/sql/sqlcomp/nadefaults.cpp | 7 +-
6 files changed, 859 insertions(+), 385 deletions(-)
----------------------------------------------------------------------
[3/4] incubator-trafodion git commit: [TRAFODION-2827] Turn update
costing code on by default
Posted by db...@apache.org.
[TRAFODION-2827] Turn update costing code on by default
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/b1498748
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/b1498748
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/b1498748
Branch: refs/heads/master
Commit: b1498748391b1cb3edec057c2ee25058450026bb
Parents: a07222f
Author: Dave Birdsall <db...@apache.org>
Authored: Wed Dec 6 22:03:24 2017 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Wed Dec 6 22:03:24 2017 +0000
----------------------------------------------------------------------
core/sql/regress/compGeneral/EXPECTED013.SB | 12 +-
core/sql/regress/compGeneral/EXPECTED071 | 5 +-
core/sql/regress/core/EXPECTED020.SB | 19 +-
core/sql/regress/seabase/EXPECTED010 | 1107 +++++++++++++++-------
core/sql/regress/seabase/EXPECTED011 | 94 +-
core/sql/sqlcomp/nadefaults.cpp | 7 +-
6 files changed, 859 insertions(+), 385 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b1498748/core/sql/regress/compGeneral/EXPECTED013.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED013.SB b/core/sql/regress/compGeneral/EXPECTED013.SB
index 685f1c7..7592226 100644
--- a/core/sql/regress/compGeneral/EXPECTED013.SB
+++ b/core/sql/regress/compGeneral/EXPECTED013.SB
@@ -109,14 +109,14 @@ CREATE TABLE TRAFODION.SCH.ORDERS1
;
-- The following index is a system created index --
-CREATE INDEX ORDERS1_277948757_4279 ON TRAFODION.SCH.ORDERS1
+CREATE INDEX ORDERS1_733933879_4153 ON TRAFODION.SCH.ORDERS1
(
O_CUSTKEY ASC
)
;
ALTER TABLE TRAFODION.SCH.ORDERS1 ADD CONSTRAINT
- TRAFODION.SCH.ORDERS1_277948757_4279 FOREIGN KEY
+ TRAFODION.SCH.ORDERS1_733933879_4153 FOREIGN KEY
(
O_CUSTKEY
)
@@ -139,14 +139,14 @@ CREATE TABLE TRAFODION.SCH.ORDERS2
;
-- The following index is a system created index --
-CREATE INDEX ORDERS2_417358757_4279 ON TRAFODION.SCH.ORDERS2
+CREATE INDEX ORDERS2_693443879_4153 ON TRAFODION.SCH.ORDERS2
(
O_CUSTKEY ASC
)
;
ALTER TABLE TRAFODION.SCH.ORDERS2 ADD CONSTRAINT
- TRAFODION.SCH.ORDERS2_417358757_4279 FOREIGN KEY
+ TRAFODION.SCH.ORDERS2_693443879_4153 FOREIGN KEY
(
O_CUSTKEY
)
@@ -205,9 +205,11 @@ SCAN
BLOCKED_UNION
TRAFODION_VSBB_U
TRAFODION_DELETE
+NESTED_JOIN
TRAFODION_UPDATE
+SCAN
---- 9 row(s) selected.
+--- 11 row(s) selected.
>>
>>prepare XX from delete from customer ;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b1498748/core/sql/regress/compGeneral/EXPECTED071
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED071 b/core/sql/regress/compGeneral/EXPECTED071
index 9fa3ec3..f87f526 100644
--- a/core/sql/regress/compGeneral/EXPECTED071
+++ b/core/sql/regress/compGeneral/EXPECTED071
@@ -427,9 +427,10 @@ TRAFODION_VSBB_DELETE TRAFODION.MTD.MTD1
OPERATOR TNAME BKEY EKEY
------------------------------ ------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-TRAFODION_UPDATE TRAFODION.MTD.MTD1 max_card_est:
+TRAFODION_SCAN MTD1 max_card_est:
+TRAFODION_VSBB_UPDATE TRAFODION.MTD.MTD1 begin_key: (_DIVISION_1_ = _DIVISION_1_) and (STORE_ID = STORE_ID) and (ITEM_ID = ITEM_ID) and (SALE_DATE = SALE_DATE) end_key: (_DIVISION_1_ = _DIVISION_1_) and (STORE_ID = STORE_ID) and (ITEM_ID = ITEM_ID) and (SALE_DATE = SALE_DATE)
---- 1 row(s) selected.
+--- 2 row(s) selected.
>>
>>begin work;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b1498748/core/sql/regress/core/EXPECTED020.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED020.SB b/core/sql/regress/core/EXPECTED020.SB
index 097a530..41440e0 100644
--- a/core/sql/regress/core/EXPECTED020.SB
+++ b/core/sql/regress/core/EXPECTED020.SB
@@ -369,6 +369,8 @@ MODULE_NAME STATEMENT_NAME
? S6
? S7
? S7
+? S7
+? S7
? S8
? S8
? S8
@@ -378,7 +380,7 @@ MODULE_NAME STATEMENT_NAME
? S9
? S9
---- 34 row(s) selected.
+--- 36 row(s) selected.
>>
>>--QUERY 7 - Wildcarding is used in the explain parameters.
>>select
@@ -399,8 +401,9 @@ HYBRID_HASH_SEMI_JOIN
HYBRID_HASH_SEMI_JOIN
NESTED_JOIN
TUPLE_FLOW
+TUPLE_FLOW
---- 7 row(s) selected.
+--- 8 row(s) selected.
>>
>>-- QUERY 8
>>
@@ -426,10 +429,9 @@ SEQ_NUM LEFT_CHILD_SEQ_NUM OPERATOR RIGHT_CHILD_SEQ
1 ? TRAFODION_SCAN ?
1 ? TRAFODION_SCAN ?
1 ? TRAFODION_SCAN ?
- 1 ? TRAFODION_UPDATE ?
+ 1 ? TRAFODION_SCAN ?
1 ? TUPLELIST ?
2 1 ROOT ?
- 2 1 ROOT ?
2 1 SORT ?
2 ? TRAFODION_INSERT ?
2 ? TRAFODION_SCAN ?
@@ -437,6 +439,8 @@ SEQ_NUM LEFT_CHILD_SEQ_NUM OPERATOR RIGHT_CHILD_SEQ
2 ? TRAFODION_SCAN ?
2 ? TRAFODION_SCAN ?
2 ? TRAFODION_SCAN ?
+ 2 ? TRAFODION_UPDATE ?
+ 3 1 TUPLE_FLOW 2
3 1 TUPLE_FLOW 2
3 2 HYBRID_HASH_JOIN 1
3 2 HYBRID_HASH_JOIN 1
@@ -451,10 +455,11 @@ SEQ_NUM LEFT_CHILD_SEQ_NUM OPERATOR RIGHT_CHILD_SEQ
4 3 ROOT ?
4 3 ROOT ?
4 3 ROOT ?
+ 4 3 ROOT ?
5 4 SORT_GROUPBY ?
6 5 ROOT ?
---- 34 row(s) selected.
+--- 36 row(s) selected.
>>
>>--QUERY 9
>>select
@@ -576,9 +581,11 @@ OPERATOR
------------------------------
ROOT
+TRAFODION_SCAN
TRAFODION_UPDATE
+TUPLE_FLOW
---- 2 row(s) selected.
+--- 4 row(s) selected.
>>
>>--QUERY 16
>>select
[2/4] incubator-trafodion git commit: [TRAFODION-2827] Turn update
costing code on by default
Posted by db...@apache.org.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b1498748/core/sql/regress/seabase/EXPECTED010
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED010 b/core/sql/regress/seabase/EXPECTED010
index d0662c3..a708caf 100644
--- a/core/sql/regress/seabase/EXPECTED010
+++ b/core/sql/regress/seabase/EXPECTED010
@@ -58,7 +58,7 @@
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Thu Oct 19 22:12:21 2017
+-- Definition current Wed Dec 6 19:32:34 2017
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -71,7 +71,7 @@
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:12:22 2017
+-- Definition current Wed Dec 6 19:32:35 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -90,7 +90,7 @@
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:12:23 2017
+-- Definition current Wed Dec 6 19:32:36 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -221,7 +221,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211145371059
+PLAN_ID .................. 212379348758015068
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -263,7 +263,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333366849
+ ObjectUIDs ............. 4521198292213504056
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -304,7 +304,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211145466061
+PLAN_ID .................. 212379348758110922
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -347,7 +347,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333366849
+ ObjectUIDs ............. 4521198292213504056
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -387,7 +387,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211145557099
+PLAN_ID .................. 212379348758213608
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -429,7 +429,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333366849
+ ObjectUIDs ............. 4521198292213504056
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -470,7 +470,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211144533319
+PLAN_ID .................. 212379348757142617
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -513,7 +513,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333366849
+ ObjectUIDs ............. 4521198292213504056
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -815,7 +815,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212375211146540988
+PLAN_ID .................. 212379348759127331
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.08
STATEMENT ................ select *
@@ -860,7 +860,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -894,7 +894,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212375211146661132
+PLAN_ID .................. 212379348759215586
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -940,7 +940,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -975,7 +975,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212375211146790052
+PLAN_ID .................. 212379348759313359
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -1020,7 +1020,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -1055,7 +1055,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212375211146953887
+PLAN_ID .................. 212379348759473659
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ delete from t010t2
@@ -1100,7 +1100,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
input_variables ........ %('a')
@@ -1163,22 +1163,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212375211147208609
+PLAN_ID .................. 212379348759814355
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
STATEMENT ................ update t010t2
set d='upd'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -1209,26 +1208,64 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
input_variables ........ %('upd'), %(4)
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- iud_type ............... trafodion_update TRAFODION.SCH.T010T2
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.06
+EST_TOTAL_COST ........... 0.06
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2
new_rec_expr ........... (D assign %('upd'))
- predicate .............. (C < 2) and ((B = 'a') or (B = 'b'))
- begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>)
- end_key ................ (A = %(4)) and (B = '<max>') and (C = 2)
+ begin_key .............. (A = %(4)) and (B = B) and (C = C)
+ end_key ................ (A = %(4)) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1,#1:2,#1:3
+ key_columns ............ A, B, C
+ executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b'))
+ begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>)
+ end_key ................ (A = %(4)), (B = '<max>'), (C = 2)
--- SQL operation complete.
>>explain y1;
@@ -1236,7 +1273,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212375211147325266
+PLAN_ID .................. 212379348759940311
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.08
STATEMENT ................ select *
@@ -1282,7 +1319,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -1316,7 +1353,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212375211147405399
+PLAN_ID .................. 212379348760022181
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -1363,7 +1400,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -1398,7 +1435,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212375211147531882
+PLAN_ID .................. 212379348760123492
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -1444,7 +1481,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -1479,7 +1516,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212375211147688049
+PLAN_ID .................. 212379348760263677
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ delete from t010t2
@@ -1525,7 +1562,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
input_variables ........ %('a')
@@ -1588,22 +1625,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212375211147942334
+PLAN_ID .................. 212379348760498788
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
STATEMENT ................ update t010t2
set d='uuu'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -1635,26 +1671,64 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333367240
+ ObjectUIDs ............. 4521198292213504650
input_variables ........ %('uuu'), %(4)
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- iud_type ............... trafodion_update TRAFODION.SCH.T010T2
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.06
+EST_TOTAL_COST ........... 0.06
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2
new_rec_expr ........... (D assign %('uuu'))
- predicate .............. (C < 2) and ((B = 'a') or (B = 'b'))
- begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>)
- end_key ................ (A = %(4)) and (B = '<max>') and (C = 2)
+ begin_key .............. (A = %(4)) and (B = B) and (C = C)
+ end_key ................ (A = %(4)) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1,#1:2,#1:3
+ key_columns ............ A, B, C
+ executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b'))
+ begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>)
+ end_key ................ (A = %(4)), (B = '<max>'), (C = 2)
--- SQL operation complete.
>>
@@ -1812,7 +1886,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Thu Oct 19 22:12:54 2017
+-- Definition current Wed Dec 6 19:33:19 2017
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -1825,7 +1899,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:12:54 2017
+-- Definition current Wed Dec 6 19:33:19 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -1844,7 +1918,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:12:54 2017
+-- Definition current Wed Dec 6 19:33:19 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -1975,7 +2049,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211176420764
+PLAN_ID .................. 212379348801469433
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -2017,7 +2091,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370094
+ ObjectUIDs ............. 4521198292213508833
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -2058,7 +2132,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211176519441
+PLAN_ID .................. 212379348801563832
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -2101,7 +2175,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370094
+ ObjectUIDs ............. 4521198292213508833
select_list ............ 1, '1'
@@ -2140,7 +2214,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211176605130
+PLAN_ID .................. 212379348801653115
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -2182,7 +2256,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370094
+ ObjectUIDs ............. 4521198292213508833
select_list ............ TRAFODION.SCH.T010T1.A, '1'
@@ -2222,7 +2296,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211176696337
+PLAN_ID .................. 212379348801748346
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1;
@@ -2265,7 +2339,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370094
+ ObjectUIDs ............. 4521198292213508833
select_list ............ 1, TRAFODION.SCH.T010T1.B
@@ -2528,7 +2602,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212375211179079242
+PLAN_ID .................. 212379348804047667
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2572,7 +2646,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -2607,7 +2681,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212375211179132421
+PLAN_ID .................. 212379348804095280
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2652,7 +2726,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -2700,7 +2774,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212375211179174633
+PLAN_ID .................. 212379348804139169
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2744,7 +2818,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -2783,7 +2857,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212375211179219489
+PLAN_ID .................. 212379348804180409
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -2827,7 +2901,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -2895,22 +2969,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212375211179343865
+PLAN_ID .................. 212379348804296539
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.01
STATEMENT ................ update t010t2
set d='upd'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.01
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -2941,29 +3014,67 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- iud_type ............... trafodion_update TRAFODION.SCH.T010T2
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2
+ new_rec_expr ........... (D assign 'upd')
+ begin_key .............. (A = 4) and (B = B) and (C = C)
+ end_key ................ (A = 4) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
columns ................ all
begin_keys(incl) ....... 4,a,-2147483648
end_keys(excl) ......... 4,a,2
columns ................ all
begin_keys(incl) ....... 4,b,-2147483648
end_keys(excl) ......... 4,b,2
- new_rec_expr ........... (D assign 'upd')
- predicate .............. (C < 2)
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1,#1:2,#1:3
+ key_columns ............ A, B, C
+ executor_predicates .... (A = cast(4))
--- SQL operation complete.
>>explain y1;
@@ -2971,7 +3082,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212375211179430092
+PLAN_ID .................. 212379348804397950
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -3016,7 +3127,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -3052,7 +3163,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212375211179477243
+PLAN_ID .................. 212379348804439860
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -3098,7 +3209,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -3135,7 +3246,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212375211179524021
+PLAN_ID .................. 212379348804483567
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -3180,7 +3291,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -3217,7 +3328,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212375211179568701
+PLAN_ID .................. 212379348804530956
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -3262,7 +3373,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -3327,22 +3438,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212375211179667464
+PLAN_ID .................. 212379348804641427
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.01
STATEMENT ................ update t010t2
set d='uuu'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.01
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -3374,26 +3484,65 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333370450
+ ObjectUIDs ............. 4521198292213509188
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- iud_type ............... trafodion_update TRAFODION.SCH.T010T2
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2
+ new_rec_expr ........... (D assign 'uuu')
+ begin_key .............. (A = 4) and (B = B) and (C = C)
+ end_key ................ (A = 4) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
columns ................ all
begin_keys(incl) ....... 4,,-2147483648
end_keys(incl) ......... 4,??????????,2
- new_rec_expr ........... (D assign 'uuu')
- predicate .............. ((B = 'a') or (B = 'b')) and (C < 2)
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1,#1:2,#1:3
+ key_columns ............ A, B, C
+ executor_predicates .... (A = cast(4)) and ((B = 'a') or (B = 'b')) and (C <
+ 2)
--- SQL operation complete.
>>
@@ -3551,7 +3700,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Thu Oct 19 22:13:32 2017
+-- Definition current Wed Dec 6 19:33:54 2017
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -3564,7 +3713,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:13:32 2017
+-- Definition current Wed Dec 6 19:33:54 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -3583,7 +3732,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:13:32 2017
+-- Definition current Wed Dec 6 19:33:55 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -3714,7 +3863,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211214603886
+PLAN_ID .................. 212379348836829518
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -3756,7 +3905,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333373856
+ ObjectUIDs ............. 4521198292213512245
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -3797,7 +3946,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211214727858
+PLAN_ID .................. 212379348836914056
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -3840,7 +3989,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333373856
+ ObjectUIDs ............. 4521198292213512245
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -3880,7 +4029,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211214827240
+PLAN_ID .................. 212379348837015437
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -3922,7 +4071,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333373856
+ ObjectUIDs ............. 4521198292213512245
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -3963,7 +4112,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211213767413
+PLAN_ID .................. 212379348836007827
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -4006,7 +4155,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333373856
+ ObjectUIDs ............. 4521198292213512245
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -4270,7 +4419,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212375211217409963
+PLAN_ID .................. 212379348839526111
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4314,7 +4463,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -4350,7 +4499,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212375211217459964
+PLAN_ID .................. 212379348839573995
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4395,7 +4544,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4432,7 +4581,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212375211217505716
+PLAN_ID .................. 212379348839649101
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4476,7 +4625,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4513,7 +4662,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212375211217557562
+PLAN_ID .................. 212379348839729420
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -4557,7 +4706,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
input_variables ........ %('a')
@@ -4622,22 +4771,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212375211217660993
+PLAN_ID .................. 212379348839892863
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
STATEMENT ................ update t010t2
set d='upd'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -4668,26 +4816,64 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
input_variables ........ %('upd'), %(4)
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- iud_type ............... trafodion_update TRAFODION.SCH.T010T2
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.06
+EST_TOTAL_COST ........... 0.06
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2
new_rec_expr ........... (D assign %('upd'))
- predicate .............. (C < 2) and ((B = 'a') or (B = 'b'))
- begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>)
- end_key ................ (A = %(4)) and (B = '<max>') and (C = 2)
+ begin_key .............. (A = %(4)) and (B = B) and (C = C)
+ end_key ................ (A = %(4)) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1,#1:2,#1:3
+ key_columns ............ A, B, C
+ executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b'))
+ begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>)
+ end_key ................ (A = %(4)), (B = '<max>'), (C = 2)
--- SQL operation complete.
>>explain y1;
@@ -4695,7 +4881,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212375211217753803
+PLAN_ID .................. 212379348840011934
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4740,7 +4926,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -4776,7 +4962,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212375211217802644
+PLAN_ID .................. 212379348840057206
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4822,7 +5008,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4859,7 +5045,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212375211217854498
+PLAN_ID .................. 212379348840109396
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4904,7 +5090,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4941,7 +5127,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212375211217910650
+PLAN_ID .................. 212379348840159610
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -4986,7 +5172,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
input_variables ........ %('a')
@@ -5051,22 +5237,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212375211218041292
+PLAN_ID .................. 212379348840301376
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
STATEMENT ................ update t010t2
set d='uuu'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -5098,26 +5283,64 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333374241
+ ObjectUIDs ............. 4521198292213512695
input_variables ........ %('uuu'), %(4)
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- iud_type ............... trafodion_update TRAFODION.SCH.T010T2
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.06
+EST_TOTAL_COST ........... 0.06
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2
new_rec_expr ........... (D assign %('uuu'))
- predicate .............. (C < 2) and ((B = 'a') or (B = 'b'))
- begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>)
- end_key ................ (A = %(4)) and (B = '<max>') and (C = 2)
+ begin_key .............. (A = %(4)) and (B = B) and (C = C)
+ end_key ................ (A = %(4)) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1,#1:2,#1:3
+ key_columns ............ A, B, C
+ executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b'))
+ begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>)
+ end_key ................ (A = %(4)), (B = '<max>'), (C = 2)
--- SQL operation complete.
>>
@@ -5275,7 +5498,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Thu Oct 19 22:14:04 2017
+-- Definition current Wed Dec 6 19:34:26 2017
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -5288,7 +5511,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:14:04 2017
+-- Definition current Wed Dec 6 19:34:26 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -5307,7 +5530,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:14:04 2017
+-- Definition current Wed Dec 6 19:34:26 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -5438,7 +5661,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211246332375
+PLAN_ID .................. 212379348868257922
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -5480,7 +5703,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377111
+ ObjectUIDs ............. 4521198292213515531
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -5521,7 +5744,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211246427100
+PLAN_ID .................. 212379348868363894
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -5564,7 +5787,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377111
+ ObjectUIDs ............. 4521198292213515531
select_list ............ 1, '1'
@@ -5603,7 +5826,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211246514744
+PLAN_ID .................. 212379348868464952
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -5645,7 +5868,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377111
+ ObjectUIDs ............. 4521198292213515531
select_list ............ TRAFODION.SCH.T010T1.A, '1'
@@ -5685,7 +5908,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211246603784
+PLAN_ID .................. 212379348868560130
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1;
@@ -5728,7 +5951,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377111
+ ObjectUIDs ............. 4521198292213515531
select_list ............ 1, TRAFODION.SCH.T010T1.B
@@ -6029,7 +6252,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212375211248914713
+PLAN_ID .................. 212379348870927172
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.08
STATEMENT ................ select *
@@ -6074,7 +6297,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -6107,7 +6330,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212375211248990476
+PLAN_ID .................. 212379348871007882
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -6153,7 +6376,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6187,7 +6410,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212375211249093605
+PLAN_ID .................. 212379348871109051
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -6232,7 +6455,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6266,7 +6489,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212375211249243720
+PLAN_ID .................. 212379348871270890
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ delete from t010t2
@@ -6311,7 +6534,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -6373,22 +6596,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212375211249478019
+PLAN_ID .................. 212379348871511759
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.01
STATEMENT ................ update t010t2
set d='upd'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.01
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -6419,29 +6641,65 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- iud_type ............... trafodion_update TRAFODION.SCH.T010T2
- columns ................ all
- begin_keys(incl) ....... 4,a,-2147483648
- end_keys(excl) ......... 4,a,2
- columns ................ all
- begin_keys(incl) ....... 4,b,-2147483648
- end_keys(excl) ......... 4,b,2
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2
new_rec_expr ........... (D assign 'upd')
- predicate .............. (C < 2)
+ begin_key .............. (A = 4) and (B = B) and (C = C)
+ end_key ................ (A = 4) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
+ columns ................ all
+ begin_keys(incl) ....... 4,,-2147483648
+ end_keys(incl) ......... 4,??????????,2
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1,#1:2,#1:3
+ key_columns ............ A, B, C
+ executor_predicates .... ((B = 'a') or (B = 'b')) and (C < 2) and (A =
+ cast(4))
--- SQL operation complete.
>>explain y1;
@@ -6449,7 +6707,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212375211249603770
+PLAN_ID .................. 212379348871620240
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.08
STATEMENT ................ select *
@@ -6495,7 +6753,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -6528,7 +6786,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212375211249685191
+PLAN_ID .................. 212379348871688832
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -6575,7 +6833,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6609,7 +6867,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212375211249786072
+PLAN_ID .................. 212379348871785317
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -6655,7 +6913,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6689,7 +6947,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212375211249940535
+PLAN_ID .................. 212379348871935257
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ delete from t010t2
@@ -6735,7 +6993,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -6797,22 +7055,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212375211250156714
+PLAN_ID .................. 212379348872142593
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.01
STATEMENT ................ update t010t2
set d='uuu'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.01
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -6844,26 +7101,65 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333377468
+ ObjectUIDs ............. 4521198292213515889
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- iud_type ............... trafodion_update TRAFODION.SCH.T010T2
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_VSBB_UPDATE ===================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ iud_type ............... trafodion_vsbb_update TRAFODION.SCH.T010T2
+ new_rec_expr ........... (D assign 'uuu')
+ begin_key .............. (A = 4) and (B = B) and (C = C)
+ end_key ................ (A = 4) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
columns ................ all
begin_keys(incl) ....... 4,,-2147483648
end_keys(incl) ......... 4,??????????,2
- new_rec_expr ........... (D assign 'uuu')
- predicate .............. ((B = 'a') or (B = 'b')) and (C < 2)
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1,#1:2,#1:3
+ key_columns ............ A, B, C
+ executor_predicates .... ((B = 'a') or (B = 'b')) and (C < 2) and (A =
+ cast(4))
--- SQL operation complete.
>>
@@ -7044,7 +7340,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Thu Oct 19 22:14:41 2017
+-- Definition current Wed Dec 6 19:35:08 2017
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -7057,7 +7353,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:14:41 2017
+-- Definition current Wed Dec 6 19:35:08 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -7076,7 +7372,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:14:42 2017
+-- Definition current Wed Dec 6 19:35:08 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -7207,7 +7503,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211283939586
+PLAN_ID .................. 212379348910114619
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -7249,7 +7545,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380547
+ ObjectUIDs ............. 4521198292213519441
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -7290,7 +7586,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211284071529
+PLAN_ID .................. 212379348910196043
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -7333,7 +7629,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380547
+ ObjectUIDs ............. 4521198292213519441
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -7373,7 +7669,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211284182877
+PLAN_ID .................. 212379348910294783
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -7415,7 +7711,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380547
+ ObjectUIDs ............. 4521198292213519441
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -7456,7 +7752,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212375211283074993
+PLAN_ID .................. 212379348909321835
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -7499,7 +7795,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380547
+ ObjectUIDs ............. 4521198292213519441
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -7801,7 +8097,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212375211286758015
+PLAN_ID .................. 212379348912742892
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.08
STATEMENT ................ select *
@@ -7846,7 +8142,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -7880,7 +8176,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212375211286838992
+PLAN_ID .................. 212379348912824948
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -7926,7 +8222,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -7961,7 +8257,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212375211286932222
+PLAN_ID .................. 212379348912933016
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -8006,7 +8302,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -8041,7 +8337,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212375211287075899
+PLAN_ID .................. 212379348913060022
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ delete from t010t2
@@ -8086,7 +8382,7 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
input_variables ........ %('a')
@@ -8149,22 +8445,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212375211287292325
+PLAN_ID .................. 212379348913273694
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
STATEMENT ................ update t010t2
set d='upd'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -8195,26 +8490,64 @@ DESCRIPTION
TRAF_ALIGNED_ROW_FORMAT ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
input_variables ........ %('upd'), %(4)
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_UPDATE ========================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.06
+EST_TOTAL_COST ........... 0.06
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
iud_type ............... trafodion_update TRAFODION.SCH.T010T2
new_rec_expr ........... (D assign %('upd'))
- predicate .............. (C < 2) and ((B = 'a') or (B = 'b'))
- begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>)
- end_key ................ (A = %(4)) and (B = '<max>') and (C = 2)
+ begin_key .............. (A = %(4)) and (B = B) and (C = C)
+ end_key ................ (A = %(4)) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1
+ key_columns ............ A, B, C
+ executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b'))
+ begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>)
+ end_key ................ (A = %(4)), (B = '<max>'), (C = 2)
--- SQL operation complete.
>>explain y1;
@@ -8222,7 +8555,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212375211287404754
+PLAN_ID .................. 212379348913400087
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.08
STATEMENT ................ select *
@@ -8268,7 +8601,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -8302,7 +8635,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212375211287492474
+PLAN_ID .................. 212379348913480479
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -8349,7 +8682,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -8384,7 +8717,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212375211287598527
+PLAN_ID .................. 212379348913571313
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ select *
@@ -8430,7 +8763,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -8465,7 +8798,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212375211287756111
+PLAN_ID .................. 212379348913717936
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.11
STATEMENT ................ delete from t010t2
@@ -8511,7 +8844,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
input_variables ........ %('a')
@@ -8574,22 +8907,21 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212375211287956918
+PLAN_ID .................. 212379348913944078
ROWS_OUT ................. 2
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
STATEMENT ................ update t010t2
set d='uuu'
where a=4 and b in ('a', 'b') and c < 2;
------------------------------------------------------------------ NODE LISTING
-ROOT ====================================== SEQ_NO 2 ONLY CHILD 1
+ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
- olt_optimization ....... used
est_memory_per_node .... 10240.00(Limit), 0.00(BMOs), 0.00(nBMOs) MB
max_card_est ........... 2
fragment_id ............ 0
@@ -8621,26 +8953,64 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 5140439103333380976
+ ObjectUIDs ............. 4521198292213519805
input_variables ........ %('uuu'), %(4)
-TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
-TABLE_NAME ............... TRAFODION.SCH.T010T2
+TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 2
-EST_OPER_COST ............ 0
-EST_TOTAL_COST ........... 0
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.06
DESCRIPTION
max_card_est ........... 2
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
+ join_type .............. inner
+ join_method ............ in-order nested
+
+
+TRAFODION_UPDATE ========================== SEQ_NO 2 NO CHILDREN
+TABLE_NAME ............... TRAFODION.SCH.T010T2
+REQUESTS_IN .............. 2
+ROWS/REQUEST ............. 1
+EST_OPER_COST ............ 0.06
+EST_TOTAL_COST ........... 0.06
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
iud_type ............... trafodion_update TRAFODION.SCH.T010T2
new_rec_expr ........... (D assign %('uuu'))
- predicate .............. (C < 2) and ((B = 'a') or (B = 'b'))
- begin_key .............. (A = %(4)) and (B = '<min>') and (C = <min>)
- end_key ................ (A = %(4)) and (B = '<max>') and (C = 2)
+ begin_key .............. (A = %(4)) and (B = B) and (C = C)
+ end_key ................ (A = %(4)) and (B = B) and (C = C)
+
+
+TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
+TABLE_NAME ............... T010T2
+REQUESTS_IN .............. 1
+ROWS_OUT ................. 2
+EST_OPER_COST ............ 0.01
+EST_TOTAL_COST ........... 0.01
+DESCRIPTION
+ max_card_est .......... 50
+ fragment_id ............ 0
+ parent_frag ............ (none)
+ fragment_type .......... master
+ scan_type .............. subset scan of table TRAFODION.SCH.T010T2
+ object_type ............ Trafodion
+ cache_size ........... 100
+ cache_blocks ........... ON
+ small_scanner .......... ON
+ probes ................. 1
+ rows_accessed ......... 10
+ column_retrieved ....... #1:1
+ key_columns ............ A, B, C
+ executor_predicates .... (C < 2) and (A = %(4)) and ((B = 'a') or (B = 'b'))
+ begin_key .............. (A = %(4)), (B = '<min>'), (C = <min>)
+ end_key ................ (A = %(4)), (B = '<max>'), (C = 2)
--- SQL operation complete.
>>
@@ -8798,7 +9168,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Thu Oct 19 22:15:18 2017
+-- Definition current Wed Dec 6 19:35:43 2017
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -8811,7 +9181,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:15:19 2017
+-- Definition current Wed Dec 6 19:35:43 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -8830,7 +9200,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Thu Oct 19 22:15:19 2017
+-- Definition current Wed Dec 6 19:35:43 2017
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -8961,7 +9331,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
-------------------------------------------------------
<TRUNCATED>