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

[Paul Ramsey]

Reproduction data?
P 


--  
http://postgis.net  
http://cleverelephant.ca


On June 1, 2015 at 6:47:27 AM, Rémi Cura (remi.cura at gmail.com) wrote:
> 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
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel