[postgis-tickets] [PostGIS] #2543: invalid join selectivity error from simple query

[PostGIS]

#2543: invalid join selectivity error from simple query
---------------------------+------------------------------------------------
  Reporter:  paulfriedman  |       Owner:  pramsey      
      Type:  defect        |      Status:  reopened     
  Priority:  high          |   Milestone:  PostGIS 2.1.2
 Component:  postgis       |     Version:  2.1.x        
Resolution:                |    Keywords:               
---------------------------+------------------------------------------------
Changes (by jimktrains):

  * status:  closed => reopened
  * resolution:  fixed =>


Comment:

 I experienced this issue on a Windows 7 x64 Machine. robe2 suggested I
 reopen this ticket.

 PostgreSQL 9.4.1
         POSTGIS="2.1.5 r13152" GEOS="3.4.2-CAPI-1.8.2 r3924" PROJ="Rel.
 4.8.0, 6 March 2012" GDAL="GDAL 1.11.1, released 2014/09/24 GDAL_DATA not
 found" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER
 PostgreSQL 9.3.6
         POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3924" PROJ="Rel.
 4.8.0, 6 March 2012" GDAL="GDAL 1.10.0, released 2013/04/24 GDAL_DATA not
 found" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER"

 SELECT *
 FROM
   blocks AS b,
   neighborhood AS n
 WHERE n.hood LIKE 'Central%'
       AND  ST_CONTAINS(n.geom,b.geom);
 ---------------------------------------------
 ERROR:  invalid join selectivity: 22339560.000000
 ********** Error **********
 ERROR: invalid join selectivity: 22339560.000000
 SQL state: XX000

 +++++++++++++++++++++++++++++++++++++++++++++++++
 HOWEVER
 on my home machine, with tables larger than the
 two I was helping my friend with, it works fine
 +++++++++++++++++++++++++++++++++++++++++++++++++

 Ubuntu 14.04.1
 geodata=# select version();
                                                version
 ------------------------------------------------------------------------------------------------------
  PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu
 4.8.2-19ubuntu1) 4.8.2, 64-bit
 (1 row)

 geodata=# select postgis_full_version();NOTICE:  Function
 postgis_topology_scripts_installed() not found. Is topology support
 enabled and topology.sql installed?
 postgis_full_version
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="2.1.3 r12547" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
 March 2012" GDAL="GDAL 1.11.0, released 2014/04/16" LIBXML="2.9.1"
 LIBJSON="UNKNOWN" (core procs from "2.1.2 r12389" need upgrade) RASTER
 (raster procs from "2.1.2 r12389" need upgrade)
 (1 row)

 geodata=# select count(*) from tiger2013.sldu inner join
 tiger2013.tabblock  on st_contains(sldu.geom, tabblock.geom) where
 sldu.geoid = '42042';
  count
 -------
  25228
 (1 row)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2543#comment:13>
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.