[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-556-gc5766f2f7

[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  c5766f2f7069f94b9f4b32ab3243a928d583b21b (commit)
      from  0326a711a33a2ff3a60630537326f8c2ce09616e (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 c5766f2f7069f94b9f4b32ab3243a928d583b21b
Author: Sandro Santilli <strk at kbt.io>
Date:   Mon Jan 23 17:28:47 2023 +0100

    Test that the selectivity functions are as expected core types operators

diff --git a/regress/core/regress_selectivity.sql b/regress/core/regress_selectivity.sql
index bfcd4299e..5cb6868fc 100644
--- a/regress/core/regress_selectivity.sql
+++ b/regress/core/regress_selectivity.sql
@@ -1,5 +1,22 @@
 -- Make example data
 
+SELECT 'restrict',
+	format('%s %s %s', o.oprleft::regtype, o.oprname, o.oprright::regtype),
+	o.oprrest
+FROM pg_operator o, pg_type t
+WHERE o.oprname IN
+	-- Shall we have more of these ?
+	( '&&', '&&&', '@', '~' )
+AND o.oprleft = t.oid
+AND o.oprright = t.oid
+AND t.typname IN
+	-- raster and topology intentionally left out
+	-- as they'd belong in a different test
+	( 'geometry', 'geography' )
+ORDER BY oprname, oprleft::regtype::text, oprright::regtype::text
+;
+
+
 CREATE TABLE regular_overdots_ab (
     a integer,
     b integer
diff --git a/regress/core/regress_selectivity_expected b/regress/core/regress_selectivity_expected
index 1ce252849..266fa094b 100644
--- a/regress/core/regress_selectivity_expected
+++ b/regress/core/regress_selectivity_expected
@@ -1,3 +1,8 @@
+restrict|geography && geography|gserialized_gist_sel_nd
+restrict|geometry && geometry|gserialized_gist_sel_2d
+restrict|geometry &&& geometry|gserialized_gist_sel_nd
+restrict|geometry @ geometry|contsel
+restrict|geometry ~ geometry|contsel
 ERROR:  stats for "no_stats.g" do not exist
 ERROR:  stats for "no_stats.g" do not exist
 ERROR:  stats for "no_stats.g" do not exist

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

Summary of changes:
 regress/core/regress_selectivity.sql      | 17 +++++++++++++++++
 regress/core/regress_selectivity_expected |  5 +++++
 2 files changed, 22 insertions(+)


hooks/post-receive
-- 
PostGIS