Debian Codegraph @

mysql-test/suite/gis/t/spatial_analysis_functions_distance.test

raw
1 # Disabled on Windows ASAN due to https://bugs.llvm.org/show_bug.cgi?id=35365
2 --source include/not_asan_windows.inc
3
4 ##################################################################################
5 # #
6 # This test is aimed to focus on Spatial Analysis Functions. #
7 # #
8 # ST_Distance functions take 2 geometries as inpout parameters and #
9 # returns minimum distance between them. #
10 # #
11 # Creation Date: 2014-06-09 #
12 # Author : Pavan Naik #
13 # #
14 ##################################################################################
15
16
17 ############################################################################################
18 # Creating the spatial objects #
19 ############################################################################################
20
21 --echo # Creating the spatial Geometry object
22 USE test;
23
24 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
25
26 ############################################################################################
27 # Inserting the values specific to the spatial objects #
28 ############################################################################################
29
30 # Geometric elements constructing a star and some of its elememts as base
31 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
32 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
33 SET @star_center= 'POINT(15 10)';
34 SET @star_top= 'POINT(15 25)';
35 SET @star_bottom_left= 'POINT(5 0)';
36 SET @star_bottom_right= 'POINT(25 0)';
37 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
38 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
39 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
40 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
41 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
42 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
43 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
44 SET @star= 'POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))';
45 SET @star_elem_vertical_val= '((5 0,15 25,25 0,15 5,5 0))';
46 SET @star_elem_horizontal_val= '((25 0,0 15,30 15,22 10,25 0))';
47 SET @star_of_elems='MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))';
48 SET @star_collection_elems='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
49 SET @star_collection_multilinestr='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),MULTILINESTRING((25 0,0 15,15 30,0 5)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
50
51 # Star identical to the base star
52 SET @star_elem_vertical_1= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
53 SET @star_elem_horizontal_1= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
54 SET @star_center_1= 'POINT(15 10)';
55 SET @star_top_1= 'POINT(15 25)';
56 SET @star_bottom_left_1= 'POINT(5 0)';
57 SET @star_bottom_right_1= 'POINT(25 0)';
58 SET @star_bottom_points_1= 'MULTIPOINT(5 0,25 0)';
59 SET @star_all_points_1= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
60 SET @star_line_horizontal_1= 'LINESTRING(10 15,20 15)';
61 SET @star_line_vertical_1= 'LINESTRING(15 5,15 25)';
62 SET @star_top_to_center_1= 'LINESTRING(15 25,15 10)';
63 SET @star_lines_near_horizontal_1= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
64 SET @star_lines_near_vertical_1= 'MULTILINESTRING((0 5,15 25,0 25))';
65 SET @star_1= 'POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))';
66 SET @star_elem_vertical_val_1= '((5 0,15 25,25 0,15 5,5 0))';
67 SET @star_elem_horizontal_val_1= '((25 0,0 15,30 15,22 10,25 0))';
68 SET @star_of_elems_1='MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))';
69 SET @star_collection_elems_1='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
70
71 # Star like the base star, but shifted to right by 10 on X to overlap base star
72 SET @star_elem_vertical_2= 'POLYGON((15 0,25 25,35 0,25 5,15 0))';
73 SET @star_elem_horizontal_2= 'POLYGON((35 0,10 15,40 15,32 10,35 0))';
74 SET @star_center_2= 'POINT(25 10)';
75 SET @star_top_2= 'POINT(25 25)';
76 SET @star_bottom_left_2= 'POINT(15 0)';
77 SET @star_bottom_right_2= 'POINT(35 0)';
78 SET @star_bottom_points_2= 'MULTIPOINT(15 0,35 0)';
79 SET @star_all_points_2= 'MULTIPOINT(15 0,35 0,35 10,25 25)';
80 SET @star_line_horizontal_2= 'LINESTRING(20 15,30 15)';
81 SET @star_line_vertical_2= 'LINESTRING(25 5,25 25)';
82 SET @star_top_to_center_2= 'LINESTRING(25 25,25 10)';
83 SET @star_lines_near_horizontal_2= 'MULTILINESTRING((35 0,10 15,25 30,10 5))';
84 SET @star_lines_near_vertical_2= 'MULTILINESTRING((10 5,25 25,10 25))';
85 SET @star_2= 'POLYGON((15 0,17 10,10 15,20 15,25 25,30 15,40 15,32 10,35 0,25 5,15 0))';
86 SET @star_elem_vertical_val_2= '((15 0,25 25,35 0,25 5,15 0))';
87 SET @star_elem_horizontal_val_2= '((35 0,10 15,40 15,32 10,35 0))';
88 SET @star_of_elems_2='MULTIPOLYGON(((15 0,25 25,35 0,25 5,15 0)),((35 0,10 15,40 15,32 10,35 0)))';
89 SET @star_collection_elems_2='GEOMETRYCOLLECTION(MULTIPOLYGON(((15 0,25 25,35 0,25 5,15 0)),((35 0,10 15,40 15,32 10,35 0))),POLYGON((15 0,17 10,10 15,20 15,25 25,30 15,40 15,32 10,35 0,25 5,15 0)),LINESTRING(25 25,25 10),MULTIPOINT(15 0,35 0),POINT(25 25))';
90
91 # Star like the base star, but shifted to right by 60 on X to be completly separate
92 SET @star_elem_vertical_3= 'POLYGON((65 0,75 25,85 0,75 5,65 0))';
93 SET @star_elem_horizontal_3= 'POLYGON((85 0,60 15,90 15,82 10,85 0))';
94 SET @star_center_3= 'POINT(75 10)';
95 SET @star_top_3= 'POINT(75 25)';
96 SET @star_bottom_left_3= 'POINT(65 0)';
97 SET @star_bottom_right_3= 'POINT(85 0)';
98 SET @star_bottom_points_3= 'MULTIPOINT(65 0,85 0)';
99 SET @star_all_points_3= 'MULTIPOINT(65 0,85 0,75 10,75 25)';
100 SET @star_line_horizontal_3= 'LINESTRING(70 15,80 15)';
101 SET @star_line_vertical_3= 'LINESTRING(75 5,75 25)';
102 SET @star_top_to_center_3= 'LINESTRING(75 25,75 10)';
103 SET @star_lines_near_horizontal_3= 'MULTILINESTRING((85 0,60 15,85 30,60 5))';
104 SET @star_lines_near_vertical_3= 'MULTILINESTRING((60 5,75 25,60 25))';
105 SET @star_3= 'POLYGON((65 0,67 10,60 15,70 15,75 25,80 15,90 15,82 10,85 0,75 5,65 0))';
106 SET @star_elem_vertical_val_3= '((65 0,75 25,85 0,75 5,65 0))';
107 SET @star_elem_horizontal_val_3= '((85 0,60 15,90 15,82 10,85 0))';
108 SET @star_of_elems_3='MULTIPOLYGON(((65 0,75 25,85 0,75 5,65 0)),((85 0,60 15,90 15,82 10,85 0)))';
109 SET @star_collection_elems_3='GEOMETRYCOLLECTION(MULTIPOLYGON(((65 0,75 25,85 0,75 5,65 0)),((85 0,60 15,90 15,82 10,85 0))),POLYGON((65 0,67 10,60 15,70 15,75 25,80 15,90 15,82 10,85 0,75 5,65 0)),LINESTRING(75 25,75 10),MULTIPOINT(65 0,85 0),POINT(75 25))';
110
111 --echo # INSERT base star
112 --disable_warnings
113 INSERT INTO gis_geometrycollection VALUES
114 (100,ST_GEOMFROMTEXT(@star)),
115 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
116 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
117 (103,ST_GEOMFROMTEXT(@star_of_elems)),
118 (104,ST_GEOMFROMTEXT(@star_top)),
119 (105,ST_GEOMFROMTEXT(@star_center)),
120 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
121 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
122 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
123 (109,ST_GEOMFROMTEXT(@star_all_points)),
124 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
125 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
126 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
127 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
128 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
129 (115,ST_GEOMFROMTEXT(@star_collection_elems));
130 --enable_warnings
131
132 --echo # INSERT identical (to base) star
133 --disable_warnings
134 INSERT INTO gis_geometrycollection VALUES
135 (200,ST_GEOMFROMTEXT(@star_1)),
136 (201,ST_GEOMFROMTEXT(@star_elem_vertical_1)),
137 (202,ST_GEOMFROMTEXT(@star_elem_horizontal_1)),
138 (203,ST_GEOMFROMTEXT(@star_of_elems_1)),
139 (204,ST_GEOMFROMTEXT(@star_top_1)),
140 (205,ST_GEOMFROMTEXT(@star_center_1)),
141 (206,ST_GEOMFROMTEXT(@star_bottom_left_1)),
142 (207,ST_GEOMFROMTEXT(@star_bottom_right_1)),
143 (208,ST_GEOMFROMTEXT(@star_bottom_points_1)),
144 (209,ST_GEOMFROMTEXT(@star_all_points_1)),
145 (210,ST_GEOMFROMTEXT(@star_line_horizontal_1)),
146 (211,ST_GEOMFROMTEXT(@star_line_vertical_1)),
147 (212,ST_GEOMFROMTEXT(@star_top_to_center_1)),
148 (213,ST_GEOMFROMTEXT(@star_lines_near_horizontal_1)),
149 (214,ST_GEOMFROMTEXT(@star_lines_near_vertical_1)),
150 (215,ST_GEOMFROMTEXT(@star_collection_elems_1));
151 --enable_warnings
152
153 --echo # INSERT overlapping star
154 --disable_warnings
155 INSERT INTO gis_geometrycollection VALUES
156 (300,ST_GEOMFROMTEXT(@star_2)),
157 (301,ST_GEOMFROMTEXT(@star_elem_vertical_2)),
158 (302,ST_GEOMFROMTEXT(@star_elem_horizontal_2)),
159 (303,ST_GEOMFROMTEXT(@star_of_elems_2)),
160 (304,ST_GEOMFROMTEXT(@star_top_2)),
161 (305,ST_GEOMFROMTEXT(@star_center_2)),
162 (306,ST_GEOMFROMTEXT(@star_bottom_left_2)),
163 (307,ST_GEOMFROMTEXT(@star_bottom_right_2)),
164 (308,ST_GEOMFROMTEXT(@star_bottom_points_2)),
165 (309,ST_GEOMFROMTEXT(@star_all_points_2)),
166 (310,ST_GEOMFROMTEXT(@star_line_horizontal_2)),
167 (311,ST_GEOMFROMTEXT(@star_line_vertical_2)),
168 (312,ST_GEOMFROMTEXT(@star_top_to_center_2)),
169 (313,ST_GEOMFROMTEXT(@star_lines_near_horizontal_2)),
170 (314,ST_GEOMFROMTEXT(@star_lines_near_vertical_2)),
171 (315,ST_GEOMFROMTEXT(@star_collection_elems_2));
172 --enable_warnings
173
174 --echo # INSERT separate star
175 --disable_warnings
176 INSERT INTO gis_geometrycollection VALUES
177 (400,ST_GEOMFROMTEXT(@star_3)),
178 (401,ST_GEOMFROMTEXT(@star_elem_vertical_3)),
179 (402,ST_GEOMFROMTEXT(@star_elem_horizontal_3)),
180 (403,ST_GEOMFROMTEXT(@star_of_elems_3)),
181 (404,ST_GEOMFROMTEXT(@star_top_3)),
182 (405,ST_GEOMFROMTEXT(@star_center_3)),
183 (406,ST_GEOMFROMTEXT(@star_bottom_left_3)),
184 (407,ST_GEOMFROMTEXT(@star_bottom_right_3)),
185 (408,ST_GEOMFROMTEXT(@star_bottom_points_3)),
186 (409,ST_GEOMFROMTEXT(@star_all_points_3)),
187 (410,ST_GEOMFROMTEXT(@star_line_horizontal_3)),
188 (411,ST_GEOMFROMTEXT(@star_line_vertical_3)),
189 (412,ST_GEOMFROMTEXT(@star_top_to_center_3)),
190 (413,ST_GEOMFROMTEXT(@star_lines_near_horizontal_3)),
191 (414,ST_GEOMFROMTEXT(@star_lines_near_vertical_3)),
192 (415,ST_GEOMFROMTEXT(@star_collection_elems_3));
193 --enable_warnings
194
195 CREATE TABLE gis_geometrycollection_2 SELECT fid as fid2,g as g2 FROM gis_geometrycollection;
196
197 --echo # Checking the integrity of the above create/insert statements
198
199 --echo # 64 rows.
200 SELECT count(ST_AsText(g) != 'NULL') FROM gis_geometrycollection;
201 --echo # 64 rows.
202 SELECT count(ST_AsText(g2) != 'NULL') FROM gis_geometrycollection_2;
203
204 --echo #####################################################################################
205 --echo # ST_DISTANCE(g1,g2)
206 --echo #####################################################################################
207
208 --echo #====================================================================================
209 --echo # point,point
210 --echo #====================================================================================
211 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
212
213 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
214
215 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(-0 0.00)'));
216
217 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(1e154 0)'));
218
219 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(-1e154 0)'));
220
221 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=105;
222
223 --echo #====================================================================================
224 --echo # point,multipoint
225 --echo #====================================================================================
226 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
227
228 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(10 10)'));
229
230 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(1e154 0)'),ST_GEOMFROMTEXT('MULTIPOINT(1e154 10)'));
231
232 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(-0 0.000,-0.000 0)'));
233
234 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=106;
235
236 --echo #====================================================================================
237 --echo # point,linestring
238 --echo #====================================================================================
239 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
240
241 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(10 10,10 0)'));
242
243 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(10 10,10 0,0.0000 -0.0000)'));
244
245 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
246
247 --echo #====================================================================================
248 --echo # point,multilinestring
249 --echo #====================================================================================
250 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
251
252 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((10 10,1 0))'));
253
254 --error ER_GIS_INVALID_DATA
255 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((10 10,10 0),(0.0000 -0.0000))'));
256
257 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(1e77 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 1e154),(0 1e154,1e154 0))'));
258
259 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
260
261 --echo #====================================================================================
262 --echo # point,polygon
263 --echo #====================================================================================
264 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
265
266 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
267
268 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'));
269
270 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
271
272 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=104;
273
274 --echo #====================================================================================
275 --echo # point,multipolygon
276 --echo #====================================================================================
277 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
278
279 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(1 1)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)))'));
280
281 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(15 15)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)))'));
282
283 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(4 4)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)))'));
284
285 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),'
286 '((3 3,3 7,7 7,7 3, 3 3),(4 4,4 6,6 6,6 4,4 4)))'));
287
288 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
289 '((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))'));
290
291 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
292
293 --echo #====================================================================================
294 --echo # point,geometrycollection
295 --echo #====================================================================================
296 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
297
298 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(5 5)))'));
299
300 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
301 'LINESTRING(1 1,2 2,3 3,4 4,5 5),'
302 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
303
304 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
305 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
306 'POLYGON((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))'));
307
308 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
309
310 --echo #====================================================================================
311 --echo # multipoint,point
312 --echo #====================================================================================
313 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
314
315 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
316
317 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'),ST_GEOMFROMTEXT('POINT(5 0)'));
318
319 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'),ST_GEOMFROMTEXT('POINT(5 5)'));
320
321 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'),ST_GEOMFROMTEXT('POINT(10 5)'));
322
323 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(1e154 0)'),ST_GEOMFROMTEXT('POINT(1e154 0)'));
324
325 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
326
327 --echo #====================================================================================
328 --echo # multipoint,multipoint
329 --echo #====================================================================================
330 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points));
331
332 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
333
334 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(10 0.0001)'));
335
336 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(2.5 0.0001)'));
337
338 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 -1e154)'));
339
340 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=108;
341
342 --echo #====================================================================================
343 --echo # multipoint,linestring
344 --echo #====================================================================================
345 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
346
347 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0)'),ST_GEOMFROMTEXT('LINESTRING(2 2,5 0,8 2)'));
348
349 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'),ST_GEOMFROMTEXT('LINESTRING(2 2,8 2)'));
350
351 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(1 1,1 4,4 4,4 0.00009)'),ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
352
353 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=109;
354
355 --echo #====================================================================================
356 --echo # multipoint,multilinestring
357 --echo #====================================================================================
358 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
359
360 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
361
362 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((2 2,5 0),(1 1,10 10))'));
363
364 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((2 2,2 10,10 10),(10 10,10 2,2 2))'));
365
366 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(4 4,6 6)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 10,10 10,10 0,0 0))'));
367
368 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=109;
369
370 --echo #====================================================================================
371 --echo # multipoint,polygon
372 --echo #====================================================================================
373 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical));
374
375 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
376
377 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(4 4,11 11)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
378
379 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 -2,11 11)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
380
381 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(5.5 5.5)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'));
382
383 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(4 4,6 6)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'));
384
385 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=109;
386
387 --echo #====================================================================================
388 --echo # multipoint,multipolygon
389 --echo #====================================================================================
390 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
391
392 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems));
393
394 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'));
395
396 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(4.5 4.5,5.5 5.5)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
397 '((4 4,4 6,6 6,6 4,4 4)))'));
398
399 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(5 5,15 15.1)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),'
400 '((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'));
401
402 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=109;
403
404 --echo #====================================================================================
405 --echo # multipoint,geometrycollection
406 --echo #====================================================================================
407 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
408
409 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr));
410
411 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems));
412
413 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(5 5,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(5 5)))'));
414
415 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(5 5,20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
416 'LINESTRING(1 1,2 2,3 3,4 4,5 5),'
417 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
418
419 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT(5 5,20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
420 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
421 'POLYGON((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))'));
422
423 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=109;
424
425 --echo #====================================================================================
426 --echo # linestring,point
427 --echo #====================================================================================
428 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
429
430 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
431
432 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'),ST_GEOMFROMTEXT('POINT(5 0)'));
433
434 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'),ST_GEOMFROMTEXT('POINT(10 0.00000001)'));
435
436 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'),ST_GEOMFROMTEXT('POINT(5 1000000)'));
437
438 SELECT ST_DISTANCE(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
439
440 --echo #====================================================================================
441 --echo # linestring,multipoint
442 --echo #====================================================================================
443 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
444
445 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
446
447 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,10 10,0 10)'),ST_GEOMFROMTEXT('MULTIPOINT(5 0,10 5,5 10)'));
448
449 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,10 10,0 10)'),ST_GEOMFROMTEXT('MULTIPOINT(10.2 0,10 10.4)'));
450
451 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,10 10,0 10)'),ST_GEOMFROMTEXT('MULTIPOINT(4 4,5 5,7 7)'));
452
453 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=111;
454
455 --echo #====================================================================================
456 --echo # linestring,linestring
457 --echo #====================================================================================
458 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
459
460 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
461
462 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 10,10 0)'));
463
464 --replace_numeric_round 14
465 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 10,10 19)'));
466
467 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=111;
468
469 --echo #====================================================================================
470 --echo # linestring,multilinestring
471 --echo #====================================================================================
472 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
473
474 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical));
475
476 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 10,5 5.5),(5 4.6,10 0))'));
477
478 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 19),(10 0,10 10))'));
479
480 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=110;
481
482 --echo #====================================================================================
483 --echo # linestring,polygon
484 --echo #====================================================================================
485 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
486
487 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10, 11 15))'));
488
489 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(4 4,6 6)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
490
491 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(4 4,6 6)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'));
492
493 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(-11 -11,-11 11)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
494
495 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(4.5 4.5,5.5 5.4)'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'));
496
497 --echo #====================================================================================
498 --echo # linestring,multipolygon
499 --echo #====================================================================================
500 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
501
502 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,19 10,11 15)),((25 0,0 15,25 10,25 0)))'));
503
504 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,20 20,30 30)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'));
505
506 --error ER_GIS_INVALID_DATA
507 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(-1 5)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'));
508
509 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(4.5 4.5,5.5 5.5)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
510 '((4 4,4 6,6 6,6 4,4 4)))'));
511
512 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(5 5,15 15)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),'
513 '((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'));
514
515 --echo #====================================================================================
516 --echo # linestring,geometrycollection
517 --echo #====================================================================================
518 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
519
520 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
521
522 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
523
524 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 5)))'));
525
526 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(4.5 4.5,5.5 5.5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
527 'LINESTRING(1 1,2 2,3 3,4 4),'
528 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
529
530 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(5 5,15 15,25 24)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
531 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
532 'POLYGON((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))'));
533
534 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_collection_elems_3)) FROM gis_geometrycollection WHERE fid=110;
535
536 --echo #====================================================================================
537 --echo # multilinestring,point
538 --echo #====================================================================================
539 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
540
541 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
542
543 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(0 10,10 10))'),ST_GEOMFROMTEXT('POINT(5 0)'));
544
545 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(0 10,10 10))'),ST_GEOMFROMTEXT('POINT(5 5)'));
546
547 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(0 10,10 10))'),ST_GEOMFROMTEXT('POINT(5 1000000)'));
548
549 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
550
551 --echo #====================================================================================
552 --echo # multilinestring,multipoint
553 --echo #====================================================================================
554 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points));
555
556 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
557
558 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(10 10,0 10))'),ST_GEOMFROMTEXT('MULTIPOINT(5 0,10 5,5 10)'));
559
560 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(10 10,0 10))'),ST_GEOMFROMTEXT('MULTIPOINT(10.41 0,10 10.4)'));
561
562 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(10 10,0 10))'),ST_GEOMFROMTEXT('MULTIPOINT(4 4,5 5,6.5 6.5)'));
563
564 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=114;
565
566 SELECT ST_DISTANCE(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
567
568 --echo #====================================================================================
569 --echo # multilinestring,linestring
570 --echo #====================================================================================
571 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
572
573 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
574
575 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(10 10,0 10))'),ST_GEOMFROMTEXT('LINESTRING(0 5,10 5)'));
576
577 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(10 10,0 10))'),ST_GEOMFROMTEXT('LINESTRING(0 10,10 19)'));
578
579 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
580
581 --echo #====================================================================================
582 --echo # multilinestring,multilinestring
583 --echo #====================================================================================
584 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
585
586 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'));
587
588 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(0 10,10 10))'),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,14.5 5,14 15,0 15))'));
589
590 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0),(0 10,10 10))'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 10,10 0,10 10))'));
591
592 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
593
594 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
595
596 --echo #====================================================================================
597 --echo # multilinestring,polygon
598 --echo #====================================================================================
599 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical));
600
601 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
602
603 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((4 4,6 6))'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
604
605 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((4 4,6 6))'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'));
606
607 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((-11 -11,-11 11))'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
608
609 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((4.5 4.5,5.5 5.4))'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'));
610
611 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((14 14,14 16),(10 15,10 20,20 20))'),ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),'
612 '(14 14,14 16,16 16,16 14,14 14))'));
613
614 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
615
616 --echo #====================================================================================
617 --echo # multilinestring,multipolygon
618 --echo #====================================================================================
619 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
620
621 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical));
622
623 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,20 20,30 30))'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'));
624
625 --error ER_GIS_INVALID_DATA
626 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((10 10,20 20),(30 30))'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'));
627
628 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((4.5 4.5,5.5 5.5))'),
629 ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'));
630
631 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((4.5 4.5,5.5 5.5),(14.5 14.5,15.4 15.6))'),
632 ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'));
633
634 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=114;
635
636 --echo #====================================================================================
637 --echo # multilinestring,geometrycollection
638 --echo #====================================================================================
639 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
640
641 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr));
642
643 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems));
644
645 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 5)))'));
646
647 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((4.5 4.5,5.5 5.5))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
648 'LINESTRING(1 1,2 2,3 3,4 4),'
649 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
650
651 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTILINESTRING((5 5,15 15,25 25))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
652 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
653 'POLYGON((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))'));
654
655 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=114;
656
657 --echo #====================================================================================
658 --echo # polygon,point
659 --echo #====================================================================================
660 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
661
662 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
663
664 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('POINT(5 0)'));
665
666 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('POINT(20 20)'));
667
668 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('POINT(5 5)'));
669
670 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('POINT(6 6)'));
671
672 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(14 14,14 16,16 16,16 14,14 14))'),ST_GEOMFROMTEXT('POINT(15 15)'));
673
674 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
675
676 --echo #====================================================================================
677 --echo # polygon,multipoint
678 --echo #====================================================================================
679 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points));
680
681 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
682
683 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('MULTIPOINT(5 0,20 20)'));
684
685 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('MULTIPOINT(20 20,-9 -9)'));
686
687 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('MULTIPOINT(4.5 4.5,5.5 5.5)'));
688
689 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('MULTIPOINT(4 4,6 6,8 8,15 15)'));
690
691 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(14 14,14 16,16 16,16 14,14 14))'),ST_GEOMFROMTEXT('MULTIPOINT(15 15)'));
692
693 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
694
695 --echo #====================================================================================
696 --echo # polygon,linestring
697 --echo #====================================================================================
698 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical));
699
700 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
701
702 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(5 0,20 20,100 100)'));
703
704 --replace_numeric_round 13
705 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(110 110,-100 50)'));
706
707 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('LINESTRING(4.3 4.3,5.5 5.5)'));
708
709 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('LINESTRING(4 4,6 6,8 8,15 15)'));
710
711 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(14 14,14 16,16 16,16 14,14 14))'),
712 ST_GEOMFROMTEXT('LINESTRING(11 11,14 14,15 15,16 16,20 20)'));
713
714 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=100;
715
716 SELECT ST_DISTANCE(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
717
718 --echo #====================================================================================
719 --echo # polygon,multilinestring
720 --echo #====================================================================================
721 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical));
722
723 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
724
725 --error ER_GIS_INVALID_DATA
726 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('MULTILINESTRING((5 0,20 20),(100 100))'));
727
728 --error ER_GIS_INVALID_DATA
729 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('MULTILINESTRING((110 110,-100 100),(-50 50))'));
730
731 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('MULTILINESTRING((4.3 4.3,5.5 5.5))'));
732
733 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),
734 ST_GEOMFROMTEXT('MULTILINESTRING((0 0,2 2,4 4,6 6),(8 8,10 10,15 15))'));
735
736 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(14 14,14 16,16 16,16 14,14 14))'),
737 ST_GEOMFROMTEXT('MULTILINESTRING((11 11,14 14),(15 15,16 16,20 20))'));
738
739 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=100;
740
741 --echo #====================================================================================
742 --echo # polygon,polygon
743 --echo #====================================================================================
744 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical));
745
746 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
747
748 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('POLYGON((5 0,20 20,100 100,5 0))'));
749
750 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('POLYGON((110 110,-100 100,-50 50,110 110))'));
751
752 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('POLYGON((4.3 4.3,4.5 4.8,5 5.5,4.3 4.3))'));
753
754 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('POLYGON((4 4,6 6,8 8,10 15,4 4))'));
755
756 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=100;
757
758 --echo #====================================================================================
759 --echo # polygon,multipolygon
760 --echo #====================================================================================
761 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems));
762
763 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
764
765 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('MULTIPOLYGON(((110 110,-100 100,-50 50,110 110)))'));
766
767 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,20 20,100 100,5 0)),((0 0,-10 -10,10 100,0 0)))'));
768
769 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('MULTIPOLYGON(((4.3 4.3,4.7 5,5 5.6,4.3 4.3)))'));
770
771 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,6 6,8 8,10 15,4 4)))'));
772
773 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
774
775 --echo #====================================================================================
776 --echo # polygon,geometrycollection
777 --echo #====================================================================================
778 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems));
779
780 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
781
782 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
783
784 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 15)))'));
785
786 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'),
787 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'));
788
789 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4))'),
790 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
791
792 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(14 14,14 16,16 16,16 14,14 14))'),
793 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
794 'POLYGON((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))'));
795
796 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
797
798 --echo #====================================================================================
799 --echo # multipolygon,point
800 --echo #====================================================================================
801 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
802
803 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
804
805 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('POINT(0 8)'));
806
807 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('POINT(20 20)'));
808
809 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'),
810 ST_GEOMFROMTEXT('POINT(5 5)'));
811
812 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
813 ST_GEOMFROMTEXT('POINT(15 15)'));
814
815 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
816 ST_GEOMFROMTEXT('POINT(16.1 16.1)'));
817
818 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=103;
819
820 --echo #====================================================================================
821 --echo # multipolygon,multipoint
822 --echo #====================================================================================
823 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
824
825 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
826
827 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('MULTIPOINT(0 8,100 100)'));
828
829 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('MULTIPOINT(50 50,-30 50)'));
830
831 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'),
832 ST_GEOMFROMTEXT('MULTIPOINT(4.5 4.5,5.5 5.5)'));
833
834 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
835 ST_GEOMFROMTEXT('MULTIPOINT(15.9 15.9)'));
836
837 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
838 ST_GEOMFROMTEXT('MULTIPOINT(19 19,100 100)'));
839
840 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
841
842 --echo #====================================================================================
843 --echo # multipolygon,linestring
844 --echo #====================================================================================
845 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
846
847 --replace_numeric_round 14
848 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
849
850 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('LINESTRING(0 8,100 100)'));
851
852 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('LINESTRING(50 50,-30 50)'));
853
854 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'),
855 ST_GEOMFROMTEXT('LINESTRING(4.5 4.5,5.5 5.5)'));
856
857 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
858 ST_GEOMFROMTEXT('LINESTRING(14.5 14.5,15.5 15.5)'));
859
860 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
861 ST_GEOMFROMTEXT('LINESTRING(19 19,100 100)'));
862
863 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
864
865 --echo #====================================================================================
866 --echo # multipolygon,multilinestring
867 --echo #====================================================================================
868 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
869
870 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
871
872 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),
873 ST_GEOMFROMTEXT('MULTILINESTRING((0 8,10 10,20 20),(50 50,75 75,100 100))'));
874
875 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),
876 ST_GEOMFROMTEXT('MULTILINESTRING((50 50,100 50),(-50 50,-40 50))'));
877
878 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'),
879 ST_GEOMFROMTEXT('MULTILINESTRING((4.5 4.5,5.5 5.5))'));
880
881 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
882 ST_GEOMFROMTEXT('MULTILINESTRING((14.5 14.5,15.5 15.5))'));
883
884 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
885 ST_GEOMFROMTEXT('MULTILINESTRING((-10 -10,50 50,100 100))'));
886
887 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
888
889 --echo #====================================================================================
890 --echo # multipolygon,polygon
891 --echo #====================================================================================
892 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
893
894 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star));
895
896 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
897
898 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('POLYGON((10 10,10 -10,-10 -10,-10 10,10 10))'));
899
900 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('POLYGON((20 20,20 30,30 30,30 20,20 20))'));
901
902 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'),
903 ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4))'));
904
905 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
906 ST_GEOMFROMTEXT('POLYGON((14.5 14.5,14.5 15.5,15.5 15.5,14.5 14.5))'));
907
908 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=103;
909
910 --echo #====================================================================================
911 --echo # multipolygon,multipolygon
912 --echo #====================================================================================
913 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
914
915 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
916
917 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),
918 ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 -10,-10 -10,-10 10,10 10)))'));
919
920 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),
921 ST_GEOMFROMTEXT('MULTIPOLYGON(((20 20,20 30,30 30,30 20,20 20)))'));
922
923 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'),
924 ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4)))'));
925
926 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
927 ST_GEOMFROMTEXT('MULTIPOLYGON(((14.5 14.5,14.5 15.5,15.5 15.5,14.5 14.5)))'));
928
929 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=103;
930
931 SELECT ST_DISTANCE(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
932
933 SELECT ST_DISTANCE(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
934
935 --echo #====================================================================================
936 --echo # multipolygon,geometrycollection
937 --echo #====================================================================================
938 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
939
940 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
941
942 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
943
944 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),
945 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(50 55)))'));
946
947 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),
948 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'));
949
950 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'),
951 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
952
953 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)),((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14)))'),
954 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
955 'POLYGON((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))'));
956
957 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=103;
958
959 SELECT ST_DISTANCE(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=215;
960
961 --echo #====================================================================================
962 --echo # geometrycollection,point
963 --echo #====================================================================================
964 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
965
966 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
967
968 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT('POINT(30 30)'));
969
970 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(50 50)))'),ST_GEOMFROMTEXT('POINT(0 0)'));
971
972 Select ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'),ST_GEOMFROMTEXT('POINT(100 100)'));
973
974 Select ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),POLYGON((0 0,0 10,10 10,10 0,0 0)))'),ST_GEOMFROMTEXT('POINT(100 100)'));
975
976 Select ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('POINT(100 100)'));
977
978 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'),
979 ST_GEOMFROMTEXT('POINT(20 20)'));
980
981 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4))),'
982 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'),
983 ST_GEOMFROMTEXT('POINT(5 5)'));
984
985 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))),'
986 'GEOMETRYCOLLECTION(MULTIPOLYGON(((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))))'),
987 ST_GEOMFROMTEXT('POINT(15 15)'));
988
989 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=115;
990
991 --echo #====================================================================================
992 --echo # geometrycollection,multipoint
993 --echo #====================================================================================
994 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
995
996 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
997
998 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
999
1000 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(50 50)))'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,100 100)'));
1001
1002 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('MULTIPOINT(5 0,10 0)'));
1003
1004 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'),
1005 ST_GEOMFROMTEXT('MULTIPOINT(20 20,40 40,60 60)'));
1006
1007 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4))),'
1008 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'),
1009 ST_GEOMFROMTEXT('MULTIPOINT(4.5 4.5,5.5 5.5)'));
1010
1011 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))),'
1012 'GEOMETRYCOLLECTION(MULTIPOLYGON(((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))))'),
1013 ST_GEOMFROMTEXT('MULTIPOINT(4 4,6 6,8 8)'));
1014
1015 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
1016
1017 --echo #====================================================================================
1018 --echo # geometrycollection,linestring
1019 --echo #====================================================================================
1020 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
1021
1022 --replace_numeric_round 14
1023 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
1024
1025 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
1026
1027 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(50 50)))'),ST_GEOMFROMTEXT('LINESTRING(0 0,100 100)'));
1028
1029 Select ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1030
1031 Select ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),POLYGON((0 0,0 10,10 10,10 0,0 0)))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1032
1033 Select ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1034
1035 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'),
1036 ST_GEOMFROMTEXT('LINESTRING(20 20,40 40,60 60)'));
1037
1038 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20))'),ST_GEOMFROMTEXT('LINESTRING(5 0,10 0)'));
1039
1040 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('LINESTRING(5 0,10 0)'));
1041
1042 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4))),'
1043 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'),
1044 ST_GEOMFROMTEXT('LINESTRING(4.5 4.5,5.5 5.5)'));
1045
1046 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))),'
1047 'GEOMETRYCOLLECTION(MULTIPOLYGON(((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))))'),
1048 ST_GEOMFROMTEXT('LINESTRING(4 4,6 6,8 8)'));
1049
1050 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
1051
1052 --echo #====================================================================================
1053 --echo # geometrycollection,multilinestring
1054 --echo #====================================================================================
1055 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1056
1057 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
1058
1059 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
1060
1061 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(50 50)))'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,100 100))'));
1062
1063 --error ER_GIS_INVALID_DATA
1064 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'),
1065 ST_GEOMFROMTEXT('MULTILINESTRING((20 20,40 40),(60 60))'));
1066
1067 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4))),'
1068 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'),
1069 ST_GEOMFROMTEXT('MULTILINESTRING((4.5 4.5,5.5 5.5))'));
1070
1071 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))),'
1072 'GEOMETRYCOLLECTION(MULTIPOLYGON(((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))))'),
1073 ST_GEOMFROMTEXT('MULTILINESTRING((4 4,6 6),(8 8,10 10))'));
1074
1075 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
1076
1077 --echo #====================================================================================
1078 --echo # geometrycollection,polygon
1079 --echo #====================================================================================
1080 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
1081
1082 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star));
1083
1084 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
1085
1086 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
1087
1088 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(50 50)))'),ST_GEOMFROMTEXT('POLYGON((0 0,30 40,90 100, 0 0))'));
1089
1090 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'),
1091 ST_GEOMFROMTEXT('POLYGON((20 20,40 40,50 60,20 20))'));
1092
1093 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4))),'
1094 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'),
1095 ST_GEOMFROMTEXT('POLYGON((4.2 4.2,5 5,5.7 5.8,4.2 4.2))'));
1096
1097 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))),'
1098 'GEOMETRYCOLLECTION(MULTIPOLYGON(((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))))'),
1099 ST_GEOMFROMTEXT('POLYGON((4 4,6 6,8 8,10 20,4 4))'));
1100
1101 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=115;
1102
1103 --echo #====================================================================================
1104 --echo # geometrycollection,multipolygon
1105 --echo #====================================================================================
1106 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
1107
1108 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
1109
1110 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
1111
1112 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(50 50)))'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,30 40,90 100,0 0)))'));
1113
1114 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'),
1115 ST_GEOMFROMTEXT('MULTIPOLYGON(((20 20,40 40,50 60,20 20)))'));
1116
1117 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4))),'
1118 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'),
1119 ST_GEOMFROMTEXT('MULTIPOLYGON(((4.2 4.2,5 5,5.7 5.8,4.2 4.2)))'));
1120
1121 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))),'
1122 'GEOMETRYCOLLECTION(MULTIPOLYGON(((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))))'),
1123 ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,6 6,8 8,10 20,4 4)))'));
1124
1125 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
1126
1127 SELECT ST_DISTANCE(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=103;
1128
1129 --echo #====================================================================================
1130 --echo # geometrycollection,geometrycollection
1131 --echo #====================================================================================
1132 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
1133
1134 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
1135
1136 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT(@star_collection_elems_3));
1137
1138 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(50 50)))'),
1139 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,50 0,100 0))'));
1140
1141 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((20 20,20 30,30 30,30 20,20 20),(0 0,0 10,10 10,10 0,0 0)))'),
1142 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'));
1143
1144 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3,4 4))),'
1145 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'),
1146 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(4.5 4.5,5.5 5.5))'));
1147
1148 --error ER_GIS_INVALID_DATA
1149 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))),'
1150 'GEOMETRYCOLLECTION(MULTIPOLYGON(((3 3,3 7,7 7,7 3,3 3),(4 4,4 6,6 6,6 4,4 4)))))'),
1151 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((40 40,50 50),(5 5)))'));
1152
1153 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
1154
1155 SELECT ST_DISTANCE(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=215;
1156
1157 --echo #####################################################################################
1158 --echo # ST_DISTANCE() with 2 geometries of same SRID
1159 --echo #####################################################################################
1160
1161 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
1162
1163 --error ER_SRS_NOT_FOUND
1164 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,100),ST_GEOMFROMTEXT(@star_center,100));
1165
1166 --error ER_SRS_NOT_FOUND
1167 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,20000),ST_GEOMFROMTEXT(@star_center,20000));
1168
1169 --error ER_SRS_NOT_FOUND
1170 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,123456),ST_GEOMFROMTEXT(@star_center,123456));
1171
1172 --error ER_SRS_NOT_FOUND
1173 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,1048575),ST_GEOMFROMTEXT(@star_center,1048575));
1174
1175 --error ER_SRS_NOT_FOUND
1176 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,4294967295),ST_GEOMFROMTEXT(@star_center,4294967295));
1177
1178 --error ER_DATA_OUT_OF_RANGE
1179 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
1180
1181 --error ER_DATA_OUT_OF_RANGE
1182 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
1183
1184 --error ER_DATA_OUT_OF_RANGE
1185 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
1186
1187 --echo #####################################################################################
1188 --echo # Invalid function calls
1189 --echo #####################################################################################
1190
1191 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1192 SELECT ST_DISTANCE();
1193
1194 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1195 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(10 10)'));
1196
1197 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(10 10)'),NULL);
1198
1199 SELECT ST_DISTANCE(NULL,ST_GEOMFROMTEXT('POINT(10 10)'));
1200
1201 --error ER_GIS_DIFFERENT_SRIDS
1202 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
1203
1204 --error ER_SRS_NOT_FOUND
1205 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_top,1048576),ST_GEOMFROMTEXT(@star_center,4326));
1206
1207 SELECT ST_DISTANCE(NULL,ST_GEOMFROMTEXT(@star_top));
1208
1209 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),NULL);
1210
1211 SELECT ST_DISTANCE(NULL,NULL);
1212
1213 SELECT ST_DISTANCE(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1214
1215 SELECT ST_DISTANCE(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1216
1217 --error ER_GIS_INVALID_DATA
1218 SELECT ST_DISTANCE(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1219
1220 --error ER_GIS_INVALID_DATA
1221 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1222
1223 --error ER_GIS_INVALID_DATA
1224 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1225
1226 --error ER_GIS_INVALID_DATA
1227 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1228
1229 --error ER_PARSE_ERROR
1230 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1231
1232 --error ER_GIS_INVALID_DATA
1233 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1234
1235 --error ER_GIS_INVALID_DATA
1236 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1237
1238 --error ER_GIS_INVALID_DATA
1239 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1240
1241 --error ER_PARSE_ERROR
1242 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1243
1244 --error ER_GIS_INVALID_DATA
1245 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1246
1247 --error ER_GIS_INVALID_DATA
1248 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1249
1250 --error ER_GIS_INVALID_DATA
1251 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1252
1253 --error ER_PARSE_ERROR
1254 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1255
1256 --error ER_GIS_INVALID_DATA
1257 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1258
1259 --error ER_GIS_INVALID_DATA
1260 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1261
1262 --error ER_GIS_INVALID_DATA
1263 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,11 15))')) FROM gis_geometrycollection WHERE fid=110;
1264
1265 --error ER_GIS_INVALID_DATA
1266 SELECT ST_DISTANCE(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))')) FROM gis_geometrycollection WHERE fid=110;
1267
1268 --echo # Invalid polygon.
1269 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(14 14,14 16,16 16,16 14,14 14))'),
1270 ST_GEOMFROMTEXT('POLYGON((11 11,14 14,15 15,16 16,20 20,11 11))'));
1271
1272 --echo # Invalid polygon.
1273 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(14 14,14 16,16 16,16 14,14 14))'),
1274 ST_GEOMFROMTEXT('MULTIPOLYGON(((11 11,14 14,15 15,11 11)),((16 16,20 20,30 30,16 16)))'));
1275
1276 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
1277
1278 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
1279
1280 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'),ST_GEOMFROMTEXT('POINT(10 10)'));
1281
1282 --error ER_PARSE_ERROR
1283 SELECT ST_DISTANCE(,);
1284
1285 --error ER_PARSE_ERROR
1286 SELECT ST_DISTANCE(ST_GEOMFROMTEXT(@star_of_elems),);
1287
1288 --error ER_PARSE_ERROR
1289 SELECT ST_DISTANCE(,ST_GEOMFROMTEXT(@star_top));
1290
1291 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1292 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(1 1)'));
1293
1294 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1295 SELECT ST_DISTANCE(ST_GEOMFROMTEXT('POINT(1 1)'), ST_GEOMFROMTEXT('POINT(0 0)'), 200, 300);
1296
1297 --echo # Clean up
1298 DROP TABLE gis_geometrycollection;
1299 DROP TABLE gis_geometrycollection_2;
1300
1301 --echo #
1302 --echo # WL#8579 Spatial Reference Systems
1303 --echo #
1304
1305 --echo # SRID 0 (should pass)
1306 SELECT ST_DISTANCE(
1307 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1308 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1309 );
1310
1311 --echo # Projected SRS (should pass)
1312 SELECT ST_DISTANCE(
1313 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1314 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1315 );
1316
1317 --echo # Geographic SRS (should pass)
1318 SELECT ST_DISTANCE(
1319 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1320 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1321 );
1322
1323 --echo # Undefined SRS (should fail)
1324 # Assume SRID 13000000 is undefined
1325 --error ER_SRS_NOT_FOUND
1326 SELECT ST_DISTANCE(
1327 ST_GEOMFROMTEXT('POINT(0 0)', 13000000),
1328 ST_GEOMFROMTEXT('POINT(0 0)', 13000000)
1329 );
1330
1331 --echo #
1332 --echo # WL#9347 Ellipsoidal ST_Distance for point and multipoint
1333 --echo #
1334
1335 --echo # All parameter types (Cartesian)
1336
1337 DO ST_DISTANCE(
1338 ST_GEOMFROMTEXT('POINT(0 0)'),
1339 ST_GEOMFROMTEXT('POINT(1 0)'));
1340 DO ST_DISTANCE(
1341 ST_GEOMFROMTEXT('POINT(0 0)'),
1342 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'));
1343 DO ST_DISTANCE(
1344 ST_GEOMFROMTEXT('POINT(0 0)'),
1345 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'));
1346 DO ST_DISTANCE(
1347 ST_GEOMFROMTEXT('POINT(0 0)'),
1348 ST_GEOMFROMTEXT('MULTIPOINT((1 0))'));
1349 DO ST_DISTANCE(
1350 ST_GEOMFROMTEXT('POINT(0 0)'),
1351 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'));
1352 DO ST_DISTANCE(
1353 ST_GEOMFROMTEXT('POINT(0 0)'),
1354 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'));
1355 DO ST_DISTANCE(
1356 ST_GEOMFROMTEXT('POINT(0 0)'),
1357 ST_GEOMFROMTEXT(
1358 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))'));
1359
1360 DO ST_DISTANCE(
1361 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'),
1362 ST_GEOMFROMTEXT('POINT(1 0)'));
1363 DO ST_DISTANCE(
1364 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'),
1365 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'));
1366 DO ST_DISTANCE(
1367 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'),
1368 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'));
1369 DO ST_DISTANCE(
1370 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'),
1371 ST_GEOMFROMTEXT('MULTIPOINT((1 0))'));
1372 DO ST_DISTANCE(
1373 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'),
1374 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'));
1375 DO ST_DISTANCE(
1376 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'),
1377 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'));
1378 DO ST_DISTANCE(
1379 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'),
1380 ST_GEOMFROMTEXT(
1381 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))'));
1382
1383 DO ST_DISTANCE(
1384 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'),
1385 ST_GEOMFROMTEXT('POINT(1 0)'));
1386 DO ST_DISTANCE(
1387 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'),
1388 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'));
1389 DO ST_DISTANCE(
1390 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'),
1391 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'));
1392 DO ST_DISTANCE(
1393 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'),
1394 ST_GEOMFROMTEXT('MULTIPOINT((1 0))'));
1395 DO ST_DISTANCE(
1396 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'),
1397 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'));
1398 DO ST_DISTANCE(
1399 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'),
1400 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'));
1401 DO ST_DISTANCE(
1402 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'),
1403 ST_GEOMFROMTEXT(
1404 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))'));
1405
1406 DO ST_DISTANCE(
1407 ST_GEOMFROMTEXT('MULTIPOINT((0 0))'),
1408 ST_GEOMFROMTEXT('POINT(1 0)'));
1409 DO ST_DISTANCE(
1410 ST_GEOMFROMTEXT('MULTIPOINT((0 0))'),
1411 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'));
1412 DO ST_DISTANCE(
1413 ST_GEOMFROMTEXT('MULTIPOINT((0 0))'),
1414 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'));
1415 DO ST_DISTANCE(
1416 ST_GEOMFROMTEXT('MULTIPOINT((0 0))'),
1417 ST_GEOMFROMTEXT('MULTIPOINT((1 0))'));
1418 DO ST_DISTANCE(
1419 ST_GEOMFROMTEXT('MULTIPOINT((0 0))'),
1420 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'));
1421 DO ST_DISTANCE(
1422 ST_GEOMFROMTEXT('MULTIPOINT((0 0))'),
1423 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'));
1424 DO ST_DISTANCE(
1425 ST_GEOMFROMTEXT('MULTIPOINT((0 0))'),
1426 ST_GEOMFROMTEXT(
1427 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))'));
1428
1429 DO ST_DISTANCE(
1430 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'),
1431 ST_GEOMFROMTEXT('POINT(1 0)'));
1432 DO ST_DISTANCE(
1433 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'),
1434 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'));
1435 DO ST_DISTANCE(
1436 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'),
1437 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'));
1438 DO ST_DISTANCE(
1439 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'),
1440 ST_GEOMFROMTEXT('MULTIPOINT((1 0))'));
1441 DO ST_DISTANCE(
1442 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'),
1443 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'));
1444 DO ST_DISTANCE(
1445 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'),
1446 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'));
1447 DO ST_DISTANCE(
1448 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'),
1449 ST_GEOMFROMTEXT(
1450 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))'));
1451
1452 DO ST_DISTANCE(
1453 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'),
1454 ST_GEOMFROMTEXT('POINT(1 0)'));
1455 DO ST_DISTANCE(
1456 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'),
1457 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'));
1458 DO ST_DISTANCE(
1459 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'),
1460 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'));
1461 DO ST_DISTANCE(
1462 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'),
1463 ST_GEOMFROMTEXT('MULTIPOINT((1 0))'));
1464 DO ST_DISTANCE(
1465 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'),
1466 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'));
1467 DO ST_DISTANCE(
1468 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'),
1469 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'));
1470 DO ST_DISTANCE(
1471 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'),
1472 ST_GEOMFROMTEXT(
1473 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))'));
1474
1475 DO ST_DISTANCE(
1476 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))'),
1477 ST_GEOMFROMTEXT('POINT(1 0)'));
1478 DO ST_DISTANCE(
1479 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))'),
1480 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)'));
1481 DO ST_DISTANCE(
1482 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))'),
1483 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))'));
1484 DO ST_DISTANCE(
1485 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))'),
1486 ST_GEOMFROMTEXT('MULTIPOINT((1 0))'));
1487 DO ST_DISTANCE(
1488 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))'),
1489 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))'));
1490 DO ST_DISTANCE(
1491 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))'),
1492 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))'));
1493 DO ST_DISTANCE(
1494 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))'),
1495 ST_GEOMFROMTEXT(
1496 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))'));
1497
1498 --echo # All parameter types (Geographic)
1499
1500 DO ST_DISTANCE(
1501 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1502 ST_GEOMFROMTEXT('POINT(1 0)', 4326));
1503
1504 DO ST_DISTANCE(
1505 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1506 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326));
1507
1508 DO ST_DISTANCE(
1509 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1510 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326));
1511 DO ST_DISTANCE(
1512 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1513 ST_GEOMFROMTEXT('MULTIPOINT((1 0))', 4326));
1514
1515 DO ST_DISTANCE(
1516 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1517 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326));
1518
1519 DO ST_DISTANCE(
1520 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1521 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326));
1522
1523 DO ST_DISTANCE(
1524 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1525 ST_GEOMFROMTEXT(
1526 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))', 4326)
1527 );
1528
1529
1530 DO ST_DISTANCE(
1531 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326),
1532 ST_GEOMFROMTEXT('POINT(1 0)', 4326));
1533
1534 DO ST_DISTANCE(
1535 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326),
1536 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326));
1537
1538 DO ST_DISTANCE(
1539 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326),
1540 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326));
1541
1542 DO ST_DISTANCE(
1543 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326),
1544 ST_GEOMFROMTEXT('MULTIPOINT((1 0))', 4326));
1545
1546 DO ST_DISTANCE(
1547 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326),
1548 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326));
1549
1550 DO ST_DISTANCE(
1551 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326),
1552 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326));
1553
1554 DO ST_DISTANCE(
1555 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326),
1556 ST_GEOMFROMTEXT(
1557 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))', 4326)
1558 );
1559
1560
1561 DO ST_DISTANCE(
1562 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326),
1563 ST_GEOMFROMTEXT('POINT(1 0)', 4326));
1564
1565 DO ST_DISTANCE(
1566 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326),
1567 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326));
1568
1569 DO ST_DISTANCE(
1570 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326),
1571 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326));
1572
1573 DO ST_DISTANCE(
1574 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326),
1575 ST_GEOMFROMTEXT('MULTIPOINT((1 0))', 4326));
1576
1577 DO ST_DISTANCE(
1578 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326),
1579 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326));
1580
1581 DO ST_DISTANCE(
1582 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326),
1583 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326));
1584
1585 DO ST_DISTANCE(
1586 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326),
1587 ST_GEOMFROMTEXT(
1588 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))', 4326)
1589 );
1590
1591 DO ST_DISTANCE(
1592 ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1593 ST_GEOMFROMTEXT('POINT(1 0)', 4326));
1594
1595 DO ST_DISTANCE(
1596 ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1597 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326));
1598
1599 DO ST_DISTANCE(
1600 ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1601 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326));
1602
1603 DO ST_DISTANCE(
1604 ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1605 ST_GEOMFROMTEXT('MULTIPOINT((1 0))', 4326));
1606
1607 DO ST_DISTANCE(
1608 ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1609 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326));
1610
1611 DO ST_DISTANCE(
1612 ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1613 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326));
1614
1615 DO ST_DISTANCE(
1616 ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1617 ST_GEOMFROMTEXT(
1618 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))', 4326)
1619 );
1620
1621
1622 DO ST_DISTANCE(
1623 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326),
1624 ST_GEOMFROMTEXT('POINT(1 0)', 4326));
1625
1626 DO ST_DISTANCE(
1627 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326),
1628 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326));
1629
1630 DO ST_DISTANCE(
1631 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326),
1632 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326));
1633
1634 DO ST_DISTANCE(
1635 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326),
1636 ST_GEOMFROMTEXT('MULTIPOINT((1 0))', 4326));
1637
1638 DO ST_DISTANCE(
1639 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326),
1640 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326));
1641
1642 DO ST_DISTANCE(
1643 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326),
1644 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326));
1645
1646 DO ST_DISTANCE(
1647 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326),
1648 ST_GEOMFROMTEXT(
1649 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))', 4326)
1650 );
1651
1652
1653 DO ST_DISTANCE(
1654 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326),
1655 ST_GEOMFROMTEXT('POINT(1 0)', 4326));
1656
1657 DO ST_DISTANCE(
1658 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326),
1659 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326));
1660
1661 DO ST_DISTANCE(
1662 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326),
1663 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326));
1664
1665 DO ST_DISTANCE(
1666 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326),
1667 ST_GEOMFROMTEXT('MULTIPOINT((1 0))', 4326));
1668
1669 DO ST_DISTANCE(
1670 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326),
1671 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326));
1672
1673 DO ST_DISTANCE(
1674 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326),
1675 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326));
1676
1677 DO ST_DISTANCE(
1678 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326),
1679 ST_GEOMFROMTEXT(
1680 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))', 4326)
1681 );
1682
1683
1684 DO ST_DISTANCE(
1685 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))',
1686 4326),
1687 ST_GEOMFROMTEXT('POINT(1 0)', 4326));
1688
1689 DO ST_DISTANCE(
1690 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))',
1691 4326),
1692 ST_GEOMFROMTEXT('LINESTRING(1 0, 1 1)', 4326));
1693
1694 DO ST_DISTANCE(
1695 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))',
1696 4326),
1697 ST_GEOMFROMTEXT('POLYGON((1 0, 2 0, 2 1, 1 1, 1 0))', 4326));
1698
1699 DO ST_DISTANCE(
1700 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))',
1701 4326),
1702 ST_GEOMFROMTEXT('MULTIPOINT((1 0))', 4326));
1703
1704 DO ST_DISTANCE(
1705 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))',
1706 4326),
1707 ST_GEOMFROMTEXT('MULTILINESTRING((1 0, 1 1))', 4326));
1708
1709 DO ST_DISTANCE(
1710 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))',
1711 4326),
1712 ST_GEOMFROMTEXT('MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0)))', 4326));
1713
1714 DO ST_DISTANCE(
1715 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(-1 -1, -2 -2))',
1716 4326),
1717 ST_GEOMFROMTEXT(
1718 'GEOMETRYCOLLECTION(MULTIPOLYGON(((1 0, 2 0, 2 1, 1 1, 1 0))))', 4326));
1719
1720 --echo # All types in a geometrycollection
1721 SET @pt = ST_GEOMFROMTEXT('POINT(0 0)');
1722 SET @ls = ST_GEOMFROMTEXT('LINESTRING(0 0, 10 0, 10 10, 0 10, 0 0)');
1723 SET @py = ST_GEOMFROMTEXT(
1724 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0),(2 2, 8 2, 8 8, 2 8, 2 2))');
1725 SET @mpt = ST_GEOMFROMTEXT('MULTIPOINT((0 0),(1 1))');
1726 SET @mls = ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1),(2 2, 3 3))');
1727 SET @mpy = ST_GEOMFROMTEXT(
1728 'MULTIPOLYGON(((0 0, 10 0, 10 10, 0 10, 0 0),(2 2, 8 2, 8 8, 2 8, 2 2)))');
1729 SET @gc = ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(
1730 POINT(0 0),
1731 LINESTRING(0 0, 10 0, 10 10, 0 10, 0 0),
1732 POLYGON((0 0, 10 0, 10 10, 0 10, 0 0),(2 2, 8 2, 8 8, 2 8, 2 2)),
1733 MULTIPOINT((0 0),(1 1)),
1734 MULTILINESTRING((0 0, 1 1),(2 2, 3 3)),
1735 MULTIPOLYGON(((0 0, 10 0, 10 10, 0 10, 0 0),(2 2, 8 2, 8 8, 2 8, 2 2))),
1736 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 0))),
1737 GEOMETRYCOLLECTION())'
1738 );
1739 DO ST_DISTANCE(ST_SRID(@pt, 0), ST_SRID(@gc, 0));
1740
1741 DO ST_DISTANCE(ST_SRID(@pt, 4326), ST_SRID(@gc, 4326));
1742
1743 --echo # Polygon ring directions
1744
1745 # CCW exterior
1746 DO ST_DISTANCE(POINT(0, 0), ST_GEOMFROMTEXT(
1747 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0))'
1748 ));
1749
1750 # CW exterior
1751 DO ST_DISTANCE(POINT(0, 0), ST_GEOMFROMTEXT(
1752 'POLYGON((0 0, 0 10, 10 10, 10 0, 0 0))'
1753 ));
1754
1755 # CCW interior
1756 DO ST_DISTANCE(POINT(0, 0), ST_GEOMFROMTEXT(
1757 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0),(2 2, 8 2, 8 8, 2 2))'
1758 ));
1759
1760 # CW interior
1761 DO ST_DISTANCE(POINT(0, 0), ST_GEOMFROMTEXT(
1762 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0),(2 2, 8 8, 8 2, 2 2))'
1763 ));
1764
1765 # Exterior with only one point
1766 --echo # Invalid polygon.
1767 DO ST_DISTANCE(POINT(0, 0), ST_GEOMFROMTEXT(
1768 'POLYGON((0 0, 0 0, 0 0, 0 0, 0 0))'
1769 ));
1770
1771 # Interior with only one point
1772 --echo # Invalid polygon.
1773 DO ST_DISTANCE(POINT(0, 0), ST_GEOMFROMTEXT(
1774 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0),(2 2, 2 2, 2 2, 2 2, 2 2))'
1775 ));
1776
1777 # Assume SRID 13001000-13001999 are undefined
1778 # WGS 84 with long-lat axis ordering
1779 CREATE SPATIAL REFERENCE SYSTEM 13001000 NAME 'TEST13001000 Long-Lat WGS 84' DEFINITION 'GEOGCS["Long-Lat WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lon",EAST],AXIS["Lat",NORTH],AUTHORITY["EPSG","4326"]]';
1780 # WGS 84 with gradians
1781 CREATE SPATIAL REFERENCE SYSTEM 13001001 NAME 'TEST13001001 Gradian WGS 84' DEFINITION 'GEOGCS["Gradian WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["grad",0.01570796326794895,AUTHORITY["EPSG","9105"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
1782 # WGS 84 with lat-long (South-West) axes in gradians, meridian 10 grads East of
1783 # Greenwich.
1784 CREATE SPATIAL REFERENCE SYSTEM 13001002 NAME 'TEST13001002 Tweaked WGS 84' DEFINITION 'GEOGCS["Tweaked",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["10 E",10,AUTHORITY["EPSG","8901"]],UNIT["grad",0.01570796326794895,AUTHORITY["EPSG","9105"]],AXIS["Lat",SOUTH],AXIS["Lon",WEST],AUTHORITY["EPSG","4326"]]';
1785 # WGS 84 with radians
1786 CREATE SPATIAL REFERENCE SYSTEM 13001003 NAME 'TEST13001003 Radian WGS 84' DEFINITION 'GEOGCS["Radian WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["radian",1.0,AUTHORITY["EPSG","9101"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
1787
1788 --echo # From the Equator to the North Pole along the Greenwich meridian
1789
1790 # Degrees (lat-long)
1791 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1792 ST_GEOMFROMTEXT('POINT(90 0)', 4326)), 3) AS d;
1793 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1794 ST_GEOMFROMTEXT('MULTIPOINT((90 0))', 4326)), 3) AS d;
1795 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1796 ST_GEOMFROMTEXT('POINT(90 0)', 4326)), 3) AS d;
1797
1798 # Degrees (long-lat)
1799 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 13001000),
1800 ST_GEOMFROMTEXT('POINT(0 90)', 13001000)), 3) AS d;
1801 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 13001000),
1802 ST_GEOMFROMTEXT('MULTIPOINT((0 90))', 13001000)), 3) AS d;
1803 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 13001000),
1804 ST_GEOMFROMTEXT('POINT(0 90)', 13001000)), 3) AS d;
1805
1806 # Gradians (lat-long)
1807 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 13001001),
1808 ST_GEOMFROMTEXT('POINT(100 0)', 13001001)), 3) AS d;
1809 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 13001001),
1810 ST_GEOMFROMTEXT('MULTIPOINT((100 0))', 13001001)), 3) AS d;
1811 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 13001001),
1812 ST_GEOMFROMTEXT('POINT(100 0)', 13001001)), 3) AS d;
1813
1814 # Gradians (lat-long), meridian at 10 grad East
1815 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 10)', 13001002),
1816 ST_GEOMFROMTEXT('POINT(-100 10)', 13001002)), 3) AS d;
1817 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 10)', 13001002),
1818 ST_GEOMFROMTEXT('MULTIPOINT((-100 10))', 13001002)), 3) AS d;
1819 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT((0 10))', 13001002),
1820 ST_GEOMFROMTEXT('POINT(-100 10)', 13001002)), 3) AS d;
1821
1822 --echo # 45 degrees East along the Equator from the Greenwich meridian
1823
1824 # Degrees (lat-long)
1825 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1826 ST_GEOMFROMTEXT('POINT(0 45)', 4326)), 3) AS d;
1827 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1828 ST_GEOMFROMTEXT('MULTIPOINT((0 45))', 4326)), 3) AS d;
1829 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326),
1830 ST_GEOMFROMTEXT('POINT(0 45)', 4326)), 3) AS d;
1831
1832 # Degreees (long-lat)
1833 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 13001000),
1834 ST_GEOMFROMTEXT('POINT(45 0)', 13001000)), 3) AS d;
1835 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 13001000),
1836 ST_GEOMFROMTEXT('MULTIPOINT((45 0))', 13001000)), 3) AS d;
1837 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 13001000),
1838 ST_GEOMFROMTEXT('POINT(45 0)', 13001000)), 3) AS d;
1839
1840 # Gradians (lat-long)
1841 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 13001001),
1842 ST_GEOMFROMTEXT('POINT(0 50)', 13001001)), 3) AS d;
1843 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 0)', 13001001),
1844 ST_GEOMFROMTEXT('MULTIPOINT((0 50))', 13001001)), 3) AS d;
1845 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 13001001),
1846 ST_GEOMFROMTEXT('POINT(0 50)', 13001001)), 3) AS d;
1847
1848 # Gradians (lat-long), meridian at 10 grad East
1849 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 10)', 13001002),
1850 ST_GEOMFROMTEXT('POINT(0 -40)', 13001002)), 3) AS d;
1851 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('POINT(0 10)', 13001002),
1852 ST_GEOMFROMTEXT('MULTIPOINT((0 -40))', 13001002)), 3) AS d;
1853 SELECT ROUND(ST_DISTANCE(ST_GEOMFROMTEXT('MULTIPOINT((0 10))', 13001002),
1854 ST_GEOMFROMTEXT('POINT(0 -40)', 13001002)), 3) AS d;
1855
1856 --echo # Trondheim (63.430492N, 10.395046E) - Bangalore (12.976679N, 77.593916E)
1857
1858 # Degrees (lat-long)
1859 SELECT ROUND(ST_DISTANCE(
1860 ST_GEOMFROMTEXT('POINT(63.430492 10.395046)', 4326),
1861 ST_GEOMFROMTEXT('POINT(12.976679 77.593916)', 4326)
1862 ), 3) AS d;
1863 SELECT ROUND(ST_DISTANCE(
1864 ST_GEOMFROMTEXT('POINT(63.430492 10.395046)', 4326),
1865 ST_GEOMFROMTEXT('MULTIPOINT((12.976679 77.593916))', 4326)
1866 ), 3) AS d;
1867 SELECT ROUND(ST_DISTANCE(
1868 ST_GEOMFROMTEXT('MULTIPOINT((63.430492 10.395046))', 4326),
1869 ST_GEOMFROMTEXT('POINT(12.976679 77.593916)', 4326)
1870 ), 3) AS d;
1871
1872 # Degreees (long-lat)
1873 SELECT ROUND(ST_DISTANCE(
1874 ST_GEOMFROMTEXT('POINT(10.395046 63.430492)', 13001000),
1875 ST_GEOMFROMTEXT('POINT(77.593916 12.976679)', 13001000)
1876 ), 3) AS d;
1877 SELECT ROUND(ST_DISTANCE(
1878 ST_GEOMFROMTEXT('POINT(10.395046 63.430492)', 13001000),
1879 ST_GEOMFROMTEXT('MULTIPOINT((77.593916 12.976679))', 13001000)
1880 ), 3) AS d;
1881 SELECT ROUND(ST_DISTANCE(
1882 ST_GEOMFROMTEXT('MULTIPOINT((10.395046 63.430492))', 13001000),
1883 ST_GEOMFROMTEXT('POINT(77.593916 12.976679)', 13001000)
1884 ), 3) AS d;
1885
1886 # Gradians (lat-long)
1887 SELECT ROUND(ST_DISTANCE(
1888 ST_GEOMFROMTEXT('POINT(70.47832444444444 11.550051111111111)', 13001001),
1889 ST_GEOMFROMTEXT('POINT(14.418532222222222 86.21546222222221)', 13001001)
1890 ), 3) AS d;
1891 SELECT ROUND(ST_DISTANCE(
1892 ST_GEOMFROMTEXT('POINT(70.47832444444444 11.550051111111111)', 13001001),
1893 ST_GEOMFROMTEXT('MULTIPOINT((14.418532222222222 86.21546222222221))',
1894 13001001)
1895 ), 3) AS d;
1896 SELECT ROUND(ST_DISTANCE(
1897 ST_GEOMFROMTEXT('MULTIPOINT((70.47832444444444 11.550051111111111))',
1898 13001001),
1899 ST_GEOMFROMTEXT('POINT(14.418532222222222 86.21546222222221)', 13001001)
1900 ), 3) AS d;
1901
1902 # Gradians (lat-long), meridian at 10 grad East
1903 SELECT ROUND(ST_DISTANCE(
1904 ST_GEOMFROMTEXT('POINT(70.47832444444444 -1.550051111111111)', 13001002),
1905 ST_GEOMFROMTEXT('POINT(14.418532222222222 -76.21546222222221)', 13001002)
1906 ), 3) AS d;
1907 SELECT ROUND(ST_DISTANCE(
1908 ST_GEOMFROMTEXT('POINT(70.47832444444444 -1.550051111111111)', 13001002),
1909 ST_GEOMFROMTEXT('MULTIPOINT((14.418532222222222 -76.21546222222221))',
1910 13001002)
1911 ), 3) AS d;
1912 SELECT ROUND(ST_DISTANCE(
1913 ST_GEOMFROMTEXT('MULTIPOINT((70.47832444444444 -1.550051111111111))',
1914 13001002),
1915 ST_GEOMFROMTEXT('POINT(14.418532222222222 -76.21546222222221)', 13001002)
1916 ), 3) AS d;
1917
1918 --echo # Unit test DistanceTest.Geographic_Multipolygon_MultiPoint
1919
1920 SELECT ROUND(ST_DISTANCE(
1921 ST_GEOMFROMTEXT('MULTIPOINT(0.2 0.2, 0.525 0.2)', 13001000),
1922 ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 1 0, 0 1, 0 0)),((0.05 0.05, 0.05 0.95, 0.95 0.05, 0.05 0.05)))', 13001000)
1923 ), 0) AS d;
1924
1925 --echo # Longitude out of range
1926
1927 # Degrees (lat-long)
1928 # Due to floating point math, the limit is around +/- 180.00000000000017.
1929 # SRID=4326, long=180.000000000001, lat=0.
1930 SET @pt_long_above = x'E6100000010100000023000000008066400000000000000000';
1931 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1932 DO ST_DISTANCE(
1933 @pt_long_above,
1934 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 4326)
1935 ) AS d;
1936 # Just within range
1937 DO ST_DISTANCE(
1938 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(0 180)')), 4326),
1939 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 4326)
1940 ) AS d;
1941 # SRID=4326, long=-180.000000000001, lat=0.
1942 SET @pt_long_below = x'E6100000010100000023000000008066C00000000000000000';
1943 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1944 DO ST_DISTANCE(
1945 @pt_long_below,
1946 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 4326)
1947 ) AS d;
1948 # Just within range
1949 DO ST_DISTANCE(
1950 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(0 -179.999999999999)')), 4326),
1951 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 4326)
1952 ) AS d;
1953
1954 # Degreees (long-lat)
1955 # Due to floating point math, the limit is around +/- 180.00000000000017.
1956 # SRID=13001000, long=180.000000000001, lat=0.
1957 SET @pt_long_above = x'2861C600010100000023000000008066400000000000000000';
1958 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1959 DO ST_DISTANCE(
1960 @pt_long_above,
1961 ST_SRID(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'), 13001000)
1962 ) AS d;
1963 # Just within range
1964 DO ST_DISTANCE(
1965 ST_SRID(ST_GEOMFROMTEXT('POINT(180 0)'), 13001000),
1966 ST_SRID(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'), 13001000)
1967 ) AS d;
1968 # SRID=13001000, long=-180.000000000001, lat=0.
1969 SET @pt_long_below = x'2861C600010100000023000000008066C00000000000000000';
1970 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1971 DO ST_DISTANCE(
1972 @pt_long_below,
1973 ST_SRID(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'), 13001000)
1974 ) AS d;
1975 # Just within range
1976 DO ST_DISTANCE(
1977 ST_SRID(ST_GEOMFROMTEXT('POINT(-179.999999999999 0)'), 13001000),
1978 ST_SRID(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'), 13001000)
1979 ) AS d;
1980
1981 # Gradians (lat-long)
1982 # Due to floating point math, the limit is around +/- 200.0000000000002.
1983 # SRID=13001001, long=200.000000000001, lat=0.
1984 SET @pt_long_above = x'2961C600010100000023000000000069400000000000000000';
1985 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1986 DO ST_DISTANCE(
1987 @pt_long_above,
1988 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001001)
1989 ) AS d;
1990 # Just within range
1991 DO ST_DISTANCE(
1992 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(0 200)')), 13001001),
1993 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001001)
1994 ) AS d;
1995 # SRID=13001001, long=-200.000000000001, lat=0.
1996 SET @pt_long_below = x'2961C600010100000023000000000069C00000000000000000';
1997 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1998 DO ST_DISTANCE(
1999 @pt_long_below,
2000 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001001)
2001 ) AS d;
2002 # Just within range
2003 DO ST_DISTANCE(
2004 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(0 -199.999999999999)')), 13001001),
2005 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001001)
2006 ) AS d;
2007
2008 # Gradians (lat-long), meridian at 10 grad East
2009 # Due to floating point math, the limit is around +/- 200.0000000000002.
2010 # SRID=13001002, long=200.000000000001, lat=0.
2011 SET @pt_long_above = x'2A61C600010100000023000000000069400000000000000000';
2012 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
2013 DO ST_DISTANCE(
2014 @pt_long_above,
2015 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001002)
2016 ) AS d;
2017 # Just within range
2018 DO ST_DISTANCE(
2019 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(0 200)')), 13001002),
2020 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001002)
2021 ) AS d;
2022 # SRID=13001002, long=-200.000000000001, lat=0.
2023 SET @pt_long_below = x'2A61C600010100000023000000000069C00000000000000000';
2024 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
2025 DO ST_DISTANCE(
2026 @pt_long_below,
2027 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001002)
2028 ) AS d;
2029 # Just within range
2030 DO ST_DISTANCE(
2031 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(0 -199.999999999999)')), 13001002),
2032 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001002)
2033 ) AS d;
2034
2035 # Radians (lat-long)
2036 # The limit is around +/- 3.141592653589793.
2037 # SRID=13001003, long=3.141592653589794, lat=0.
2038 SET @pt_long_above = x'2B61C60001010000001A2D4454FB2109400000000000000000';
2039 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
2040 DO ST_DISTANCE(
2041 @pt_long_above,
2042 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001003)
2043 ) AS d;
2044 # Just within range
2045 DO ST_DISTANCE(
2046 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(0 3.141592653589793)')), 13001003),
2047 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001003)
2048 ) AS d;
2049 # SRID=13001003, long=-3.141592653589793, lat=0.
2050 SET @pt_long_below = x'2B61C6000101000000182D4454FB2109C00000000000000000';
2051 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
2052 DO ST_DISTANCE(
2053 @pt_long_below,
2054 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001003)
2055 ) AS d;
2056 # Just within range
2057 DO ST_DISTANCE(
2058 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(0 -3.141592653589792)')), 13001003),
2059 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001003)
2060 ) AS d;
2061
2062 --echo # Latitude out of range
2063
2064 # Degrees (lat-long)
2065 # Due to floating point math, the limit is around +/- 90.00000000000009.
2066 # SRID=4326, long=0, lat=90.0000000000001.
2067 SET @pt_lat_above = x'E6100000010100000000000000000000000700000000805640';
2068 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2069 DO ST_DISTANCE(
2070 @pt_lat_above,
2071 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 4326)
2072 ) AS d;
2073 # Just within range
2074 DO ST_DISTANCE(
2075 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(90 0)')), 4326),
2076 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 4326)
2077 ) AS d;
2078 # SRID=4326, long=0, lat=-90.0000000000001.
2079 SET @pt_lat_below = x'E61000000101000000000000000000000007000000008056C0';
2080 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2081 DO ST_DISTANCE(
2082 @pt_lat_below,
2083 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 4326)
2084 ) AS d;
2085 # Just within range
2086 DO ST_DISTANCE(
2087 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(-90 0)')), 4326),
2088 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 4326)
2089 ) AS d;
2090
2091 # Degreees (long-lat)
2092 # Due to floating point math, the limit is around +/- 90.00000000000009.
2093 # SRID=13001000, long=0, lat=90.0000000000001.
2094 SET @pt_lat_above = x'2861C600010100000000000000000000000700000000805640';
2095 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2096 DO ST_DISTANCE(
2097 @pt_lat_above,
2098 ST_SRID(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'), 13001000)
2099 ) AS d;
2100 # Just within range
2101 DO ST_DISTANCE(
2102 ST_SRID(ST_GEOMFROMTEXT('POINT(0 90)'), 13001000),
2103 ST_SRID(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'), 13001000)
2104 ) AS d;
2105 # SRID=13001000, long=0, lat=-90.0000000000001.
2106 SET @pt_lat_below = x'2861C6000101000000000000000000000007000000008056C0';
2107 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2108 DO ST_DISTANCE(
2109 @pt_lat_below,
2110 ST_SRID(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'), 13001000)
2111 ) AS d;
2112 # Just within range
2113 DO ST_DISTANCE(
2114 ST_SRID(ST_GEOMFROMTEXT('POINT(0 -90)'), 13001000),
2115 ST_SRID(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'), 13001000)
2116 ) AS d;
2117
2118 # Gradians (lat-long)
2119 # Due to floating point math, the limit is around +/- 100.0000000000001.
2120 # SRID=13001001, long=0, lat=100.000000000001.
2121 SET @pt_lat_above = x'2961C600010100000000000000000000004600000000005940';
2122 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2123 DO ST_DISTANCE(
2124 @pt_lat_above,
2125 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001001)
2126 ) AS d;
2127 # Just within range
2128 DO ST_DISTANCE(
2129 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(100 0)')), 13001001),
2130 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001001)
2131 ) AS d;
2132 # SRID=13001001, long=0, lat=-100.000000000001.
2133 SET @pt_lat_below = x'2961C6000101000000000000000000000046000000000059C0';
2134 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2135 DO ST_DISTANCE(
2136 @pt_lat_below,
2137 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001001)
2138 ) AS d;
2139 # Just within range
2140 DO ST_DISTANCE(
2141 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(-100 0)')), 13001001),
2142 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001001)
2143 ) AS d;
2144
2145 # Gradians (lat-long), meridian at 10 grad East
2146 # Due to floating point math, the limit is around +/- 100.0000000000001.
2147 # SRID=13001002, long=0, lat=100.000000000001.
2148 SET @pt_lat_above = x'2A61C600010100000000000000000000004600000000005940';
2149 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2150 DO ST_DISTANCE(
2151 @pt_lat_above,
2152 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001002)
2153 ) AS d;
2154 # Just within range
2155 DO ST_DISTANCE(
2156 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(100 0)')), 13001002),
2157 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001002)
2158 ) AS d;
2159 # SRID=13001002, long=0, lat=-100.000000000001.
2160 SET @pt_lat_below = x'2A61C6000101000000000000000000000046000000000059C0';
2161 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2162 DO ST_DISTANCE(
2163 @pt_lat_below,
2164 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001002)
2165 ) AS d;
2166 # Just within range
2167 DO ST_DISTANCE(
2168 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(-100 0)')), 13001002),
2169 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001002)
2170 ) AS d;
2171
2172 # Radians (lat-long)
2173 # The limit is around +/- 1.5707963267948966.
2174 # SRID=13001003, long=0, lat=1.5707963267948967.
2175 SET @pt_lat_above = x'2B61C60001010000000000000000000000192D4454FB21F93F';
2176 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2177 DO ST_DISTANCE(
2178 @pt_lat_above,
2179 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001003)
2180 ) AS d;
2181 # Just within range
2182 DO ST_DISTANCE(
2183 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(1.5707963267948966 0)')), 13001003),
2184 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001003)
2185 ) AS d;
2186 # SRID=13001003, long=0, lat=-1.5707963267948967.
2187 SET @pt_lat_below = x'2B61C60001010000000000000000000000192D4454FB21F9BF';
2188 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2189 DO ST_DISTANCE(
2190 @pt_lat_below,
2191 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001003)
2192 ) AS d;
2193 # Just within range
2194 DO ST_DISTANCE(
2195 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(-1.5707963267948965 0)')), 13001003),
2196 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('MULTIPOINT((0 0))')), 13001003)
2197 ) AS d;
2198
2199 # Longitude out of range in a point in a multipoint.
2200 # SRID=4326, MULTIPOINT((0 0), (0 200)).
2201 SET @mpt_long_above = x'E6100000010400000002000000010100000000000000000000000000000000000000010100000000000000000069400000000000000000';
2202 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
2203 DO ST_DISTANCE(
2204 @mpt_long_above,
2205 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(1 1)')), 4326)
2206 ) AS d;
2207 # Latitude out of range in a point in a multipoint.
2208 # SRID=4326, MULTIPOINT((0 0), (100 0)).
2209 SET @mpt_lat_above = x'E6100000010400000002000000010100000000000000000000000000000000000000010100000000000000000000000000000000005940';
2210 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
2211 DO ST_DISTANCE(
2212 @mpt_lat_above,
2213 ST_SRID(ST_SWAPXY(ST_GEOMFROMTEXT('POINT(1 1)')), 4326)
2214 ) AS d;
2215
2216 DROP SPATIAL REFERENCE SYSTEM 13001000;
2217 DROP SPATIAL REFERENCE SYSTEM 13001001;
2218 DROP SPATIAL REFERENCE SYSTEM 13001002;
2219 DROP SPATIAL REFERENCE SYSTEM 13001003;
2220
2221 --echo # Spherical SRS
2222
2223 SELECT ROUND(ST_DISTANCE(
2224 ST_GEOMFROMTEXT('POINT(0 0)', 4053),
2225 ST_GEOMFROMTEXT('POINT(90 0)', 4053)), 3
2226 ) AS d;
2227
2228 SELECT ROUND(ST_DISTANCE(
2229 ST_GEOMFROMTEXT('POINT(0 0)', 4053),
2230 ST_GEOMFROMTEXT('POINT(0 45)', 4053)), 3
2231 ) AS d;
2232
2233 SELECT ROUND(ST_DISTANCE(
2234 ST_GEOMFROMTEXT('POINT(63.430492 10.395046)', 4053),
2235 ST_GEOMFROMTEXT('POINT(12.976679 77.593916)', 4053)), 3
2236 ) AS d;
2237
2238 --echo # Input parsing
2239
2240 # NaN
2241
2242 # POINT(0 NaN) and MULTIPOINT((0 0))
2243 --error ER_GIS_INVALID_DATA
2244 DO ST_DISTANCE(
2245 x'E610000001010000000000000000000000FFFFFFFFFFFFFFFF',
2246 x'E6100000010400000001000000010100000000000000000000000000000000000000'
2247 );
2248
2249 # MULTIPOINT((NaN 0)) and POINT(0 0)
2250 --error ER_GIS_INVALID_DATA
2251 DO ST_DISTANCE(
2252 x'000000000104000000010000000101000000FFFFFFFFFFFFFFFF0000000000000000',
2253 x'00000000010100000000000000000000000000000000000000'
2254 );
2255
2256 # Inf
2257 --error ER_GIS_INVALID_DATA
2258 DO ST_DISTANCE(POINT(1.7e+308, 1.7e308), POINT(-1.7e308, -1.7e308));
2259
2260 --disable_result_log
2261 SELECT UNIT_NAME, CONVERSION_FACTOR, UNIT_TYPE, DESCRIPTION FROM INFORMATION_SCHEMA.ST_UNITS_OF_MEASURE;
2262 --enable_result_log
2263
2264 SELECT ROUND(ST_DISTANCE( ST_GEOMFROMTEXT('POINT(63.430492 10.395046)', 4053), ST_GEOMFROMTEXT('POINT(12.976679 77.593916)', 4053),'metre'), 5) AS d;
2265 SELECT ST_DISTANCE( ST_GEOMFROMTEXT('POINT(63.430492 10.395046)', 2001), ST_GEOMFROMTEXT('POINT(12.976679 77.593916)', 2001),'metre') AS d;
2266 --error ER_UNIT_NOT_FOUND
2267 SELECT ST_DISTANCE( ST_GEOMFROMTEXT('POINT(63.430492 10.395046)', 4053), ST_GEOMFROMTEXT('POINT(12.976679 77.593916)', 4053),'meter') AS d;
2268 --error ER_GEOMETRY_IN_UNKNOWN_LENGTH_UNIT
2269 SELECT ST_DISTANCE( ST_GEOMFROMTEXT('POINT(63.430492 10.395046)'), ST_GEOMFROMTEXT('POINT(12.976679 77.593916)'),'metre') AS d;
2270
2271 SET @A = 'POINT(0 0)';
2272 SET @B = 'POINT(0.1 0.1)';
2273 SET @A_SRID0 = ST_GEOMFROMTEXT(@A);
2274 SET @B_SRID0 = ST_GEOMFROMTEXT(@B);
2275 SET @A_WGS84 = ST_GEOMFROMTEXT(@A,4326);
2276 SET @B_WGS84 = ST_GEOMFROMTEXT(@B,4326);
2277 SET @A_EPSG4053 = ST_GEOMFROMTEXT(@A,4053);
2278 SET @B_EPSG4053 = ST_GEOMFROMTEXT(@B,4053);
2279 SELECT ROUND(ST_DISTANCE(@A_WGS84,@B_WGS84), 5); # this and the next should be the same
2280 SELECT ROUND(ST_DISTANCE(@A_WGS84,@B_WGS84, "metre"), 5);
2281 --error ER_UNIT_NOT_FOUND
2282 SELECT ST_DISTANCE(@A_WGS84,@B_WGS84, "meter");
2283 SELECT ROUND(ST_DISTANCE(@A_EPSG4053, @B_EPSG4053), 5); # this and the next should be the same
2284 SELECT ROUND(ST_DISTANCE(@A_EPSG4053, @B_EPSG4053, "metre"), 5);
2285 SELECT ROUND(ST_DISTANCE(@A_EPSG4053, @B_EPSG4053, "Clarke's link"), 5); # check that apostrophes are handled
2286 SELECT ST_DISTANCE(@A_EPSG4053, @B_EPSG4053, NULL); # check that null values are handled,
2287 SELECT ST_DISTANCE(@A_EPSG4053, NULL, "Clarke's link");
2288 # Result is NULL when any geometry argument is NULL
2289 SELECT ST_DISTANCE(NULL, @B_EPSG4053, "Clarke's link");
2290 SELECT ST_DISTANCE(@A_EPSG4053, NULL, NULL);
2291 SELECT ST_DISTANCE(NULL, @B_EPSG4053, NULL);
2292 SELECT ST_DISTANCE(NULL,NULL, "Clarke's link");
2293 SELECT ST_DISTANCE(NULL, NULL, NULL);
2294 SELECT ROUND(ST_DISTANCE(@A_WGS84, @B_WGS84, "British link (Sears 1922)"), 5);
2295 SELECT ROUND(ST_DISTANCE(@A_EPSG4053, @B_EPSG4053, "Clarke's link") , 5);
2296
2297 --error ER_GEOMETRY_IN_UNKNOWN_LENGTH_UNIT
2298 SELECT ST_DISTANCE(@A_SRID0, @B_SRID0, "metre");
2299
2300 SET @EMPTY_COLLECTION_A = 'GEOMETRYCOLLECTION EMPTY';
2301 SET @EMPTY_COLLECTION_SRID0_A = ST_GEOMFROMTEXT(@EMPTY_COLLECTION_A);
2302 SET @EMPTY_COLLECTION_SRID4326_A = ST_GEOMFROMTEXT(@EMPTY_COLLECTION_A,4326);
2303 SELECT ST_DISTANCE( @EMPTY_COLLECTION_SRID0_A, @A_SRID0);
2304 SELECT ST_DISTANCE( @A_SRID0, @EMPTY_COLLECTION_SRID0_A);
2305 SELECT ST_DISTANCE( @EMPTY_COLLECTION_SRID4326_A, @A_WGS84);
2306 SELECT ST_DISTANCE( @A_WGS84, @EMPTY_COLLECTION_SRID4326_A);