[postgis-tickets] [PostGIS] #4604: ST_Intersects discrepancy between 2.5.3 and 3.0.0

PostGIS trac at osgeo.org
Tue Feb 18 08:25:23 PST 2020


#4604: ST_Intersects discrepancy between 2.5.3 and 3.0.0
----------------------+---------------------------
  Reporter:  paf31    |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.0.1
 Component:  postgis  |    Version:  3.0.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by sergius):

 I think the following info is related.

 Official documentation ( https://postgis.net/docs/ST_Intersects.html )
 example shows:

 Geography Examples

 {{{
 SELECT ST_Intersects(
 'SRID=4326;LINESTRING(-43.23456 72.4567,-43.23456 72.4568)'::geography,
 'SRID=4326;POINT(-43.23456 72.4567772)'::geography
 );
  st_intersects
 ---------------
 t
 }}}

 But at my environment the same code provides:
 ''false''

 "PostgreSQL 12.1, compiled by Visual C++ build 1914, 64-bit POSTGIS="3.0.0
 r17983" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 " PROJ="Rel.
 5.2.0, September 15th, 2018" LIBXML="2.9.9" LIBJSON="0.12"
 LIBPROTOBUF="1.2.1" WAGYU="0.4.3 (Internal)""

 **PostgreSQL 11 with POSTGIS 3.0.0 executes this query correctly.**

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4604#comment:2>
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.


More information about the postgis-tickets mailing list