[postgis-tickets] [PostGIS] #2422: geography regression difference ST_DWithin, ST_Intersects, ST_Distance (was: geography regression difference ST_DWithin and ST_Intersects)

[PostGIS]

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

Comment(by robe):

 Not sure if it helps -- but definitely something screwy with distance
 cache -- observe using the example above:


 {{{
 SELECT id , ST_Distance(condition_geo,
 ST_Buffer(ST_GeogFromText('POINT(20.0 30.0)'), 20.0)) from test;

  id | st_distance
 ----+-------------
   1 |           0
   2 | 9.954690252
 (2 rows)
 }}}

 and only picking one of course which means it can't use the cache :)


 {{{
 SELECT id , ST_Distance(condition_geo,
 ST_Buffer(ST_GeogFromText('POINT(20.0 30.0)'), 20.0)) from test
 where id = 2;

  id | st_distance
 ----+-------------
   2 |           0
 }}}

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