Debian Codegraph @

mysql-test/suite/gis/r/spatial_analysis_functions_distance.result

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