You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by hz...@apache.org on 2016/10/31 22:55:09 UTC
[02/11] incubator-trafodion git commit: [TRAFODION-2317]
Infrastructure for common subexpressions
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/b90dc334/core/sql/regress/core/EXPECTED004.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED004.SB b/core/sql/regress/core/EXPECTED004.SB
index 797c654..0bd919b 100644
--- a/core/sql/regress/core/EXPECTED004.SB
+++ b/core/sql/regress/core/EXPECTED004.SB
@@ -4569,11 +4569,11 @@ OP DESCRIP
[8 ] ROOT statement: select * from ta where a1 not in (select b2 from tb) order by a1;
[7 ] SORT ?
-[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no
+[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum)
[5 ] NESTED_ANTI_SEMI_JOIN join_type: inner anti-semi join_method: nested parallel_join_type: 2 (N2J Opens all inner partitions)
[4 ] PROBE_CACHE ?
[3 ] TRAFODION_SCAN (TB) executor_predicates: not((TRAFODION.SCH.TA.A1 <> B2) is true)
-[2 ] ESP_EXCHANGE parent_processes: 4 child_processes: 1 parent_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no partitioning_expression: (HashDistPartHash(cast(randomNum)) Hash2Distrib scaledNumParts) merged_order: TRAFODION.SCH.TA.A1
+[2 ] ESP_EXCHANGE parent_processes: 4 child_processes: 1 parent_partitioning_function: hash2 partitioned 4 ways on (randomNum) partitioning_expression: (HashDistPartHash(cast(randomNum)) Hash2Distrib scaledNumParts) merged_order: TRAFODION.SCH.TA.A1
[1 ] TRAFODION_SCAN (TA) ?
--- 8 row(s) selected.
@@ -4614,11 +4614,11 @@ OP DESCRIP
[8 ] ROOT statement: select * from ta where a1 not in (select b4 from tb) order by a1;
[7 ] SORT ?
-[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no
+[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum)
[5 ] NESTED_ANTI_SEMI_JOIN join_type: inner anti-semi join_method: nested parallel_join_type: 2 (N2J Opens all inner partitions)
[4 ] PROBE_CACHE ?
[3 ] TRAFODION_SCAN (TB) executor_predicates: not((TRAFODION.SCH.TA.A1 <> B4) is true)
-[2 ] ESP_EXCHANGE parent_processes: 4 child_processes: 1 parent_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no partitioning_expression: (HashDistPartHash(cast(randomNum)) Hash2Distrib scaledNumParts) merged_order: TRAFODION.SCH.TA.A1
+[2 ] ESP_EXCHANGE parent_processes: 4 child_processes: 1 parent_partitioning_function: hash2 partitioned 4 ways on (randomNum) partitioning_expression: (HashDistPartHash(cast(randomNum)) Hash2Distrib scaledNumParts) merged_order: TRAFODION.SCH.TA.A1
[1 ] TRAFODION_SCAN (TA) ?
--- 8 row(s) selected.
@@ -4753,11 +4753,11 @@ OP DESCRIP
[8 ] ROOT statement: select * from ta where a2 not in (select b1 from tb) order by a1;
[7 ] SORT ?
-[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no
+[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum)
[5 ] NESTED_ANTI_SEMI_JOIN join_type: inner anti-semi join_method: nested parallel_join_type: 2 (N2J Opens all inner partitions)
[4 ] PROBE_CACHE ?
[3 ] TRAFODION_SCAN (TB) executor_predicates: not((TRAFODION.SCH.TA.A2 <> B1) is true)
-[2 ] ESP_EXCHANGE parent_processes: 4 child_processes: 1 parent_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no partitioning_expression: (HashDistPartHash(cast(randomNum)) Hash2Distrib scaledNumParts) merged_order: TRAFODION.SCH.TA.A1
+[2 ] ESP_EXCHANGE parent_processes: 4 child_processes: 1 parent_partitioning_function: hash2 partitioned 4 ways on (randomNum) partitioning_expression: (HashDistPartHash(cast(randomNum)) Hash2Distrib scaledNumParts) merged_order: TRAFODION.SCH.TA.A1
[1 ] TRAFODION_SCAN (TA) ?
--- 8 row(s) selected.
@@ -4805,11 +4805,11 @@ OP DESCRIP
[8 ] ROOT statement: select * from ta where a2 not in (select b2 from tb) order by a1;
[7 ] SORT ?
-[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no
+[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum)
[5 ] NESTED_ANTI_SEMI_JOIN join_type: inner anti-semi join_method: nested parallel_join_type: 2 (N2J Opens all inner partitions)
[4 ] PROBE_CACHE ?
[3 ] TRAFODION_SCAN (TB) executor_predicates: not((TRAFODION.SCH.TA.A2 <> B2) is true)
-[2 ] ESP_EXCHANGE parent_processes: 4 child_processes: 1 parent_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no partitioning_expression: (HashDistPartHash(cast(randomNum)) Hash2Distrib scaledNumParts) merged_order: TRAFODION.SCH.TA.A1
+[2 ] ESP_EXCHANGE parent_processes: 4 child_processes: 1 parent_partitioning_function: hash2 partitioned 4 ways on (randomNum) partitioning_expression: (HashDistPartHash(cast(randomNum)) Hash2Distrib scaledNumParts) merged_order: TRAFODION.SCH.TA.A1
[1 ] TRAFODION_SCAN (TA) ?
--- 8 row(s) selected.
@@ -4849,11 +4849,11 @@ OP DESCRIP
[8 ] ROOT statement: select * from ta where a4 not in (select b4 from tb) order by a1;
[7 ] SORT ?
-[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum) seamonster_query: no seamonster_exchange: no
+[6 ] ESP_EXCHANGE parent_processes: 1 child_processes: 4 child_partitioning_function: hash2 partitioned 4 ways on (randomNum)
<TRUNCATED>