http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/seabase/EXPECTED010 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED010 b/core/sql/regress/seabase/EXPECTED010 index 1253abb..c6f739f 100644 --- a/core/sql/regress/seabase/EXPECTED010 +++ b/core/sql/regress/seabase/EXPECTED010 @@ -55,19 +55,20 @@ >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Wed Feb 10 17:24:52 2016 +-- Definition current Tue Mar 8 05:44:04 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE , B CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + PRIMARY KEY (A ASC) --- SQL operation complete. >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:24:53 2016 +-- Definition current Tue Mar 8 05:44:04 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -80,12 +81,13 @@ , COL_VALUE VARCHAR(20) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:24:53 2016 +-- Definition current Tue Mar 8 05:44:04 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -93,6 +95,7 @@ , COLUMN_DETAILS VARCHAR(60) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >> @@ -215,7 +218,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885094893012 +PLAN_ID .................. 212324175846829763 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -258,7 +261,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977067 + ObjectUIDs ............. 4560549616040773770 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -298,7 +301,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885094974287 +PLAN_ID .................. 212324175846906889 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -342,7 +345,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977067 + ObjectUIDs ............. 4560549616040773770 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -381,7 +384,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885095061744 +PLAN_ID .................. 212324175846969122 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -424,7 +427,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977067 + ObjectUIDs ............. 4560549616040773770 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -464,7 +467,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885093467820 +PLAN_ID .................. 212324175845471717 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -508,7 +511,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977067 + ObjectUIDs ............. 4560549616040773770 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -771,7 +774,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212321885096382137 +PLAN_ID .................. 212324175848182134 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -816,7 +819,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -850,7 +853,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212321885096449206 +PLAN_ID .................. 212324175848230338 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -896,7 +899,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -931,7 +934,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212321885096528149 +PLAN_ID .................. 212324175848288383 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -976,7 +979,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1011,7 +1014,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212321885096610874 +PLAN_ID .................. 212324175848362739 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -1056,7 +1059,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 input_variables ........ %('a') @@ -1120,7 +1123,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212321885096769866 +PLAN_ID .................. 212324175848523585 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -1167,7 +1170,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 input_variables ........ %('upd'), %(4) @@ -1194,7 +1197,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212321885096839283 +PLAN_ID .................. 212324175848610087 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1240,7 +1243,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -1274,7 +1277,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212321885096892358 +PLAN_ID .................. 212324175848664515 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1321,7 +1324,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1356,7 +1359,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212321885096964168 +PLAN_ID .................. 212324175848732834 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1402,7 +1405,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1437,7 +1440,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212321885097028060 +PLAN_ID .................. 212324175848803150 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -1483,7 +1486,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 input_variables ........ %('a') @@ -1547,7 +1550,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212321885097193080 +PLAN_ID .................. 212324175848938512 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -1595,7 +1598,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177977162 + ObjectUIDs ............. 4560549616040773848 input_variables ........ %('uuu'), %(4) @@ -1772,19 +1775,20 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Wed Feb 10 17:25:15 2016 +-- Definition current Tue Mar 8 05:44:33 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE , B CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + PRIMARY KEY (A ASC) --- SQL operation complete. >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:25:15 2016 +-- Definition current Tue Mar 8 05:44:33 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1797,12 +1801,13 @@ _SALT_ A B C D , COL_VALUE VARCHAR(20) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:25:15 2016 +-- Definition current Tue Mar 8 05:44:33 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1810,6 +1815,7 @@ _SALT_ A B C D , COLUMN_DETAILS VARCHAR(60) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >> @@ -1932,7 +1938,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885117562364 +PLAN_ID .................. 212324175874760960 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -1975,7 +1981,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979649 + ObjectUIDs ............. 4560549616040776750 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -2015,7 +2021,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885117630076 +PLAN_ID .................. 212324175874820914 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -2059,7 +2065,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979649 + ObjectUIDs ............. 4560549616040776750 select_list ............ 1, '1' @@ -2097,7 +2103,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885117688131 +PLAN_ID .................. 212324175874880851 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -2140,7 +2146,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979649 + ObjectUIDs ............. 4560549616040776750 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -2179,7 +2185,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885117743655 +PLAN_ID .................. 212324175874938755 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -2223,7 +2229,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979649 + ObjectUIDs ............. 4560549616040776750 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -2485,7 +2491,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212321885119498869 +PLAN_ID .................. 212324175876688173 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2530,7 +2536,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -2564,7 +2570,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212321885119535261 +PLAN_ID .................. 212324175876724288 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2610,7 +2616,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2657,7 +2663,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212321885119574822 +PLAN_ID .................. 212324175876780593 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2702,7 +2708,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2740,7 +2746,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212321885119613489 +PLAN_ID .................. 212324175876833674 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -2785,7 +2791,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -2852,7 +2858,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212321885119716625 +PLAN_ID .................. 212324175876909335 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -2899,7 +2905,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -2929,7 +2935,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212321885119793180 +PLAN_ID .................. 212324175876971746 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2975,7 +2981,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -3010,7 +3016,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212321885119836459 +PLAN_ID .................. 212324175877010951 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3057,7 +3063,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3093,7 +3099,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212321885119870483 +PLAN_ID .................. 212324175877059861 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3139,7 +3145,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3175,7 +3181,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212321885119915606 +PLAN_ID .................. 212324175877104899 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -3221,7 +3227,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -3285,7 +3291,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212321885119998609 +PLAN_ID .................. 212324175877185429 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -3333,7 +3339,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177979769 + ObjectUIDs ............. 4560549616040776809 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -3510,19 +3516,20 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Wed Feb 10 17:25:37 2016 +-- Definition current Tue Mar 8 05:44:59 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE , B CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + PRIMARY KEY (A ASC) --- SQL operation complete. >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:25:37 2016 +-- Definition current Tue Mar 8 05:44:59 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3535,12 +3542,13 @@ _SALT_ A B C D , COL_VALUE VARCHAR(20) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:25:37 2016 +-- Definition current Tue Mar 8 05:44:59 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3548,6 +3556,7 @@ _SALT_ A B C D , COLUMN_DETAILS VARCHAR(60) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >> @@ -3670,7 +3679,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885139456457 +PLAN_ID .................. 212324175901195506 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -3713,7 +3722,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981872 + ObjectUIDs ............. 4560549616040779258 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -3753,7 +3762,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885139522620 +PLAN_ID .................. 212324175901265852 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -3797,7 +3806,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981872 + ObjectUIDs ............. 4560549616040779258 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -3836,7 +3845,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885139598890 +PLAN_ID .................. 212324175901340557 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -3879,7 +3888,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981872 + ObjectUIDs ............. 4560549616040779258 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -3919,7 +3928,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885138325650 +PLAN_ID .................. 212324175899984759 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -3963,7 +3972,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981872 + ObjectUIDs ............. 4560549616040779258 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -4226,7 +4235,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212321885141453521 +PLAN_ID .................. 212324175903165153 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4271,7 +4280,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4306,7 +4315,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212321885141492306 +PLAN_ID .................. 212324175903203605 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4352,7 +4361,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4388,7 +4397,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212321885141528792 +PLAN_ID .................. 212324175903242740 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4433,7 +4442,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4469,7 +4478,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212321885141575489 +PLAN_ID .................. 212324175903283921 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4514,7 +4523,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 input_variables ........ %('a') @@ -4578,7 +4587,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212321885141664461 +PLAN_ID .................. 212324175903360153 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -4625,7 +4634,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 input_variables ........ %('upd'), %(4) @@ -4652,7 +4661,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212321885141733289 +PLAN_ID .................. 212324175903436779 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4698,7 +4707,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4733,7 +4742,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212321885141769945 +PLAN_ID .................. 212324175903476720 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4780,7 +4789,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4816,7 +4825,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212321885141803748 +PLAN_ID .................. 212324175903512047 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4862,7 +4871,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4898,7 +4907,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212321885141846512 +PLAN_ID .................. 212324175903553526 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4944,7 +4953,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 input_variables ........ %('a') @@ -5008,7 +5017,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212321885141938820 +PLAN_ID .................. 212324175903632779 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -5056,7 +5065,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177981941 + ObjectUIDs ............. 4560549616040779320 input_variables ........ %('uuu'), %(4) @@ -5233,19 +5242,20 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Wed Feb 10 17:26:00 2016 +-- Definition current Tue Mar 8 05:45:25 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE , B CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + PRIMARY KEY (A ASC) --- SQL operation complete. >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:26:00 2016 +-- Definition current Tue Mar 8 05:45:25 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5258,12 +5268,13 @@ _SALT_ A B C D , COL_VALUE VARCHAR(20) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:26:00 2016 +-- Definition current Tue Mar 8 05:45:25 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5271,6 +5282,7 @@ _SALT_ A B C D , COLUMN_DETAILS VARCHAR(60) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >> @@ -5393,7 +5405,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885161677240 +PLAN_ID .................. 212324175927123261 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -5436,7 +5448,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984042 + ObjectUIDs ............. 4560549616040781936 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -5476,7 +5488,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885161745895 +PLAN_ID .................. 212324175927192763 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -5520,7 +5532,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984042 + ObjectUIDs ............. 4560549616040781936 select_list ............ 1, '1' @@ -5558,7 +5570,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885161799613 +PLAN_ID .................. 212324175927251686 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -5601,7 +5613,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984042 + ObjectUIDs ............. 4560549616040781936 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -5640,7 +5652,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885161866012 +PLAN_ID .................. 212324175927312652 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -5684,7 +5696,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984042 + ObjectUIDs ............. 4560549616040781936 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -5946,7 +5958,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212321885163649284 +PLAN_ID .................. 212324175928946210 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -5991,7 +6003,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -6024,7 +6036,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212321885163703104 +PLAN_ID .................. 212324175929005102 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6070,7 +6082,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6104,7 +6116,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212321885163762184 +PLAN_ID .................. 212324175929068640 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6149,7 +6161,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6183,7 +6195,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212321885163841840 +PLAN_ID .................. 212324175929139799 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -6228,7 +6240,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6291,7 +6303,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212321885164005046 +PLAN_ID .................. 212324175929266354 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -6338,7 +6350,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -6368,7 +6380,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212321885164071839 +PLAN_ID .................. 212324175929346869 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6414,7 +6426,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -6447,7 +6459,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212321885164141735 +PLAN_ID .................. 212324175929409191 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6494,7 +6506,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6528,7 +6540,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212321885164217816 +PLAN_ID .................. 212324175929479669 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6574,7 +6586,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6608,7 +6620,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212321885164282567 +PLAN_ID .................. 212324175929545793 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -6654,7 +6666,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6717,7 +6729,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212321885164415433 +PLAN_ID .................. 212324175929666763 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -6765,7 +6777,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177984162 + ObjectUIDs ............. 4560549616040781998 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -6962,19 +6974,20 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Wed Feb 10 17:26:23 2016 +-- Definition current Tue Mar 8 05:45:52 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE , B CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + PRIMARY KEY (A ASC) --- SQL operation complete. >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:26:23 2016 +-- Definition current Tue Mar 8 05:45:52 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -6987,12 +7000,13 @@ _SALT_ A B C D , COL_VALUE VARCHAR(20) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:26:23 2016 +-- Definition current Tue Mar 8 05:45:52 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -7000,6 +7014,7 @@ _SALT_ A B C D , COLUMN_DETAILS VARCHAR(60) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >> @@ -7122,7 +7137,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885185091978 +PLAN_ID .................. 212324175953641296 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -7165,7 +7180,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986351 + ObjectUIDs ............. 4560549616040784604 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -7205,7 +7220,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885185152819 +PLAN_ID .................. 212324175953734141 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -7249,7 +7264,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986351 + ObjectUIDs ............. 4560549616040784604 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -7288,7 +7303,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885185203931 +PLAN_ID .................. 212324175953816734 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -7331,7 +7346,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986351 + ObjectUIDs ............. 4560549616040784604 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -7372,7 +7387,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885183743840 +PLAN_ID .................. 212324175952493666 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -7416,7 +7431,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986351 + ObjectUIDs ............. 4560549616040784604 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -7679,7 +7694,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212321885186898865 +PLAN_ID .................. 212324175955526117 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7724,7 +7739,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -7758,7 +7773,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212321885186959156 +PLAN_ID .................. 212324175955589592 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7804,7 +7819,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7839,7 +7854,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212321885187022838 +PLAN_ID .................. 212324175955661668 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7884,7 +7899,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7919,7 +7934,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212321885187080416 +PLAN_ID .................. 212324175955727413 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -7964,7 +7979,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 input_variables ........ %('a') @@ -8028,7 +8043,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212321885187212767 +PLAN_ID .................. 212324175955856497 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -8075,7 +8090,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 input_variables ........ %('upd'), %(4) @@ -8102,7 +8117,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212321885187278448 +PLAN_ID .................. 212324175955924581 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8148,7 +8163,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -8182,7 +8197,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212321885187324046 +PLAN_ID .................. 212324175955973846 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8229,7 +8244,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8264,7 +8279,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212321885187382745 +PLAN_ID .................. 212324175956030695 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8310,7 +8325,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8345,7 +8360,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212321885187439570 +PLAN_ID .................. 212324175956088526 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -8391,7 +8406,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 input_variables ........ %('a') @@ -8455,7 +8470,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212321885187560565 +PLAN_ID .................. 212324175956213485 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -8503,7 +8518,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177986475 + ObjectUIDs ............. 4560549616040784661 input_variables ........ %('uuu'), %(4) @@ -8680,19 +8695,20 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Wed Feb 10 17:26:44 2016 +-- Definition current Tue Mar 8 05:46:17 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE , B CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + PRIMARY KEY (A ASC) --- SQL operation complete. >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:26:44 2016 +-- Definition current Tue Mar 8 05:46:17 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8705,12 +8721,13 @@ _SALT_ A B C D , COL_VALUE VARCHAR(20) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Wed Feb 10 17:26:44 2016 +-- Definition current Tue Mar 8 05:46:17 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8718,6 +8735,7 @@ _SALT_ A B C D , COLUMN_DETAILS VARCHAR(60) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >> @@ -8840,7 +8858,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885206481311 +PLAN_ID .................. 212324175978975431 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -8883,7 +8901,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988580 + ObjectUIDs ............. 4560549616040787190 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -8923,7 +8941,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885206545625 +PLAN_ID .................. 212324175979034252 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -8967,7 +8985,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988580 + ObjectUIDs ............. 4560549616040787190 select_list ............ 1, '1' @@ -9005,7 +9023,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885206601773 +PLAN_ID .................. 212324175979087509 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -9048,7 +9066,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988580 + ObjectUIDs ............. 4560549616040787190 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -9088,7 +9106,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212321885206657193 +PLAN_ID .................. 212324175979144151 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -9132,7 +9150,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988580 + ObjectUIDs ............. 4560549616040787190 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -9394,7 +9412,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212321885208444428 +PLAN_ID .................. 212324175980723729 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9439,7 +9457,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -9472,7 +9490,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212321885208506444 +PLAN_ID .................. 212324175980766745 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9518,7 +9536,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9552,7 +9570,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212321885208569011 +PLAN_ID .................. 212324175980834930 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9597,7 +9615,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9631,7 +9649,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212321885208626953 +PLAN_ID .................. 212324175980894503 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -9676,7 +9694,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -9739,7 +9757,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212321885208874924 +PLAN_ID .................. 212324175981003233 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -9786,7 +9804,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -9816,7 +9834,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212321885208941580 +PLAN_ID .................. 212324175981066009 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9862,7 +9880,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -9895,7 +9913,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212321885208994111 +PLAN_ID .................. 212324175981117543 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9942,7 +9960,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9976,7 +9994,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212321885209059552 +PLAN_ID .................. 212324175981174168 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -10022,7 +10040,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -10056,7 +10074,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212321885209136694 +PLAN_ID .................. 212324175981243822 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -10102,7 +10120,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -10165,7 +10183,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212321885209255812 +PLAN_ID .................. 212324175981365129 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -10213,7 +10231,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 5395965056177988641 + ObjectUIDs ............. 4560549616040787250 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -10721,12 +10739,12 @@ CREATE TABLE TRAFODION.SCH."delim_tab" --- SQL operation complete. >>get all volatile schemas; -Schema(Active ): VOLATILE_SCHEMA_MXID110000259692123218850742930010000000002 +Schema(Active ): VOLATILE_SCHEMA_MXID110000244852123241758147790010000000002 --- SQL operation complete. >>get all volatile tables; -Schema(Active ): VOLATILE_SCHEMA_MXID110000259692123218850742930010000000002 +Schema(Active ): VOLATILE_SCHEMA_MXID110000244852123241758147790010000000002 Table: VTAB1 Table: VTAB2
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/seabase/EXPECTED011 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED011 b/core/sql/regress/seabase/EXPECTED011 index 400317e..53ee692 100644 --- a/core/sql/regress/seabase/EXPECTED011 +++ b/core/sql/regress/seabase/EXPECTED011 @@ -7,13 +7,14 @@ >>invoke T011T1; -- Definition of Trafodion table TRAFODION.SCH.T011T1 --- Definition current Wed Mar 2 05:16:53 2016 +-- Definition current Tue Mar 8 05:49:30 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE , B CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + PRIMARY KEY (A ASC) --- SQL operation complete. >> @@ -142,7 +143,7 @@ A B ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... NOT NAMED -PLAN_ID .................. 212323655814425974 +PLAN_ID .................. 212324176171390042 ROWS_OUT ................. 7 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t011t1 where a >= 3 and a < 5; @@ -182,7 +183,7 @@ DESCRIPTION SCHEMA ................. TRAFODION.SCH QUERY_CACHE ............ 0 GENERATE_EXPLAIN ....... ON - ObjectUIDs ............. 4553793696580766799 + ObjectUIDs ............. 7433846178641183029 select_list ............ TRAFODION.SCH.T011T1.A, TRAFODION.SCH.T011T1.B @@ -1269,7 +1270,7 @@ METRIC_TEXT_TABLE >>invoke trafodion."_REPOS_".metric_query_table; -- Definition of Trafodion table TRAFODION."_REPOS_".METRIC_QUERY_TABLE --- Definition current Wed Mar 2 05:18:55 2016 +-- Definition current Tue Mar 8 05:51:31 2016 ( INSTANCE_ID INT UNSIGNED NO DEFAULT NOT NULL NOT @@ -1424,7 +1425,10 @@ METRIC_TEXT_TABLE , NUM_NODES LARGEINT DEFAULT NULL , UDR_PROCESS_BUSY_TIME LARGEINT DEFAULT NULL , PERTABLE_STATS INT DEFAULT NULL + , "_SALT_" INT UNSIGNED NO DEFAULT NOT NULL NOT + DROPPABLE ) + PRIMARY KEY ("_SALT_" ASC, EXEC_START_UTC_TS ASC, QUERY_ID ASC) --- SQL operation complete. >> @@ -1451,7 +1455,7 @@ METRIC_TEXT_TABLE >>-- get qid for the prepared stmt >>get qid for statement explstmt; -MXID11000008089212323655795185001000000000206U3333300_1994_EXPLSTMT +MXID11000029589212324176152856001000000000206U3333300_1994_EXPLSTMT --- SQL operation complete. >> @@ -1503,7 +1507,7 @@ SEQ_NUM OPERATOR --- SQL command prepared. >>get qid for statement explstmt2; -MXID11000008089212323655795185001000000000206U3333300_2005_EXPLSTMT2 +MXID11000029589212324176152856001000000000206U3333300_2005_EXPLSTMT2 --- SQL operation complete. >>set qid MXID123456 for explstmt2; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/seabase/EXPECTED012 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED012 b/core/sql/regress/seabase/EXPECTED012 index e4ba376..4db69b5 100644 --- a/core/sql/regress/seabase/EXPECTED012 +++ b/core/sql/regress/seabase/EXPECTED012 @@ -41,7 +41,7 @@ >>invoke t012t1; -- Definition of Trafodion table TRAFODION.SCH.T012T1 --- Definition current Fri Feb 5 15:58:51 2016 +-- Definition current Thu Feb 25 09:14:19 2016 ( A SMALLINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -55,6 +55,7 @@ DEFAULT DEFAULT NULL , G NUMERIC(5, 2) DEFAULT NULL ) + PRIMARY KEY (A DESC) --- SQL operation complete. >> @@ -64,7 +65,7 @@ >>invoke t012v1; -- Definition of Trafodion view TRAFODION.SCH.T012V1 --- Definition current Fri Feb 5 15:58:54 2016 +-- Definition current Thu Feb 25 09:14:22 2016 ( A SMALLINT NO DEFAULT NOT NULL NOT DROPPABLE http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/seabase/EXPECTED020 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED020 b/core/sql/regress/seabase/EXPECTED020 index b1e8606..08bfb7c 100644 --- a/core/sql/regress/seabase/EXPECTED020 +++ b/core/sql/regress/seabase/EXPECTED020 @@ -6,13 +6,14 @@ >>invoke test020t1; -- Definition of Trafodion table TRAFODION.SCH.TEST020T1 --- Definition current Fri Jun 5 10:06:01 2015 +-- Definition current Sun Mar 13 06:02:17 2016 ( C1 INT NO DEFAULT NOT NULL NOT DROPPABLE , C2 CHAR(20) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT _ISO88591't20t1''s column c2' ) + PRIMARY KEY (C1 ASC) --- SQL operation complete. >>showddl test020t1; @@ -48,13 +49,14 @@ C1 C2 >>invoke test020t2; -- Definition of Trafodion table TRAFODION.SCH.TEST020T2 --- Definition current Fri Jun 5 10:06:03 2015 +-- Definition current Tue Mar 8 22:57:08 2016 ( C CHAR(15) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE , D INT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (C ASC, D ASC) --- SQL operation complete. >>showddl test020t2; @@ -142,15 +144,16 @@ G0 >>-- Test columns named SYSKEY >>-- >> ->>-- Expecting error 1080 message: Duplicate references to column SYSKEY ->>-- in the create request ->>-- when the following Create Table command is executed. +>>-- Expecting error 1269 message: Col name SYSKEY is reserved. >>create table test020t5(syskey int); -*** ERROR[1080] The DDL request has duplicate references to column SYSKEY. +*** ERROR[1269] Column name SYSKEY is reserved for internal system usage. It cannot be specified as a user column. --- SQL operation failed with errors. >> +>>cqd traf_allow_reserved_colnames 'ON'; + +--- SQL operation complete. >>create table test020t5(c int not null not droppable primary key not >>droppable, +> syskey char(4)); @@ -158,13 +161,14 @@ G0 >>invoke test020t5; -- Definition of Trafodion table TRAFODION.SCH.TEST020T5 --- Definition current Fri Jun 5 10:06:10 2015 +-- Definition current Tue Mar 8 22:57:24 2016 ( C INT NO DEFAULT NOT NULL NOT DROPPABLE , SYSKEY CHAR(4) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + PRIMARY KEY (C ASC) --- SQL operation complete. >>showddl test020t5; @@ -215,6 +219,11 @@ ALTER TABLE TRAFODION.SCH.TEST020T5 ADD CONSTRAINT TRAFODION.SCH.TEST020T5C1 *** ERROR[8101] The operation is prevented by check constraint TRAFODION.SCH.TEST020T5C1 on table TRAFODION.SCH.TEST020T5. --- 0 row(s) inserted. +>> +>>cqd traf_allow_reserved_colnames reset; + +--- SQL operation complete. +>> >>-------------------------------------------- >>-- test cases for solution 10-040607-6721 -- >>-------------------------------------------- @@ -251,10 +260,11 @@ ALTER TABLE TRAFODION.SCH.TEST020T5 ADD CONSTRAINT TRAFODION.SCH.TEST020T5C1 >>invoke test020t6; -- Definition of Trafodion table TRAFODION.SCH.TEST020T6 --- Definition current Fri Jun 5 10:06:54 2015 +-- Definition current Tue Mar 8 22:58:27 2016 ( - C INT DEFAULT NULL + SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE + , C INT DEFAULT NULL ) --- SQL operation complete. @@ -415,10 +425,10 @@ ATEST BTEST CTEST DTEST A ----------- - ? 1 - ? 3 + ? + ? --- 4 row(s) selected. >> @@ -3496,4 +3506,24 @@ E@ A 6 5 --- 5 row(s) selected. +>> +>>create table test020t43(c1 int, c2 int ) attribute aligned format ; + +--- SQL operation complete. +>>upsert into test020t43 values (1,1); + +--- 1 row(s) inserted. +>>upsert into test020t43 (c1) values(1); + +--- 1 row(s) inserted. +>>select * from test020t43 ; + +C1 C2 +----------- ----------- + + 1 1 + 1 ? + +--- 2 row(s) selected. +>> >>log; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/seabase/EXPECTED022 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED022 b/core/sql/regress/seabase/EXPECTED022 index 49c30f6..48b4c23 100644 --- a/core/sql/regress/seabase/EXPECTED022 +++ b/core/sql/regress/seabase/EXPECTED022 @@ -426,7 +426,7 @@ ROW_ID (EXPR) >>invoke hbase."_CELL_".t022hbt2; -- Definition of Trafodion table HBASE."_CELL_".T022HBT2 --- Definition current Mon Jul 27 15:00:54 2015 +-- Definition current Thu Feb 25 09:47:53 2016 ( ROW_ID VARCHAR(100) CHARACTER SET ISO88591 @@ -439,12 +439,13 @@ ROW_ID (EXPR) , COL_VALUE VARCHAR(1000) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>invoke hbase."_ROW_".t022hbt2; -- Definition of Trafodion table HBASE."_ROW_".T022HBT2 --- Definition current Mon Jul 27 15:00:54 2015 +-- Definition current Thu Feb 25 09:47:53 2016 ( ROW_ID VARCHAR(100) CHARACTER SET ISO88591 @@ -452,6 +453,7 @@ ROW_ID (EXPR) , COLUMN_DETAILS VARCHAR(10000) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>cqd hbase_max_column_val_length '100000'; @@ -463,7 +465,7 @@ ROW_ID (EXPR) >>invoke hbase."_CELL_".t022hbt2; -- Definition of Trafodion table HBASE."_CELL_".T022HBT2 --- Definition current Mon Jul 27 15:00:54 2015 +-- Definition current Thu Feb 25 09:47:53 2016 ( ROW_ID VARCHAR(100) CHARACTER SET ISO88591 @@ -476,12 +478,13 @@ ROW_ID (EXPR) , COL_VALUE VARCHAR(100000) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>invoke hbase."_ROW_".t022hbt2; -- Definition of Trafodion table HBASE."_ROW_".T022HBT2 --- Definition current Mon Jul 27 15:00:54 2015 +-- Definition current Thu Feb 25 09:47:53 2016 ( ROW_ID VARCHAR(100) CHARACTER SET ISO88591 @@ -489,6 +492,7 @@ ROW_ID (EXPR) , COLUMN_DETAILS VARCHAR(100000) CHARACTER SET ISO88591 COLLATE DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE ) + PRIMARY KEY (ROW_ID ASC) --- SQL operation complete. >>insert into hbase."_CELL_".t022hbt2 values ('1', 'cf', 'a', -1, repeat('a', >>100000)); http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/seabase/EXPECTED025 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED025 b/core/sql/regress/seabase/EXPECTED025 index 5834ac7..522f424 100644 --- a/core/sql/regress/seabase/EXPECTED025 +++ b/core/sql/regress/seabase/EXPECTED025 @@ -1884,7 +1884,7 @@ CREATE TABLE TRAFODION.S025.T025T004 >>insert into T025T003 values +>(DEFAULT,-3,0,1,'dasf',2.1,'dfaf','dfa','dfa','d'); -*** ERROR[8101] The operation is prevented by check constraint TRAFODION.S025.T025T003_953976361_2228 on table TRAFODION.S025.T025T003. +*** ERROR[8101] The operation is prevented by check constraint TRAFODION.S025.T025T003_527751321_8674 on table TRAFODION.S025.T025T003. --- 0 row(s) inserted. >> @@ -1894,7 +1894,7 @@ CREATE TABLE TRAFODION.S025.T025T004 +>(DEFAULT,-2,1,1,'dasf',2.1,'dfaf','dfa','dfa','d'), +>(DEFAULT,-1,2,1,'dasf',2.1,'dfaf','dfa','dfa','d'); -*** ERROR[8101] The operation is prevented by check constraint TRAFODION.S025.T025T003_953976361_2228 on table TRAFODION.S025.T025T003. +*** ERROR[8101] The operation is prevented by check constraint TRAFODION.S025.T025T003_527751321_8674 on table TRAFODION.S025.T025T003. --- 0 row(s) inserted. >> @@ -2603,7 +2603,7 @@ CREATE VOLATILE TABLE T025T00V2 >>invoke T025T00V2; -- Definition of Trafodion volatile table T025T00V2 --- Definition current Sun May 31 00:47:11 2015 +-- Definition current Thu Feb 25 09:56:14 2016 ( SURROGATE_KEY SMALLINT UNSIGNED GENERATED BY DEFAULT AS @@ -2612,6 +2612,7 @@ CREATE VOLATILE TABLE T025T00V2 DROPPABLE , C INT UNSIGNED DEFAULT NULL ) + PRIMARY KEY (SURROGATE_KEY ASC) --- SQL operation complete. >>
