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>
