v20251212-0001-Remove-redundant-SET-enable_partitionwise_.patch

From 6e17012cfd7995e44f5a699d82dcc784c2337fd0 Mon Sep 17 00:00:00 2001
From: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Date: Fri, 12 Dec 2025 17:43:01 +0530
Subject: [PATCH v20251212] Remove redundant SET enable_partitionwise_join = on
 statement

partition_join.sql test enables partitionwise join using SET
enable_partitionwise_join = on as the first statement. It is reset only at the
end of the test. Hence another SET enable_partitionwise_join = on in between is
not required.

Author: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
---
 src/test/regress/expected/partition_join.out | 1 -
 src/test/regress/sql/partition_join.sql      | 1 -
 2 files changed, 2 deletions(-)

diff --git a/src/test/regress/expected/partition_join.out b/src/test/regress/expected/partition_join.out
index 17d27ef3d46..290fe52902d 100644
--- a/src/test/regress/expected/partition_join.out
+++ b/src/test/regress/expected/partition_join.out
@@ -5198,7 +5198,6 @@ ANALYZE fract_t;
 -- (avoid merge joins, because the costs of partitionwise and non-partitionwise
 -- merge joins tend to be almost equal, and we want this test to be stable)
 SET max_parallel_workers_per_gather = 0;
-SET enable_partitionwise_join = on;
 SET enable_mergejoin = off;
 EXPLAIN (COSTS OFF)
 SELECT x.id, y.id FROM fract_t x LEFT JOIN fract_t y USING (id) ORDER BY x.id ASC LIMIT 10;
diff --git a/src/test/regress/sql/partition_join.sql b/src/test/regress/sql/partition_join.sql
index d153297acba..19a6d19a99c 100644
--- a/src/test/regress/sql/partition_join.sql
+++ b/src/test/regress/sql/partition_join.sql
@@ -1225,7 +1225,6 @@ ANALYZE fract_t;
 -- (avoid merge joins, because the costs of partitionwise and non-partitionwise
 -- merge joins tend to be almost equal, and we want this test to be stable)
 SET max_parallel_workers_per_gather = 0;
-SET enable_partitionwise_join = on;
 SET enable_mergejoin = off;
 
 EXPLAIN (COSTS OFF)

base-commit: 493eb0da31be4520252e1af723342dc7ead0c3e5
-- 
2.34.1