[SCM] PostGIS branch master updated. 3.5.0-212-gae7be624b

[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  ae7be624b433fff989ccf9e0ff129892c535e4ae (commit)
      from  202d59f44f2e3690038821f889e6506c3b553abf (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 ae7be624b433fff989ccf9e0ff129892c535e4ae
Author: Paul Ramsey <pramsey at cleverelephant.ca>
Date:   Mon Feb 24 16:34:17 2025 -0800

    Fix index binding for ST_DFullyWithin, closes #5855

diff --git a/postgis/gserialized_supportfn.c b/postgis/gserialized_supportfn.c
index 4431ed50c..b6fe6dbba 100644
--- a/postgis/gserialized_supportfn.c
+++ b/postgis/gserialized_supportfn.c
@@ -85,7 +85,7 @@ static const int16 GeometryStrategies[] = {
 	[ST_OVERLAPS_IDX]               = RTOverlapStrategyNumber,
 	[ST_COVERS_IDX]                 = RTContainsStrategyNumber,
 	[ST_CROSSES_IDX]                = RTOverlapStrategyNumber,
-	[ST_DFULLYWITHIN_IDX]           = RTContainsStrategyNumber,
+	[ST_DFULLYWITHIN_IDX]           = RTContainedByStrategyNumber,
 	[ST_3DDWITHIN_IDX]              = RTOverlapStrategyNumber,
 	[ST_3DDFULLYWITHIN_IDX]         = RTOverlapStrategyNumber,
 	[ST_LINECROSSINGDIRECTION_IDX]  = RTOverlapStrategyNumber,
diff --git a/regress/core/tickets.sql b/regress/core/tickets.sql
index 8228e59ca..913970d4b 100644
--- a/regress/core/tickets.sql
+++ b/regress/core/tickets.sql
@@ -1561,3 +1561,17 @@ SELECT '#5677',
 SELECT '#5686', ST_NumInteriorRings('TRIANGLE (( -71.0821 42.3036, -71.0821 42.3936, -71.0901 42.3036, -71.0821 42.3036))'::geometry);
 
 SELECT '#5747', ST_Length('MULTISURFACE (((0 0, 1 0, 1 1, 0 1, 0 0)), CURVEPOLYGON (CIRCULARSTRING (10 10, 11 11, 12 10, 11 9, 10 10)))'::geometry);
+
+-- #5855
+CREATE TEMP TABLE TEST (street text, extent geometry(Polygon,32633));
+INSERT INTO test VALUES ('Knosesmauet','0103000020797F0000010000000500000010B2468761BDDFC06390523AA1B0594110B2468761BDDFC030554D9BC3B0594107992AF50799DFC030554D9BC3B0594107992AF50799DFC06390523AA1B0594110B2468761BDDFC06390523AA1B05941');
+SET enable_seqscan=false;
+CREATE INDEX test_idx ON test USING GIST ( extent );
+
+SELECT '#5855', street
+FROM test
+WHERE ST_DFullyWithin(
+    ST_SetSRID(ST_GeomFromText('POINT(-32356 6734606)'), 32633),
+    extent,
+    1700
+);
diff --git a/regress/core/tickets_expected b/regress/core/tickets_expected
index e81b530ef..27d415dba 100644
--- a/regress/core/tickets_expected
+++ b/regress/core/tickets_expected
@@ -482,3 +482,4 @@ ERROR:  Geometry contains invalid coordinates
 #5677|POLYGON((0 0,0 10,20 22,20 30,30 30,30 20,22 20,10 0,0 0))
 #5686|0
 #5747|0
+#5855|Knosesmauet

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

Summary of changes:
 postgis/gserialized_supportfn.c |  2 +-
 regress/core/tickets.sql        | 14 ++++++++++++++
 regress/core/tickets_expected   |  1 +
 3 files changed, 16 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS