[postgis-tickets] [SCM] PostGIS branch stable-3.2 updated. 3.2.1-3-ge9014f4aa

[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, stable-3.2 has been updated
       via  e9014f4aa144b17a65e3a4a2e4f796108c3032f6 (commit)
      from  3422d27f6dc45c1e17d302857c3d4d21ac56586d (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 e9014f4aa144b17a65e3a4a2e4f796108c3032f6
Author: Sandro Santilli <strk at kbt.io>
Date:   Tue Feb 15 14:30:42 2022 +0100

    Do not sort by edge_id in getClosestEdge callback, to effectively use index.
    
    Closes #5097 in stable-3.2 branch (3.2.2dev)
    
    Includes NEWS item

diff --git a/NEWS b/NEWS
index e4df8b33a..0ca0b162f 100644
--- a/NEWS
+++ b/NEWS
@@ -1,3 +1,10 @@
+PostGIS 3.2.2dev
+2022/MM/DD
+
+* Bug Fixes *
+  - #5097, Ensure spatial index is used during topology population
+           at the getClosestEdge step (Sandro Santilli)
+
 PostGIS 3.2.1
 2022/02/12
 
diff --git a/topology/postgis_topology.c b/topology/postgis_topology.c
index 152446118..e42a1e916 100644
--- a/topology/postgis_topology.c
+++ b/topology/postgis_topology.c
@@ -3007,7 +3007,7 @@ cb_getClosestEdge( const LWT_BE_TOPOLOGY* topo, const LWPOINT* pt, uint64_t *num
 
   appendStringInfoString(sql, "SELECT ");
   addEdgeFields(sql, fields, 0);
-  appendStringInfo(sql, " FROM \"%s\".edge_data ORDER BY geom <-> $1 ASC, edge_id ASC LIMIT 1", topo->name);
+  appendStringInfo(sql, " FROM \"%s\".edge_data ORDER BY geom <-> $1 ASC LIMIT 1", topo->name);
 
   POSTGIS_DEBUGF(1, "cb_getClosestEdge query: %s", sql->data);
 

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

Summary of changes:
 NEWS                        | 7 +++++++
 topology/postgis_topology.c | 2 +-
 2 files changed, 8 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS