Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit f5f084f

Browse filesBrowse files
committed
Remove unstable KNN SP-GiST test
6cae9d2 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
1 parent 8c8a267 commit f5f084f
Copy full SHA for f5f084f

File tree

Expand file treeCollapse file tree

2 files changed

+0
-14
lines changed
Filter options
Expand file treeCollapse file tree

2 files changed

+0
-14
lines changed

‎src/test/regress/expected/create_index_spgist.out

Copy file name to clipboardExpand all lines: src/test/regress/expected/create_index_spgist.out
-10Lines changed: 0 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -555,16 +555,6 @@ WHERE seq.dist IS DISTINCT FROM idx.dist;
555555
---+------+---+---+------+---
556556
(0 rows)
557557

558-
-- check ORDER BY distance to NULL
559-
SELECT (SELECT p FROM kd_point_tbl ORDER BY p <-> pt LIMIT 1)
560-
FROM (VALUES (point '1,2'), (NULL), ('1234,5678')) pts(pt);
561-
p
562-
-------------
563-
(59,21)
564-
(9853,112)
565-
(1239,5647)
566-
(3 rows)
567-
568558
EXPLAIN (COSTS OFF)
569559
SELECT count(*) FROM radix_text_tbl WHERE t = 'P0123456789abcdef';
570560
QUERY PLAN

‎src/test/regress/sql/create_index_spgist.sql

Copy file name to clipboardExpand all lines: src/test/regress/sql/create_index_spgist.sql
-4Lines changed: 0 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -225,10 +225,6 @@ SELECT * FROM quad_point_tbl_ord_seq3 seq FULL JOIN kd_point_tbl_ord_idx3 idx
225225
ON seq.n = idx.n
226226
WHERE seq.dist IS DISTINCT FROM idx.dist;
227227

228-
-- check ORDER BY distance to NULL
229-
SELECT (SELECT p FROM kd_point_tbl ORDER BY p <-> pt LIMIT 1)
230-
FROM (VALUES (point '1,2'), (NULL), ('1234,5678')) pts(pt);
231-
232228

233229
EXPLAIN (COSTS OFF)
234230
SELECT count(*) FROM radix_text_tbl WHERE t = 'P0123456789abcdef';

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.