You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2015/08/28 01:07:40 UTC
[1/2] incubator-trafodion git commit: fix #JIRA 1449: missing end key.
Repository: incubator-trafodion
Updated Branches:
refs/heads/master c7b4b1205 -> c5c516e05
fix #JIRA 1449: missing end key.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/f95b46eb
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/f95b46eb
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/f95b46eb
Branch: refs/heads/master
Commit: f95b46eb824c89d3628b026d10689dec10444787
Parents: 5928f31
Author: Qifan Chen <qf...@dev02.trafodion.org>
Authored: Thu Aug 27 03:56:32 2015 +0000
Committer: Qifan Chen <qf...@dev02.trafodion.org>
Committed: Thu Aug 27 03:56:32 2015 +0000
----------------------------------------------------------------------
core/sql/generator/GenPreCode.cpp | 18 +-
core/sql/optimizer/SearchKey.cpp | 64 ++++
core/sql/optimizer/SearchKey.h | 20 +-
core/sql/optimizer/SimpleScanOptimizer.cpp | 23 +-
core/sql/optimizer/disjuncts.h | 8 +-
core/sql/optimizer/mdam.cpp | 40 +--
core/sql/regress/seabase/EXPECTED010 | 379 ++++++++++++------------
7 files changed, 320 insertions(+), 232 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f95b46eb/core/sql/generator/GenPreCode.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenPreCode.cpp b/core/sql/generator/GenPreCode.cpp
index 7daa0c8..d374eb3 100644
--- a/core/sql/generator/GenPreCode.cpp
+++ b/core/sql/generator/GenPreCode.cpp
@@ -154,15 +154,19 @@ static NABoolean processConstHBaseKeys(Generator * generator,
// convert built-in search key to entries with constants, if possible
if (skey->areAllKeysConstants(TRUE))
{
- ValueIdSet exePreds;
ValueIdSet nonKeyColumnSet;
idesc->getNonKeyColumnSet(nonKeyColumnSet);
- // seed exePreds with all predicates, key and non-key
- // they will be reduced by the method below
- skey->getKeyPredicates(exePreds);
+ // seed keyPreds with only the full key predicate from skey
+ ValueIdSet keyPreds = skey->getFullKeyPredicates();
+
+ // include executorPreds and selection predicates
+ // but exclude the full key predicates.
+ ValueIdSet exePreds;
+
exePreds += executorPreds;
exePreds += relExpr->getSelectionPred();
+ exePreds.subtractSet(keyPreds);
HbaseSearchKey::makeHBaseSearchKeys(
skey,
@@ -170,12 +174,16 @@ static NABoolean processConstHBaseKeys(Generator * generator,
skey->getIndexDesc()->getOrderOfKeyValues(),
relExpr->getGroupAttr()->getCharacteristicInputs(),
TRUE, /* forward scan */
- exePreds,
+ keyPreds,
nonKeyColumnSet,
idesc,
relExpr->getGroupAttr()->getCharacteristicOutputs(),
mySearchKeys);
+ // Include any remaining key predicates that have not been
+ // picked up (to be used as the HBase search keys).
+ exePreds += keyPreds;
+
TableDesc *tdesc = NULL;
if (mySearchKeys.entries()>0)
{
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f95b46eb/core/sql/optimizer/SearchKey.cpp
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/SearchKey.cpp b/core/sql/optimizer/SearchKey.cpp
index d10ce27..3902394 100644
--- a/core/sql/optimizer/SearchKey.cpp
+++ b/core/sql/optimizer/SearchKey.cpp
@@ -201,6 +201,11 @@ void SearchKey::init(const ValueIdList & keyColumns,
);
+ // Find any full key predicate in setOfPredicates that refers
+ // to a key column and save the result in fullKeyPredicates_.
+ computeFullKeyPredicates(setOfPredicates);
+
+
// We do not want to remove the predicates which have two constants
// in their VEG. These should be evaluated like any other predicate.
@@ -2711,6 +2716,65 @@ void SearchKey::computeCoveredLeadingKeys()
}
}
+void SearchKey::computeFullKeyPredicates(ValueIdSet& predicates)
+{
+ // If the key column is an INDEX COLUMN, convert it into a base column
+ ValueIdList baseKeyCols;
+
+ ValueId vid;
+ const ValueIdList& keyColumns = getKeyColumns();
+ for (CollIndex i=0; i<keyColumns.entries(); i++ ) {
+ if ( keyColumns[i].getItemExpr()->getOperatorType() == ITM_INDEXCOLUMN )
+ vid = ((IndexColumn*)(keyColumns[i].getItemExpr()))->getDefinition();
+ else
+ vid = keyColumns[i];
+
+ baseKeyCols.insertAt(baseKeyCols.entries(), vid);
+ }
+
+ // compute the # of leading key columns covered by the key columns
+ // in the disjunct.
+ ValueIdSet columnsCoveredByKey;
+
+ vid = predicates.init();
+ for (; predicates.next(vid); predicates.advance(vid)) {
+
+ columnsCoveredByKey.clear();
+ vid.getItemExpr()->findAll(ITM_BASECOLUMN, columnsCoveredByKey, TRUE, TRUE);
+
+ // for each vid (or predicate), check the base column list
+ for (CollIndex i=0; i<baseKeyCols.entries(); i++ ) {
+
+ NABoolean found = FALSE;
+
+ // the predicate directly refers the base column
+ if ( columnsCoveredByKey.containsTheGivenValue(baseKeyCols[i]) ) {
+ fullKeyPredicates_ += vid;
+ found = TRUE;
+ } else {
+ // do a search by column position
+ BaseColumn* keyCol = (BaseColumn*)(baseKeyCols[i].getItemExpr());
+
+
+ ValueId cvid = columnsCoveredByKey.init();
+ for (; columnsCoveredByKey.next(cvid); columnsCoveredByKey.advance(cvid)) {
+ BaseColumn* colInKeyPred = (BaseColumn*)(cvid.getItemExpr());
+
+ // the key column in the predicate is the same as the base column
+ if ( keyCol->getColNumber() == colInKeyPred->getColNumber() ) {
+ fullKeyPredicates_ += vid;
+ found = TRUE;
+ break;
+ }
+ }
+ }
+
+ if ( found )
+ break;
+ }
+ }
+}
+
// ---------------------------------------------------------------------------
// Take a set of predicates and make one or more HBase search keys from it.
// Parameters are the same as for HbaseSearchKey constructor, with the
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f95b46eb/core/sql/optimizer/SearchKey.h
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/SearchKey.h b/core/sql/optimizer/SearchKey.h
index 6a797bc..1a684d1 100644
--- a/core/sql/optimizer/SearchKey.h
+++ b/core/sql/optimizer/SearchKey.h
@@ -307,6 +307,8 @@ public:
{ return keyPredicates_; }
ValueIdSet & keyPredicates() { return keyPredicates_; }
+ const ValueIdSet & getFullKeyPredicates() const { return fullKeyPredicates_; }
+
// ---------------------------------------------------------------------
// Method for determining whether the key predicates are unique.
// ---------------------------------------------------------------------
@@ -331,6 +333,7 @@ public:
// scan's selection predicates:
void getKeyPredicatesByColumn(ColumnOrderList& colOrdLis,
CollIndex disjunctNumber = 0) const;
+
// Obtain the set of key predicates in the disjunct:
//for SearchKey allKeyPredicates and disjunctNumber are
//insignificant, but the signature of the function had to
@@ -382,6 +385,7 @@ public:
protected:
void computeCoveredLeadingKeys();
+ void computeFullKeyPredicates(ValueIdSet& predicates);
private:
@@ -400,10 +404,24 @@ private:
ValueIdList endKeyValues_;
// -----------------------------------------------------------------------
- // The set of key predicates
+ // The set of key predicates that are derived from the common predicate,
+ // computed by computeCommonPredicates() and is an intersection of all
+ // predicates in DisjunctArray). During the computation, the range spec is
+ // examined and only those NOT in OR form are included in the common
+ // predicate. For example, the IN list in the following query is an OR
+ // predicate,
+ // select * from t010t2 where a in (1,4) and b='a' and c = 1;
+ // the predicate "a in (1,4)" will not be part of the common predicate.
// -----------------------------------------------------------------------
ValueIdSet keyPredicates_;
+ // -----------------------------------------------------------------------
+ // The set of full key predicates that are derived from the selection
+ // predicates. This set includes every predicate that refers to any key
+ // columns.
+ // -----------------------------------------------------------------------
+ ValueIdSet fullKeyPredicates_;
+
// ---------------------------------------------------------------------
// Boolean indicating whether key predicates formulate a unique key.
// ---------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f95b46eb/core/sql/optimizer/SimpleScanOptimizer.cpp
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/SimpleScanOptimizer.cpp b/core/sql/optimizer/SimpleScanOptimizer.cpp
index d1b766a..133f9e2 100644
--- a/core/sql/optimizer/SimpleScanOptimizer.cpp
+++ b/core/sql/optimizer/SimpleScanOptimizer.cpp
@@ -218,25 +218,14 @@ SimpleFileScanOptimizer::isLogicalSubPartitioned() const
SearchKey *
SimpleFileScanOptimizer::constructSearchKey()
{
+ // We do not need to incude the flatten version of RANGE SPEC predicates
+ // to the exePreds because SearchKey is capable of handling such predicates.
+ // In addition, we do not want to confuse the SearchKey::ini() method
+ // about what are the original predicates and what are derived predicates,
+ // since combing these two forms will confuse SearchKey::makeHBaseSearchKey()
+ // and cause the missing of the end keys (JIRA1449).
ValueIdSet exePreds(getRelExpr().getSelectionPred());
- ValueIdList selectionPredList(exePreds);
- ItemExpr *inputItemExprTree;
- if((CmpCommon::getDefault(RANGESPEC_TRANSFORMATION) == DF_ON )
- && ( exePreds.entries())){
- ValueIdSet resultSet;
- inputItemExprTree = selectionPredList.rebuildExprTree(ITM_AND,FALSE,FALSE);
- ItemExpr* resultOld = revertBackToOldTree(CmpCommon::statementHeap(),
- inputItemExprTree);
-// revertBackToOldTreeUsingValueIdSet(exePreds, resultSet);
-// exePreds.clear();
-// ItemExpr* resultOld = resultSet.rebuildExprTree(ITM_AND,FALSE,FALSE);
-// exePreds += resultSet;
-// doNotReplaceAnItemExpressionForLikePredicates(resultOld,exePreds,resultOld);
- resultOld->convertToValueIdSet(exePreds, NULL, ITM_AND, FALSE);
- doNotReplaceAnItemExpressionForLikePredicates(resultOld,exePreds,resultOld);
- }
-
const Disjuncts *curDisjuncts = &(getDisjuncts());
if(isLogicalSubPartitioned()) {
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f95b46eb/core/sql/optimizer/disjuncts.h
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/disjuncts.h b/core/sql/optimizer/disjuncts.h
index ed423e5..d14f4af 100644
--- a/core/sql/optimizer/disjuncts.h
+++ b/core/sql/optimizer/disjuncts.h
@@ -104,7 +104,13 @@ public:
private:
void createDisjunctArray(const ValueIdSet& selectionPredicates);
-
+ // An array of disjuncts created by calling createDisjunctArray().
+ // The main functionality of that method is to call mdamTreeWalk() on
+ // ItemExpr and convert the predicates into disjunctive normal form.
+ // Note that for a RANGE SPEC itemExpr, only predicates NOT in OR
+ // forms can be processed. Also, the mdam tree walk has a
+ // threshold of 256 * 8 = 2000 disjuncts that are allowed in the array.
+ // Beyond that, a NULL is returned.
DisjunctArray *disjunctArrayPtr_;
}; // class MaterialDisjuncts
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f95b46eb/core/sql/optimizer/mdam.cpp
----------------------------------------------------------------------
diff --git a/core/sql/optimizer/mdam.cpp b/core/sql/optimizer/mdam.cpp
index ab0f1a4..0ee3563 100644
--- a/core/sql/optimizer/mdam.cpp
+++ b/core/sql/optimizer/mdam.cpp
@@ -2007,39 +2007,39 @@ void Disjuncts::computeCommonPredicates()
get(disjunct,i);
if(CmpCommon::getDefault(RANGESPEC_TRANSFORMATION) == DF_ON )
{
- ValueIdSet inVidset = disjunct.getAsValueIdSet();
- ValueIdSet outVidset,parsedVs;
- for (ValueId predId = inVidset.init();
- inVidset.next(predId);
- inVidset.advance(predId) )
- {
- if(predId.getItemExpr()->getOperatorType() == ITM_RANGE_SPEC_FUNC )
- {
- if(predId.getItemExpr()->child(1)->getOperatorType() == ITM_AND ){
- predId.getItemExpr()->child(1)->convertToValueIdSet(parsedVs, NULL, ITM_AND, FALSE);
+ ValueIdSet inVidset = disjunct.getAsValueIdSet();
+ ValueIdSet outVidset,parsedVs;
+ for (ValueId predId = inVidset.init();
+ inVidset.next(predId);
+ inVidset.advance(predId) )
+ {
+ if(predId.getItemExpr()->getOperatorType() == ITM_RANGE_SPEC_FUNC )
+ {
+ if(predId.getItemExpr()->child(1)->getOperatorType() == ITM_AND ){
+ predId.getItemExpr()->child(1)->convertToValueIdSet(parsedVs, NULL, ITM_AND, FALSE);
outVidset +=parsedVs;
- }
- else if(predId.getItemExpr()->child(1)->getOperatorType() != ITM_AND
+ }
+ else if(predId.getItemExpr()->child(1)->getOperatorType() != ITM_AND
&& predId.getItemExpr()->child(1)->getOperatorType() != ITM_OR)
- outVidset += predId.getItemExpr()->child(1)->castToItemExpr()->getValueId();
- }
+ outVidset += predId.getItemExpr()->child(1)->castToItemExpr()->getValueId();
+ }
else
- outVidset +=predId;
- parsedVs.clear();
+ outVidset +=predId;
+ parsedVs.clear();
}
if (i==0)
commonPredicates_.insert(outVidset);
else
commonPredicates_.intersectSet(outVidset);
- }
- else
- {
+ }
+ else
+ {
if (i==0)
commonPredicates_.insert(disjunct.getAsValueIdSet());
else
commonPredicates_.intersectSet(disjunct.getAsValueIdSet());
- }
+ }
}
}
} // Disjuncts::computeCommonPredicates(..)
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/f95b46eb/core/sql/regress/seabase/EXPECTED010
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED010 b/core/sql/regress/seabase/EXPECTED010
index 718c259..99324cc 100644
--- a/core/sql/regress/seabase/EXPECTED010
+++ b/core/sql/regress/seabase/EXPECTED010
@@ -55,7 +55,7 @@
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Wed May 27 00:18:12 2015
+-- Definition current Wed Aug 26 14:20:46 2015
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -67,7 +67,7 @@
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:18:12 2015
+-- Definition current Wed Aug 26 14:20:46 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -85,7 +85,7 @@
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:18:12 2015
+-- Definition current Wed Aug 26 14:20:46 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -201,7 +201,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471093611281
+PLAN_ID .................. 212307358847491196
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -242,7 +242,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223724
+ ObjectUIDs ............. 2718560551442843779
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -280,7 +280,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471093661990
+PLAN_ID .................. 212307358847573976
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -322,7 +322,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223724
+ ObjectUIDs ............. 2718560551442843779
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -359,7 +359,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471093715550
+PLAN_ID .................. 212307358847671340
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -400,7 +400,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223724
+ ObjectUIDs ............. 2718560551442843779
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -438,7 +438,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471093434704
+PLAN_ID .................. 212307358847221846
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -480,7 +480,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223724
+ ObjectUIDs ............. 2718560551442843779
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -741,7 +741,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212299471096327562
+PLAN_ID .................. 212307358850999891
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -784,7 +784,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -816,7 +816,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212299471096382061
+PLAN_ID .................. 212307358851062623
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -860,7 +860,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -893,7 +893,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212299471096444859
+PLAN_ID .................. 212307358851146217
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -936,7 +936,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -969,7 +969,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212299471096503826
+PLAN_ID .................. 212307358851223200
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -1012,7 +1012,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
input_variables ........ %('a')
@@ -1074,7 +1074,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212299471096637126
+PLAN_ID .................. 212307358851540757
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -1119,7 +1119,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
input_variables ........ %('upd'), %(4)
@@ -1146,7 +1146,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212299471096698653
+PLAN_ID .................. 212307358851635674
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -1190,7 +1190,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -1222,7 +1222,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212299471096749409
+PLAN_ID .................. 212307358851697502
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -1267,7 +1267,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -1300,7 +1300,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212299471096813776
+PLAN_ID .................. 212307358851804097
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -1344,7 +1344,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -1377,7 +1377,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212299471096874312
+PLAN_ID .................. 212307358851887594
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -1421,7 +1421,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
input_variables ........ %('a')
@@ -1483,7 +1483,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212299471096978847
+PLAN_ID .................. 212307358852059650
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -1529,7 +1529,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437223802
+ ObjectUIDs ............. 2718560551442843847
input_variables ........ %('uuu'), %(4)
@@ -1706,7 +1706,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Wed May 27 00:18:38 2015
+-- Definition current Wed Aug 26 14:21:10 2015
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -1718,7 +1718,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:18:38 2015
+-- Definition current Wed Aug 26 14:21:10 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -1736,7 +1736,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:18:38 2015
+-- Definition current Wed Aug 26 14:21:10 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -1852,7 +1852,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471119164315
+PLAN_ID .................. 212307358871281586
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -1893,7 +1893,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226364
+ ObjectUIDs ............. 2718560551442846284
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -1931,7 +1931,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471119215657
+PLAN_ID .................. 212307358871371752
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -1973,7 +1973,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226364
+ ObjectUIDs ............. 2718560551442846284
select_list ............ 1, '1'
@@ -2009,7 +2009,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471119265219
+PLAN_ID .................. 212307358871439620
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -2050,7 +2050,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226364
+ ObjectUIDs ............. 2718560551442846284
select_list ............ TRAFODION.SCH.T010T1.A, '1'
@@ -2087,7 +2087,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471119313814
+PLAN_ID .................. 212307358871511925
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1;
@@ -2129,7 +2129,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226364
+ ObjectUIDs ............. 2718560551442846284
select_list ............ 1, TRAFODION.SCH.T010T1.B
@@ -2389,7 +2389,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212299471121578704
+PLAN_ID .................. 212307358874528802
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2432,7 +2432,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -2464,7 +2464,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212299471121611308
+PLAN_ID .................. 212307358874570968
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2508,7 +2508,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -2553,7 +2553,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212299471121643583
+PLAN_ID .................. 212307358874620154
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2596,7 +2596,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -2632,7 +2632,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212299471121675508
+PLAN_ID .................. 212307358874662337
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -2675,7 +2675,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -2740,7 +2740,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212299471121732276
+PLAN_ID .................. 212307358874758636
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -2785,7 +2785,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -2807,6 +2807,7 @@ DESCRIPTION
begin_keys(incl) ....... 4,b,-2147483648
end_keys(excl) ......... 4,b,2
new_rec_expr ........... (D assign 'upd')
+ predicate .............. (C < 2)
--- SQL operation complete.
>>explain y1;
@@ -2814,7 +2815,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212299471121783919
+PLAN_ID .................. 212307358874831705
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2858,7 +2859,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -2891,7 +2892,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212299471121817657
+PLAN_ID .................. 212307358874979812
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2936,7 +2937,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -2970,7 +2971,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212299471121849909
+PLAN_ID .................. 212307358875044999
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -3014,7 +3015,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -3048,7 +3049,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212299471121885273
+PLAN_ID .................. 212307358875092141
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -3092,7 +3093,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -3154,7 +3155,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212299471121942892
+PLAN_ID .................. 212307358875177750
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -3200,7 +3201,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437226462
+ ObjectUIDs ............. 2718560551442846338
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -3377,7 +3378,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Wed May 27 00:19:04 2015
+-- Definition current Wed Aug 26 14:21:36 2015
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -3389,7 +3390,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:19:04 2015
+-- Definition current Wed Aug 26 14:21:36 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -3407,7 +3408,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:19:04 2015
+-- Definition current Wed Aug 26 14:21:36 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -3523,7 +3524,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471144660436
+PLAN_ID .................. 212307358897173143
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -3564,7 +3565,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437228949
+ ObjectUIDs ............. 2718560551442848878
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -3602,7 +3603,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471144712283
+PLAN_ID .................. 212307358897259828
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -3644,7 +3645,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437228949
+ ObjectUIDs ............. 2718560551442848878
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -3681,7 +3682,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471144761726
+PLAN_ID .................. 212307358897318165
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -3722,7 +3723,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437228949
+ ObjectUIDs ............. 2718560551442848878
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -3760,7 +3761,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471144508022
+PLAN_ID .................. 212307358896950116
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -3802,7 +3803,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437228949
+ ObjectUIDs ............. 2718560551442848878
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -4063,7 +4064,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212299471146943995
+PLAN_ID .................. 212307358900563464
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4106,7 +4107,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -4139,7 +4140,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212299471146979601
+PLAN_ID .................. 212307358900604767
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4183,7 +4184,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4217,7 +4218,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212299471147013790
+PLAN_ID .................. 212307358900666113
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4260,7 +4261,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4294,7 +4295,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212299471147049449
+PLAN_ID .................. 212307358900716273
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -4337,7 +4338,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
input_variables ........ %('a')
@@ -4399,7 +4400,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212299471147114607
+PLAN_ID .................. 212307358900811033
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -4444,7 +4445,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
input_variables ........ %('upd'), %(4)
@@ -4471,7 +4472,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212299471147168801
+PLAN_ID .................. 212307358900886538
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4515,7 +4516,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -4548,7 +4549,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212299471147203181
+PLAN_ID .................. 212307358900944443
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4593,7 +4594,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4627,7 +4628,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212299471147236612
+PLAN_ID .................. 212307358900984587
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4671,7 +4672,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4705,7 +4706,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212299471147272579
+PLAN_ID .................. 212307358901053244
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -4749,7 +4750,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
input_variables ........ %('a')
@@ -4811,7 +4812,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212299471147333576
+PLAN_ID .................. 212307358901146111
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -4857,7 +4858,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437229017
+ ObjectUIDs ............. 2718560551442848936
input_variables ........ %('uuu'), %(4)
@@ -5034,7 +5035,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Wed May 27 00:19:25 2015
+-- Definition current Wed Aug 26 14:22:00 2015
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -5046,7 +5047,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:19:25 2015
+-- Definition current Wed Aug 26 14:22:00 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -5064,7 +5065,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:19:25 2015
+-- Definition current Wed Aug 26 14:22:00 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -5180,7 +5181,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471166383911
+PLAN_ID .................. 212307358920780905
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -5221,7 +5222,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231080
+ ObjectUIDs ............. 2718560551442851160
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -5259,7 +5260,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471166434885
+PLAN_ID .................. 212307358920861166
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -5301,7 +5302,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231080
+ ObjectUIDs ............. 2718560551442851160
select_list ............ 1, '1'
@@ -5337,7 +5338,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471166482747
+PLAN_ID .................. 212307358920922135
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -5378,7 +5379,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231080
+ ObjectUIDs ............. 2718560551442851160
select_list ............ TRAFODION.SCH.T010T1.A, '1'
@@ -5415,7 +5416,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471166530637
+PLAN_ID .................. 212307358920997485
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1;
@@ -5457,7 +5458,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231080
+ ObjectUIDs ............. 2718560551442851160
select_list ............ 1, TRAFODION.SCH.T010T1.B
@@ -5717,7 +5718,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212299471168596235
+PLAN_ID .................. 212307358924294992
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -5760,7 +5761,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -5791,7 +5792,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212299471168641744
+PLAN_ID .................. 212307358924353978
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -5835,7 +5836,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -5867,7 +5868,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212299471168695906
+PLAN_ID .................. 212307358924425348
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -5910,7 +5911,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -5942,7 +5943,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212299471168754574
+PLAN_ID .................. 212307358924508589
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -5985,7 +5986,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -6046,7 +6047,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212299471168844724
+PLAN_ID .................. 212307358924643800
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -6091,7 +6092,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -6113,6 +6114,7 @@ DESCRIPTION
begin_keys(incl) ....... 4,b,-2147483648
end_keys(excl) ......... 4,b,2
new_rec_expr ........... (D assign 'upd')
+ predicate .............. (C < 2)
--- SQL operation complete.
>>explain y1;
@@ -6120,7 +6122,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212299471168896538
+PLAN_ID .................. 212307358924711974
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -6164,7 +6166,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -6195,7 +6197,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212299471168941452
+PLAN_ID .................. 212307358924768400
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -6240,7 +6242,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6272,7 +6274,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212299471168991472
+PLAN_ID .................. 212307358924843154
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -6316,7 +6318,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6348,7 +6350,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212299471169046951
+PLAN_ID .................. 212307358924911236
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -6392,7 +6394,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -6453,7 +6455,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212299471169131646
+PLAN_ID .................. 212307358925069228
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -6499,7 +6501,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437231197
+ ObjectUIDs ............. 2718560551442851266
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -6696,7 +6698,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Wed May 27 00:19:50 2015
+-- Definition current Wed Aug 26 14:22:24 2015
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -6708,7 +6710,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:19:50 2015
+-- Definition current Wed Aug 26 14:22:24 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -6726,7 +6728,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:19:50 2015
+-- Definition current Wed Aug 26 14:22:24 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -6842,7 +6844,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471190555749
+PLAN_ID .................. 212307358945000630
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -6883,7 +6885,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233568
+ ObjectUIDs ............. 2718560551442853599
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -6921,7 +6923,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471190606309
+PLAN_ID .................. 212307358945073270
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -6963,7 +6965,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233568
+ ObjectUIDs ............. 2718560551442853599
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -7000,7 +7002,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471190653260
+PLAN_ID .................. 212307358945169910
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -7041,7 +7043,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233568
+ ObjectUIDs ............. 2718560551442853599
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -7079,7 +7081,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471190408347
+PLAN_ID .................. 212307358944790567
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -7121,7 +7123,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233568
+ ObjectUIDs ............. 2718560551442853599
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -7382,7 +7384,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212299471192801843
+PLAN_ID .................. 212307358948105922
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7425,7 +7427,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -7457,7 +7459,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212299471192844713
+PLAN_ID .................. 212307358948168410
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7501,7 +7503,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -7534,7 +7536,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212299471192895874
+PLAN_ID .................. 212307358948251382
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7577,7 +7579,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -7610,7 +7612,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212299471192946876
+PLAN_ID .................. 212307358948325532
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -7653,7 +7655,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
input_variables ........ %('a')
@@ -7714,7 +7716,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212299471193048121
+PLAN_ID .................. 212307358948509466
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -7759,7 +7761,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
input_variables ........ %('upd'), %(4)
@@ -7786,7 +7788,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212299471193099896
+PLAN_ID .................. 212307358948587307
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7830,7 +7832,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -7862,7 +7864,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212299471193140077
+PLAN_ID .................. 212307358948668856
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7907,7 +7909,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -7940,7 +7942,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212299471193188067
+PLAN_ID .................. 212307358948765443
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7984,7 +7986,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -8017,7 +8019,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212299471193237767
+PLAN_ID .................. 212307358948871492
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -8061,7 +8063,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
input_variables ........ %('a')
@@ -8122,7 +8124,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212299471193326623
+PLAN_ID .................. 212307358949044019
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -8168,7 +8170,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437233637
+ ObjectUIDs ............. 2718560551442853711
input_variables ........ %('uuu'), %(4)
@@ -8345,7 +8347,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Wed May 27 00:20:13 2015
+-- Definition current Wed Aug 26 14:22:47 2015
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -8357,7 +8359,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:20:13 2015
+-- Definition current Wed Aug 26 14:22:47 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -8375,7 +8377,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Wed May 27 00:20:13 2015
+-- Definition current Wed Aug 26 14:22:47 2015
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -8491,7 +8493,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471214427740
+PLAN_ID .................. 212307358968146345
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -8532,7 +8534,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437235965
+ ObjectUIDs ............. 2718560551442855996
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -8570,7 +8572,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471214475553
+PLAN_ID .................. 212307358968213378
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -8612,7 +8614,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437235965
+ ObjectUIDs ............. 2718560551442855996
select_list ............ 1, '1'
@@ -8648,7 +8650,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471214520721
+PLAN_ID .................. 212307358968298478
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -8689,7 +8691,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437235965
+ ObjectUIDs ............. 2718560551442855996
select_list ............ TRAFODION.SCH.T010T1.A, '1'
@@ -8726,7 +8728,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212299471214566535
+PLAN_ID .................. 212307358968363288
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1;
@@ -8768,7 +8770,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437235965
+ ObjectUIDs ............. 2718560551442855996
select_list ............ 1, TRAFODION.SCH.T010T1.B
@@ -9028,7 +9030,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212299471216646050
+PLAN_ID .................. 212307358971925802
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9071,7 +9073,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -9102,7 +9104,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212299471216690874
+PLAN_ID .................. 212307358971986764
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9146,7 +9148,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -9178,7 +9180,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212299471216744884
+PLAN_ID .................. 212307358972085527
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9221,7 +9223,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -9253,7 +9255,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212299471216799063
+PLAN_ID .................. 212307358972169061
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -9296,7 +9298,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -9356,7 +9358,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212299471216894449
+PLAN_ID .................. 212307358972320579
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -9401,7 +9403,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -9423,6 +9425,7 @@ DESCRIPTION
begin_keys(incl) ....... 4,b,-2147483648
end_keys(excl) ......... 4,b,2
new_rec_expr ........... (D assign 'upd')
+ predicate .............. (C < 2)
--- SQL operation complete.
>>explain y1;
@@ -9430,7 +9433,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212299471216945052
+PLAN_ID .................. 212307358972388221
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9474,7 +9477,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -9505,7 +9508,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212299471216988910
+PLAN_ID .................. 212307358972452949
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9550,7 +9553,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -9582,7 +9585,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212299471217038813
+PLAN_ID .................. 212307358972534947
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9626,7 +9629,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -9658,7 +9661,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212299471217090118
+PLAN_ID .................. 212307358972612063
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -9702,7 +9705,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -9762,7 +9765,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212299471217178964
+PLAN_ID .................. 212307358972753683
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -9808,7 +9811,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 26525986437236032
+ ObjectUIDs ............. 2718560551442856050
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -10316,12 +10319,12 @@ CREATE TABLE TRAFODION.SCH."delim_tab"
--- SQL operation complete.
>>get all volatile schemas;
-Schema(Active ): VOLATILE_SCHEMA_MXID110000212952122994710660444710000000002
+Schema(Active ): VOLATILE_SCHEMA_MXID110000212132123073588113805260000000002
--- SQL operation complete.
>>get all volatile tables;
-Schema(Active ): VOLATILE_SCHEMA_MXID110000212952122994710660444710000000002
+Schema(Active ): VOLATILE_SCHEMA_MXID110000212132123073588113805260000000002
Table: VTAB1
Table: VTAB2
[2/2] incubator-trafodion git commit: Merge remote branch
'origin/pr/66/head' into mrg_41
Posted by su...@apache.org.
Merge remote branch 'origin/pr/66/head' into mrg_41
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/c5c516e0
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/c5c516e0
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/c5c516e0
Branch: refs/heads/master
Commit: c5c516e0575f9d86bbee6ade107620eb619f32b4
Parents: c7b4b12 f95b46e
Author: Suresh Subbiah <su...@apache.org>
Authored: Thu Aug 27 23:07:11 2015 +0000
Committer: Suresh Subbiah <su...@apache.org>
Committed: Thu Aug 27 23:07:11 2015 +0000
----------------------------------------------------------------------
core/sql/generator/GenPreCode.cpp | 18 +-
core/sql/optimizer/SearchKey.cpp | 64 ++++
core/sql/optimizer/SearchKey.h | 20 +-
core/sql/optimizer/SimpleScanOptimizer.cpp | 23 +-
core/sql/optimizer/disjuncts.h | 8 +-
core/sql/optimizer/mdam.cpp | 40 +--
core/sql/regress/seabase/EXPECTED010 | 379 ++++++++++++------------
7 files changed, 320 insertions(+), 232 deletions(-)
----------------------------------------------------------------------