From 3355cf0b7506145e4997958f08f47968b88be953 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 7 Jan 2017 08:45:33 +0000 Subject: [PATCH] Add regress check for ERROR: index returned tuples in wrong order references #3418 git-svn-id: http://svn.osgeo.org/postgis/trunk@15284 b70326c6-7e19-0410-871a-916f4a2858ee --- regress/knn_recheck.sql | 13 +++++++++++++ regress/knn_recheck_expected | 2 ++ 2 files changed, 15 insertions(+) diff --git a/regress/knn_recheck.sql b/regress/knn_recheck.sql index 1475c7219..c216eadc1 100644 --- a/regress/knn_recheck.sql +++ b/regress/knn_recheck.sql @@ -223,3 +223,16 @@ DROP TABLE knn_recheck_geom_nd; -- #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; diff --git a/regress/knn_recheck_expected b/regress/knn_recheck_expected index b81bb729b..9c37f2373 100644 --- a/regress/knn_recheck_expected +++ b/regress/knn_recheck_expected @@ -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 -- 2.40.0