[postgis-tickets] [PostGIS] #5025: Inconsistent behavior with ST_Within across versions

[PostGIS]

#5025: Inconsistent behavior with ST_Within across versions
----------------------+---------------------------
  Reporter:  byrman   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.0.6
 Component:  postgis  |    Version:  3.1.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by byrman):

 Imre Samu (docker-postgis contributor) recommended me on the postgis-users
 mailing list to remove the older docker images from my test cases and to
 add postgres / postgis / alpine versions:

 {{{
 TAG: 11-2.5-alpine
 IMAGE ID: 10c7c19a572c
 CREATED: 4 days ago
 VERSION: PostgreSQL 11.14 on x86_64-pc-linux-musl, compiled by gcc (Alpine
 10.3.1_git20211027) 10.3.1 20211027, 64-bit
 POSTGIS_FULL_VERSION: POSTGIS="2.5.5" [EXTENSION] PGSQL="110"
 GEOS="3.8.1-CAPI-1.13.3" PROJ="Rel. 7.2.1, January 1st, 2021" GDAL="GDAL
 3.2.3, released 2021/04/27" LIBXML="2.9.12" LIBJSON="0.15"
 LIBPROTOBUF="1.4.0" TOPOLOGY RASTER
 OS VERSION_ID: 3.15.0
 COUNT(*) BEFORE DROPPING INDEX a_3d_idx: 100
 COUNT(*) AFTER DROPPING INDEX a_3d_idx: 100

 TAG: 11-3.2-alpine
 IMAGES ID: 0303403af49f
 CREATED: 4 days ago
 VERSION: PostgreSQL 11.14 on x86_64-pc-linux-musl, compiled by gcc (Alpine
 10.3.1_git20211027) 10.3.1 20211027, 64-bit
 POSTGIS_FULL_VERSION: POSTGIS="3.2.0 0" [EXTENSION] PGSQL="110"
 GEOS="3.10.2-CAPI-1.16.0" PROJ="8.2.0" LIBXML="2.9.12" LIBJSON="0.15"
 LIBPROTOBUF="1.4.0" WAGYU="0.5.0 (Internal)" TOPOLOGY
 OS VERSION_ID: 3.15.0
 COUNT(*) BEFORE DROPPING INDEX a_3d_idx: 100
 COUNT(*) AFTER DROPPING INDEX a_3d_idx: 100

 TAG: 12-3.2-alpine
 IMAGE ID: 964255f0cf36
 CREATED: 4 days ago
 VERSION: PostgreSQL 12.9 on x86_64-pc-linux-musl, compiled by gcc (Alpine
 10.3.1_git20211027) 10.3.1 20211027, 64-bit
 POSTGIS_FULL_VERSION: POSTGIS="3.2.0 0" [EXTENSION] PGSQL="120"
 GEOS="3.10.2-CAPI-1.16.0" PROJ="8.2.0" LIBXML="2.9.12" LIBJSON="0.15"
 LIBPROTOBUF="1.4.0" WAGYU="0.5.0 (Internal)" TOPOLOGY
 OS VERSION_ID: 3.15.0
 COUNT(*) BEFORE DROPPING INDEX a_3d_idx: 50
 COUNT(*) AFTER DROPPING INDEX a_3d_idx: 100

 TAG: 13-3.2-alpine
 IMAGE ID: 5136446fc2a7
 CREATED: 4 days ago
 VERSION: PostgreSQL 13.5 on x86_64-pc-linux-musl, compiled by gcc (Alpine
 10.3.1_git20211027) 10.3.1 20211027, 64-bit
 POSTGIS_FULL_VERSION: POSTGIS="3.2.0 0" [EXTENSION] PGSQL="130"
 GEOS="3.10.2-CAPI-1.16.0" PROJ="8.2.0" LIBXML="2.9.12" LIBJSON="0.15"
 LIBPROTOBUF="1.4.0" WAGYU="0.5.0 (Internal)" TOPOLOGY
 OS VERSION_ID: 3.15.0
 COUNT(*) BEFORE DROPPING INDEX a_3d_idx: 50
 COUNT(*) AFTER DROPPING INDEX a_3d_idx: 100

 TAG: 14-3.2-alpine
 IMAGE ID: 171454c0721a
 CREATED: 4 days ago
 VERSION: PostgreSQL 14.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine
 10.3.1_git20211027) 10.3.1 20211027, 64-bit
 POSTGIS_FULL_VERSION: POSTGIS="3.2.0 0" [EXTENSION] PGSQL="140"
 GEOS="3.10.2-CAPI-1.16.0" PROJ="8.2.0" LIBXML="2.9.12" LIBJSON="0.15"
 LIBPROTOBUF="1.4.0" WAGYU="0.5.0 (Internal)" TOPOLOGY
 OS VERSION_ID: 3.15.0
 COUNT(*) BEFORE DROPPING INDEX a_3d_idx: 50
 COUNT(*) AFTER DROPPING INDEX a_3d_idx: 100
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5025#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.