[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-554-g8b1363ac4

[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  8b1363ac4365a96715ecef67df51eff40980dcd8 (commit)
      from  d03aa1b80f8c0cb04cf37ee8186e29a94feb2abe (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 8b1363ac4365a96715ecef67df51eff40980dcd8
Author: Sandro Santilli <strk at kbt.io>
Date:   Mon Jan 23 17:06:20 2023 +0100

    Make test for selectivity estimation more readable

diff --git a/regress/core/regress_index.sql b/regress/core/regress_index.sql
index 30e7617e2..494ef9ec5 100644
--- a/regress/core/regress_index.sql
+++ b/regress/core/regress_index.sql
@@ -53,6 +53,8 @@ DECLARE
   act INT; -- actual count
   mat TEXT[];
 BEGIN
+
+  -- TODO: rewrite using json output ?
   EXECUTE 'EXPLAIN ANALYZE ' || qry INTO anl;
 
   SELECT regexp_matches(anl, ' rows=([0-9]*) .* rows=([0-9]*) ')
@@ -63,7 +65,7 @@ BEGIN
 
   err = abs(est-act);
 
-  RETURN act || '+=' || tol || ':' || coalesce(
+  RETURN act || '+-' || tol || ':' || coalesce(
     nullif((err < tol)::text,'false'),
     'false:'||err::text
     );
@@ -88,7 +90,7 @@ ALTER TABLE test ALTER COLUMN the_geom SET STATISTICS 10000;
 
 ANALYZE test;
 
-SELECT estimate_error(
+SELECT '&&', id, estimate_error(
   'select num from test where the_geom && ' || box, tol )
   FROM sample_queries ORDER BY id;
 
@@ -97,7 +99,7 @@ SELECT estimate_error(
 CREATE INDEX expressional_gist on test using gist ( st_centroid(the_geom) );
 ANALYZE test;
 
-SELECT 'expr', estimate_error(
+SELECT 'expr &&', id, estimate_error(
   'select num from test where st_centroid(the_geom) && ' || box, tol )
   FROM sample_queries ORDER BY id;
 
diff --git a/regress/core/regress_index_expected b/regress/core/regress_index_expected
index 41cfbb2ff..8872c19ef 100644
--- a/regress/core/regress_index_expected
+++ b/regress/core/regress_index_expected
@@ -10,12 +10,12 @@ scan_seq|Index Scan
 27373|POINT(129.481991 125.755641)
 33863|POINT(127.143785 131.932614)
 45851|POINT(130.986464 132.890625)
-5+=5:true
-907+=60:true
-12505+=500:true
-50000+=600:true
-expr|5+=5:true
-expr|907+=60:true
-expr|12505+=500:true
-expr|50000+=600:true
+&&|1|5+-5:true
+&&|2|907+-60:true
+&&|3|12505+-500:true
+&&|4|50000+-600:true
+expr &&|1|5+-5:true
+expr &&|2|907+-60:true
+expr &&|3|12505+-500:true
+expr &&|4|50000+-600:true
 _st_sortablehash|0|768602608280535040|768602608280535040

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

Summary of changes:
 regress/core/regress_index.sql      |  8 +++++---
 regress/core/regress_index_expected | 16 ++++++++--------
 2 files changed, 13 insertions(+), 11 deletions(-)


hooks/post-receive
-- 
PostGIS