[postgis-devel] Major bug with postgis && operator, affecting topology

[Rémi Cura]

Hey,
I re-opened the ticket [here](
http://trac.osgeo.org/postgis/ticket/2543#comment:21).

This is a major bug (in my opinion).


Simply doing something like
------
SELECT *
FROM node, face
WHERE geom && mbr
--------

raises an error
"ERROR: invalid join selectivity:"
(answer should be None, tables have one line each! )

This is pretty terrible, because spatial intersect is at the basis of
PostGIS, and it affects classical PostGIS topology tables, so it is not
possible to change the tables easily.

Worse, it affects a pretty recent PostGIS version (POSTGIS="2.2.0dev
r12846" GEOS="3.5.0dev-CAPI-1.9.0 r0" PROJ="Rel. 4.8.0, 6 March 2012"
GDAL="GDAL 2.0.0dev, released 2014/04/16" LIBXML="2.8.0" TOPOLOGY RASTER),
with Postgres 9.3 and Ubuntu 12.04.

Cheers,
Remi-C
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20150601/f25dda65/attachment.html>