[SCM] PostGIS branch stable-3.3 updated. 3.3.10-89-g5c81d8e00

[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.3 has been updated
       via  5c81d8e00a78deae3387a6a875441284bbdc5634 (commit)
       via  b76c8ea766bf55ad15362f26f042adb9d0200431 (commit)
      from  27f4d3304b832ba82ef257b4412d9142be47c132 (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 5c81d8e00a78deae3387a6a875441284bbdc5634
Merge: 27f4d3304 b76c8ea76
Author: Darafei Praliaskouski <komzpa at gmail.com>
Date:   Fri Jul 24 04:56:25 2026 -0700

    Merge pull request 'Fix regress_index on PostgreSQL 18 for 3.3' (!501) from Komzpa/postgis:fix/stable33-regress-index-pg18-20260724 into stable-3.3
    
    Reviewed-on: https://gitea.osgeo.org/postgis/postgis/pulls/501


commit b76c8ea766bf55ad15362f26f042adb9d0200431
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Mar 3 00:38:17 2025 -0500

    Fix regress_index on PostgreSQL 18
    
    PostgreSQL 18 can report fractional actual row counts in EXPLAIN ANALYZE. Accept that form and cast through numeric before comparing the selectivity estimate with the actual count.
    
    Use an escape string for the regular expression so the test remains stable when standard_conforming_strings is off.
    
    References #5851 for PostGIS 3.3
    
    (cherry picked from commit 8b1bb8316bab89f0433cf36ee085974b5acdeec8)
    
    (cherry picked from commit 56a3c6e3099d1e7da4326400779b23b8e3e7c634)
    
    (cherry picked from commit bdf0f1ab2ec393271eb37037f6cda8e94632e576)
    
    (cherry picked from commit 9b18cb4be92d5222faa253566618c915c3bf39ba)

diff --git a/NEWS b/NEWS
index 08f31397d..48bd45c03 100644
--- a/NEWS
+++ b/NEWS
@@ -4,6 +4,8 @@ PostGIS 3.3.11
 * Bug Fixes and Enhancements *
 
  - #5823, Build support for Pg18 (Paul Ramsey)
+ - #5851, Fix regress_index test with PostgreSQL 18 fractional actual rows
+   (Regina Obe)
  - #6094, [upgrade] Avoid legacy string literal warnings in downgrade checks
    with standard_conforming_strings off (Darafei Praliaskouski)
  - Flatgeobuf schema mismatch vulnerability (NeuroWinter)
diff --git a/regress/core/regress_index.sql b/regress/core/regress_index.sql
index 30e7617e2..d8765f661 100644
--- a/regress/core/regress_index.sql
+++ b/regress/core/regress_index.sql
@@ -55,11 +55,11 @@ DECLARE
 BEGIN
   EXECUTE 'EXPLAIN ANALYZE ' || qry INTO anl;
 
-  SELECT regexp_matches(anl, ' rows=([0-9]*) .* rows=([0-9]*) ')
+  SELECT regexp_matches(anl, E' rows=([0-9]*) .* rows=([0-9\.]*) ')
   INTO mat;
 
   est := mat[1];
-  act := mat[2];
+  act := mat[2]::numeric::integer;
 
   err = abs(est-act);
 

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

Summary of changes:
 NEWS                           | 2 ++
 regress/core/regress_index.sql | 4 ++--
 2 files changed, 4 insertions(+), 2 deletions(-)


hooks/post-receive
-- 
PostGIS