[postgis-tickets] [PostGIS] #2422: geography regression difference ST_DWithin

[PostGIS]

#2422: geography regression difference ST_DWithin
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  2.1.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by robe):

 Hmm it might not be specific to geometry.  If I put these 2 bad geometries
 in a table called bad_face2  and run this:


 {{{
 SELECT id
 , _ST_DistanceTree(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography)
 , _ST_DistanceUnCached(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography)
 FROM bad_face2
 WHERE
   NOT _ST_DWithin(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography, 1609.344,true )
 AND _ST_DWithinUnCached(geog, st_setsrid(st_makepoint(-71.0636, 42.3584),
 4326)::geography, 1609.344 );
 }}}

 I get this:


 {{{
  id   | _st_distancetree | _st_distanceuncached
 ------+------------------+----------------------
 12301 | 1398.40705751386 |     1398.40705751386
 }}}

 I get only one back.

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