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

[Paul Ramsey]

Because by inspection, I don't see how anything gets past this:

https://github.com/postgis/postgis/blob/svn-trunk/postgis/gserialized_estimate.c#L1094-L1096

On Mon, Jun 1, 2015 at 6:49 AM, Paul Ramsey <pramsey at cleverelephant.ca> wrote:
> 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
>