[PostGIS] #5601: A ST_Intersect row is missed when using JOIN.
PostGIS
trac at osgeo.org
Tue Oct 31 00:43:38 PDT 2023
#5601: A ST_Intersect row is missed when using JOIN.
-----------------------+---------------------------
Reporter: Wenjing | Owner: pramsey
Type: defect | Status: new
Priority: critical | Milestone: PostGIS 3.5.0
Component: postgis | Version: 3.4.x
Resolution: | Keywords:
-----------------------+---------------------------
Comment (by Wenjing):
The (2, 3) row is missed.
{{{
SELECT a1.id, a2.id FROM t As a1 JOIN t As a2 ON ST_Intersects(a1.geom,
a2.geom) WHERE a1.id <> a2.id;
-- id | id
-- ----+----
-- 1 | 2
-- 1 | 3
-- 2 | 1
-- 3 | 1
-- 3 | 2
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5601#comment:1>
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