[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:  new
  Priority:  blocker  |  Milestone:  PostGIS 2.2.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 Try this:


 {{{
 CREATE TABLE knn_recheck_geog_small (
     gid integer,
     geog geography
 );



 INSERT INTO knn_recheck_geog_small VALUES (33768,
 '0101000020E61000003D0AD7A370DD57406666666666E62440');
 INSERT INTO knn_recheck_geog_small VALUES (33767,
 '0101000020E61000003D0AD7A370DD57400000000000002340');
 INSERT INTO knn_recheck_geog_small VALUES (33587,
 '0101000020E610000066666666669657406666666666E62440');
 INSERT INTO knn_recheck_geog_small VALUES (33586,
 '0101000020E610000066666666669657400000000000002340');
 INSERT INTO knn_recheck_geog_small VALUES (33769,
 '0101000020E61000003D0AD7A370DD5740CDCCCCCCCCCC2640');
 INSERT INTO knn_recheck_geog_small VALUES (33766,
 '0101000020E61000003D0AD7A370DD57409A99999999192140');
 INSERT INTO knn_recheck_geog_small VALUES (33588,
 '0101000020E61000006666666666965740CDCCCCCCCCCC2640');
 INSERT INTO knn_recheck_geog_small VALUES (33585,
 '0101000020E610000066666666669657409A99999999192140');
 INSERT INTO knn_recheck_geog_small VALUES (33949,
 '0101000020E610000014AE47E17A2458406666666666E62440');
 INSERT INTO knn_recheck_geog_small VALUES (33948,
 '0101000020E610000014AE47E17A2458400000000000002340');

 CREATE INDEX idx_knn_recheck_geog_small_gist ON knn_recheck_geog_small
 USING gist(geog);


 SELECT gid
 FROM knn_recheck_geog_small
 ORDER BY 'POINT(95 10)'::geography <-> geog LIMIT 1;
 }}}

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