[postgis-tickets] [PostGIS] #3131: KNN geography still gives ERROR: index returned tuples in wrong order

[PostGIS]

#3131: KNN geography still gives  ERROR:  index returned tuples in wrong order
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  reopened
  Priority:  blocker  |  Milestone:  PostGIS 2.2.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------
Changes (by robe):

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


Comment:

 okeedok nothing like breaking one thing to fix another.  My commit at
 r13590 fixed #3127 but broke this one again:

 though now I think I can only exercise with a large test like:


 {{{
 set enable_seqscan = true; --with index use fails (when use_spheroid =
 true )
 SELECT a.gid, ST_geometryType(a.geog::geometry),  ARRAY(SELECT
 (gid,a.geog <-> g.geog)
                         FROM knn_recheck_geog As g WHERE a.gid <> g.gid
 ORDER BY a.geog <-> g.geog LIMIT 5)  ,
         ARRAY(SELECT  (gid )
                         FROM knn_recheck_geog As g WHERE a.gid <> g.gid
 ORDER BY ST_Distance(a.geog, g.geog) LIMIT 5)
 FROM knn_recheck_geog As a
         WHERE a.gid IN(500000,500001,1000,2614)
 ORDER BY a.gid;

 }}}


 I'm okay with sacrificing and just putting in a note in docs tht <-> uses
 sphere instead of spheroid.  Unless you think there is an easy fix or its
 just uncovering a more serious issue.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3131#comment:12>
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.