You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
@@ -20,18 +19,15 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20
19
BEGIN;
21
20
22
21
UPDATE edges SET cost = sign(cost), reverse_cost = sign(reverse_cost);
23
-
SELECT CASE WHEN min_version('4.0.0') THEN plan(17) WHEN min_version('3.8.0') THEN plan(33) WHEN min_version('3.4.0') THEN plan(34) ELSE plan(1) END;
24
-
SET client_min_messages TO 'WARNING';
25
-
22
+
SELECT CASE WHEN min_version('3.8.0') THEN plan(16) ELSE plan(1) END;
26
23
27
24
CREATE OR REPLACE FUNCTION edge_cases()
28
25
RETURNS SETOF TEXT AS
29
26
$BODY$
30
-
DECLARE
31
-
the_q TEXT;
32
27
BEGIN
33
-
IF NOT min_version('3.4.0') THEN
34
-
RETURN QUERY SELECT skip(1, 'Function added on 3.4.0');
28
+
29
+
IF NOT min_version('3.8.0') THEN
30
+
RETURN QUERY SELECT skip(1, 'pgr_findcloseedges testing only valid signatures from 4.0.0');
35
31
RETURN;
36
32
END IF;
37
33
@@ -97,84 +93,6 @@ BEGIN
97
93
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM bar), 0.5)$$,
98
94
'42P01', 'relation "bar" does not exist');
99
95
100
-
IF min_version('4.0.0') THEN
101
-
RETURN QUERY SELECT skip(1, 'Signatures with partial flag is removed on 4.0.0');
102
-
RETURN;
103
-
END IF;
104
-
105
-
-- Test with partial flag
106
-
RETURN QUERY SELECT is_empty($$SELECT * FROM pgr_findCloseEdges(
107
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, true, true)$$, 'One geom: partial,dryrun = true,true');
108
-
RETURN QUERY SELECT isnt_empty($$SELECT * FROM pgr_findCloseEdges(
109
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, true, false)$$, 'One geom: partial,dryrun = true,false');
110
-
RETURN QUERY SELECT is_empty($$SELECT * FROM pgr_findCloseEdges(
111
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, false, true)$$, 'One geom: partial,dryrun = false,true');
112
-
RETURN QUERY SELECT isnt_empty($$SELECT * FROM pgr_findCloseEdges(
113
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, false, false)$$, 'One geom: partial,dryrun = false,false');
114
-
115
-
RETURN QUERY SELECT is_empty($$SELECT * FROM pgr_findCloseEdges(
116
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, true, true)$$, 'Many geom: partial,dryrun = true,true');
117
-
RETURN QUERY SELECT isnt_empty($$SELECT * FROM pgr_findCloseEdges(
118
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, true, false)$$, 'Many geom: partial,dryrun = true,false');
119
-
RETURN QUERY SELECT is_empty($$SELECT * FROM pgr_findCloseEdges(
120
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, false, true)$$, 'Many geom: partial,dryrun = false,true');
121
-
RETURN QUERY SELECT isnt_empty($$SELECT * FROM pgr_findCloseEdges(
122
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, false, false)$$, 'Many geom: partial,dryrun = false,false');
123
-
124
-
RETURN QUERY SELECT
125
-
CASE WHEN min_version('3.8.0') THEN
126
-
collect_tap(
127
-
throws_ok($$SELECT * FROM pgr_findCloseEdges(
128
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, partial => true) WHERE distance IS NOT NULL$$,
129
-
'42883','function pgr_findcloseedges(unknown, geometry, numeric, integer, partial => boolean) does not exist', 'throws: One geom, with cap value, naming partial => true'),
130
-
throws_ok($$SELECT * FROM pgr_findCloseEdges(
131
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, partial => true) WHERE distance IS NOT NULL$$,
132
-
'42883','function pgr_findcloseedges(unknown, geometry, numeric, partial => boolean) does not exist', 'throws: One geom, without cap value naming partial => true'),
133
-
isnt_empty($$SELECT * FROM pgr_findCloseEdges(
134
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, true, false) WHERE distance IS NOT NULL$$, 'partial, One geom: isnt_empty distance'),
135
-
isnt_empty($$SELECT * FROM pgr_findCloseEdges(
136
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, true, false) WHERE geom IS NOT NULL$$, 'partial, One geom: isnt_empty geom'),
137
-
isnt_empty($$SELECT * FROM pgr_findCloseEdges(
138
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, true, false) WHERE edge IS NOT NULL$$, 'partial, One geom: isnt_empty edge'),
139
-
140
-
throws_ok($$SELECT * FROM pgr_findCloseEdges(
141
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, partial => true) WHERE distance IS NOT NULL$$,
142
-
'42883','function pgr_findcloseedges(unknown, geometry[], numeric, integer, partial => boolean) does not exist', 'throws: Many geom, with cap value, naming partial => true'),
143
-
throws_ok($$SELECT * FROM pgr_findCloseEdges(
144
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, partial => true) WHERE distance IS NOT NULL$$,
145
-
'42883','function pgr_findcloseedges(unknown, geometry[], numeric, partial => boolean) does not exist', 'throws: Many geom, without cap value naming partial => true'),
146
-
isnt_empty($$SELECT * FROM pgr_findCloseEdges(
147
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, true, false) WHERE distance IS NOT NULL$$, 'partial, Many geom: isnt_empty distance'),
148
-
isnt_empty($$SELECT * FROM pgr_findCloseEdges(
149
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, true, false) WHERE edge IS NOT NULL$$, 'partial, Many geom: isnt_empty edge')
150
-
)
151
-
152
-
ELSE
153
-
collect_tap(
154
-
lives_ok($$SELECT * FROM pgr_findCloseEdges(
155
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, partial => true) WHERE distance IS NOT NULL$$, 'One geom, with cap value, naming partial => true'),
156
-
lives_ok($$SELECT * FROM pgr_findCloseEdges(
157
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, partial => true) WHERE distance IS NOT NULL$$, 'One geom, without cap value, naming partial => true'),
158
-
is_empty($$SELECT * FROM pgr_findCloseEdges(
159
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, true, false) WHERE distance IS NOT NULL$$, 'partial, One geom: is_empty distance'),
160
-
is_empty($$SELECT * FROM pgr_findCloseEdges(
161
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, true, false) WHERE geom IS NOT NULL$$, 'partial, One geom: is_empty geom'),
162
-
is_empty($$SELECT * FROM pgr_findCloseEdges(
163
-
'SELECT id, geom FROM edges', (SELECT geom FROM pointsOfInterest WHERE pid = 5), 0.5, 1, true, false) WHERE edge IS NOT NULL$$, 'partial, One geom: is_empty edge'),
164
-
165
-
lives_ok($$SELECT * FROM pgr_findCloseEdges(
166
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, partial => true) WHERE distance IS NOT NULL$$, 'Many geom, with cap value, naming partial => true'),
167
-
lives_ok($$SELECT * FROM pgr_findCloseEdges(
168
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, partial => true) WHERE distance IS NOT NULL$$, 'Many geom, without cap value, naming partial => true'),
169
-
isnt_empty($$SELECT * FROM pgr_findCloseEdges(
170
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, true, false) WHERE distance IS NOT NULL$$, 'partial, Many geom: isnt_empty distance'),
171
-
isnt_empty($$SELECT * FROM pgr_findCloseEdges(
172
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, true, false) WHERE geom IS NOT NULL$$, 'partial, Many geom: isnt_empty geom'),
173
-
is_empty($$SELECT * FROM pgr_findCloseEdges(
174
-
'SELECT id, geom FROM edges', (SELECT array_agg(geom) FROM pointsOfInterest), 0.5, 1, true, false) WHERE edge IS NOT NULL$$, 'partial, Many geom: is_empty edge')
0 commit comments