From 6a6c752b08ac2d4a24811123d5c565412f75f6f4 Mon Sep 17 00:00:00 2001
From: Neil Conway <neilc@samurai.com>
Date: Tue, 29 May 2007 04:17:08 +0000
Subject: [PATCH] Stop a few regression tests from needlessly disabling GEQO.
 This was necessary in 1997, when geqo_threshold did not exist, but it is no
 longer needed.

---
 src/test/regress/expected/geometry.out   | 2 --
 src/test/regress/expected/geometry_1.out | 2 --
 src/test/regress/expected/geometry_2.out | 2 --
 src/test/regress/expected/point.out      | 2 --
 src/test/regress/expected/tinterval.out  | 2 --
 src/test/regress/sql/geometry.sql        | 4 ----
 src/test/regress/sql/point.sql           | 5 -----
 src/test/regress/sql/tinterval.sql       | 4 ----
 8 files changed, 23 deletions(-)

diff --git a/src/test/regress/expected/geometry.out b/src/test/regress/expected/geometry.out
index e90952cc2f..6910e54ec6 100644
--- a/src/test/regress/expected/geometry.out
+++ b/src/test/regress/expected/geometry.out
@@ -284,7 +284,6 @@ SELECT '' AS twenty, b.f1 / p.f1 AS rotation
 --
 -- Paths
 --
-SET geqo TO 'off';
 SELECT '' AS eight, npoints(f1) AS npoints, f1 AS path FROM PATH_TBL;
  eight | npoints |           path            
 -------+---------+---------------------------
@@ -337,7 +336,6 @@ SELECT '' AS eight, p1.f1 * point '(2,-1)' AS dist_mul
        | ((34,13),(40,15))
 (8 rows)
 
-RESET geqo;
 --
 -- Polygons
 --
diff --git a/src/test/regress/expected/geometry_1.out b/src/test/regress/expected/geometry_1.out
index 164fc71017..0e01492525 100644
--- a/src/test/regress/expected/geometry_1.out
+++ b/src/test/regress/expected/geometry_1.out
@@ -284,7 +284,6 @@ SELECT '' AS twenty, b.f1 / p.f1 AS rotation
 --
 -- Paths
 --
-SET geqo TO 'off';
 SELECT '' AS eight, npoints(f1) AS npoints, f1 AS path FROM PATH_TBL;
  eight | npoints |           path            
 -------+---------+---------------------------
@@ -337,7 +336,6 @@ SELECT '' AS eight, p1.f1 * point '(2,-1)' AS dist_mul
        | ((34,13),(40,15))
 (8 rows)
 
-RESET geqo;
 --
 -- Polygons
 --
diff --git a/src/test/regress/expected/geometry_2.out b/src/test/regress/expected/geometry_2.out
index 2763ca1643..7787dab061 100644
--- a/src/test/regress/expected/geometry_2.out
+++ b/src/test/regress/expected/geometry_2.out
@@ -284,7 +284,6 @@ SELECT '' AS twenty, b.f1 / p.f1 AS rotation
 --
 -- Paths
 --
-SET geqo TO 'off';
 SELECT '' AS eight, npoints(f1) AS npoints, f1 AS path FROM PATH_TBL;
  eight | npoints |           path            
 -------+---------+---------------------------
@@ -337,7 +336,6 @@ SELECT '' AS eight, p1.f1 * point '(2,-1)' AS dist_mul
        | ((34,13),(40,15))
 (8 rows)
 
-RESET geqo;
 --
 -- Polygons
 --
diff --git a/src/test/regress/expected/point.out b/src/test/regress/expected/point.out
index 96bcc6d695..a31a4b39b7 100644
--- a/src/test/regress/expected/point.out
+++ b/src/test/regress/expected/point.out
@@ -105,7 +105,6 @@ SELECT '' AS six, p.f1, p.f1 <-> point '(0,0)' AS dist
      | (5.1,34.5) | 34.8749193547455
 (6 rows)
 
-SET geqo TO 'off';
 SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist
    FROM POINT_TBL p1, POINT_TBL p2
    ORDER BY dist, p1.f1[0], p2.f1[0];
@@ -222,4 +221,3 @@ SELECT '' AS three, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS dista
        | (5.1,34.5) | (10,10)  | 24.9851956166046
 (3 rows)
 
-RESET geqo;
diff --git a/src/test/regress/expected/tinterval.out b/src/test/regress/expected/tinterval.out
index 5644cbc493..1b4586b87a 100644
--- a/src/test/regress/expected/tinterval.out
+++ b/src/test/regress/expected/tinterval.out
@@ -103,7 +103,6 @@ SELECT '' AS three, t1.*
        | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
 (3 rows)
 
-SET geqo TO 'off';
 SELECT '' AS five, t1.f1, t2.f1
    FROM TINTERVAL_TBL t1, TINTERVAL_TBL t2
    WHERE t1.f1 && t2.f1 and
@@ -167,4 +166,3 @@ SELECT '' AS three, t1.f1
        | ["Wed Dec 31 16:00:00 1969 PST" "Mon May 01 00:30:30 1995 PDT"]
 (3 rows)
 
-RESET geqo;
diff --git a/src/test/regress/sql/geometry.sql b/src/test/regress/sql/geometry.sql
index 523bcdb76d..73f8032bb1 100644
--- a/src/test/regress/sql/geometry.sql
+++ b/src/test/regress/sql/geometry.sql
@@ -87,8 +87,6 @@ SELECT '' AS twenty, b.f1 / p.f1 AS rotation
 -- Paths
 --
 
-SET geqo TO 'off';
-
 SELECT '' AS eight, npoints(f1) AS npoints, f1 AS path FROM PATH_TBL;
 
 SELECT '' AS four, path(f1) FROM POLYGON_TBL;
@@ -101,8 +99,6 @@ SELECT '' AS eight, p1.f1 + point '(10,10)' AS dist_add
 SELECT '' AS eight, p1.f1 * point '(2,-1)' AS dist_mul
    FROM PATH_TBL p1;
 
-RESET geqo;
-
 --
 -- Polygons
 --
diff --git a/src/test/regress/sql/point.sql b/src/test/regress/sql/point.sql
index 1f5f7635d1..8523c2ee9f 100644
--- a/src/test/regress/sql/point.sql
+++ b/src/test/regress/sql/point.sql
@@ -55,8 +55,6 @@ SELECT '' AS six, p.f1, p.f1 <-> point '(0,0)' AS dist
    FROM POINT_TBL p
    ORDER BY dist;
 
-SET geqo TO 'off';
-
 SELECT '' AS thirtysix, p1.f1 AS point1, p2.f1 AS point2, p1.f1 <-> p2.f1 AS dist
    FROM POINT_TBL p1, POINT_TBL p2
    ORDER BY dist, p1.f1[0], p2.f1[0];
@@ -76,6 +74,3 @@ SELECT '' AS three, p1.f1 AS point1, p2.f1 AS point2, (p1.f1 <-> p2.f1) AS dista
    FROM POINT_TBL p1, POINT_TBL p2 
    WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 >^ p2.f1
    ORDER BY distance;
-
-RESET geqo;
-
diff --git a/src/test/regress/sql/tinterval.sql b/src/test/regress/sql/tinterval.sql
index 82d61dda3e..5abdb6d106 100644
--- a/src/test/regress/sql/tinterval.sql
+++ b/src/test/regress/sql/tinterval.sql
@@ -70,8 +70,6 @@ SELECT '' AS three, t1.*
    WHERE t1.f1 &&
         tinterval '["Aug 15 14:23:19 1983" "Sep 16 14:23:19 1983"]';
 
-SET geqo TO 'off';
-
 SELECT '' AS five, t1.f1, t2.f1
    FROM TINTERVAL_TBL t1, TINTERVAL_TBL t2
    WHERE t1.f1 && t2.f1 and
@@ -97,5 +95,3 @@ SELECT '' AS three, t1.f1
         (abstime 'Aug 15 14:23:19 1983' <#>
          abstime 'Sep 16 14:23:19 1983')
    ORDER BY t1.f1;
-
-RESET geqo;
-- 
2.40.0