[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.6
 Component:  postgis       |     Version:  2.1.x        
Resolution:                |    Keywords:               
---------------------------+------------------------------------------------

Comment(by jimktrains):

 I was not able to test the exact same tables, and may not be back to
 their office for a bit.  The ones I used were from the TIGER 2013
 dataset for Pennsylvania (SLDU and TABBLOCK).  Theirs was TABBLOCK for
 Allegheny County (FIPS=003) in Pennsylvnia (FIPS=42) and a file defining
 the neighborhoods in Pittsburgh (available here
 http://pittsburghpa.gov/dcp/gis/gis-data).

 As my tables are much larger, containing all blocks in the state and not
 just our county, I wasn't sure exactly where to go to reproduce the
 problem.  I could attempt to mimic their setup on a Windows 8 VM, but may
 not be able to do that for a few days.  If you can think of a situation
 I can force my local install to force it to fail, I can give that a
 shot. (Tomorrow I will try with the exact data they were using, but on
 my machine).

 Thanks,
 Jim

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