diff options
| author | Alexander Korotkov <akorotkov@postgresql.org> | 2019-09-20 01:46:49 +0300 |
|---|---|---|
| committer | Alexander Korotkov <akorotkov@postgresql.org> | 2019-09-20 01:51:05 +0300 |
| commit | f5f084fc3ec516545d826e1e9b7ab4aabf612698 (patch) | |
| tree | fa0682b8f04be555fd4313d6e1f98743fae3ade0 | |
| parent | 8c8a267201bebb0edeaab2a76b7d3bcc9739924f (diff) | |
Remove unstable KNN SP-GiST test
6cae9d2c10 introduced test for NULL values in KNN SP-GiST. This test relies on
undetermined ordering showing different results on various platforms. This
commit removes that test. Will be replaced with better test later.
Discussion: https://postgr.es/m/6d51305e1159241cabee132f7efc7eff%40xs4all.nl
Backpatch-through: 12
| -rw-r--r-- | src/test/regress/expected/create_index_spgist.out | 10 | ||||
| -rw-r--r-- | src/test/regress/sql/create_index_spgist.sql | 4 |
2 files changed, 0 insertions, 14 deletions
diff --git a/src/test/regress/expected/create_index_spgist.out b/src/test/regress/expected/create_index_spgist.out index 5ccea915867..81b4a67c390 100644 --- a/src/test/regress/expected/create_index_spgist.out +++ b/src/test/regress/expected/create_index_spgist.out @@ -555,16 +555,6 @@ WHERE seq.dist IS DISTINCT FROM idx.dist; ---+------+---+---+------+--- (0 rows) --- check ORDER BY distance to NULL -SELECT (SELECT p FROM kd_point_tbl ORDER BY p <-> pt LIMIT 1) -FROM (VALUES (point '1,2'), (NULL), ('1234,5678')) pts(pt); - p -------------- - (59,21) - (9853,112) - (1239,5647) -(3 rows) - EXPLAIN (COSTS OFF) SELECT count(*) FROM radix_text_tbl WHERE t = 'P0123456789abcdef'; QUERY PLAN diff --git a/src/test/regress/sql/create_index_spgist.sql b/src/test/regress/sql/create_index_spgist.sql index 629936fd3d4..66d77286356 100644 --- a/src/test/regress/sql/create_index_spgist.sql +++ b/src/test/regress/sql/create_index_spgist.sql @@ -225,10 +225,6 @@ SELECT * FROM quad_point_tbl_ord_seq3 seq FULL JOIN kd_point_tbl_ord_idx3 idx ON seq.n = idx.n WHERE seq.dist IS DISTINCT FROM idx.dist; --- check ORDER BY distance to NULL -SELECT (SELECT p FROM kd_point_tbl ORDER BY p <-> pt LIMIT 1) -FROM (VALUES (point '1,2'), (NULL), ('1234,5678')) pts(pt); - EXPLAIN (COSTS OFF) SELECT count(*) FROM radix_text_tbl WHERE t = 'P0123456789abcdef'; |