NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitf5f084f

committed

Remove unstable KNN SP-GiST test

6cae9d2 introduced test for NULL values in KNN SP-GiST. This test relies onundetermined ordering showing different results on various platforms. Thiscommit removes that test. Will be replaced with better test later.Discussion:https://postgr.es/m/6d51305e1159241cabee132f7efc7eff%40xs4all.nlBackpatch-through: 12

1 parent8c8a267 commitf5f084fCopy full SHA for f5f084f

File tree

2 files changed

-14

lines changed

src/test/regress
- expected
  - create_index_spgist.out
- sql
  - create_index_spgist.sql

2 files changed

-14

lines changed

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

Lines changed: 0 additions & 10 deletions

Original file line number	Diff line number	Diff line change
`@@ -555,16 +555,6 @@ WHERE seq.dist IS DISTINCT FROM idx.dist;`
`555`	`555`	`---+------+---+---+------+---`
`556`	`556`	`(0 rows)`
`557`	`557`
`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`		`-`
`568`	`558`	`EXPLAIN (COSTS OFF)`
`569`	`559`	`SELECT count(*) FROM radix_text_tbl WHERE t = 'P0123456789abcdef';`
`570`	`560`	`QUERY PLAN`

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

Lines changed: 0 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -225,10 +225,6 @@ SELECT * FROM quad_point_tbl_ord_seq3 seq FULL JOIN kd_point_tbl_ord_idx3 idx`
`225`	`225`	`ONseq.n=idx.n`
`226`	`226`	`WHEREseq.dist IS DISTINCTFROMidx.dist;`
`227`	`227`
`228`		`--- check ORDER BY distance to NULL`
`229`		`-SELECT (SELECT pFROM kd_point_tblORDER BY p<-> ptLIMIT1)`
`230`		`-FROM (VALUES (point'1,2'), (NULL), ('1234,5678')) pts(pt);`
`231`		`-`
`232`	`228`
`233`	`229`	`EXPLAIN (COSTS OFF)`
`234`	`230`	`SELECTcount(*)FROM radix_text_tblWHERE t='P0123456789abcdef';`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitf5f084f

File tree

2 files changed

2 files changed

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

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

0 commit comments