ST_Intersects missing rows
|Reported by:||schmiddy||Owned by:||pramsey|
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.