Debian Codegraph @

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

raw
1 #####################################################################
2 # #
3 # This test is aimed to focus on Spatial Analysis Functions. #
4 # #
5 # ST_ConvexHull function returns the minimum convex geometry #
6 # that encloses all geometries within the set. #
7 # #
8 # Creation Date: 2014-06-05 #
9 # Author : Pavan Naik #
10 # #
11 #####################################################################
12
13
14 ############################################################################################
15 # Creating the spatial objects #
16 ############################################################################################
17
18 --echo # Creating the spatial Geometry object
19 USE test;
20
21 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
22
23 ############################################################################################
24 # Inserting the values specific to the spatial objects #
25 ############################################################################################
26
27 # Geometric elements constructing a star and some of its elememts as base
28 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
29 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
30 SET @star_center= 'POINT(15 10)';
31 SET @star_top= 'POINT(15 25)';
32 SET @star_bottom_left= 'POINT(5 0)';
33 SET @star_bottom_right= 'POINT(25 0)';
34 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
35 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
36 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
37 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
38 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
39 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
40 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
41 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))';
42 SET @star_elem_vertical_val= '((5 0,15 25,25 0,15 5,5 0))';
43 SET @star_elem_horizontal_val= '((25 0,0 15,30 15,22 10,25 0))';
44 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)))';
45 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))';
46 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))';
47
48 --echo # INSERT base star
49 --disable_warnings
50 INSERT INTO gis_geometrycollection VALUES
51 (100,ST_GEOMFROMTEXT(@star)),
52 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
53 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
54 (103,ST_GEOMFROMTEXT(@star_of_elems)),
55 (104,ST_GEOMFROMTEXT(@star_top)),
56 (105,ST_GEOMFROMTEXT(@star_center)),
57 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
58 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
59 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
60 (109,ST_GEOMFROMTEXT(@star_all_points)),
61 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
62 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
63 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
64 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
65 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
66 (115,ST_GEOMFROMTEXT(@star_collection_elems)),
67 (116,ST_GEOMFROMTEXT(@star_collection_multilinestr));
68 --enable_warnings
69
70 --echo # Checking the integrity of the above create/insert statements
71
72 --echo # 17 rows.
73 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
74
75 --echo #####################################################################################
76 --echo # ST_CONVEXHULL(point)
77 --echo #####################################################################################
78
79 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_center)));
80
81 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_top)));
82
83 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(-0 0)')));
84
85 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(2.34 -2.34)')));
86
87 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(1e308 -1e308)')));
88
89 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(-0.0000 0.000001)')));
90
91 SELECT ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometrycollection WHERE fid=105;
92
93 --echo #####################################################################################
94 --echo # ST_CONVEXHULL(multipoint)
95 --echo #####################################################################################
96
97 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_all_points)));
98
99 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_bottom_points)));
100
101 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)')));
102
103 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0,0 0)')));
104
105 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1000 -1000,0.0001 0.000)')));
106
107 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOINT(5 -3,0 2,5 7,10 2,10 0,10 -2)')));
108
109 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOINT(5 0,0 5,5 10,10 5,10 -5)')));
110
111 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOINT(2 -5,2 5,8 5,8 2,8 0)')));
112
113 Select ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOINT(5 0,25 0,15 10,15 25)')));
114
115 SELECT ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometrycollection WHERE fid=108;
116
117 --echo #####################################################################################
118 --echo # ST_CONVEXHULL(linestring)
119 --echo #####################################################################################
120
121 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_top_to_center)));
122
123 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_line_horizontal)));
124
125 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(0 0,-0.00 0,0.0 0)')));
126
127 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')));
128
129 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(1 -1,1000 -1000,0.0001 0.000)')));
130
131 SELECT ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometrycollection WHERE fid=110;
132
133 --echo #####################################################################################
134 --echo # ST_CONVEXHULL(multilinestring)
135 --echo #####################################################################################
136
137 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_lines_near_vertical)));
138
139 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_lines_near_horizontal)));
140
141 --error ER_GIS_INVALID_DATA
142 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0.00 0),(0.0 0))')));
143
144 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))')));
145
146 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))')));
147
148 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1000 -1000,0.0001 0.000))')));
149
150 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTILINESTRING((4 7,1 0,1 7),(4 9,8 6,9 4))')));
151
152 SELECT ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometrycollection WHERE fid=114;
153
154 --echo #####################################################################################
155 --echo # ST_CONVEXHULL(polygon)
156 --echo #####################################################################################
157
158 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star)));
159
160 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_elem_vertical)));
161
162 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5, 0 0))')));
163
164 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((5 2,5 5,2 8,5 2))')));
165
166 Select ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((5 0,15 25,25 0,15 5,5 0))')));
167
168 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))')));
169
170 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((10 10,10 0,0 20,0 10,10 10))')));
171
172 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,-10 0,-10 -10,0 -10, 0 0))')));
173
174 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')));
175
176 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0))')));
177
178 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0))')));
179
180 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8))')));
181
182 SELECT ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometrycollection WHERE fid=100;
183
184 --echo #####################################################################################
185 --echo # ST_CONVEXHULL(multipolygon)
186 --echo #####################################################################################
187
188 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_of_elems)));
189
190 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5, 0 0)))')));
191
192 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0, 0 10)),((0 0,10 10,10 0, 0 0)))')));
193
194 Select ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4,4 4)))')));
195
196 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10, 0 0)),((10 10,10 15,15 15,10 10)))')));
197
198 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4,4 4)))')));
199
200 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0),(4 4,4 6,6 6,6 4,4 4)))')));
201
202 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)))')));
203
204 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0)))')));
205
206 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8)))')));
207
208 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 0,5 10,10 10)),((0 10,0 20,5 10,0 10)))')));
209
210 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),'
211 '((0 0,0 10,10 10,10 0,0 0)))')));
212
213 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),'
214 '((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6, 4 4)))')));
215
216 --echo #####################################################################################
217 --echo # ST_CONVEXHULL(geometrycollection)
218 --echo #####################################################################################
219
220 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_collection_elems)));
221
222 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_collection_multilinestr)));
223
224 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')));
225
226 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())')));
227
228 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))')));
229
230 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10))')));
231
232 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10)))')));
233
234 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
235 'MULTILINESTRING((0 0,0 10,10 10,10 0, 0 0),(10 10,10 15,15 15,10 10)))')));
236
237 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),'
238 'MULTIPOINT(0 0,10 10),'
239 'LINESTRING(1 1,2 2,3 3),'
240 'MULTILINESTRING((0 0,0 10,10 10,10 0, 0 0),(10 10,10 15,15 15,10 10)))')));
241
242 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))')));
243
244 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))))')));
245
246 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)),POLYGON((0 0,10 0,10 -10,0 -10,0 0)))')));
247
248 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10,10 0,0 0),LINESTRING(0 0,10 0,10 -10,0 -10,0 0))')));
249
250 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
251 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),((10 10,10 15,15 15,15 10,10 10))))')));
252
253 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),POLYGON((0 0,0 10,10 10,10 0,0 0)))')));
254
255 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)),GEOMETRYCOLLECTION())')));
256
257 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
258 'MULTIPOINT(0 0,10 10)),'
259 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
260 'MULTILINESTRING((0 0,0 10,10 10,10 0, 0 0),(10 10,10 15,15 15,10 10))))')));
261
262 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
263 'MULTIPOINT(0 0,10 10)),'
264 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
265 'MULTILINESTRING((0 0,0 10,10 10,10 0, 0 0),(10 10,10 15,15 15,10 10))),'
266 'GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
267 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),'
268 '((10 10,10 15,15 15,15 10,10 10)))))')));
269
270 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
271 'MULTIPOINT(0 0,10 10)),'
272 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
273 'MULTILINESTRING((0 0,0 10,10 10,10 0, 0 0),(10 10,10 15,15 15,10 10))),'
274 'GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))')));
275
276 SELECT ST_ASTEXT(ST_CONVEXHULL(g)) FROM gis_geometrycollection WHERE fid=115;
277
278 --echo #####################################################################################
279 --echo # ST_CONVEXHULL(geometry) with different SRID values
280 --echo #####################################################################################
281
282 --error ER_DATA_OUT_OF_RANGE
283 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_center,-1024)));
284
285 --error ER_DATA_OUT_OF_RANGE
286 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_all_points,-1)));
287
288 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_top_to_center,0)));
289
290 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_lines_near_vertical,2000)));
291
292 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star,0)));
293
294 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
295 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_elem_vertical,4145)));
296
297 --error ER_DATA_OUT_OF_RANGE
298 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_of_elems,4294967296)));
299
300 --error ER_DATA_OUT_OF_RANGE
301 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT(@star_collection_elems,4294967295000)));
302
303 --echo #####################################################################################
304 --echo # Invalid function calls
305 --echo #####################################################################################
306
307 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
308 SELECT ST_ASTEXT(ST_CONVEXHULL());
309
310 SELECT ST_ASTEXT(ST_CONVEXHULL(NULL));
311
312 --error ER_GIS_INVALID_DATA
313 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT()')));
314
315 --error ER_GIS_INVALID_DATA
316 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING()')));
317
318 --error ER_GIS_INVALID_DATA
319 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON(())')));
320
321 --error ER_GIS_INVALID_DATA
322 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOINT()')));
323
324 --error ER_GIS_INVALID_DATA
325 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTILINESTRING(())')));
326
327 --error ER_GIS_INVALID_DATA
328 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON((()))')));
329
330 --error ER_GIS_INVALID_DATA
331 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(a 0)')));
332
333 --error ER_GIS_INVALID_DATA
334 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(! 0)')));
335
336 --error ER_PARSE_ERROR
337 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT('!' 0)')));
338
339 --error ER_GIS_INVALID_DATA
340 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(12,34 0)')));
341
342 --error ER_GIS_INVALID_DATA
343 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)')));
344
345 --error ER_GIS_INVALID_DATA
346 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)')));
347
348 --error ER_PARSE_ERROR
349 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)')));
350
351 --error ER_GIS_INVALID_DATA
352 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)')));
353
354 --error ER_GIS_INVALID_DATA
355 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))')));
356
357 --error ER_GIS_INVALID_DATA
358 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))')));
359
360 --error ER_PARSE_ERROR
361 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))')));
362
363 --error ER_GIS_INVALID_DATA
364 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))')));
365
366 --error ER_GIS_INVALID_DATA
367 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0))')));
368
369 --error ER_GIS_INVALID_DATA
370 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,5 5))')));
371
372 --error ER_GIS_INVALID_DATA
373 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,10 10))')));
374
375 --error ER_GIS_INVALID_DATA
376 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,10 10),(0 0))')));
377
378 --error ER_GIS_INVALID_DATA
379 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 10)),((10 10)))')));
380
381 --error ER_GIS_INVALID_DATA
382 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 10)),((10 10))')));
383
384 --error ER_GIS_DATA_WRONG_ENDIANESS
385 SELECT ST_ASTEXT(ST_CONVEXHULL(0x000000000200000000000000000000000000000000));
386
387 --error ER_GIS_DATA_WRONG_ENDIANESS
388 SELECT ST_ASTEXT(ST_CONVEXHULL(0x010100000001000000010100000000000000000000));
389
390 --error ER_GIS_DATA_WRONG_ENDIANESS
391 SELECT ST_ASTEXT(ST_CONVEXHULL(0x010100000002000000000000000000000000000000));
392
393 --error ER_GIS_DATA_WRONG_ENDIANESS
394 SELECT ST_ASTEXT(ST_CONVEXHULL(0x000000000600000001000000000200000002000000));
395
396 --error ER_GIS_DATA_WRONG_ENDIANESS
397 SELECT ST_ASTEXT(ST_CONVEXHULL(0x000000000200000001000000050000000000000000));
398
399 --error ER_GIS_DATA_WRONG_ENDIANESS
400 SELECT ST_ASTEXT(ST_CONVEXHULL(0x010300000002000000010300000002000000050000));
401
402 --error ER_GIS_DATA_WRONG_ENDIANESS
403 SELECT ST_ASTEXT(ST_CONVEXHULL(0x010400000002000000010100000000000000000000));
404
405 --echo # Clean up
406 DROP TABLE gis_geometrycollection;
407
408 --echo #
409 --echo # WL#8579 Spatial Reference Systems
410 --echo #
411
412 --echo # SRID 0 (should pass)
413 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(0 0)', 0)));
414
415 --echo # Projected SRS (should pass)
416 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(0 0)', 2000)));
417
418 --echo # Geographic SRS (should fail)
419 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
420 SELECT ST_ASTEXT(ST_CONVEXHULL(ST_GEOMFROMTEXT('POINT(0 0)', 4326)));
421
422 --echo #
423 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
424 --echo #
425
426 --echo # Assume SRID 10 is not defined.
427 --error ER_SRS_NOT_FOUND
428 DO ST_CONVEXHULL(x'0A000000010100000000000000000000000000000000000000');