[postgis-tickets] [PostGIS] #2556: geography ST_Intersects results depending on insert order

[PostGIS]

#2556: geography ST_Intersects results depending on insert order
--------------------------------------------------+-------------------------
 Reporter:  gekorob                               |       Owner:  pramsey      
     Type:  defect                                |      Status:  new          
 Priority:  high                                  |   Milestone:  PostGIS 2.1.2
Component:  postgis                               |     Version:  2.1.x        
 Keywords:  st_intersects intersection geography  |  
--------------------------------------------------+-------------------------

Comment(by robe):

 I've confirmed same issue with original ticket example so the two are the
 same issue.


 {{{
 SELECT id, _ST_DistanceUnCached(extent, geog) As uncached_dist,
 ST_Distance(extent,geog) As dist,
 _ST_DistanceUncached(ST_Boundary(extent::geometry)::geography,
 ST_Boundary(geog::Geometry)::geography) As bounddist
 from images CROSS JOIN st_geogfromtext('SRID=4326;POLYGON((-46.625977
 81.634149,-46.625977 81.348076,-48.999023 81.348076,-48.999023
 81.634149,-46.625977 81.634149))') As geog;

  id   |  uncached_dist   |      dist       |    bounddist
 ------+------------------+-----------------+------------------
 47409 | 20623.2731762032 | 20623.273176203 | 20623.2731762032
     1 |                0 | 16361.577605712 | 16361.5776057123
 }}}

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