[PostGIS] #5601: A ST_Intersect row is missed when using JOIN.

[PostGIS]

#5601: A ST_Intersect row is missed when using JOIN.
-----------------------+--------------------------
  Reporter:  Wenjing   |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  critical  |  Milestone:  PostGIS GEOS
 Component:  postgis   |    Version:  3.4.x
Resolution:            |   Keywords:
-----------------------+--------------------------
Comment (by pramsey):

 This is a GEOS issue, in versions 3.11 and lower. The following test shows
 the failure in GEOS.
 {{{
 diff --git a/tests/unit/geom/prep/PreparedGeometryTest.cpp
 b/tests/unit/geom/prep/PreparedGeometryTest.cpp
 index efc5c4b82..ffdd90faf 100644
 --- a/tests/unit/geom/prep/PreparedGeometryTest.cpp
 +++ b/tests/unit/geom/prep/PreparedGeometryTest.cpp
 @@ -68,4 +68,21 @@ void object::test<1>
      ensure( pg1->covers(g2.get()));
  }

 +
 +// See https://trac.osgeo.org/postgis/ticket/5601
 +template<>
 +template<>
 +void object::test<2>
 +()
 +{
 +    g1 = reader.read( "LINESTRING(-1 0,0 0)" );
 +    g2 = reader.read( "GEOMETRYCOLLECTION(MULTIPOINT(-1 0),LINESTRING(0
 -1,1 0))" );
 +
 +    pg1 = prep::PreparedGeometryFactory::prepare(g1.get());
 +
 +    ensure(  g1->intersects(g2.get()) );
 +    ensure( pg1->intersects(g2.get()) );
 +}
 +
 +
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5601#comment:5>
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.