Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id B6E91200C49 for ; Fri, 17 Mar 2017 18:44:15 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id B58B9160B80; Fri, 17 Mar 2017 17:44:15 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 6C586160B70 for ; Fri, 17 Mar 2017 18:44:13 +0100 (CET) Received: (qmail 97893 invoked by uid 500); 17 Mar 2017 17:44:12 -0000 Mailing-List: contact commits-help@trafodion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@trafodion.apache.org Delivered-To: mailing list commits@trafodion.apache.org Received: (qmail 97884 invoked by uid 99); 17 Mar 2017 17:44:12 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Mar 2017 17:44:12 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 17A66180B10 for ; Fri, 17 Mar 2017 17:44:12 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -2.528 X-Spam-Level: X-Spam-Status: No, score=-2.528 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LOTSOFHASH=0.25, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-0.001, SPF_NEUTRAL=0.652, UPPERCASE_50_75=0.791] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id jHm_EdshGUPT for ; Fri, 17 Mar 2017 17:44:01 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id BE9785F613 for ; Fri, 17 Mar 2017 17:43:59 +0000 (UTC) Received: (qmail 97645 invoked by uid 99); 17 Mar 2017 17:43:59 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Mar 2017 17:43:59 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id DB55CDFD73; Fri, 17 Mar 2017 17:43:58 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: dbirdsall@apache.org To: commits@trafodion.incubator.apache.org Date: Fri, 17 Mar 2017 17:43:58 -0000 Message-Id: <98ff7a1166c94e71988c8cfd7f01c529@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [1/2] incubator-trafodion git commit: [TRAFODION-2537] Add file_desc to salted secondary indexes indexes_desc archived-at: Fri, 17 Mar 2017 17:44:15 -0000 Repository: incubator-trafodion Updated Branches: refs/heads/master 1b724a845 -> 39de98789 [TRAFODION-2537] Add file_desc to salted secondary indexes indexes_desc Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/e5e1356b Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/e5e1356b Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/e5e1356b Branch: refs/heads/master Commit: e5e1356bf1ea70ee4b23d4e921a218f40cdf8577 Parents: 2ba737c Author: Dave Birdsall Authored: Wed Mar 15 20:42:58 2017 +0000 Committer: Dave Birdsall Committed: Wed Mar 15 20:42:58 2017 +0000 ---------------------------------------------------------------------- core/sql/generator/Generator.cpp | 8 + core/sql/regress/hive/EXPECTED017 | 18 +- core/sql/regress/seabase/EXPECTED010 | 378 +++++++++++++++--------------- 3 files changed, 205 insertions(+), 199 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e5e1356b/core/sql/generator/Generator.cpp ---------------------------------------------------------------------- diff --git a/core/sql/generator/Generator.cpp b/core/sql/generator/Generator.cpp index b6b113e..eb054e0 100644 --- a/core/sql/generator/Generator.cpp +++ b/core/sql/generator/Generator.cpp @@ -2206,6 +2206,14 @@ TrafDesc * Generator::createVirtualTableDesc curr_index_desc->indexesDesc()->hbaseCreateOptions = NULL; curr_index_desc->indexesDesc()->numSaltPartns = indexInfo[i].numSaltPartns; + if (curr_index_desc->indexesDesc()->numSaltPartns > 0) + { + // the presence of the files descriptor tells createNAFileSets + // that the index is salted like the base table + TrafDesc * ci_files_desc = TrafAllocateDDLdesc(DESC_FILES_TYPE, space); + ci_files_desc->filesDesc()->setAudited(TRUE); // audited table + curr_index_desc->indexesDesc()->files_desc = ci_files_desc; + } curr_index_desc->indexesDesc()->setRowFormat(indexInfo[i].rowFormat); if (indexInfo[i].hbaseCreateOptions) { http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e5e1356b/core/sql/regress/hive/EXPECTED017 ---------------------------------------------------------------------- diff --git a/core/sql/regress/hive/EXPECTED017 b/core/sql/regress/hive/EXPECTED017 index 2e746b7..c32b437 100644 --- a/core/sql/regress/hive/EXPECTED017 +++ b/core/sql/regress/hive/EXPECTED017 @@ -940,11 +940,10 @@ _SALT_@ B@ A LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- -5 . 6 root 1.00E+002 -4 . 5 esp_exchange 1:2(range) 1.00E+002 -2 3 4 tuple_flow 1.00E+002 -. . 3 trafodion_load_prepa T017TTCIDXB 1.00E+000 -1 . 2 esp_exchange 2(range):1 (m) 1.00E+002 +4 . 5 root 1.00E+002 +3 . 4 esp_exchange 1:2(range) 1.00E+002 +1 2 3 tuple_flow 1.00E+002 +. . 2 trafodion_load_prepa T017TTCIDXB 1.00E+000 . . 1 trafodion_index_scan T017TTCIDXB 1.00E+002 --- SQL operation complete. @@ -954,11 +953,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- -5 . 6 root 1.00E+002 -4 . 5 esp_exchange 1:2(range) 1.00E+002 -2 3 4 tuple_flow 1.00E+002 -. . 3 trafodion_load_prepa T017TTCIDXB 1.00E+000 -1 . 2 esp_exchange 2(range):1 (m) 1.00E+002 +4 . 5 root 1.00E+002 +3 . 4 esp_exchange 1:2(range) 1.00E+002 +1 2 3 tuple_flow 1.00E+002 +. . 2 trafodion_load_prepa T017TTCIDXB 1.00E+000 . . 1 trafodion_index_scan T017TTCIDXB 1.00E+002 --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e5e1356b/core/sql/regress/seabase/EXPECTED010 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED010 b/core/sql/regress/seabase/EXPECTED010 index f033682..c949f10 100644 --- a/core/sql/regress/seabase/EXPECTED010 +++ b/core/sql/regress/seabase/EXPECTED010 @@ -58,7 +58,7 @@ >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Tue Sep 20 21:15:13 2016 +-- Definition current Wed Mar 15 02:25:11 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -71,7 +71,7 @@ >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:15:13 2016 +-- Definition current Wed Mar 15 02:25:11 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -90,7 +90,7 @@ >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:15:14 2016 +-- Definition current Wed Mar 15 02:25:11 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -221,7 +221,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166116039721 +PLAN_ID .................. 212356304713548391 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -263,7 +263,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723316 + ObjectUIDs ............. 4453058303811968296 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -303,7 +303,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166116148042 +PLAN_ID .................. 212356304713627230 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -346,7 +346,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723316 + ObjectUIDs ............. 4453058303811968296 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -385,7 +385,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166116256760 +PLAN_ID .................. 212356304713727245 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -427,7 +427,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723316 + ObjectUIDs ............. 4453058303811968296 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -467,7 +467,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166115139219 +PLAN_ID .................. 212356304712746144 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -510,7 +510,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723316 + ObjectUIDs ............. 4453058303811968296 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -773,7 +773,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212341166117154559 +PLAN_ID .................. 212356304714542757 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -817,7 +817,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -851,7 +851,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212341166117228203 +PLAN_ID .................. 212356304714609170 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -896,7 +896,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -931,7 +931,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212341166117332373 +PLAN_ID .................. 212356304714682650 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -975,7 +975,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1010,7 +1010,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212341166117433757 +PLAN_ID .................. 212356304714760334 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -1054,7 +1054,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 input_variables ........ %('a') @@ -1118,7 +1118,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212341166117673791 +PLAN_ID .................. 212356304714959599 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -1164,7 +1164,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 input_variables ........ %('upd'), %(4) @@ -1191,7 +1191,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212341166117788693 +PLAN_ID .................. 212356304715042908 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1236,7 +1236,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -1270,7 +1270,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212341166117857546 +PLAN_ID .................. 212356304715100531 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1316,7 +1316,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1351,7 +1351,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212341166117952190 +PLAN_ID .................. 212356304715175937 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1396,7 +1396,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1431,7 +1431,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212341166118067767 +PLAN_ID .................. 212356304715268897 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -1476,7 +1476,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 input_variables ........ %('a') @@ -1540,7 +1540,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212341166118330512 +PLAN_ID .................. 212356304715430313 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -1587,7 +1587,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228723632 + ObjectUIDs ............. 4453058303811968703 input_variables ........ %('uuu'), %(4) @@ -1764,7 +1764,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Tue Sep 20 21:15:47 2016 +-- Definition current Wed Mar 15 02:25:49 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1777,7 +1777,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:15:47 2016 +-- Definition current Wed Mar 15 02:25:49 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1796,7 +1796,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:15:47 2016 +-- Definition current Wed Mar 15 02:25:49 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1927,7 +1927,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166148692438 +PLAN_ID .................. 212356304751044503 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -1969,7 +1969,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228726820 + ObjectUIDs ............. 4453058303811972377 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -2009,7 +2009,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166148776404 +PLAN_ID .................. 212356304751132896 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -2052,7 +2052,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228726820 + ObjectUIDs ............. 4453058303811972377 select_list ............ 1, '1' @@ -2090,7 +2090,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166148864170 +PLAN_ID .................. 212356304751234081 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -2132,7 +2132,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228726820 + ObjectUIDs ............. 4453058303811972377 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -2171,7 +2171,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166148960666 +PLAN_ID .................. 212356304751352362 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -2214,7 +2214,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228726820 + ObjectUIDs ............. 4453058303811972377 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -2476,7 +2476,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212341166152203364 +PLAN_ID .................. 212356304753693894 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2520,7 +2520,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -2554,7 +2554,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212341166152240325 +PLAN_ID .................. 212356304753750298 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2599,7 +2599,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2646,7 +2646,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212341166152283061 +PLAN_ID .................. 212356304753793359 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2690,7 +2690,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2728,7 +2728,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212341166152334718 +PLAN_ID .................. 212356304753832303 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -2772,7 +2772,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -2839,7 +2839,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212341166152442576 +PLAN_ID .................. 212356304753912740 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -2885,7 +2885,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -2915,7 +2915,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212341166152531325 +PLAN_ID .................. 212356304753990824 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2960,7 +2960,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -2995,7 +2995,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212341166152571509 +PLAN_ID .................. 212356304754029491 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3041,7 +3041,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3077,7 +3077,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212341166152614772 +PLAN_ID .................. 212356304754067803 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3122,7 +3122,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3158,7 +3158,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212341166152658800 +PLAN_ID .................. 212356304754107558 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -3203,7 +3203,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -3267,7 +3267,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212341166152748616 +PLAN_ID .................. 212356304754184445 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -3314,7 +3314,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228727063 + ObjectUIDs ............. 4453058303811972619 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -3491,7 +3491,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Tue Sep 20 21:16:21 2016 +-- Definition current Wed Mar 15 02:26:18 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -3504,7 +3504,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:16:21 2016 +-- Definition current Wed Mar 15 02:26:18 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3523,7 +3523,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:16:21 2016 +-- Definition current Wed Mar 15 02:26:18 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3654,7 +3654,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166182383631 +PLAN_ID .................. 212356304779721578 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -3696,7 +3696,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730252 + ObjectUIDs ............. 4453058303811975304 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -3736,7 +3736,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166182484131 +PLAN_ID .................. 212356304779821552 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -3779,7 +3779,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730252 + ObjectUIDs ............. 4453058303811975304 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -3818,7 +3818,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166182585727 +PLAN_ID .................. 212356304779906972 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -3860,7 +3860,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730252 + ObjectUIDs ............. 4453058303811975304 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -3900,7 +3900,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166181671867 +PLAN_ID .................. 212356304778960764 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -3943,7 +3943,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730252 + ObjectUIDs ............. 4453058303811975304 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -4206,7 +4206,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212341166184925966 +PLAN_ID .................. 212356304782258948 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4250,7 +4250,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4285,7 +4285,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212341166184977053 +PLAN_ID .................. 212356304782305790 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4330,7 +4330,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4366,7 +4366,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212341166185022203 +PLAN_ID .................. 212356304782347906 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4410,7 +4410,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4446,7 +4446,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212341166185073122 +PLAN_ID .................. 212356304782399979 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4490,7 +4490,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 input_variables ........ %('a') @@ -4554,7 +4554,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212341166185187618 +PLAN_ID .................. 212356304782487785 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -4600,7 +4600,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 input_variables ........ %('upd'), %(4) @@ -4627,7 +4627,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212341166185274121 +PLAN_ID .................. 212356304782567336 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4672,7 +4672,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4707,7 +4707,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212341166185326066 +PLAN_ID .................. 212356304782607298 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4753,7 +4753,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4789,7 +4789,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212341166185372151 +PLAN_ID .................. 212356304782645724 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4834,7 +4834,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4870,7 +4870,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212341166185418019 +PLAN_ID .................. 212356304782694053 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4915,7 +4915,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 input_variables ........ %('a') @@ -4979,7 +4979,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212341166185508967 +PLAN_ID .................. 212356304782772302 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -5026,7 +5026,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228730503 + ObjectUIDs ............. 4453058303811975515 input_variables ........ %('uuu'), %(4) @@ -5203,7 +5203,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Tue Sep 20 21:16:54 2016 +-- Definition current Wed Mar 15 02:26:50 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -5216,7 +5216,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:16:54 2016 +-- Definition current Wed Mar 15 02:26:50 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5235,7 +5235,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:16:54 2016 +-- Definition current Wed Mar 15 02:26:50 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5366,7 +5366,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166215708432 +PLAN_ID .................. 212356304812067827 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -5408,7 +5408,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733568 + ObjectUIDs ............. 4453058303811978441 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -5448,7 +5448,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166215796358 +PLAN_ID .................. 212356304812165826 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -5491,7 +5491,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733568 + ObjectUIDs ............. 4453058303811978441 select_list ............ 1, '1' @@ -5529,7 +5529,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166215876425 +PLAN_ID .................. 212356304812270202 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -5571,7 +5571,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733568 + ObjectUIDs ............. 4453058303811978441 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -5610,7 +5610,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166215962732 +PLAN_ID .................. 212356304812367499 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -5653,7 +5653,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733568 + ObjectUIDs ............. 4453058303811978441 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -5915,7 +5915,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212341166218102543 +PLAN_ID .................. 212356304814574894 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -5959,7 +5959,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -5992,7 +5992,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212341166218167370 +PLAN_ID .................. 212356304814637647 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6037,7 +6037,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6071,7 +6071,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212341166218259256 +PLAN_ID .................. 212356304814713897 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6115,7 +6115,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6149,7 +6149,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212341166218351366 +PLAN_ID .................. 212356304814788364 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -6193,7 +6193,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6256,7 +6256,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212341166218524156 +PLAN_ID .................. 212356304814931991 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -6302,7 +6302,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -6332,7 +6332,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212341166218610768 +PLAN_ID .................. 212356304814999113 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6377,7 +6377,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -6410,7 +6410,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212341166218678758 +PLAN_ID .................. 212356304815058061 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6456,7 +6456,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6490,7 +6490,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212341166218781059 +PLAN_ID .................. 212356304815129977 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6535,7 +6535,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6569,7 +6569,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212341166218879181 +PLAN_ID .................. 212356304815206675 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -6614,7 +6614,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6677,7 +6677,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212341166219052170 +PLAN_ID .................. 212356304815341474 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -6724,7 +6724,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228733822 + ObjectUIDs ............. 4453058303811978693 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -6924,7 +6924,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Tue Sep 20 21:17:33 2016 +-- Definition current Wed Mar 15 02:27:20 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -6937,7 +6937,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:17:33 2016 +-- Definition current Wed Mar 15 02:27:20 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -6956,7 +6956,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:17:33 2016 +-- Definition current Wed Mar 15 02:27:20 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -7087,7 +7087,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166254383717 +PLAN_ID .................. 212356304841870306 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -7129,7 +7129,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737367 + ObjectUIDs ............. 4453058303811981438 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -7169,7 +7169,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166254477172 +PLAN_ID .................. 212356304841968327 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -7212,7 +7212,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737367 + ObjectUIDs ............. 4453058303811981438 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -7251,7 +7251,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166254569861 +PLAN_ID .................. 212356304842057826 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -7293,7 +7293,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737367 + ObjectUIDs ............. 4453058303811981438 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -7333,7 +7333,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166253652595 +PLAN_ID .................. 212356304841099325 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -7376,7 +7376,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737367 + ObjectUIDs ............. 4453058303811981438 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -7639,7 +7639,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212341166256768909 +PLAN_ID .................. 212356304844349013 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7683,7 +7683,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -7717,7 +7717,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212341166256836319 +PLAN_ID .................. 212356304844409731 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7762,7 +7762,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7797,7 +7797,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212341166256922064 +PLAN_ID .................. 212356304844484629 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7841,7 +7841,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7876,7 +7876,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212341166257014241 +PLAN_ID .................. 212356304844560891 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -7920,7 +7920,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 input_variables ........ %('a') @@ -7984,7 +7984,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212341166257204807 +PLAN_ID .................. 212356304844715624 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -8030,7 +8030,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 input_variables ........ %('upd'), %(4) @@ -8057,7 +8057,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212341166257311610 +PLAN_ID .................. 212356304844790614 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8102,7 +8102,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -8136,7 +8136,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212341166257372707 +PLAN_ID .................. 212356304844844169 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8182,7 +8182,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8217,7 +8217,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212341166257458692 +PLAN_ID .................. 212356304844914885 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8262,7 +8262,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8297,7 +8297,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212341166257543506 +PLAN_ID .................. 212356304844979384 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -8342,7 +8342,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 input_variables ........ %('a') @@ -8406,7 +8406,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212341166257713479 +PLAN_ID .................. 212356304845119317 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -8453,7 +8453,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228737626 + ObjectUIDs ............. 4453058303811981668 input_variables ........ %('uuu'), %(4) @@ -8630,7 +8630,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Tue Sep 20 21:18:07 2016 +-- Definition current Wed Mar 15 02:27:48 2017 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -8643,7 +8643,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:18:07 2016 +-- Definition current Wed Mar 15 02:27:48 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8662,7 +8662,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Tue Sep 20 21:18:07 2016 +-- Definition current Wed Mar 15 02:27:49 2017 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8793,7 +8793,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166288808256 +PLAN_ID .................. 212356304870397294 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -8835,7 +8835,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228740763 + ObjectUIDs ............. 4453058303811984293 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -8875,7 +8875,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166288908764 +PLAN_ID .................. 212356304870488453 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -8918,7 +8918,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228740763 + ObjectUIDs ............. 4453058303811984293 select_list ............ 1, '1' @@ -8956,7 +8956,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166289002020 +PLAN_ID .................. 212356304870577345 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -8998,7 +8998,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228740763 + ObjectUIDs ............. 4453058303811984293 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -9037,7 +9037,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212341166289094029 +PLAN_ID .................. 212356304870656226 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -9080,7 +9080,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228740763 + ObjectUIDs ............. 4453058303811984293 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -9342,7 +9342,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212341166291222429 +PLAN_ID .................. 212356304872859573 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9386,7 +9386,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -9419,7 +9419,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212341166291283576 +PLAN_ID .................. 212356304872923669 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9464,7 +9464,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9498,7 +9498,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212341166291382456 +PLAN_ID .................. 212356304872999893 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9542,7 +9542,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9576,7 +9576,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212341166291495851 +PLAN_ID .................. 212356304873072049 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -9620,7 +9620,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -9683,7 +9683,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212341166291672666 +PLAN_ID .................. 212356304873229690 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -9729,7 +9729,7 @@ DESCRIPTION TRAF_ALIGNED_ROW_FORMAT ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -9759,7 +9759,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212341166291751375 +PLAN_ID .................. 212356304873302029 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9804,7 +9804,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -9837,7 +9837,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212341166291815140 +PLAN_ID .................. 212356304873366824 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9883,7 +9883,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9917,7 +9917,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212341166291896463 +PLAN_ID .................. 212356304873437012 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9962,7 +9962,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9996,7 +9996,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212341166291975275 +PLAN_ID .................. 212356304873513284 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -10041,7 +10041,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -10104,7 +10104,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212341166292185118 +PLAN_ID .................. 212356304873668121 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -10151,7 +10151,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 3703193827228741057 + ObjectUIDs ............. 4453058303811984530 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -10439,7 +10439,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ---- ---- ---- -------------------- -------- -------------------- --------- 1 . 2 root 1.00E+009 -. . 1 trafodion_scan T010T4 1.00E+009 +. . 1 trafodion_index_scan T010IX1 1.00E+009 --- SQL operation complete. >>execute s; @@ -10662,12 +10662,12 @@ CREATE TABLE TRAFODION.SCH."delim_tab" --- SQL operation complete. >>get all volatile schemas; -Schema(Active ): VOLATILE_SCHEMA_MXID110000065782123411660630659580000000002 +Schema(Active ): VOLATILE_SCHEMA_MXID110000242942123563046888583610000000002 --- SQL operation complete. >>get all volatile tables; -Schema(Active ): VOLATILE_SCHEMA_MXID110000065782123411660630659580000000002 +Schema(Active ): VOLATILE_SCHEMA_MXID110000242942123563046888583610000000002 Table: VTAB1 Table: VTAB2