[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0beta2-20-g2249fb637

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, master has been updated
       via  2249fb637b3afcdac3c6a2b0d01306b59f4379e7 (commit)
      from  a80b805b095d5f75b5d24bde43092e661ad60f6d (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 2249fb637b3afcdac3c6a2b0d01306b59f4379e7
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Jul 25 21:48:57 2022 -0400

    Regression test for  #5139

diff --git a/regress/core/tickets.sql b/regress/core/tickets.sql
index 89a817cb9..08b0fd6a4 100644
--- a/regress/core/tickets.sql
+++ b/regress/core/tickets.sql
@@ -1438,3 +1438,29 @@ SELECT
 
 -- https://trac.osgeo.org/postgis/ticket/5151
 SELECT '#5151', ST_SetPoint(ST_GeomFromText('LINESTRING EMPTY',4326), 1, ST_GeomFromText('POINT(40 50)',4326)) As result;
+
+-- https://trac.osgeo.org/postgis/ticket/5139
+SET client_min_messages TO ERROR;
+DROP TABLE IF EXISTS a;
+CREATE TABLE a AS
+SELECT x AS id, ST_Point(40000 + 10000, -100000 , 27700) AS geom
+FROM generate_series(1,1000000) AS x ;
+
+set max_parallel_workers_per_gather=3;
+set force_parallel_mode=on;
+DROP TABLE IF EXISTS object_list_temp;
+WITH object_list AS (
+	SELECT '#5139'::text AS t, id, to_jsonb(geom) AS json_data
+	FROM a
+	WHERE id::text LIKE '100000%'
+)
+SELECT * INTO TEMPORARY TABLE object_list_temp
+FROM object_list;
+DROP TABLE IF EXISTS object_list;
+SELECT t, id FROM object_list_temp;
+DROP TABLE IF EXISTS object_list_temp;
+DROP TABLE IF EXISTS a;
+reset max_parallel_workers_per_gather;
+reset force_parallel_mode;
+
+SET client_min_messages TO NOTICE;
diff --git a/regress/core/tickets_expected b/regress/core/tickets_expected
index 1dea7e91d..da7ebe1a9 100644
--- a/regress/core/tickets_expected
+++ b/regress/core/tickets_expected
@@ -461,3 +461,5 @@ ERROR:  LWGEOM_addpoint: Invalid offset
 #4799|{"type": "Feature", "geometry": {"type":"Point","crs":{"type":"name","properties":{"name":"EPSG:25832"}},"coordinates":[359667,5651729]}, "properties": {"id": 1, "geom1": {"type":"Point","crs":{"type":"name","properties":{"name":"EPSG:3035"}},"coordinates":[4110471,3103061]}}}
 #5008|f|f
 ERROR:  Line has no points
+#5139|100000
+#5139|1000000

-----------------------------------------------------------------------

Summary of changes:
 regress/core/tickets.sql      | 26 ++++++++++++++++++++++++++
 regress/core/tickets_expected |  2 ++
 2 files changed, 28 insertions(+)


hooks/post-receive
-- 
PostGIS