[postgis-tickets] [PostGIS] #3418: KNN recheck in 9.5 fails with index returned tuples in wrong order when used in function

[PostGIS]

#3418: KNN recheck in 9.5 fails with index returned tuples in wrong order when
used in function
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.4.0
 Component:  postgis  |    Version:  2.2.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 As before, this issue only affects geometry.  Our geography implementation
 seems to be okay.


 {{{
 create table test_geog (geo geography);
  insert into test_geog values
   ('0101000020E61000007D91D0967329E4BF6631B1F9B8D64A40'::geography),
   ('0101000020E6100000E2AFC91AF510C1BFCDCCCCCCCCAC4A40'::geography);


 create index on test_geog using gist (geo);
 vacuum analyze test_geog;
 set enable_seqscan = false;
 select * from test_geog ORDER BY geo <->
 ('0101000020E610000092054CE0D6DDE5BFCDCCCCCCCCAC4A40'::geography);

 }}}

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