[postgis-tickets] r15284 - Add regress check for ERROR: index returned tuples in wrong order

[Regina Obe]

Author: robe
Date: 2017-01-07 00:45:33 -0800 (Sat, 07 Jan 2017)
New Revision: 15284

Modified:
   trunk/regress/knn_recheck.sql
   trunk/regress/knn_recheck_expected
Log:
Add regress check for ERROR:  index returned tuples in wrong order
references #3418

Modified: trunk/regress/knn_recheck.sql
===================================================================
--- trunk/regress/knn_recheck.sql	2017-01-06 16:22:38 UTC (rev 15283)
+++ trunk/regress/knn_recheck.sql	2017-01-07 08:45:33 UTC (rev 15284)
@@ -223,3 +223,16 @@
 -- #3573
 SELECT '#3573', 'POINT M (0 0 13)'::geometry <<->> 'LINESTRING M (0 0 5, 0 1 6)'::geometry;
 
+-- #3418
+CREATE TABLE test_wo (geo geometry);
+INSERT INTO test_wo VALUES 
+  ('0101000020E61000007D91D0967329E4BF6631B1F9B8D64A40'::geometry), 
+  ('0101000020E6100000E2AFC91AF510C1BFCDCCCCCCCCAC4A40'::geometry);
+CREATE INDEX ON TEST_WO USING GIST (GEO);
+analyze test_wo;
+SET enable_seqscan = false;
+SELECT '#3418' As ticket, '0101000020E610000092054CE0D6DDE5BFCDCCCCCCCCAC4A40'::geometry <-> geo, ST_Distance('0101000020E610000092054CE0D6DDE5BFCDCCCCCCCCAC4A40'::geometry, geo) 
+FROM test_wo ORDER BY geo <->
+('0101000020E610000092054CE0D6DDE5BFCDCCCCCCCCAC4A40'::geometry);
+DROP TABLE test_wo;
+set enable_seqscan to default;

Modified: trunk/regress/knn_recheck_expected
===================================================================
--- trunk/regress/knn_recheck_expected	2017-01-06 16:22:38 UTC (rev 15283)
+++ trunk/regress/knn_recheck_expected	2017-01-07 08:45:33 UTC (rev 15284)
@@ -125,3 +125,5 @@
 #3nd-3|600001|9749|54.5453|54.5453
 #3nd-3|600001|10041|54.6233|54.6233
 #3573|8
+#3418|0.331823813642119|0.331823813642119
+#3418|0.55|0.55