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

Commit11a83bb

Browse files
committed
Silence another create_index regression test failure.
More platform differences in the less-significant digits in output.Per buildfarm member rover_firefly, still.
1 parent07af523 commit11a83bb

File tree

2 files changed

+16
-16
lines changed

2 files changed

+16
-16
lines changed

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

Lines changed: 14 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -1207,27 +1207,27 @@ SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10;
12071207
(10 rows)
12081208

12091209
EXPLAIN (COSTS OFF)
1210-
SELECT* FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
1210+
SELECTcircle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
12111211
QUERY PLAN
12121212
---------------------------------------------------
12131213
Limit
12141214
-> Index Scan using ggcircleind on gcircle_tbl
12151215
Order By: (f1 <-> '(200,300)'::point)
12161216
(3 rows)
12171217

1218-
SELECT* FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
1219-
f1
1220-
-----------------------------------
1221-
<(288.5,407),68.2367203197809>
1222-
<(710.5,175),49.9624859269432>
1223-
<(323.5,1433),51.4417145903983>
1224-
<(927.5,1178.5),30.4384625104489>
1225-
<(1395,373.5),57.1948424248201>
1226-
<(1555.5,1007),52.7091073724456>
1227-
<(217,1835),44.5982062419555>
1228-
<(489,2421.5),22.3886131772381>
1229-
<(2424,120.5),39.5>
1230-
<(751.5,2655),20.4022057631032>
1218+
SELECTcircle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10;
1219+
circle_center | radius
1220+
----------------+--------
1221+
(288.5,407) | 68
1222+
(710.5,175) | 50
1223+
(323.5,1433) | 51
1224+
(927.5,1178.5) | 30
1225+
(1395,373.5) | 57
1226+
(1555.5,1007) | 53
1227+
(217,1835) | 45
1228+
(489,2421.5) | 22
1229+
(2424,120.5) | 40
1230+
(751.5,2655) | 20
12311231
(10 rows)
12321232

12331233
-- Now check the results from bitmap indexscan

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

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -446,8 +446,8 @@ SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10;
446446
SELECT*FROM gpolygon_tblORDER BY f1<->'(0,0)'::pointLIMIT10;
447447

448448
EXPLAIN (COSTS OFF)
449-
SELECT*FROM gcircle_tblORDER BY f1<->'(200,300)'::pointLIMIT10;
450-
SELECT*FROM gcircle_tblORDER BY f1<->'(200,300)'::pointLIMIT10;
449+
SELECTcircle_center(f1), round(radius(f1))as radiusFROM gcircle_tblORDER BY f1<->'(200,300)'::pointLIMIT10;
450+
SELECTcircle_center(f1), round(radius(f1))as radiusFROM gcircle_tblORDER BY f1<->'(200,300)'::pointLIMIT10;
451451

452452
-- Now check the results from bitmap indexscan
453453
SET enable_seqscan= OFF;

0 commit comments

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