[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0-544-g8288bd8ba

[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  8288bd8ba1bce2939f6a595b17c6db484947b169 (commit)
      from  b6efb488959ef3f81562d3a31ed0f43c576d81c6 (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 8288bd8ba1bce2939f6a595b17c6db484947b169
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.
    
    References #5097 in master branch (3.3.0dev)

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:
 topology/postgis_topology.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS