Repository: incubator-trafodion Updated Branches: refs/heads/master 6b3b9486d -> a8eef2d77
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/regress/seabase/EXPECTED010 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/EXPECTED010 b/core/sql/regress/seabase/EXPECTED010 index d567fae..aedd298 100644 --- a/core/sql/regress/seabase/EXPECTED010 +++ b/core/sql/regress/seabase/EXPECTED010 @@ -55,7 +55,7 @@ >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Sat Apr 23 04:03:53 2016 +-- Definition current Fri Jul 8 19:34:10 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -68,7 +68,7 @@ >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:03:53 2016 +-- Definition current Fri Jul 8 19:34:11 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -87,7 +87,7 @@ >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:03:53 2016 +-- Definition current Fri Jul 8 19:34:11 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -218,7 +218,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144236102671 +PLAN_ID .................. 212334766453842648 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -260,7 +260,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698537 + ObjectUIDs ............. 572622736601715642 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -300,7 +300,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144236172868 +PLAN_ID .................. 212334766453912871 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -343,7 +343,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698537 + ObjectUIDs ............. 572622736601715642 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -382,7 +382,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144236246122 +PLAN_ID .................. 212334766453987406 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -424,7 +424,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698537 + ObjectUIDs ............. 572622736601715642 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -464,7 +464,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144234883898 +PLAN_ID .................. 212334766452338098 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -507,7 +507,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698537 + ObjectUIDs ............. 572622736601715642 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -770,7 +770,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212328144237774804 +PLAN_ID .................. 212334766455687220 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -814,7 +814,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -848,7 +848,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212328144237838319 +PLAN_ID .................. 212334766455748750 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -893,7 +893,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -928,7 +928,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212328144237933701 +PLAN_ID .................. 212334766455827825 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -972,7 +972,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1007,7 +1007,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212328144238040780 +PLAN_ID .................. 212334766455915351 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -1051,7 +1051,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 input_variables ........ %('a') @@ -1115,7 +1115,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212328144238219552 +PLAN_ID .................. 212334766456111765 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -1161,7 +1161,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 input_variables ........ %('upd'), %(4) @@ -1188,7 +1188,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212328144238293051 +PLAN_ID .................. 212334766456203087 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1233,7 +1233,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -1267,7 +1267,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212328144238342233 +PLAN_ID .................. 212334766456263024 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1313,7 +1313,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1348,7 +1348,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212328144238413387 +PLAN_ID .................. 212334766456342810 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -1393,7 +1393,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -1428,7 +1428,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212328144238472839 +PLAN_ID .................. 212334766456419643 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -1473,7 +1473,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 input_variables ........ %('a') @@ -1537,7 +1537,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212328144238597986 +PLAN_ID .................. 212334766456613771 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -1584,7 +1584,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266698665 + ObjectUIDs ............. 572622736601715741 input_variables ........ %('uuu'), %(4) @@ -1761,7 +1761,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Sat Apr 23 04:04:22 2016 +-- Definition current Fri Jul 8 19:34:45 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -1774,7 +1774,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:04:22 2016 +-- Definition current Fri Jul 8 19:34:45 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1793,7 +1793,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:04:22 2016 +-- Definition current Fri Jul 8 19:34:45 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -1924,7 +1924,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144264792830 +PLAN_ID .................. 212334766487105587 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -1966,7 +1966,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701767 + ObjectUIDs ............. 572622736601719148 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -2006,7 +2006,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144264858194 +PLAN_ID .................. 212334766487178159 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -2049,7 +2049,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701767 + ObjectUIDs ............. 572622736601719148 select_list ............ 1, '1' @@ -2087,7 +2087,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144264920731 +PLAN_ID .................. 212334766487242937 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -2129,7 +2129,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701767 + ObjectUIDs ............. 572622736601719148 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -2168,7 +2168,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144264982346 +PLAN_ID .................. 212334766487305807 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -2211,7 +2211,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701767 + ObjectUIDs ............. 572622736601719148 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -2473,7 +2473,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212328144266615337 +PLAN_ID .................. 212334766489177010 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2517,7 +2517,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -2551,7 +2551,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212328144266661893 +PLAN_ID .................. 212334766489218800 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2596,7 +2596,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2643,7 +2643,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212328144266702743 +PLAN_ID .................. 212334766489255690 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2687,7 +2687,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -2725,7 +2725,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212328144266745552 +PLAN_ID .................. 212334766489299424 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -2769,7 +2769,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -2836,7 +2836,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212328144266819972 +PLAN_ID .................. 212334766489439489 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -2882,7 +2882,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -2912,7 +2912,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212328144266913570 +PLAN_ID .................. 212334766489537632 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -2957,7 +2957,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -2984,7 +2984,7 @@ DESCRIPTION rows_accessed ........ 100 column_retrieved ....... #1:1,#1:2,#1:3,#1:4 key_columns ............ A, B, C - executor_predicates .... (B = 'a') and (C = 1) and ((A = 1) or (A = 4)) + executor_predicates .... (B = 'a') and (C = cast(1)) and ((A = 1) or (A = 4)) --- SQL operation complete. >>explain y2; @@ -2992,7 +2992,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212328144266974806 +PLAN_ID .................. 212334766489588595 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3038,7 +3038,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3074,7 +3074,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212328144267036984 +PLAN_ID .................. 212334766489632527 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -3119,7 +3119,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -3155,7 +3155,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212328144267100023 +PLAN_ID .................. 212334766489691355 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -3200,7 +3200,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -3264,7 +3264,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212328144267191615 +PLAN_ID .................. 212334766489790654 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -3311,7 +3311,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266701834 + ObjectUIDs ............. 572622736601719272 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -3488,7 +3488,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Sat Apr 23 04:04:48 2016 +-- Definition current Fri Jul 8 19:35:15 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -3501,7 +3501,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:04:48 2016 +-- Definition current Fri Jul 8 19:35:15 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3520,7 +3520,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:04:48 2016 +-- Definition current Fri Jul 8 19:35:15 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -3651,7 +3651,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144290107608 +PLAN_ID .................. 212334766517843423 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -3693,7 +3693,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704365 + ObjectUIDs ............. 572622736601722186 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -3733,7 +3733,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144290179279 +PLAN_ID .................. 212334766517939902 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -3776,7 +3776,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704365 + ObjectUIDs ............. 572622736601722186 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -3815,7 +3815,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144290246591 +PLAN_ID .................. 212334766518006514 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -3857,7 +3857,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704365 + ObjectUIDs ............. 572622736601722186 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -3897,7 +3897,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144288935078 +PLAN_ID .................. 212334766516176126 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -3940,7 +3940,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704365 + ObjectUIDs ............. 572622736601722186 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -4203,7 +4203,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212328144292121052 +PLAN_ID .................. 212334766520083636 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4247,7 +4247,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4282,7 +4282,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212328144292161638 +PLAN_ID .................. 212334766520134179 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4327,7 +4327,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4363,7 +4363,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212328144292198590 +PLAN_ID .................. 212334766520176925 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4407,7 +4407,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4443,7 +4443,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212328144292239365 +PLAN_ID .................. 212334766520224174 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4487,7 +4487,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 input_variables ........ %('a') @@ -4551,7 +4551,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212328144292320041 +PLAN_ID .................. 212334766520354242 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -4597,7 +4597,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 input_variables ........ %('upd'), %(4) @@ -4624,7 +4624,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212328144292393136 +PLAN_ID .................. 212334766520476194 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4669,7 +4669,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -4704,7 +4704,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212328144292431753 +PLAN_ID .................. 212334766520537929 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4750,7 +4750,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4786,7 +4786,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212328144292474349 +PLAN_ID .................. 212334766520597462 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * @@ -4831,7 +4831,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -4867,7 +4867,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212328144292514451 +PLAN_ID .................. 212334766520669759 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -4912,7 +4912,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 input_variables ........ %('a') @@ -4976,7 +4976,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212328144292590301 +PLAN_ID .................. 212334766520777435 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -5023,7 +5023,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... OFF HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266704430 + ObjectUIDs ............. 572622736601722266 input_variables ........ %('uuu'), %(4) @@ -5200,7 +5200,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Sat Apr 23 04:05:13 2016 +-- Definition current Fri Jul 8 19:35:50 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -5213,7 +5213,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:05:13 2016 +-- Definition current Fri Jul 8 19:35:50 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5232,7 +5232,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:05:13 2016 +-- Definition current Fri Jul 8 19:35:50 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -5363,7 +5363,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144315059805 +PLAN_ID .................. 212334766552410284 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -5405,7 +5405,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706876 + ObjectUIDs ............. 572622736601725676 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -5445,7 +5445,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144315122372 +PLAN_ID .................. 212334766552482603 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -5488,7 +5488,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706876 + ObjectUIDs ............. 572622736601725676 select_list ............ 1, '1' @@ -5526,7 +5526,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144315180866 +PLAN_ID .................. 212334766552567708 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -5568,7 +5568,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706876 + ObjectUIDs ............. 572622736601725676 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -5607,7 +5607,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144315245579 +PLAN_ID .................. 212334766552637439 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -5650,7 +5650,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706876 + ObjectUIDs ............. 572622736601725676 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -5912,7 +5912,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212328144316926240 +PLAN_ID .................. 212334766555003288 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -5956,7 +5956,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -5989,7 +5989,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212328144317000051 +PLAN_ID .................. 212334766555091298 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6034,7 +6034,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6068,7 +6068,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212328144317075938 +PLAN_ID .................. 212334766555167856 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6112,7 +6112,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6146,7 +6146,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212328144317135494 +PLAN_ID .................. 212334766555244821 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -6190,7 +6190,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6253,7 +6253,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212328144317248537 +PLAN_ID .................. 212334766555436259 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -6299,7 +6299,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... OFF QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -6329,7 +6329,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212328144317303309 +PLAN_ID .................. 212334766555539743 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6374,7 +6374,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -6407,7 +6407,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212328144317349912 +PLAN_ID .................. 212334766555631751 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6453,7 +6453,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6487,7 +6487,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212328144317409876 +PLAN_ID .................. 212334766555728370 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -6532,7 +6532,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -6566,7 +6566,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212328144317469296 +PLAN_ID .................. 212334766555808295 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -6611,7 +6611,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -6674,7 +6674,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212328144317572749 +PLAN_ID .................. 212334766555985230 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -6721,7 +6721,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266706932 + ObjectUIDs ............. 572622736601725746 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -6918,7 +6918,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Sat Apr 23 04:05:38 2016 +-- Definition current Fri Jul 8 19:36:27 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -6931,7 +6931,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:05:38 2016 +-- Definition current Fri Jul 8 19:36:27 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -6950,7 +6950,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:05:38 2016 +-- Definition current Fri Jul 8 19:36:27 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -7081,7 +7081,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144340252394 +PLAN_ID .................. 212334766589212272 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -7123,7 +7123,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709376 + ObjectUIDs ............. 572622736601729331 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -7163,7 +7163,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144340312113 +PLAN_ID .................. 212334766589284052 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -7206,7 +7206,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709376 + ObjectUIDs ............. 572622736601729331 select_list ............ %(1), %('1') input_variables ........ %(1), %('1') @@ -7245,7 +7245,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144340368341 +PLAN_ID .................. 212334766589363594 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -7287,7 +7287,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709376 + ObjectUIDs ............. 572622736601729331 select_list ............ TRAFODION.SCH.T010T1.A, %('1') input_variables ........ %('1') @@ -7328,7 +7328,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144339112888 +PLAN_ID .................. 212334766587812069 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a = 2; @@ -7371,7 +7371,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709376 + ObjectUIDs ............. 572622736601729331 select_list ............ %(2), TRAFODION.SCH.T010T1.B input_variables ........ %(2) @@ -7634,7 +7634,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212328144342277216 +PLAN_ID .................. 212334766591435696 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7678,7 +7678,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -7712,7 +7712,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212328144342325330 +PLAN_ID .................. 212334766591502962 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7757,7 +7757,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7792,7 +7792,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212328144342385845 +PLAN_ID .................. 212334766591597985 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -7836,7 +7836,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -7871,7 +7871,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212328144342447114 +PLAN_ID .................. 212334766591667392 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -7915,7 +7915,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 input_variables ........ %('a') @@ -7979,7 +7979,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212328144342571114 +PLAN_ID .................. 212334766591821559 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -8025,7 +8025,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 input_variables ........ %('upd'), %(4) @@ -8052,7 +8052,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212328144342639729 +PLAN_ID .................. 212334766591896726 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8097,7 +8097,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), %(1), TRAFODION.SCH.T010T2.D input_variables ........ %('a'), %(1) @@ -8131,7 +8131,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212328144342687157 +PLAN_ID .................. 212334766591946271 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8177,7 +8177,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8212,7 +8212,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212328144342740627 +PLAN_ID .................. 212334766592020522 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -8257,7 +8257,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 select_list ............ TRAFODION.SCH.T010T2.A, %('a'), TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D input_variables ........ %('a') @@ -8292,7 +8292,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212328144342829114 +PLAN_ID .................. 212334766592094795 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -8337,7 +8337,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 input_variables ........ %('a') @@ -8401,7 +8401,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212328144342988889 +PLAN_ID .................. 212334766592243933 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -8448,7 +8448,7 @@ DESCRIPTION QUERY_CACHE ........ 1,024 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266709434 + ObjectUIDs ............. 572622736601729430 input_variables ........ %('uuu'), %(4) @@ -8625,7 +8625,7 @@ _SALT_ A B C D >>invoke t010t1; -- Definition of Trafodion table TRAFODION.SCH.T010T1 --- Definition current Sat Apr 23 04:06:04 2016 +-- Definition current Fri Jul 8 19:36:57 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -8638,7 +8638,7 @@ _SALT_ A B C D >>invoke hbase."_CELL_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_CELL_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:06:04 2016 +-- Definition current Fri Jul 8 19:36:57 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8657,7 +8657,7 @@ _SALT_ A B C D >>invoke hbase."_ROW_"."TRAFODION.SCH.T010T1"; -- Definition of Trafodion table HBASE."_ROW_"."TRAFODION.SCH.T010T1" --- Definition current Sat Apr 23 04:06:04 2016 +-- Definition current Fri Jul 8 19:36:57 2016 ( ROW_ID VARCHAR(10) CHARACTER SET ISO88591 COLLATE @@ -8788,7 +8788,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144365540549 +PLAN_ID .................. 212334766618952598 ROWS_OUT ................ 11 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 or b='1'; @@ -8830,7 +8830,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711846 + ObjectUIDs ............. 572622736601732377 select_list ............ TRAFODION.SCH.T010T1.A, TRAFODION.SCH.T010T1.B @@ -8870,7 +8870,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144365595968 +PLAN_ID .................. 212334766619021126 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1 and b='1'; @@ -8913,7 +8913,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711846 + ObjectUIDs ............. 572622736601732377 select_list ............ 1, '1' @@ -8951,7 +8951,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144365647254 +PLAN_ID .................. 212334766619113688 ROWS_OUT ................ 10 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where b='1'; @@ -8993,7 +8993,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711846 + ObjectUIDs ............. 572622736601732377 select_list ............ TRAFODION.SCH.T010T1.A, '1' @@ -9033,7 +9033,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... XX -PLAN_ID .................. 212328144365700486 +PLAN_ID .................. 212334766619196629 ROWS_OUT ................. 1 EST_TOTAL_COST ........... 0.01 STATEMENT ................ select * from t010t1 where a=1; @@ -9076,7 +9076,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711846 + ObjectUIDs ............. 572622736601732377 select_list ............ 1, TRAFODION.SCH.T010T1.B @@ -9338,7 +9338,7 @@ A B C D ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X1 -PLAN_ID .................. 212328144367286744 +PLAN_ID .................. 212334766621230951 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9382,7 +9382,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -9415,7 +9415,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X2 -PLAN_ID .................. 212328144367337278 +PLAN_ID .................. 212334766621294981 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9460,7 +9460,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9494,7 +9494,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X3 -PLAN_ID .................. 212328144367394943 +PLAN_ID .................. 212334766621378363 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9538,7 +9538,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9572,7 +9572,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X4 -PLAN_ID .................. 212328144367453475 +PLAN_ID .................. 212334766621459813 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -9616,7 +9616,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -9679,7 +9679,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... X5 -PLAN_ID .................. 212328144367556161 +PLAN_ID .................. 212334766621622351 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -9725,7 +9725,7 @@ DESCRIPTION HBASE_FILTER_PREDS ..... ON QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -9755,7 +9755,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y1 -PLAN_ID .................. 212328144367612269 +PLAN_ID .................. 212334766621717723 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9800,7 +9800,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 select_list ............ TRAFODION.SCH.T010T2.A, 'a', 1, TRAFODION.SCH.T010T2.D @@ -9833,7 +9833,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y2 -PLAN_ID .................. 212328144367662094 +PLAN_ID .................. 212334766621795654 ROWS_OUT ................. 5 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9879,7 +9879,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9913,7 +9913,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y3 -PLAN_ID .................. 212328144367715857 +PLAN_ID .................. 212334766621885855 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0 STATEMENT ................ select * @@ -9958,7 +9958,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 select_list ............ TRAFODION.SCH.T010T2.A, 'a', TRAFODION.SCH.T010T2.C, TRAFODION.SCH.T010T2.D @@ -9992,7 +9992,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y4 -PLAN_ID .................. 212328144367769413 +PLAN_ID .................. 212334766621979533 ROWS_OUT ................. 4 EST_TOTAL_COST ........... 0.01 STATEMENT ................ delete from t010t2 @@ -10037,7 +10037,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 TUPLE_FLOW ================================ SEQ_NO 3 CHILDREN 1, 2 @@ -10100,7 +10100,7 @@ DESCRIPTION ------------------------------------------------------------------ PLAN SUMMARY MODULE_NAME .............. DYNAMICALLY COMPILED STATEMENT_NAME ........... Y5 -PLAN_ID .................. 212328144367903054 +PLAN_ID .................. 212334766622139179 ROWS_OUT ................. 2 EST_TOTAL_COST ........... 0 STATEMENT ................ update t010t2 @@ -10147,7 +10147,7 @@ DESCRIPTION QUERY_CACHE ............ 0 MDAM_SCAN_METHOD ....... ON HBASE_MAX_NUM_SEARCH_KE 1 - ObjectUIDs ............. 8974081219266711903 + ObjectUIDs ............. 572622736601732451 TRAFODION_UPDATE ========================== SEQ_NO 1 NO CHILDREN @@ -10655,12 +10655,12 @@ CREATE TABLE TRAFODION.SCH."delim_tab" --- SQL operation complete. >>get all volatile schemas; -Schema(Active ): VOLATILE_SCHEMA_MXID110000323252123281442173510010000000002 +Schema(Active ): VOLATILE_SCHEMA_MXID110000174012123347664118698220000000002 --- SQL operation complete. >>get all volatile tables; -Schema(Active ): VOLATILE_SCHEMA_MXID110000323252123281442173510010000000002 +Schema(Active ): VOLATILE_SCHEMA_MXID110000174012123347664118698220000000002 Table: VTAB1 Table: VTAB2 http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/regress/seabase/TEST003 ---------------------------------------------------------------------- diff --git a/core/sql/regress/seabase/TEST003 b/core/sql/regress/seabase/TEST003 index b2068a5..574662b 100644 --- a/core/sql/regress/seabase/TEST003 +++ b/core/sql/regress/seabase/TEST003 @@ -52,10 +52,24 @@ obey TEST003(setup_lu); obey TEST003(dml_lu); obey TEST003(errors_lu); +cqd traf_boolean_io 'ON'; +obey TEST003(setup_bool); +obey TEST003(dml_bool); +obey TEST003(errors_bool); +obey TEST003(hive_bool); + +cqd traf_boolean_io 'OFF'; +obey TEST003(setup_bool); +obey TEST003(dml_bool_short); + log; exit; ?section setup_tiny +----------------------------------------------------------- +-------------- TINYINT datatype --------------------------- +----------------------------------------------------------- + create table t003t1(a tinyint not null primary key, b tinyint, c tinyint unsigned default 10 not null, d tinyint unsigned); invoke t003t1; @@ -222,16 +236,134 @@ prepare s from insert into t003t2 values (?, ?); execute s using 18446744073709551616, 2; +?section setup_bool +----------------------------------------------------------- +-------------- BOOLEAN datatype --------------------------- +----------------------------------------------------------- + +create table if not exists t003t3(a boolean not null primary key, b boolean) + attribute aligned format; +invoke t003t3; + +create table if not exists t003t3_like like t003t3; +invoke t003t3_like; + +create table if not exists t003t3_as primary key (a) as select * from t003t3; +invoke t003t3_as; + +create table if not exists t003t3_salt(a boolean not null primary key) + salt using 2 partitions; +invoke t003t3_salt; + +?section dml_bool +insert into t003t3 values (true, true); +insert into t003t3 values (false, false); + +select * from t003t3; + +insert into t003t3_as select * from t003t3; +select * from t003t3_as; + +select * from t003t3 where a = true; +select * from t003t3 where a = false; +select * from t003t3 where b = true; +select * from t003t3 where b = false; +select * from t003t3 where a != true; +select * from t003t3 where a != false; +select * from t003t3 where b != true; +select * from t003t3 where b != false; +select * from t003t3 where a is null; +select * from t003t3 where b is not null; + +select * from t003t3 where a = true or a = false; +select * from t003t3 where b = true or b = false; + +select cast('true' as boolean) from (values(1)) x(a); +select cast(' faLse ' as boolean) from (values(1)) x(a); + +select cast(true as boolean not null) from (values(1)) x(a); +select cast(false as boolean) from (values(1)) x(a); + +select cast(a as char(10)), cast (b as varchar(11)) from t003t3; + +delete from t003t3; +prepare s from insert into t003t3 values (?, ?); +execute s using true, true; +execute s using 'false', ' falSE '; +select * from t003t3; + +select !a, !b from t003t3; +select * from t003t3 where !a = false; +update t003t3 set b = !b; +select * from t003t3; + +begin work; +delete from t003t3 where b = false; +select * from t003t3; +rollback work; +select * from t003t3; + +begin work; +update t003t3 set b = false where b != false; +select * from t003t3; +rollback work; +select * from t003t3; + +?section hive_bool +sh echo "drop table tbool;" > TEST003_junk; +sh regrhive.ksh -f TEST003_junk; + +sh echo "create table tbool(a boolean);" > TEST003_junk; +sh regrhive.ksh -f TEST003_junk; + +sh echo "insert into tbool values (true), (false), (NULL);" > TEST003_junk; +sh regrhive.ksh -f TEST003_junk; + +invoke hive.hive.tbool; +select * from hive.hive.tbool; +insert into hive.hive.tbool values (false), (true), (null); +select * from hive.hive.tbool; +insert overwrite table hive.hive.tbool select a from t003t3; +select * from hive.hive.tbool; + +?section errors_bool +update t003t3 set b = b + 1; + +delete from t003t3; + +insert into t003t3 values ('true', false); +insert into t003t3 values (1, true); + +select cast(' truee' as boolean) from (values(1)) x(a); + +prepare s from insert into t003t3 values (?, ?); +execute s using 1, 2; + +?section dml_bool_short +insert into t003t3 values (true, true); +insert into t003t3 values (false, false); + +select * from t003t3; + +delete from t003t3; +prepare s from insert into t003t3 values (cast(? as boolean), cast(? as boolean)); +execute s using true, true; +execute s using 'false', 'falSE'; +select * from t003t3; + ?section clean_up drop table t003t1; drop table t003t1_like; drop table t003t1_as; - drop table t003t2; drop table t003t2_like; drop table t003t2_as; +drop table t003t3; +drop table t003t3_like; +drop table t003t3_as; +drop table t003t3_salt; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/regress/udr/EXPECTED001 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/EXPECTED001 b/core/sql/regress/udr/EXPECTED001 index 25043d4..1c0a4f4 100644 --- a/core/sql/regress/udr/EXPECTED001 +++ b/core/sql/regress/udr/EXPECTED001 @@ -188,7 +188,7 @@ *** ERROR[11246] An error occurred locating function or class 'SESSIONIZE_NON_EXISTENT' in library 'TEST001.dll'. *** ERROR[11248] A call to dlsym returned errors 0 and 0. Details: -/mnt/ssubbiah/incubator-trafodion/core/sqf/rundir/udr/TEST001.dll: undefined symbol: SESSIONIZE_NON_EXISTENT. +/mnt2/ansharma/ansharma_bool/incubator-trafodion/core/sqf/rundir/udr/TEST001.dll: undefined symbol: SESSIONIZE_NON_EXISTENT. --- SQL operation failed with errors. >>-- For now this will succeed, since we don't load the library during @@ -305,10 +305,10 @@ CREATE TABLE_MAPPING FUNCTION TRAFODION.SCH.SESSIONIZE_JAVA SESSION_ID SEQUENCE_NO USERID TS IPADDR -------------------- -------------------- -------------------------------- -------------------- --------------- - 1 1 super-user 212332183199500000 12.345.567.345 - 2 1 super-user 212332190399500000 12.345.567.345 - 2 2 super-services 212332190399500000 12.345.567.345 - 2 3 super-services 212332190399550000 12.345.567.345 + 1 1 super-user 212334861599500000 12.345.567.345 + 2 1 super-user 212334868799500000 12.345.567.345 + 2 2 super-services 212334868799500000 12.345.567.345 + 2 3 super-services 212334868799550000 12.345.567.345 --- 4 row(s) selected. >> @@ -366,7 +366,7 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD SESSION_ID SEQUENCE_NO USERID TS IPADDR -------------------- -------------------- -------------------------------- -------------------- --------------- - 1 1 super-user 212332183199500000 12.345.567.345 + 1 1 super-user 212334861599500000 12.345.567.345 --- 1 row(s) selected. >> @@ -459,10 +459,26 @@ IPADDR SESSION_ID SEQUENCE_NO SESSION_ID SEQUENCE_NO USERID TS IPADDR -------------------- -------------------- -------------------------------- -------------------- --------------- - 1 1 super-user 212332183199500000 12.345.567.345 + 1 1 super-user 212334861599500000 12.345.567.345 --- 1 row(s) selected. >> +>>-- will fail until tinyint support is added for spj/procedures +>>cqd traf_tinyint_spj_support 'ON'; + +--- SQL operation complete. +>>select * ++>from UDF(fibonacci(1,10)) XO ++>order by 1; + +*** ERROR[11151] Unable to use 'type' 'NUMERIC(1) SIGNED NO NULLS' in a user-defined routine. Details: Tinyint datatype not yet supported. + +*** ERROR[8822] The statement was not prepared. + +>>cqd traf_tinyint_spj_support reset; + +--- SQL operation complete. +>> >>select * +>from UDF(fibonacci(1,10)) XO +>order by 1; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/regress/udr/TEST001 ---------------------------------------------------------------------- diff --git a/core/sql/regress/udr/TEST001 b/core/sql/regress/udr/TEST001 index e7089ca..026a794 100644 --- a/core/sql/regress/udr/TEST001 +++ b/core/sql/regress/udr/TEST001 @@ -331,6 +331,13 @@ where operator = 'TMUDF' and description like '% preds_evaluated_by_udf: (SESSION_ID < 2) %'; execute s; +-- will fail until tinyint support is added for spj/procedures +cqd traf_tinyint_spj_support 'ON'; +select * +from UDF(fibonacci(1,10)) XO +order by 1; +cqd traf_tinyint_spj_support reset; + select * from UDF(fibonacci(1,10)) XO order by 1; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/sqlci/Formatter.cpp ---------------------------------------------------------------------- diff --git a/core/sql/sqlci/Formatter.cpp b/core/sql/sqlci/Formatter.cpp index 7ffbee8..6564a17 100644 --- a/core/sql/sqlci/Formatter.cpp +++ b/core/sql/sqlci/Formatter.cpp @@ -227,6 +227,10 @@ Lng32 Formatter::display_length(Lng32 datatype, } break; + case REC_BOOLEAN: + d_len = d_buflen = SQL_BOOLEAN_DISPLAY_SIZE; + break; + default: d_len = d_buflen = length; break; @@ -341,6 +345,7 @@ Int32 Formatter::buffer_it(SqlciEnv * sqlci_env, char *data, case REC_FLOAT32: case REC_FLOAT64: case REC_DATETIME: + case REC_BOOLEAN: { short retcode = convDoIt(data, length, http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/sqlci/Param.cpp ---------------------------------------------------------------------- diff --git a/core/sql/sqlci/Param.cpp b/core/sql/sqlci/Param.cpp index 869d6fa..3f81a83 100644 --- a/core/sql/sqlci/Param.cpp +++ b/core/sql/sqlci/Param.cpp @@ -327,6 +327,7 @@ short Param::convertValue(SqlciEnv * sqlci_env, short targetType, switch(targetType) { + case REC_BOOLEAN: case REC_BIN8_SIGNED: case REC_BIN8_UNSIGNED: case REC_BIN16_SIGNED: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/sqlci/SqlciEnv.cpp ---------------------------------------------------------------------- diff --git a/core/sql/sqlci/SqlciEnv.cpp b/core/sql/sqlci/SqlciEnv.cpp index a8d9bab..a071f27 100644 --- a/core/sql/sqlci/SqlciEnv.cpp +++ b/core/sql/sqlci/SqlciEnv.cpp @@ -491,6 +491,10 @@ void SqlciEnv::datatypeSupport() // can handle largeint unsigned datatype SqlCmd::executeQuery("CONTROL QUERY DEFAULT TRAF_LARGEINT_UNSIGNED_IO 'ON';", this); + + // can handle boolean datatype + SqlCmd::executeQuery("CONTROL QUERY DEFAULT TRAF_BOOLEAN_IO 'ON';", this); + if (!specialError_) { exit(EXIT_FAILURE); http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp ---------------------------------------------------------------------- diff --git a/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp b/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp index 5c7c259..cef4da1 100644 --- a/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp +++ b/core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp @@ -2814,8 +2814,7 @@ short CmpSeabaseDDL::getTypeInfo(const NAType * naType, } break; - - case NA_LOB_TYPE: + case NA_LOB_TYPE: { if (datatype == REC_BLOB) { @@ -2832,6 +2831,12 @@ short CmpSeabaseDDL::getTypeInfo(const NAType * naType, } break; + + case NA_BOOLEAN_TYPE: + { + precision = 0; + } + break; default: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/sqlcomp/CmpSeabaseDDLutil.cpp ---------------------------------------------------------------------- diff --git a/core/sql/sqlcomp/CmpSeabaseDDLutil.cpp b/core/sql/sqlcomp/CmpSeabaseDDLutil.cpp index d127fdd..39ceae4 100644 --- a/core/sql/sqlcomp/CmpSeabaseDDLutil.cpp +++ b/core/sql/sqlcomp/CmpSeabaseDDLutil.cpp @@ -259,6 +259,7 @@ const literalAndEnumStruct ODBCDataTypeXlateArray [] = {COM_DECIMAL_UNSIGNED_ODT, COM_DECIMAL_UNSIGNED_ODT_LIT}, {COM_BLOB_SDT, COM_BLOB_ODT_LIT}, {COM_CLOB_SDT, COM_CLOB_ODT_LIT}, + {COM_BOOLEAN_SDT, COM_BOOLEAN_ODT_LIT}, {COM_DATETIME_ODT, COM_DATETIME_ODT_LIT}, {COM_TIMESTAMP_ODT, COM_TIMESTAMP_ODT_LIT}, {COM_DATE_ODT, COM_DATE_ODT_LIT}, @@ -293,6 +294,7 @@ const literalAndEnumStruct SQLDataTypeXlateArray [] = {COM_LARGE_DECIMAL_SIGNED_SDT, COM_DECIMAL_SIGNED_SDT_LIT}, // one-way conversion enum->literal {COM_BLOB_SDT, COM_BLOB_SDT_LIT}, {COM_CLOB_SDT, COM_CLOB_SDT_LIT}, + {COM_BOOLEAN_SDT, COM_BOOLEAN_SDT_LIT}, {COM_DATETIME_SDT, COM_DATETIME_SDT_LIT}, {COM_TIMESTAMP_SDT, COM_TIMESTAMP_SDT_LIT}, {COM_DATE_SDT, COM_DATE_SDT_LIT}, http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/sqlcomp/DefaultConstants.h ---------------------------------------------------------------------- diff --git a/core/sql/sqlcomp/DefaultConstants.h b/core/sql/sqlcomp/DefaultConstants.h index 3aaebbc..b274b94 100644 --- a/core/sql/sqlcomp/DefaultConstants.h +++ b/core/sql/sqlcomp/DefaultConstants.h @@ -3847,10 +3847,18 @@ enum DefaultConstants // Otherwise typed as bignum TRAF_LARGEINT_UNSIGNED_IO, + // If ON, boolean is supported as returned datatype for a select + // stmt, and for input params. + // Otherwise typed as char + TRAF_BOOLEAN_IO, + // if TRUE, create signed numeric literal for both +ve and -ve numbers. // if FALSE, create unsigned literal for +ve and signed literal for -ve nums. TRAF_CREATE_SIGNED_NUMERIC_LITERAL, + // if TRUE, create tinyint literal insteadl of smallint. + TRAF_CREATE_TINYINT_LITERAL, + // This enum constant must be the LAST one in the list; it's a count, // not an Attribute (it's not IN DefaultDefaults; it's the SIZE of it)! __NUM_DEFAULT_ATTRIBUTES http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/d48a0c94/core/sql/sqlcomp/nadefaults.cpp ---------------------------------------------------------------------- diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp index 3856a76..14e274e 100644 --- a/core/sql/sqlcomp/nadefaults.cpp +++ b/core/sql/sqlcomp/nadefaults.cpp @@ -3323,6 +3323,8 @@ XDDkwd__(SUBQUERY_UNNESTING, "ON"), DDkwd__(TRAF_BLOB_AS_VARCHAR, "ON"), //set to OFF to enable Lobs support + DDkwd__(TRAF_BOOLEAN_IO, "OFF"), + DDkwd__(TRAF_BOOTSTRAP_MD_MODE, "OFF"), DDkwd__(TRAF_CLOB_AS_VARCHAR, "ON"), //set to OFF to enable Lobs support @@ -3333,6 +3335,8 @@ XDDkwd__(SUBQUERY_UNNESTING, "ON"), DDansi_(TRAF_CREATE_TABLE_WITH_UID, ""), + DDkwd__(TRAF_CREATE_TINYINT_LITERAL, "ON"), + DDkwd__(TRAF_DEFAULT_COL_CHARSET, (char *)SQLCHARSETSTRING_ISO88591), DDkwd__(TRAF_ENABLE_ORC_FORMAT, "OFF"),
