[postgis-tickets] [PostGIS] #2703: KNN gist with recheck for 9.5?

[PostGIS]

#2703: KNN gist with recheck for 9.5?
--------------------------+---------------------------
  Reporter:  robe         |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  high         |  Milestone:  PostGIS 2.2.0
 Component:  postgis      |    Version:  trunk
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by robe):

 Okay seems an issue if I do limit more than 1 and I have an index on
 table:


 {{{
 CREATE TABLE test_geog_knn AS
 SELECT ROW_NUMBER()OVER(ORDER BY x,y) AS gid, ST_Point(x,y)::geography As
 geog
 FROM generate_series(-10,70, 10) As x , generate_series(0,90, 10) As y;

 CREATE INDEX idx_test_geog_knn ON test_geog_knn USING gist(geog);
 SELECT * FROM test_geog_knn ORDER BY (SELECT geog FROM test_geog_knn WHERE
 gid = 1)  <-> geog limit 10;


 }}}


 outputs:


 {{{
 ERROR:  index returned tuples in wrong order
 ********** Error **********

 ERROR: index returned tuples in wrong order
 SQL state: XX000

 }}}

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