Movatterモバイル変換

[0]ホーム
URL:

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

 Sign up
Appearance settings

Commit9feaba2

Browse files
committed
Silence create_index regression test failure.
The expected output contained some floating point values which might getrounded slightly differently on different platforms. The exact output isn'tvery interesting in this test, so just round it.Per buildfarm member rover_firefly.
1 parent98edd61 commit9feaba2

File tree

2 files changed

+14
-14
lines changed

2 files changed

+14
-14
lines changed

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

Lines changed: 13 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -387,19 +387,19 @@ SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10;
387387
((2424,81),(2424,160),(2424,160),(2424,81))
388388
(10 rows)
389389

390-
SELECT* FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
391-
f1
392-
-----------------------------------
393-
<(288.5,407),68.2367203197809>
394-
<(710.5,175),49.9624859269432>
395-
<(323.5,1433),51.4417145903983>
396-
<(927.5,1178.5),30.4384625104489>
397-
<(1395,373.5),57.1948424248201>
398-
<(1555.5,1007),52.7091073724456>
399-
<(217,1835),44.5982062419555>
400-
<(489,2421.5),22.3886131772381>
401-
<(2424,120.5),39.5>
402-
<(751.5,2655),20.4022057631032>
390+
SELECTcircle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
391+
circle_center | radius
392+
----------------+--------
393+
(288.5,407) | 68
394+
(710.5,175) | 50
395+
(323.5,1433) | 51
396+
(927.5,1178.5) | 30
397+
(1395,373.5) | 57
398+
(1555.5,1007) | 53
399+
(217,1835) | 45
400+
(489,2421.5) | 22
401+
(2424,120.5) | 40
402+
(751.5,2655) | 20
403403
(10 rows)
404404

405405
-- Now check the results from plain indexscan

‎src/test/regress/sql/create_index.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -226,7 +226,7 @@ SELECT count(*) FROM radix_text_tbl WHERE t ~>~ 'Worth
226226

227227
SELECT*FROM gpolygon_tblORDER BY f1<->'(0,0)'::pointLIMIT10;
228228

229-
SELECT*FROM gcircle_tblORDER BY f1<->'(200,300)'::pointLIMIT10;
229+
SELECTcircle_center(f1), round(radius(f1))as radiusFROM gcircle_tblORDER BY f1<->'(200,300)'::pointLIMIT10;
230230

231231
-- Now check the results from plain indexscan
232232
SET enable_seqscan= OFF;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp