aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNoah Misch <noah@leadboat.com>2018-07-29 12:02:07 -0700
committerNoah Misch <noah@leadboat.com>2018-07-29 12:02:10 -0700
commite7688696db693fe4be8c08ce85fc2bc002bab285 (patch)
tree114083f3496e655d4ddfe894a5ebdb418ce5e29b
parentca4a6de17432bec94988a44de990481f0e18ab22 (diff)
downloadpostgresql-e7688696db693fe4be8c08ce85fc2bc002bab285.tar.gz
postgresql-e7688696db693fe4be8c08ce85fc2bc002bab285.zip
Fix earthdistance test suite function name typo.
Affected test queries have been testing the wrong thing since their introduction in commit 4c1383efd132e4f532213c8a8cc63a455f55e344. Back-patch to 9.3 (all supported versions).
-rw-r--r--contrib/earthdistance/expected/earthdistance.out44
-rw-r--r--contrib/earthdistance/sql/earthdistance.sql8
2 files changed, 28 insertions, 24 deletions
diff --git a/contrib/earthdistance/expected/earthdistance.out b/contrib/earthdistance/expected/earthdistance.out
index 89022491cb6..90e3d2e2d58 100644
--- a/contrib/earthdistance/expected/earthdistance.out
+++ b/contrib/earthdistance/expected/earthdistance.out
@@ -882,11 +882,12 @@ SELECT earth_box(ll_to_earth(90,180),
--
-- Test the recommended constraints.
--
-SELECT is_point(ll_to_earth(0,0));
-ERROR: function is_point(earth) does not exist
-LINE 1: SELECT is_point(ll_to_earth(0,0));
- ^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+SELECT cube_is_point(ll_to_earth(0,0));
+ cube_is_point
+---------------
+ t
+(1 row)
+
SELECT cube_dim(ll_to_earth(0,0)) <= 3;
?column?
----------
@@ -900,11 +901,12 @@ SELECT abs(cube_distance(ll_to_earth(0,0), '(0)'::cube) / earth() - 1) <
t
(1 row)
-SELECT is_point(ll_to_earth(30,60));
-ERROR: function is_point(earth) does not exist
-LINE 1: SELECT is_point(ll_to_earth(30,60));
- ^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+SELECT cube_is_point(ll_to_earth(30,60));
+ cube_is_point
+---------------
+ t
+(1 row)
+
SELECT cube_dim(ll_to_earth(30,60)) <= 3;
?column?
----------
@@ -918,11 +920,12 @@ SELECT abs(cube_distance(ll_to_earth(30,60), '(0)'::cube) / earth() - 1) <
t
(1 row)
-SELECT is_point(ll_to_earth(60,90));
-ERROR: function is_point(earth) does not exist
-LINE 1: SELECT is_point(ll_to_earth(60,90));
- ^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+SELECT cube_is_point(ll_to_earth(60,90));
+ cube_is_point
+---------------
+ t
+(1 row)
+
SELECT cube_dim(ll_to_earth(60,90)) <= 3;
?column?
----------
@@ -936,11 +939,12 @@ SELECT abs(cube_distance(ll_to_earth(60,90), '(0)'::cube) / earth() - 1) <
t
(1 row)
-SELECT is_point(ll_to_earth(-30,-90));
-ERROR: function is_point(earth) does not exist
-LINE 1: SELECT is_point(ll_to_earth(-30,-90));
- ^
-HINT: No function matches the given name and argument types. You might need to add explicit type casts.
+SELECT cube_is_point(ll_to_earth(-30,-90));
+ cube_is_point
+---------------
+ t
+(1 row)
+
SELECT cube_dim(ll_to_earth(-30,-90)) <= 3;
?column?
----------
diff --git a/contrib/earthdistance/sql/earthdistance.sql b/contrib/earthdistance/sql/earthdistance.sql
index 860450276f6..41455612175 100644
--- a/contrib/earthdistance/sql/earthdistance.sql
+++ b/contrib/earthdistance/sql/earthdistance.sql
@@ -282,19 +282,19 @@ SELECT earth_box(ll_to_earth(90,180),
-- Test the recommended constraints.
--
-SELECT is_point(ll_to_earth(0,0));
+SELECT cube_is_point(ll_to_earth(0,0));
SELECT cube_dim(ll_to_earth(0,0)) <= 3;
SELECT abs(cube_distance(ll_to_earth(0,0), '(0)'::cube) / earth() - 1) <
'10e-12'::float8;
-SELECT is_point(ll_to_earth(30,60));
+SELECT cube_is_point(ll_to_earth(30,60));
SELECT cube_dim(ll_to_earth(30,60)) <= 3;
SELECT abs(cube_distance(ll_to_earth(30,60), '(0)'::cube) / earth() - 1) <
'10e-12'::float8;
-SELECT is_point(ll_to_earth(60,90));
+SELECT cube_is_point(ll_to_earth(60,90));
SELECT cube_dim(ll_to_earth(60,90)) <= 3;
SELECT abs(cube_distance(ll_to_earth(60,90), '(0)'::cube) / earth() - 1) <
'10e-12'::float8;
-SELECT is_point(ll_to_earth(-30,-90));
+SELECT cube_is_point(ll_to_earth(-30,-90));
SELECT cube_dim(ll_to_earth(-30,-90)) <= 3;
SELECT abs(cube_distance(ll_to_earth(-30,-90), '(0)'::cube) / earth() - 1) <
'10e-12'::float8;