[postgis-tickets] [PostGIS] #2758: ST_Intersects missing rows

[PostGIS]

#2758: ST_Intersects missing rows
---------------------------+------------------------------------------------
 Reporter:  schmiddy       |       Owner:  pramsey
     Type:  defect         |      Status:  new    
 Priority:  medium         |   Milestone:         
Component:  postgis        |     Version:  1.5.X  
 Keywords:  ST_Intersects  |  
---------------------------+------------------------------------------------
 Hi,
 I am testing with the following PostGIS version on OS X:

 POSTGIS="1.5.3" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March 2012"
 LIBXML="2.7.8" USE_STATS (procs from 1.5 r5385 need upgrade)

 I am attaching a simplified test dump plus test query which illustrates
 the problem; a test table is created with four rows with an identical
 geometry column, but an ST_Intersects query always only returns the first
 three rows in the table. If I move the first row COPY'ed into the table to
 the end of the COPY statement, the SELECT will find that row, but not the
 new first row.

 Sorry to be reporting on an older version of PostGIS, I know this bug may
 have already been fixed in newer versions (perhaps ticket 2675?), but
 hopefully this test script should be quite easy to verify.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2758>
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.