From 11a83bbedd73800db70f6f2af5a8eb10d15d39d7 Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Fri, 15 May 2015 21:24:23 +0300 Subject: [PATCH] Silence another create_index regression test failure. More platform differences in the less-significant digits in output. Per buildfarm member rover_firefly, still. --- src/test/regress/expected/create_index.out | 28 +++++++++++----------- src/test/regress/sql/create_index.sql | 4 ++-- 2 files changed, 16 insertions(+), 16 deletions(-) diff --git a/src/test/regress/expected/create_index.out b/src/test/regress/expected/create_index.out index 59016d5ed7..5c2e67d0db 100644 --- a/src/test/regress/expected/create_index.out +++ b/src/test/regress/expected/create_index.out @@ -1207,7 +1207,7 @@ SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10; (10 rows) EXPLAIN (COSTS OFF) -SELECT * FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; +SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; QUERY PLAN --------------------------------------------------- Limit @@ -1215,19 +1215,19 @@ SELECT * FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; Order By: (f1 <-> '(200,300)'::point) (3 rows) -SELECT * FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; - f1 ------------------------------------ - <(288.5,407),68.2367203197809> - <(710.5,175),49.9624859269432> - <(323.5,1433),51.4417145903983> - <(927.5,1178.5),30.4384625104489> - <(1395,373.5),57.1948424248201> - <(1555.5,1007),52.7091073724456> - <(217,1835),44.5982062419555> - <(489,2421.5),22.3886131772381> - <(2424,120.5),39.5> - <(751.5,2655),20.4022057631032> +SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; + circle_center | radius +----------------+-------- + (288.5,407) | 68 + (710.5,175) | 50 + (323.5,1433) | 51 + (927.5,1178.5) | 30 + (1395,373.5) | 57 + (1555.5,1007) | 53 + (217,1835) | 45 + (489,2421.5) | 22 + (2424,120.5) | 40 + (751.5,2655) | 20 (10 rows) -- Now check the results from bitmap indexscan diff --git a/src/test/regress/sql/create_index.sql b/src/test/regress/sql/create_index.sql index 39a94998a0..67dd2f0685 100644 --- a/src/test/regress/sql/create_index.sql +++ b/src/test/regress/sql/create_index.sql @@ -446,8 +446,8 @@ SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10; SELECT * FROM gpolygon_tbl ORDER BY f1 <-> '(0,0)'::point LIMIT 10; EXPLAIN (COSTS OFF) -SELECT * FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; -SELECT * FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; +SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; +SELECT circle_center(f1), round(radius(f1)) as radius FROM gcircle_tbl ORDER BY f1 <-> '(200,300)'::point LIMIT 10; -- Now check the results from bitmap indexscan SET enable_seqscan = OFF; -- 2.40.0