Debian Codegraph @

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

raw
1 ###################################################################################
2 # #
3 # This test is aimed to focus on Spatial Analysis Functions. #
4 # #
5 # ST_Envelope function returns the minimum bounding rectangle (MBR) #
6 # for the geometry value geom. The result is returned as a Polygon value. #
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_ENVELOPE(point)
77 --echo #####################################################################################
78
79 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_center)));
80
81 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top)));
82
83 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(-0 0)')));
84
85 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(2.34 -2.34)')));
86
87 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(1e308 -1e308)')));
88
89 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(-0.0000 0.000001)')));
90
91 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=105;
92
93 --echo #####################################################################################
94 --echo # ST_ENVELOPE(multipoint)
95 --echo #####################################################################################
96
97 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_all_points)));
98
99 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_bottom_points)));
100
101 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)')));
102
103 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0,0 0)')));
104
105 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1e308 -1e308,0.0001 0.000)')));
106
107 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=108;
108
109 --echo #####################################################################################
110 --echo # ST_ENVELOPE(linestring)
111 --echo #####################################################################################
112
113 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top_to_center)));
114
115 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_line_horizontal)));
116
117 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(0 0,-0.00 0,0.0 0)')));
118
119 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')));
120
121 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(1 -1,1e308 -1e308,0.0001 0.000)')));
122
123 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=110;
124
125 --echo #####################################################################################
126 --echo # ST_ENVELOPE(multilinestring)
127 --echo #####################################################################################
128
129 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_vertical)));
130
131 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_horizontal)));
132
133 --error ER_GIS_INVALID_DATA
134 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0.00 0),(0.0 0))')));
135
136 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))')));
137
138 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))')));
139
140 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1e308 -1e308,0.0001 0.000),(2 2,4 -9.002))')));
141
142 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=114;
143
144 --echo #####################################################################################
145 --echo # ST_ENVELOPE(polygon)
146 --echo #####################################################################################
147
148 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star)));
149
150 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_elem_vertical)));
151
152 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5, 0 0))')));
153
154 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))')));
155
156 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((10 10,10 0,0 20,0 10,10 10))')));
157
158 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,-10 0,-10 -10,0 -10,0 0))')));
159
160 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')));
161
162 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0))')));
163
164 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0))')));
165
166 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8))')));
167
168 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=100;
169
170 --echo #####################################################################################
171 --echo # ST_ENVELOPE(multipolygon)
172 --echo #####################################################################################
173
174 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_of_elems)));
175
176 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5, 0 0)))')));
177
178 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))')));
179
180 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))')));
181
182 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4,4 4)))')));
183
184 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))')));
185
186 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)))')));
187
188 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0)))')));
189
190 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8)))')));
191
192 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 0,5 10,10 10)),((0 10,0 20,5 10,0 10)))')));
193
194 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0)))')));
195
196 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),'
197 '((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,4 4)))')));
198
199 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=103;
200
201 --echo #####################################################################################
202 --echo # ST_ENVELOPE(geometrycollection)
203 --echo #####################################################################################
204
205 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_collection_elems)));
206
207 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_collection_multilinestr)));
208
209 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')));
210
211 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())')));
212
213 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))')));
214
215 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10))')));
216
217 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10)))')));
218
219 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
220 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10)))')));
221
222 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10))')));
223
224 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10),GEOMETRYCOLLECTION())')));
225
226 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),'
227 'MULTIPOINT(0 0,10 10),'
228 'LINESTRING(1 1,2 2,3 3),'
229 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10)))')));
230
231 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))')));
232
233 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))))')));
234
235 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
236 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),((10 10,10 15,15 15,15 10,10 10))))')));
237
238 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
239 'MULTIPOINT(0 0,10 10)),'
240 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
241 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10))))')));
242
243 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
244 'MULTIPOINT(0 0,10 10)),'
245 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
246 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10))),'
247 'GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
248 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),'
249 '((10 10,10 15,15 15,15 10,10 10)))))')));
250
251 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
252 'MULTIPOINT(0 0,10 10)),'
253 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
254 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10))),'
255 'GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))')));
256
257 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=115;
258
259 --echo #####################################################################################
260 --echo # ST_ENVELOPE(geometry) with different SRID values
261 --echo #####################################################################################
262
263 --error ER_DATA_OUT_OF_RANGE
264 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_center,-1024)));
265
266 --error ER_DATA_OUT_OF_RANGE
267 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_all_points,-1)));
268
269 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top_to_center,0)));
270
271 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_vertical,2000)));
272
273 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
274 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star,4326)));
275
276 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
277 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_elem_vertical,4145)));
278
279 --error ER_DATA_OUT_OF_RANGE
280 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_of_elems,4294967296)));
281
282 --error ER_DATA_OUT_OF_RANGE
283 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_collection_elems,4294967295000)));
284
285 --echo #####################################################################################
286 --echo # Invalid function calls
287 --echo #####################################################################################
288
289 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
290 SELECT ST_ASTEXT(ST_ENVELOPE());
291
292 SELECT ST_ASTEXT(ST_ENVELOPE(NULL));
293
294 --error ER_GIS_INVALID_DATA
295 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT()')));
296
297 --error ER_GIS_INVALID_DATA
298 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING()')));
299
300 --error ER_GIS_INVALID_DATA
301 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON(())')));
302
303 --error ER_GIS_INVALID_DATA
304 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT()')));
305
306 --error ER_GIS_INVALID_DATA
307 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING(())')));
308
309 --error ER_GIS_INVALID_DATA
310 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON((()))')));
311
312 --error ER_GIS_INVALID_DATA
313 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(a 0)')));
314
315 --error ER_GIS_INVALID_DATA
316 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(! 0)')));
317
318 --error ER_PARSE_ERROR
319 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT('!' 0)')));
320
321 --error ER_GIS_INVALID_DATA
322 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(12,34 0)')));
323
324 --error ER_GIS_INVALID_DATA
325 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)')));
326
327 --error ER_GIS_INVALID_DATA
328 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)')));
329
330 --error ER_PARSE_ERROR
331 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)')));
332
333 --error ER_GIS_INVALID_DATA
334 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)')));
335
336 --error ER_GIS_INVALID_DATA
337 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))')));
338
339 --error ER_GIS_INVALID_DATA
340 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))')));
341
342 --error ER_PARSE_ERROR
343 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))')));
344
345 --error ER_GIS_INVALID_DATA
346 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))')));
347
348 --error ER_GIS_INVALID_DATA
349 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0))')));
350
351 --error ER_GIS_INVALID_DATA
352 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,5 5))')));
353
354 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,10 10, 0 0))')));
355
356 --error ER_GIS_INVALID_DATA
357 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,10 10,0 0),(0 0))')));
358
359 --error ER_GIS_INVALID_DATA
360 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5)),((10 10)))')));
361
362 --error ER_GIS_INVALID_DATA
363 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5)),((1 1,1 1,1 1,1 1)))')));
364
365 --error ER_GIS_INVALID_DATA
366 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 10)),((10 10))')));
367
368 --error ER_GIS_DATA_WRONG_ENDIANESS
369 SELECT ST_ASTEXT(ST_ENVELOPE(0x000000000200000000000000000000000000000000));
370
371 --error ER_GIS_DATA_WRONG_ENDIANESS
372 SELECT ST_ASTEXT(ST_ENVELOPE(0x010100000001000000010100000000000000000000));
373
374 --error ER_GIS_DATA_WRONG_ENDIANESS
375 SELECT ST_ASTEXT(ST_ENVELOPE(0x010100000002000000000000000000000000000000));
376
377 --error ER_GIS_DATA_WRONG_ENDIANESS
378 SELECT ST_ASTEXT(ST_ENVELOPE(0x000000000600000001000000000200000002000000));
379
380 --error ER_GIS_DATA_WRONG_ENDIANESS
381 SELECT ST_ASTEXT(ST_ENVELOPE(0x000000000200000001000000050000000000000000));
382
383 --error ER_GIS_DATA_WRONG_ENDIANESS
384 SELECT ST_ASTEXT(ST_ENVELOPE(0x010300000002000000010300000002000000050000));
385
386 --error ER_GIS_DATA_WRONG_ENDIANESS
387 SELECT ST_ASTEXT(ST_ENVELOPE(0x010400000002000000010100000000000000000000));
388
389 --echo # Clean up
390 DROP TABLE gis_geometrycollection;
391
392 --echo #
393 --echo # WL#8579 Spatial Reference Systems
394 --echo #
395
396 --echo # SRID 0 (should pass)
397 DO ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(0 0)', 0));
398
399 --echo # Projected SRS (should pass)
400 DO ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(0 0)', 2000));
401
402 --echo # Geographic SRS (should fail)
403 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
404 DO ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
405
406 --echo #
407 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
408 --echo #
409
410 --echo # Assume SRID 10 is not defined.
411 --error ER_SRS_NOT_FOUND
412 DO ST_ENVELOPE(x'0A000000010100000000000000000000000000000000000000');