You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2016/04/26 23:38:16 UTC
[1/4] incubator-trafodion git commit: ddl xns turned on by default
(plus couple more fixes)
Repository: incubator-trafodion
Updated Branches:
refs/heads/release2.0 f0465c8c5 -> 78cb6b85c
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/regress/seabase/EXPECTED011
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED011 b/core/sql/regress/seabase/EXPECTED011
index 53ee692..6f88f5a 100644
--- a/core/sql/regress/seabase/EXPECTED011
+++ b/core/sql/regress/seabase/EXPECTED011
@@ -179,7 +179,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
QUERY_CACHE ............ 0
GENERATE_EXPLAIN ....... ON
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/regress/seabase/EXPECTED016
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED016 b/core/sql/regress/seabase/EXPECTED016
index 2128d94..0f5efb9 100644
--- a/core/sql/regress/seabase/EXPECTED016
+++ b/core/sql/regress/seabase/EXPECTED016
@@ -218,7 +218,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.HBASE
QUERY_CACHE ............ 0
CACHE_HISTOGRAMS ....... OFF
@@ -367,7 +366,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.HBASE
QUERY_CACHE ............ 0
CACHE_HISTOGRAMS ....... OFF
@@ -516,7 +514,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.HBASE
QUERY_CACHE ............ 0
CACHE_HISTOGRAMS ....... OFF
@@ -665,7 +662,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.HBASE
QUERY_CACHE ............ 0
CACHE_HISTOGRAMS ....... OFF
@@ -814,7 +810,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.HBASE
QUERY_CACHE ............ 0
CACHE_HISTOGRAMS ....... OFF
@@ -963,7 +958,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.HBASE
QUERY_CACHE ............ 0
CACHE_HISTOGRAMS ....... OFF
@@ -1112,7 +1106,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.HBASE
QUERY_CACHE ............ 0
CACHE_HISTOGRAMS ....... OFF
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/regress/tools/sbdefs
----------------------------------------------------------------------
diff --git a/core/sql/regress/tools/sbdefs b/core/sql/regress/tools/sbdefs
index 5cb15b6..ec6d988 100644
--- a/core/sql/regress/tools/sbdefs
+++ b/core/sql/regress/tools/sbdefs
@@ -32,7 +32,7 @@ cqd hbase_filter_preds '2';
cqd traf_aligned_row_format 'OFF';
--cqd traf_default_col_charset 'UTF8';
cqd traf_index_create_opt 'ON';
-cqd ddl_transactions 'ON';
+--cqd ddl_transactions 'ON';
cqd schema '$$TEST_SCHEMA$$';
set SCHEMA $$TEST_SCHEMA$$;
#endif
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp b/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp
index d186b46..bd47ccf 100644
--- a/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp
+++ b/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp
@@ -4877,8 +4877,8 @@ short CmpSeabaseDDL::updateSeabaseMDTable(
if (!insertPrivMgrInfo(objUID,
fullName,
objectType,
- tableInfo->objOwnerID,
- tableInfo->schemaOwnerID,
+ objOwnerID,
+ schemaOwnerID,
ComUser::getCurrentUser()))
{
*CmpCommon::diags()
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/sqlcomp/nadefaults.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp
index 34436a1..aab34ec 100644
--- a/core/sql/sqlcomp/nadefaults.cpp
+++ b/core/sql/sqlcomp/nadefaults.cpp
@@ -1171,7 +1171,7 @@ SDDui___(CYCLIC_ESP_PLACEMENT, "1"),
DDdskNS(DDL_DEFAULT_LOCATIONS, ""),
DDkwd__(DDL_EXPLAIN, "OFF"),
- DDkwd__(DDL_TRANSACTIONS, "OFF"),
+ DDkwd__(DDL_TRANSACTIONS, "ON"),
// We ignore this setting for the first (SYSTEM_DEFAULTS) table open+read.
DDkwd__(DEFAULTS_TABLE_ACCESS_WARNINGS, "OFF"),
[3/4] incubator-trafodion git commit: ddl xns turned on by default
(plus couple more fixes)
Posted by an...@apache.org.
ddl xns turned on by default (plus couple more fixes)
-- cqd ddl_transactions is ON by default
-- disabled init/drop trafodion and drop schema from
running in a single transaction.
This will be changed once couple of dtm issues are fixed
-- error 8616 is retuned in case of commit conflict
-- fixed begin/commit/set stmts to not retry in case of an error
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/dcf6f535
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/dcf6f535
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/dcf6f535
Branch: refs/heads/release2.0
Commit: dcf6f53505600c5ec8f46aa13ae4d3595922f85e
Parents: f0465c8
Author: Anoop Sharma <ce...@ansharma-3.novalocal>
Authored: Mon Apr 25 13:53:26 2016 +0000
Committer: Anoop Sharma <ce...@ansharma-3.novalocal>
Committed: Mon Apr 25 13:53:26 2016 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 1 +
core/sql/executor/ex_transaction.cpp | 7 +-
core/sql/exp/ExpErrorEnums.h | 1 +
core/sql/generator/GenPreCode.cpp | 3 +
core/sql/generator/GenRelDCL.cpp | 4 +
core/sql/regress/executor/EXPECTED013.SB | 1 -
core/sql/regress/executor/EXPECTED140 | 11 -
core/sql/regress/fullstack2/EXPECTED062 | 3 -
core/sql/regress/fullstack2/EXPECTED062.RELEASE | 3 -
core/sql/regress/seabase/EXPECTED010 | 460 ++++++++-----------
core/sql/regress/seabase/EXPECTED011 | 1 -
core/sql/regress/seabase/EXPECTED016 | 7 -
core/sql/regress/tools/sbdefs | 2 +-
core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp | 4 +-
core/sql/sqlcomp/nadefaults.cpp | 2 +-
15 files changed, 206 insertions(+), 304 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/bin/SqlciErrors.txt
----------------------------------------------------------------------
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index bcb4fb3..f66164e 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -1608,6 +1608,7 @@ $1~String1 --------------------------------
8613 25000 99999 BEGINNER MAJOR DBADMIN SQL cannot commit or rollback a transaction that was started by application.
8614 25000 99999 ADVANCED CRTCL DIALOUT SQL cannot begin a transaction when multiple contexts exist.
8615 ZZZZZ 99999 BEGINNER MAJOR DBADMIN A user-defined transaction has been started. Long Running Update operation cannot be performed.
+8616 ZZZZZ 99999 BEGINNER MAJOR DBADMIN A conflict was detected during commit processing. Transaction has been aborted.
8640 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ---- unused ----
8641 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ---- unused ----
8642 ZZZZZ 99999 UUUUUUUU UUUUU UUUUUUU ---- unused ----
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/executor/ex_transaction.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ex_transaction.cpp b/core/sql/executor/ex_transaction.cpp
index e508284..84d1c14 100644
--- a/core/sql/executor/ex_transaction.cpp
+++ b/core/sql/executor/ex_transaction.cpp
@@ -703,8 +703,11 @@ short ExTransaction::commitTransaction(NABoolean waited)
rollbackTransactionWaited();
}
- createDiagsArea (EXE_COMMIT_ERROR_FROM_TRANS_SUBSYS, rc,
- "TMF");
+ if (rc == FEHASCONFLICT)
+ createDiagsArea (EXE_COMMIT_CONFLICT_FROM_TRANS_SUBSYS, rc, "DTM");
+ else
+ createDiagsArea (EXE_COMMIT_ERROR_FROM_TRANS_SUBSYS, rc,
+ "DTM");
}
if (waited)
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/exp/ExpErrorEnums.h
----------------------------------------------------------------------
diff --git a/core/sql/exp/ExpErrorEnums.h b/core/sql/exp/ExpErrorEnums.h
index a56aab1..de4d00f 100644
--- a/core/sql/exp/ExpErrorEnums.h
+++ b/core/sql/exp/ExpErrorEnums.h
@@ -223,6 +223,7 @@ enum ExeErrorCode
EXE_CANT_COMMIT_OR_ROLLBACK = 8613,
EXE_CANT_BEGIN_WITH_MULTIPLE_CONTEXTS = 8614,
EXE_CANT_BEGIN_USER_TRANS_WITH_LRU = 8615,
+ EXE_COMMIT_CONFLICT_FROM_TRANS_SUBSYS = 8616,
EXE_LAST_CONCURRENCY_CONTROL_ERROR = 8629,
//-------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/generator/GenPreCode.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenPreCode.cpp b/core/sql/generator/GenPreCode.cpp
index 66ae65f..1591e9a 100644
--- a/core/sql/generator/GenPreCode.cpp
+++ b/core/sql/generator/GenPreCode.cpp
@@ -2838,6 +2838,8 @@ short DDLExpr::ddlXnsInfo(NABoolean &isDDLxn, NABoolean &xnCanBeStarted)
// committed in the called methods.
if ((ddlXns()) &&
(
+ (initHbase()) ||
+ (dropHbase()) ||
(purgedataHbase()) ||
(initAuthorization()) ||
(dropAuthorization()) ||
@@ -2855,6 +2857,7 @@ short DDLExpr::ddlXnsInfo(NABoolean &isDDLxn, NABoolean &xnCanBeStarted)
if ((ddlNode && ddlNode->castToStmtDDLNode() &&
ddlNode->castToStmtDDLNode()->ddlXns()) &&
((ddlNode->getOperatorType() == DDL_CLEANUP_OBJECTS) ||
+ (ddlNode->getOperatorType() == DDL_DROP_SCHEMA) ||
(ddlNode->getOperatorType() == DDL_ALTER_TABLE_DROP_COLUMN) ||
(ddlNode->getOperatorType() == DDL_ALTER_TABLE_ALTER_COLUMN_DATATYPE)))
{
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/generator/GenRelDCL.cpp
----------------------------------------------------------------------
diff --git a/core/sql/generator/GenRelDCL.cpp b/core/sql/generator/GenRelDCL.cpp
index 4698ad4..b677f94 100644
--- a/core/sql/generator/GenRelDCL.cpp
+++ b/core/sql/generator/GenRelDCL.cpp
@@ -259,6 +259,10 @@ short RelTransaction::codeGen(Generator * generator)
generator->setExplainTuple(
addExplainInfo(trans_tdb, 0, 0, generator));
}
+
+ // no aqr for trasaction control stmts (begin/commit/rollback/set)
+ generator->setAqrEnabled(FALSE);
+
return 0;
}
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/regress/executor/EXPECTED013.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED013.SB b/core/sql/regress/executor/EXPECTED013.SB
index b83960c..c58c7a0 100644
--- a/core/sql/regress/executor/EXPECTED013.SB
+++ b/core/sql/regress/executor/EXPECTED013.SB
@@ -442,7 +442,6 @@ CONTROL QUERY DEFAULT
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ON
HBASE_ASYNC_DROP_TABLE OFF
POS OFF
SCHEMA TRAFODION.T013_SCH
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/regress/executor/EXPECTED140
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED140 b/core/sql/regress/executor/EXPECTED140
index 00d157c..ae9f0ae 100644
--- a/core/sql/regress/executor/EXPECTED140
+++ b/core/sql/regress/executor/EXPECTED140
@@ -112,7 +112,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618858
@@ -213,7 +212,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618945
@@ -301,7 +299,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618858
@@ -400,7 +397,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618858
@@ -497,7 +493,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618858
@@ -630,7 +625,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618858
@@ -726,7 +720,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618858
@@ -874,7 +867,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618858
@@ -993,7 +985,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_SMALL_SCANNER .... OFF
PARALLEL_NUM_ESPS ...... 1
@@ -1108,7 +1099,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_SMALL_SCANNER .... OFF
PARALLEL_NUM_ESPS ...... 1
@@ -1231,7 +1221,6 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... 2
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
GENERATE_EXPLAIN ....... ON
ObjectUIDs ............. 2948826545036618945
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/regress/fullstack2/EXPECTED062
----------------------------------------------------------------------
diff --git a/core/sql/regress/fullstack2/EXPECTED062 b/core/sql/regress/fullstack2/EXPECTED062
index 4f2aa1f..ca88f6d 100644
--- a/core/sql/regress/fullstack2/EXPECTED062
+++ b/core/sql/regress/fullstack2/EXPECTED062
@@ -501,7 +501,6 @@ CONTROL QUERY DEFAULT
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ON
SHOWCONTROL_SHOW_ALL ON
SCHEMA AAA.BBB
CATALOG CCC
@@ -546,7 +545,6 @@ CONTROL QUERY DEFAULT
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ON
SHOWCONTROL_SHOW_ALL ON
DEF_CHUNK_SIZE 1000
CPUCOST_DM_GET .001
@@ -582,7 +580,6 @@ CONTROL QUERY DEFAULT
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ON
SHOWCONTROL_SHOW_ALL ON
DEF_CHUNK_SIZE 1000
CPUCOST_DM_GET .001
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/regress/fullstack2/EXPECTED062.RELEASE
----------------------------------------------------------------------
diff --git a/core/sql/regress/fullstack2/EXPECTED062.RELEASE b/core/sql/regress/fullstack2/EXPECTED062.RELEASE
index d933dc7..4b48a87 100644
--- a/core/sql/regress/fullstack2/EXPECTED062.RELEASE
+++ b/core/sql/regress/fullstack2/EXPECTED062.RELEASE
@@ -501,7 +501,6 @@ CONTROL QUERY DEFAULT
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ON
SHOWCONTROL_SHOW_ALL ON
SCHEMA AAA.BBB
CATALOG CCC
@@ -546,7 +545,6 @@ CONTROL QUERY DEFAULT
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ON
SHOWCONTROL_SHOW_ALL ON
DEF_CHUNK_SIZE 1000
CPUCOST_DM_GET .001
@@ -582,7 +580,6 @@ CONTROL QUERY DEFAULT
HBASE_SMALL_SCANNER SYSTEM
HBASE_FILTER_PREDS 2
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ON
SHOWCONTROL_SHOW_ALL ON
DEF_CHUNK_SIZE 1000
CPUCOST_DM_GET .001
[4/4] incubator-trafodion git commit: Merge PR-451 ddl_transactions
turned on by default
Posted by an...@apache.org.
Merge PR-451 ddl_transactions turned 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/78cb6b85
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/78cb6b85
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/78cb6b85
Branch: refs/heads/release2.0
Commit: 78cb6b85c9b87c1dc17fb18e60edbb8be72e35c6
Parents: f0465c8 dcf6f53
Author: Anoop Sharma <an...@edev06.esgyn.local>
Authored: Tue Apr 26 21:37:55 2016 +0000
Committer: Anoop Sharma <an...@edev06.esgyn.local>
Committed: Tue Apr 26 21:37:55 2016 +0000
----------------------------------------------------------------------
core/sql/bin/SqlciErrors.txt | 1 +
core/sql/executor/ex_transaction.cpp | 7 +-
core/sql/exp/ExpErrorEnums.h | 1 +
core/sql/generator/GenPreCode.cpp | 3 +
core/sql/generator/GenRelDCL.cpp | 4 +
core/sql/regress/executor/EXPECTED013.SB | 1 -
core/sql/regress/executor/EXPECTED140 | 11 -
core/sql/regress/fullstack2/EXPECTED062 | 3 -
core/sql/regress/fullstack2/EXPECTED062.RELEASE | 3 -
core/sql/regress/seabase/EXPECTED010 | 460 ++++++++-----------
core/sql/regress/seabase/EXPECTED011 | 1 -
core/sql/regress/seabase/EXPECTED016 | 7 -
core/sql/regress/tools/sbdefs | 2 +-
core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp | 4 +-
core/sql/sqlcomp/nadefaults.cpp | 2 +-
15 files changed, 206 insertions(+), 304 deletions(-)
----------------------------------------------------------------------
[2/4] incubator-trafodion git commit: ddl xns turned on by default
(plus couple more fixes)
Posted by an...@apache.org.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/dcf6f535/core/sql/regress/seabase/EXPECTED010
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED010 b/core/sql/regress/seabase/EXPECTED010
index 052b722..d567fae 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 Tue Mar 8 05:44:04 2016
+-- Definition current Sat Apr 23 04:03:53 2016
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -68,7 +68,7 @@
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:44:04 2016
+-- Definition current Sat Apr 23 04:03:53 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -87,7 +87,7 @@
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:44:04 2016
+-- Definition current Sat Apr 23 04:03:53 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -218,7 +218,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175846829763
+PLAN_ID .................. 212328144236102671
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -252,7 +252,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -261,7 +260,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773770
+ ObjectUIDs ............. 8974081219266698537
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -301,7 +300,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175846906889
+PLAN_ID .................. 212328144236172868
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -336,7 +335,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -345,7 +343,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773770
+ ObjectUIDs ............. 8974081219266698537
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -384,7 +382,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175846969122
+PLAN_ID .................. 212328144236246122
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -418,7 +416,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -427,7 +424,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773770
+ ObjectUIDs ............. 8974081219266698537
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -467,7 +464,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175845471717
+PLAN_ID .................. 212328144234883898
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -502,7 +499,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -511,7 +507,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773770
+ ObjectUIDs ............. 8974081219266698537
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -774,7 +770,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212324175848182134
+PLAN_ID .................. 212328144237774804
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -810,7 +806,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -819,7 +814,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -853,7 +848,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212324175848230338
+PLAN_ID .................. 212328144237838319
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -890,7 +885,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -899,7 +893,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -934,7 +928,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212324175848288383
+PLAN_ID .................. 212328144237933701
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -970,7 +964,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -979,7 +972,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -1014,7 +1007,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212324175848362739
+PLAN_ID .................. 212328144238040780
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -1050,7 +1043,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -1059,7 +1051,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
input_variables ........ %('a')
@@ -1123,7 +1115,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212324175848523585
+PLAN_ID .................. 212328144238219552
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -1161,7 +1153,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -1170,7 +1161,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
input_variables ........ %('upd'), %(4)
@@ -1197,7 +1188,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212324175848610087
+PLAN_ID .................. 212328144238293051
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -1233,7 +1224,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -1243,7 +1233,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -1277,7 +1267,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212324175848664515
+PLAN_ID .................. 212328144238342233
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -1314,7 +1304,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -1324,7 +1313,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -1359,7 +1348,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212324175848732834
+PLAN_ID .................. 212328144238413387
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -1395,7 +1384,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -1405,7 +1393,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -1440,7 +1428,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212324175848803150
+PLAN_ID .................. 212328144238472839
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -1476,7 +1464,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -1486,7 +1473,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
input_variables ........ %('a')
@@ -1550,7 +1537,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212324175848938512
+PLAN_ID .................. 212328144238597986
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -1588,7 +1575,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -1598,7 +1584,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040773848
+ ObjectUIDs ............. 8974081219266698665
input_variables ........ %('uuu'), %(4)
@@ -1775,7 +1761,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Tue Mar 8 05:44:33 2016
+-- Definition current Sat Apr 23 04:04:22 2016
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -1788,7 +1774,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:44:33 2016
+-- Definition current Sat Apr 23 04:04:22 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -1807,7 +1793,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:44:33 2016
+-- Definition current Sat Apr 23 04:04:22 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -1938,7 +1924,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175874760960
+PLAN_ID .................. 212328144264792830
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -1972,7 +1958,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -1981,7 +1966,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776750
+ ObjectUIDs ............. 8974081219266701767
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -2021,7 +2006,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175874820914
+PLAN_ID .................. 212328144264858194
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -2056,7 +2041,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2065,7 +2049,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776750
+ ObjectUIDs ............. 8974081219266701767
select_list ............ 1, '1'
@@ -2103,7 +2087,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175874880851
+PLAN_ID .................. 212328144264920731
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -2137,7 +2121,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2146,7 +2129,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776750
+ ObjectUIDs ............. 8974081219266701767
select_list ............ TRAFODION.SCH.T010T1.A, '1'
@@ -2185,7 +2168,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175874938755
+PLAN_ID .................. 212328144264982346
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1;
@@ -2220,7 +2203,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2229,7 +2211,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776750
+ ObjectUIDs ............. 8974081219266701767
select_list ............ 1, TRAFODION.SCH.T010T1.B
@@ -2491,7 +2473,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212324175876688173
+PLAN_ID .................. 212328144266615337
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2527,7 +2509,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2536,7 +2517,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -2570,7 +2551,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212324175876724288
+PLAN_ID .................. 212328144266661893
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2607,7 +2588,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2616,7 +2596,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -2663,7 +2643,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212324175876780593
+PLAN_ID .................. 212328144266702743
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2699,7 +2679,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2708,7 +2687,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -2746,7 +2725,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212324175876833674
+PLAN_ID .................. 212328144266745552
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -2782,7 +2761,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2791,7 +2769,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -2858,7 +2836,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212324175876909335
+PLAN_ID .................. 212328144266819972
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -2896,7 +2874,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2905,7 +2882,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -2935,7 +2912,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212324175876971746
+PLAN_ID .................. 212328144266913570
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -2971,7 +2948,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -2981,7 +2957,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -3016,7 +2992,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212324175877010951
+PLAN_ID .................. 212328144266974806
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -3053,7 +3029,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -3063,7 +3038,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -3099,7 +3074,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212324175877059861
+PLAN_ID .................. 212328144267036984
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -3135,7 +3110,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -3145,7 +3119,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -3181,7 +3155,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212324175877104899
+PLAN_ID .................. 212328144267100023
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -3217,7 +3191,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -3227,7 +3200,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -3291,7 +3264,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212324175877185429
+PLAN_ID .................. 212328144267191615
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -3329,7 +3302,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -3339,7 +3311,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040776809
+ ObjectUIDs ............. 8974081219266701834
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -3516,7 +3488,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Tue Mar 8 05:44:59 2016
+-- Definition current Sat Apr 23 04:04:48 2016
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -3529,7 +3501,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:44:59 2016
+-- Definition current Sat Apr 23 04:04:48 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -3548,7 +3520,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:44:59 2016
+-- Definition current Sat Apr 23 04:04:48 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -3679,7 +3651,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175901195506
+PLAN_ID .................. 212328144290107608
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -3713,7 +3685,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -3722,7 +3693,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779258
+ ObjectUIDs ............. 8974081219266704365
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -3762,7 +3733,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175901265852
+PLAN_ID .................. 212328144290179279
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -3797,7 +3768,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -3806,7 +3776,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779258
+ ObjectUIDs ............. 8974081219266704365
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -3845,7 +3815,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175901340557
+PLAN_ID .................. 212328144290246591
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -3879,7 +3849,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -3888,7 +3857,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779258
+ ObjectUIDs ............. 8974081219266704365
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -3928,7 +3897,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175899984759
+PLAN_ID .................. 212328144288935078
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -3963,7 +3932,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -3972,7 +3940,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779258
+ ObjectUIDs ............. 8974081219266704365
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -4235,7 +4203,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212324175903165153
+PLAN_ID .................. 212328144292121052
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4271,7 +4239,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4280,7 +4247,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -4315,7 +4282,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212324175903203605
+PLAN_ID .................. 212328144292161638
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4352,7 +4319,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4361,7 +4327,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4397,7 +4363,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212324175903242740
+PLAN_ID .................. 212328144292198590
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4433,7 +4399,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4442,7 +4407,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4478,7 +4443,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212324175903283921
+PLAN_ID .................. 212328144292239365
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -4514,7 +4479,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4523,7 +4487,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
input_variables ........ %('a')
@@ -4587,7 +4551,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212324175903360153
+PLAN_ID .................. 212328144292320041
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -4625,7 +4589,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4634,7 +4597,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
input_variables ........ %('upd'), %(4)
@@ -4661,7 +4624,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212324175903436779
+PLAN_ID .................. 212328144292393136
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4697,7 +4660,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4707,7 +4669,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -4742,7 +4704,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212324175903476720
+PLAN_ID .................. 212328144292431753
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4779,7 +4741,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4789,7 +4750,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4825,7 +4786,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212324175903512047
+PLAN_ID .................. 212328144292474349
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select *
@@ -4861,7 +4822,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4871,7 +4831,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -4907,7 +4867,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212324175903553526
+PLAN_ID .................. 212328144292514451
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -4943,7 +4903,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -4953,7 +4912,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
input_variables ........ %('a')
@@ -5017,7 +4976,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212324175903632779
+PLAN_ID .................. 212328144292590301
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -5055,7 +5014,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -5065,7 +5023,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... OFF
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040779320
+ ObjectUIDs ............. 8974081219266704430
input_variables ........ %('uuu'), %(4)
@@ -5242,7 +5200,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Tue Mar 8 05:45:25 2016
+-- Definition current Sat Apr 23 04:05:13 2016
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -5255,7 +5213,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:45:25 2016
+-- Definition current Sat Apr 23 04:05:13 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -5274,7 +5232,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:45:25 2016
+-- Definition current Sat Apr 23 04:05:13 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -5405,7 +5363,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175927123261
+PLAN_ID .................. 212328144315059805
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -5439,7 +5397,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -5448,7 +5405,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781936
+ ObjectUIDs ............. 8974081219266706876
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -5488,7 +5445,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175927192763
+PLAN_ID .................. 212328144315122372
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -5523,7 +5480,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -5532,7 +5488,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781936
+ ObjectUIDs ............. 8974081219266706876
select_list ............ 1, '1'
@@ -5570,7 +5526,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175927251686
+PLAN_ID .................. 212328144315180866
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -5604,7 +5560,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -5613,7 +5568,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781936
+ ObjectUIDs ............. 8974081219266706876
select_list ............ TRAFODION.SCH.T010T1.A, '1'
@@ -5652,7 +5607,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175927312652
+PLAN_ID .................. 212328144315245579
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1;
@@ -5687,7 +5642,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -5696,7 +5650,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781936
+ ObjectUIDs ............. 8974081219266706876
select_list ............ 1, TRAFODION.SCH.T010T1.B
@@ -5958,7 +5912,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212324175928946210
+PLAN_ID .................. 212328144316926240
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -5994,7 +5948,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6003,7 +5956,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -6036,7 +5989,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212324175929005102
+PLAN_ID .................. 212328144317000051
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -6073,7 +6026,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6082,7 +6034,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6116,7 +6068,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212324175929068640
+PLAN_ID .................. 212328144317075938
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -6152,7 +6104,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6161,7 +6112,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6195,7 +6146,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212324175929139799
+PLAN_ID .................. 212328144317135494
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -6231,7 +6182,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6240,7 +6190,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -6303,7 +6253,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212324175929266354
+PLAN_ID .................. 212328144317248537
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -6341,7 +6291,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6350,7 +6299,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... OFF
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -6380,7 +6329,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212324175929346869
+PLAN_ID .................. 212328144317303309
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -6416,7 +6365,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6426,7 +6374,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -6459,7 +6407,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212324175929409191
+PLAN_ID .................. 212328144317349912
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -6496,7 +6444,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6506,7 +6453,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6540,7 +6487,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212324175929479669
+PLAN_ID .................. 212328144317409876
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -6576,7 +6523,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6586,7 +6532,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -6620,7 +6566,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212324175929545793
+PLAN_ID .................. 212328144317469296
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -6656,7 +6602,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6666,7 +6611,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -6729,7 +6674,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212324175929666763
+PLAN_ID .................. 212328144317572749
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -6767,7 +6712,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -6777,7 +6721,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040781998
+ ObjectUIDs ............. 8974081219266706932
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -6974,7 +6918,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Tue Mar 8 05:45:52 2016
+-- Definition current Sat Apr 23 04:05:38 2016
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -6987,7 +6931,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:45:52 2016
+-- Definition current Sat Apr 23 04:05:38 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -7006,7 +6950,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:45:52 2016
+-- Definition current Sat Apr 23 04:05:38 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -7137,7 +7081,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175953641296
+PLAN_ID .................. 212328144340252394
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -7171,7 +7115,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -7180,7 +7123,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784604
+ ObjectUIDs ............. 8974081219266709376
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -7220,7 +7163,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175953734141
+PLAN_ID .................. 212328144340312113
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -7255,7 +7198,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -7264,7 +7206,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784604
+ ObjectUIDs ............. 8974081219266709376
select_list ............ %(1), %('1')
input_variables ........ %(1), %('1')
@@ -7303,7 +7245,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175953816734
+PLAN_ID .................. 212328144340368341
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -7337,7 +7279,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -7346,7 +7287,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784604
+ ObjectUIDs ............. 8974081219266709376
select_list ............ TRAFODION.SCH.T010T1.A, %('1')
input_variables ........ %('1')
@@ -7387,7 +7328,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175952493666
+PLAN_ID .................. 212328144339112888
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a = 2;
@@ -7422,7 +7363,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -7431,7 +7371,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784604
+ ObjectUIDs ............. 8974081219266709376
select_list ............ %(2), TRAFODION.SCH.T010T1.B
input_variables ........ %(2)
@@ -7694,7 +7634,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212324175955526117
+PLAN_ID .................. 212328144342277216
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7730,7 +7670,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -7739,7 +7678,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -7773,7 +7712,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212324175955589592
+PLAN_ID .................. 212328144342325330
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7810,7 +7749,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -7819,7 +7757,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -7854,7 +7792,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212324175955661668
+PLAN_ID .................. 212328144342385845
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -7890,7 +7828,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -7899,7 +7836,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -7934,7 +7871,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212324175955727413
+PLAN_ID .................. 212328144342447114
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -7970,7 +7907,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -7979,7 +7915,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
input_variables ........ %('a')
@@ -8043,7 +7979,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212324175955856497
+PLAN_ID .................. 212328144342571114
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -8081,7 +8017,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -8090,7 +8025,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
input_variables ........ %('upd'), %(4)
@@ -8117,7 +8052,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212324175955924581
+PLAN_ID .................. 212328144342639729
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -8153,7 +8088,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -8163,7 +8097,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1),
TRAFODION.SCH.T010T2.D
input_variables ........ %('a'), %(1)
@@ -8197,7 +8131,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212324175955973846
+PLAN_ID .................. 212328144342687157
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -8234,7 +8168,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -8244,7 +8177,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -8279,7 +8212,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212324175956030695
+PLAN_ID .................. 212328144342740627
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -8315,7 +8248,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -8325,7 +8257,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
select_list ............ TRAFODION.SCH.T010T2.A, %('a'),
TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D
input_variables ........ %('a')
@@ -8360,7 +8292,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212324175956088526
+PLAN_ID .................. 212328144342829114
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -8396,7 +8328,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -8406,7 +8337,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
input_variables ........ %('a')
@@ -8470,7 +8401,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .................. 212324175956213485
+PLAN_ID .................. 212328144342988889
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -8508,7 +8439,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -8518,7 +8448,7 @@ DESCRIPTION
QUERY_CACHE ........ 1,024
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040784661
+ ObjectUIDs ............. 8974081219266709434
input_variables ........ %('uuu'), %(4)
@@ -8695,7 +8625,7 @@ _SALT_ A B C D
>>invoke t010t1;
-- Definition of Trafodion table TRAFODION.SCH.T010T1
--- Definition current Tue Mar 8 05:46:17 2016
+-- Definition current Sat Apr 23 04:06:04 2016
(
A INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -8708,7 +8638,7 @@ _SALT_ A B C D
>>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:46:17 2016
+-- Definition current Sat Apr 23 04:06:04 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -8727,7 +8657,7 @@ _SALT_ A B C D
>>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1";
-- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1"
--- Definition current Tue Mar 8 05:46:17 2016
+-- Definition current Sat Apr 23 04:06:04 2016
(
ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE
@@ -8858,7 +8788,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175978975431
+PLAN_ID .................. 212328144365540549
ROWS_OUT ................ 11
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 or b='1';
@@ -8892,7 +8822,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -8901,7 +8830,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787190
+ ObjectUIDs ............. 8974081219266711846
select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B
@@ -8941,7 +8870,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175979034252
+PLAN_ID .................. 212328144365595968
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1 and b='1';
@@ -8976,7 +8905,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -8985,7 +8913,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787190
+ ObjectUIDs ............. 8974081219266711846
select_list ............ 1, '1'
@@ -9023,7 +8951,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175979087509
+PLAN_ID .................. 212328144365647254
ROWS_OUT ................ 10
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where b='1';
@@ -9057,7 +8985,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9066,7 +8993,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787190
+ ObjectUIDs ............. 8974081219266711846
select_list ............ TRAFODION.SCH.T010T1.A, '1'
@@ -9106,7 +9033,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
-PLAN_ID .................. 212324175979144151
+PLAN_ID .................. 212328144365700486
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t010t1 where a=1;
@@ -9141,7 +9068,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9150,7 +9076,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787190
+ ObjectUIDs ............. 8974081219266711846
select_list ............ 1, TRAFODION.SCH.T010T1.B
@@ -9412,7 +9338,7 @@ A B C D
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X1
-PLAN_ID .................. 212324175980723729
+PLAN_ID .................. 212328144367286744
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9448,7 +9374,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9457,7 +9382,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -9490,7 +9415,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X2
-PLAN_ID .................. 212324175980766745
+PLAN_ID .................. 212328144367337278
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9527,7 +9452,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9536,7 +9460,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -9570,7 +9494,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X3
-PLAN_ID .................. 212324175980834930
+PLAN_ID .................. 212328144367394943
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9606,7 +9530,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9615,7 +9538,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -9649,7 +9572,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X4
-PLAN_ID .................. 212324175980894503
+PLAN_ID .................. 212328144367453475
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -9685,7 +9608,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9694,7 +9616,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -9757,7 +9679,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... X5
-PLAN_ID .................. 212324175981003233
+PLAN_ID .................. 212328144367556161
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ update t010t2
@@ -9795,7 +9717,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9804,7 +9725,7 @@ DESCRIPTION
HBASE_FILTER_PREDS ..... ON
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN
@@ -9834,7 +9755,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y1
-PLAN_ID .................. 212324175981066009
+PLAN_ID .................. 212328144367612269
ROWS_OUT ................. 2
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9870,7 +9791,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9880,7 +9800,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1,
TRAFODION.SCH.T010T2.D
@@ -9913,7 +9833,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y2
-PLAN_ID .................. 212324175981117543
+PLAN_ID .................. 212328144367662094
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -9950,7 +9870,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -9960,7 +9879,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -9994,7 +9913,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y3
-PLAN_ID .................. 212324175981174168
+PLAN_ID .................. 212328144367715857
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0
STATEMENT ................ select *
@@ -10030,7 +9949,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -10040,7 +9958,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C,
TRAFODION.SCH.T010T2.D
@@ -10074,7 +9992,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y4
-PLAN_ID .................. 212324175981243822
+PLAN_ID .................. 212328144367769413
ROWS_OUT ................. 4
EST_TOTAL_COST ........... 0.01
STATEMENT ................ delete from t010t2
@@ -10110,7 +10028,6 @@ DESCRIPTION
HBASE_SMALL_SCANNER .... SYSTEM
TRAF_ALIGNED_ROW_FORMAT OFF
TRAF_INDEX_CREATE_OPT ON
- DDL_TRANSACTIONS ....... ON
SCHEMA ................. TRAFODION.SCH
HBASE_MAX_COLUMN_NAME_ 10
HBASE_MAX_COLUMN_VAL_L 20
@@ -10120,7 +10037,7 @@ DESCRIPTION
QUERY_CACHE ............ 0
MDAM_SCAN_METHOD ....... ON
HBASE_MAX_NUM_SEARCH_KE 1
- ObjectUIDs ............. 4560549616040787250
+ ObjectUIDs ............. 8974081219266711903
TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2
@@ -10183,7 +10100,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... Y5
-PLAN_ID .....
<TRUNCATED>