Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # CAST(... AS <GEOMETRY_TYPE>) allows casting between #
4 # certain geometry types. #
5 # #
6 # Creation Date: 2020-08-02 #
7 # Author: Magnus Rushfeldt #
8 # #
9 ###############################################################################
10
11 --echo #####################################
12 --echo # Testing of general requirements #
13 --echo #####################################
14 --echo #
15
16 --echo ####################################################################
17 --echo # Requirement F-1a: #
18 --echo # Casting using CONVERT(..., <geometry type>) must be allowed #
19 --echo # and give the same result as CAST(... AS <geometry type>). #
20 --echo ####################################################################
21 --echo #
22
23 --echo # Casting using CONVERT(..., POINT) must give the same result
24 --echo # as CAST(... AS POINT).
25 --echo # Must return 1.
26 SELECT ST_EQUALS(CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1))') AS POINT), CONVERT(ST_GEOMFROMTEXT('MULTIPOINT((1 1))'), POINT));
27 --echo #
28
29 --echo # Casting using CONVERT(..., LINESTRING) must give the same result
30 --echo # as CAST(... AS LINESTRING).
31 --echo # Must return 1.
32 SELECT ST_EQUALS(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2))') AS LINESTRING), CONVERT(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2))'), LINESTRING));
33 --echo #
34
35 --echo # Casting using CONVERT(..., POLYGON) must give the same result
36 --echo # as CAST(... AS POLYGON).
37 --echo # Must return 1.
38 SELECT ST_EQUALS(CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)))') AS POLYGON), CONVERT(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)))'), POLYGON));
39 --echo #
40
41 --echo # Casting using CONVERT(..., MULTIPOINT) must give the same result
42 --echo # as CAST(... AS MULTIPOINT).
43 --echo # Must return 1.
44 SELECT ST_EQUALS(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS MULTIPOINT), CONVERT(ST_GEOMFROMTEXT('POINT(1 1)'), MULTIPOINT));
45 --echo #
46
47 --echo # Casting using CONVERT(..., MULTILINESTRING) must give the same result
48 --echo # as CAST(... AS MULTILINESTRING).
49 --echo # Must return 1.
50 SELECT ST_EQUALS(CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS MULTILINESTRING), CONVERT(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'), MULTILINESTRING));
51 --echo #
52
53 --echo # Casting using CONVERT(..., MULTIPOLYGON) must give the same result
54 --echo # as CAST(... AS MULTIPOLYGON).
55 --echo # Must return 1.
56 SELECT ST_EQUALS(CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))') AS MULTIPOLYGON), CONVERT(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))'), MULTIPOLYGON));
57 --echo #
58
59 --echo # Casting using CONVERT(..., GEOMETRYCOLLECTION) must give the same result
60 --echo # as CAST(... AS GEOMETRYCOLLECTION).
61 --echo # Must return 1.
62 SELECT ST_EQUALS(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION), CONVERT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))'), GEOMETRYCOLLECTION));
63 --echo #
64
65 --echo ####################################################################
66 --echo # Requirement F-1b: #
67 --echo # Casting to geometry types using #
68 --echo # JSON_VALUE(... RETURNING <geometry type>) must not be allowed. #
69 --echo ####################################################################
70 --echo #
71
72 --echo # Casting to POINT using JSON_VALUE(... RETURNING POINT) must raise error.
73 --error ER_INVALID_CAST_TO_GEOMETRY
74 DO JSON_VALUE('{"geometry": {"type" : "Point", "coordinates": [1.0, 1.0]}}', '$.geometry' RETURNING POINT);
75 --echo #
76
77 --echo # Casting to LINESTRING using JSON_VALUE(... RETURNING LINESTRING) must raise error.
78 --error ER_INVALID_CAST_TO_GEOMETRY
79 DO JSON_VALUE('{"geometry": {"type": "LineString", "coordinates": [[1.0, 1.0], [2.0, 2.0]]}}', '$.geometry' RETURNING LINESTRING);
80 --echo #
81
82 --echo # Casting to POLYGON using JSON_VALUE(... RETURNING POLYGON) must raise error.
83 --error ER_INVALID_CAST_TO_GEOMETRY
84 DO JSON_VALUE('{"geometry": {"type": "Polygon", "coordinates": [[[1.0, 1.0], [4.0, 1.0], [4.0, 4.0], [1.0, 4.0], [1.0, 1.0]]]}}', '$.geometry' RETURNING POLYGON);
85 --echo #
86
87 --echo # Casting to MULTIPOINT using JSON_VALUE(... RETURNING MULTIPOINT) must raise error.
88 --error ER_INVALID_CAST_TO_GEOMETRY
89 DO JSON_VALUE('{"geometry": {"type": "MultiPoint", "coordinates": [[1.0, 1.0], [2.0, 2.0]]}}', '$.geometry' RETURNING MULTIPOINT);
90 --echo #
91
92 --echo # Casting to MULTILINESTRING using JSON_VALUE(... RETURNING MULTILINESTRING) must raise error.
93 --error ER_INVALID_CAST_TO_GEOMETRY
94 DO JSON_VALUE('{"geometry": {"type": "MultiLineString", "coordinates": [[[1.0, 1.0], [2.0, 2.0]], [[3.0, 3.0], [4.0, 4.0]]]}}', '$.geometry' RETURNING MULTILINESTRING);
95 --echo #
96
97 --echo # Casting to MULTIPOLYGON using JSON_VALUE(... RETURNING MULTIPOLYGON) must raise error.
98 --error ER_INVALID_CAST_TO_GEOMETRY
99 DO JSON_VALUE('{"geometry": {"type": "{"type": "MultiPolygon", "coordinates": [[[[1.0, 1.0], [4.0, 1.0], [4.0, 4.0], [1.0, 4.0], [1.0, 1.0]]], [[[2.0, 2.0], [2.0, 3.0], [3.0, 3.0], [3.0, 2.0], [2.0, 2.0]]]]}}', '$.geometry' RETURNING MULTIPOLYGON);
100 --echo #
101
102 --echo # Casting to GEOMETRYCOLLECTION using JSON_VALUE(... RETURNING GEOMETRYCOLLECTION) must raise error.
103 --error ER_INVALID_CAST_TO_GEOMETRY
104 DO JSON_VALUE('{"geometry": {"type": "GeometryCollection", "geometries": [{"type": "Point", "coordinates": [1.0, 1.0]}, {"type": "LineString", "coordinates": [[2.0, 2.0], [3.0, 3.0]]}]}}', '$.geometry' RETURNING GEOMETRYCOLLECTION);
105 --echo #
106
107 --echo ####################################################################
108 --echo # Requirement F-1c: #
109 --echo # Casting to ARRAY of geometry types must not be allowed. #
110 --echo ####################################################################
111 --echo #
112
113 --echo # Casting using CAST(... AS POINT ARRAY) must raise error.
114 --error ER_NOT_SUPPORTED_YET
115 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT ARRAY);
116 --echo #
117
118 --echo # Casting using CAST(... AS LINESTRING ARRAY) must raise error.
119 --error ER_NOT_SUPPORTED_YET
120 DO CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS LINESTRING ARRAY);
121 --echo #
122
123 --echo # Casting using CAST(... POLYGON ARRAY) must raise error.
124 --error ER_NOT_SUPPORTED_YET
125 DO CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))') AS POLYGON ARRAY);
126 --echo #
127
128 --echo # Casting using CAST(... MULTIPOINT ARRAY) must raise error.
129 --error ER_NOT_SUPPORTED_YET
130 DO CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS MULTIPOINT ARRAY);
131 --echo #
132
133 --echo # Casting using CAST(... MULTILINESTRING ARRAY) must raise error.
134 --error ER_NOT_SUPPORTED_YET
135 DO CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS MULTILINESTRING ARRAY);
136 --echo #
137
138 --echo # Casting using CAST(... MULTIPOLYGON ARRAY) must raise error.
139 --error ER_NOT_SUPPORTED_YET
140 DO CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 2 3, 3 3, 3 2, 2 2)))') AS MULTIPOLYGON ARRAY);
141 --echo #
142
143 --echo # Casting using CAST(... GEOMETRYCOLLECTION ARRAY) must raise error.
144 --error ER_NOT_SUPPORTED_YET
145 DO CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION ARRAY);
146 --echo #
147
148 --echo ####################################################################
149 --echo # Requirement F-1d: #
150 --echo # Non-instantiable target types must not be allowed. #
151 --echo ####################################################################
152 --echo #
153
154 --echo # Casting to GEOMETRY must raise error.
155 --error ER_PARSE_ERROR
156 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS GEOMETRY));
157 --echo #
158
159 --echo # Casting to CURVE must raise error.
160 --error ER_PARSE_ERROR
161 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS CURVE));
162 --echo #
163
164 --echo # Casting to SURFACE must raise error.
165 --error ER_PARSE_ERROR
166 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS SURFACE));
167 --echo #
168
169 --echo # Casting to MULTICURVE must raise error.
170 --error ER_PARSE_ERROR
171 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS MULTICURVE));
172 --echo #
173
174 --echo # Casting to MULTISURFACE must raise error.
175 --error ER_PARSE_ERROR
176 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS MULTISURFACE));
177 --echo #
178
179 --echo ####################################################################
180 --echo # Requirement F-1e: #
181 --echo # Casting to non-geometry types must give same result as before. #
182 --echo ####################################################################
183 --echo #
184
185 --echo # Casting geometry to SIGNED must raise error.
186 --error ER_WRONG_ARGUMENTS
187 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS SIGNED);
188 --echo #
189
190 --echo # Casting geometry to UNSIGNED must raise error.
191 --error ER_WRONG_ARGUMENTS
192 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS UNSIGNED);
193 --echo #
194
195 --echo # Casting geometry to YEAR must raise error.
196 --error ER_WRONG_ARGUMENTS
197 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS YEAR);
198 --echo #
199
200 --disable_warnings
201
202 --echo # Casting geometry to DATE must return NULL.
203 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS DATE);
204 --echo #
205
206 --echo # Casting geometry to TIME must return NULL.
207 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS TIME);
208 --echo #
209
210 --echo # Casting geometry to DATETIME must return NULL.
211 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS DATETIME);
212 --echo #
213
214 --echo # Casting geometry to BINARY must return SWKB.
215 SELECT HEX(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS BINARY));
216 --echo #
217
218 --echo # Casting geometry to DECIMAL must return 0.
219 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS DECIMAL);
220 --echo #
221
222 --echo # Casting geometry to FLOAT must return 0.
223 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS FLOAT);
224 --echo #
225
226 --echo # Casting geometry to DOUBLE must return 0.
227 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS DOUBLE);
228 --echo #
229
230 --enable_warnings
231
232 --echo # Casting geometry to JSON must return JSON-string.
233 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS JSON);
234 --echo #
235
236 --echo ####################################################################
237 --echo # Requirement F-2: #
238 --echo # Casting NULL to geometry types must return NULL. #
239 --echo ####################################################################
240 --echo #
241
242 SELECT CAST(NULL AS POINT);
243 --echo #
244
245 --echo ####################################################################
246 --echo # Requirement F-3: #
247 --echo # Casting geometries that are not syntactically well-formed #
248 --echo # must not be allowed. #
249 --echo ####################################################################
250 --echo #
251
252 --echo # Casting 'POINT(1)' to POINT must raise error.
253 --error ER_GIS_INVALID_DATA
254 DO CAST(0x000000000101000000000000000000F03F AS POINT);
255 --echo #
256
257 --echo ####################################################################
258 --echo # Requirement F-4: #
259 --echo # Casting geometry with undefined SRS must raise error. #
260 --echo ####################################################################
261 --echo #
262
263 --error ER_SRS_NOT_FOUND
264 DO CAST(ST_GEOMFROMTEXT('POINT(1 1)', 256) AS POINT);
265 --echo #
266
267 --echo ####################################################################
268 --echo # Requirement F-5: #
269 --echo # Casting must not change coordinate values or order. #
270 --echo ####################################################################
271 --echo #
272
273 --echo # Must return 1.
274 SELECT ST_EQUALS(ST_GEOMFROMTEXT('POINT(0 1)'), CAST(ST_GEOMFROMTEXT('POINT(0 1)') AS POINT));
275 --echo #
276
277 --echo # Must return 1.
278 SELECT ST_EQUALS(ST_GEOMFROMTEXT('LINESTRING(1 2, 3 4)'), CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 2), (3 4))') AS LINESTRING));
279 --echo #
280
281 --echo # Must return 1.
282 SELECT ST_EQUALS(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))'), CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 4 1, 4 4, 1 4, 1 1)') AS POLYGON));
283 --echo #
284
285 --echo # Must return 1.
286 SELECT ST_EQUALS(ST_GEOMFROMTEXT('MULTIPOINT((1 2), (3 4))'), CAST(ST_GEOMFROMTEXT('LINESTRING(1 2, 3 4)') AS MULTIPOINT));
287 --echo #
288
289 --echo # Must return 1.
290 SELECT ST_EQUALS(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 2 3, 3 3, 3 2, 2 2))'), CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 2 3, 3 3, 3 2, 2 2))') AS MULTILINESTRING));
291 --echo #
292
293 --echo # Must return 1.
294 SELECT ST_EQUALS(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 3 2, 3 3, 2 3, 2 2)))'), CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 4 1, 4 4, 1 4, 1 1), (2 2, 3 2, 3 3, 2 3, 2 2))') AS MULTIPOLYGON));
295 --echo #
296
297 --echo # Must return 1.
298 SELECT ST_EQUALS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 2), POINT(3 4))'), CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 2), (3 4))') AS GEOMETRYCOLLECTION));
299 --echo #
300
301 --echo ####################################################################
302 --echo # Requirement F-6a: #
303 --echo # Casting must not change the SRS of the geometry. #
304 --echo ####################################################################
305 --echo #
306
307 --echo # Must return 0.
308 SELECT ST_SRID(CAST(ST_GEOMFROMTEXT('POINT(1 1)', 0) AS POINT));
309 --echo #
310
311 --echo # Must return 4326.
312 SELECT ST_SRID(CAST(ST_GEOMFROMTEXT('POINT(45 90)', 4326) AS POINT));
313 --echo #
314
315 --echo ####################################################################
316 --echo # Requirement F-6b: #
317 --echo # Casting geographic geometry with longitude outside of #
318 --echo # (-180, 180] must not be allowed. #
319 --echo ####################################################################
320 --echo #
321
322 --echo # Casting POINT(0 180.000000001) with SRID=4326 to POINT must raise error.
323 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
324 DO CAST(0xE6100000010100000070890000008066400000000000000000 AS POINT);
325 --echo #
326
327 --echo # Casting POINT(0 -180.000000001) with SRID=4326 to POINT must raise error.
328 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
329 DO CAST(0xE6100000010100000070890000008066C00000000000000000 AS POINT);
330 --echo #
331
332 --echo ####################################################################
333 --echo # Requirement F-6c: #
334 --echo # Casting geographic geometry with latitude outside of #
335 --echo # [-90, 90] must not be allowed. #
336 --echo ####################################################################
337 --echo #
338
339 --echo # Casting POINT(90.000000001 0) with SRID=4326 to POINT must raise error.
340 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
341 DO CAST(0xE610000001010000000000000000000000E112010000805640 AS POINT);
342 --echo #
343
344 --echo # Casting POINT(-90.000000001 0) with SRID=4326 to POINT must raise error.
345 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
346 DO CAST(0xE610000001010000000000000000000000E1120100008056C0 AS POINT);
347 --echo #
348
349 --echo ####################################################################
350 --echo # Queries with EXPLAIN should return appropiate function name #
351 --echo ####################################################################
352 --echo #
353
354 --echo # Should return /* select#1 */ select cast(st_geomfromtext('point(1 1)') as point) AS `CAST(ST_GEOMFROMTEXT('POINT((1 1))') AS POINT)'
355 EXPLAIN SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT);
356 --echo #
357
358 --echo # Should return /* select#1 */ select cast(st_geomfromtext('LINESTRING(1 1, 2 2)') as linestring) AS `CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS LINESTRING)`
359 EXPLAIN SELECT CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS LINESTRING);
360 --echo #
361
362 --echo # Should return /* select#1 */ select cast(st_geomfromtext('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))') as polygon) AS `CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))') AS POLYGON)`
363 EXPLAIN SELECT CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))') AS POLYGON);
364 --echo #
365
366 --echo # Should return /* select#1 */ select cast(st_geomfromtext('MULTIPOINT((1 1), (2 2))') as multipoint) AS `CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS MULTIPOINT)`
367 EXPLAIN SELECT CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS MULTIPOINT);
368 --echo #
369
370 --echo # Should return /* select#1 */ select cast(st_geomfromtext('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') as multilinestring) AS `CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS MULTILINESTRING)`
371 EXPLAIN SELECT CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS MULTILINESTRING);
372 --echo #
373
374 --echo # Should return /* select#1 */ select cast(st_geomfromtext('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 2 3, 3 3, 3 2, 2 2)))') as multipolygon) AS `CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 2 3, 3 3, 3 2, 2 2)))') AS MULTIPOLYGON)`
375 EXPLAIN SELECT CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 2 3, 3 3, 3 2, 2 2)))') AS MULTIPOLYGON);
376 --echo #
377
378 --echo # Should return /* select#1 */ select cast(st_geomfromtext('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') as geometrycollection) AS `CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION)`
379 EXPLAIN SELECT CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION);
380
381 --echo ####################################################################
382 --echo # SELECT ... UNION SELECT ... with #
383 --echo # CAST(... AS <GEOMETRY_TYPE>) columns should work as expected #
384 --echo ####################################################################
385 --echo #
386
387 --echo # Should return Point.
388 WITH g(g1) AS (
389 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT)
390 UNION
391 SELECT CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS POINT))
392 SELECT ST_ASTEXT(g1) FROM g;
393 --echo #
394
395 --echo # Should return Linestring.
396 WITH g(g1) AS (
397 SELECT CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS LINESTRING)
398 UNION
399 SELECT CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS LINESTRING))
400 SELECT ST_ASTEXT(g1) FROM g;
401 --echo #
402
403 --echo # Should return Polygon.
404 WITH g(g1) AS (
405 SELECT CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))') AS POLYGON)
406 UNION
407 SELECT CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 4 1, 4 4, 1 4, 1 1))') AS POLYGON))
408 SELECT ST_ASTEXT(g1) FROM g;
409 --echo #
410
411 --echo # Should return Multipoint.
412 WITH g(g1) AS (
413 SELECT CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS MULTIPOINT)
414 UNION
415 SELECT CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS MULTIPOINT))
416 SELECT ST_ASTEXT(g1) FROM g;
417 --echo #
418
419 --echo # Should return Multilinestring.
420 WITH g(g1) AS (
421 SELECT CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS MULTILINESTRING) UNION SELECT CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS MULTILINESTRING)
422 UNION
423 SELECT CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS MULTILINESTRING) UNION SELECT CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS MULTILINESTRING))
424 SELECT ST_ASTEXT(g1) FROM g;
425 --echo #
426
427 --echo # Should return Multipolygon.
428 WITH g(g1) AS (
429 SELECT CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 2 3, 3 3, 3 2, 2 2)))') AS MULTIPOLYGON) UNION SELECT CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 2 3, 3 3, 3 2, 2 2)))') AS MULTIPOLYGON)
430 UNION
431 SELECT CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 2 3, 3 3, 3 2, 2 2)))') AS MULTIPOLYGON) UNION SELECT CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 4 1, 4 4, 1 4, 1 1)), ((2 2, 2 3, 3 3, 3 2, 2 2)))') AS MULTIPOLYGON))
432 SELECT ST_ASTEXT(g1) FROM g;
433 --echo #
434
435 --echo # Should return Geometrycollection.
436 WITH g(g1) AS (
437 SELECT CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION) UNION SELECT CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION)
438 UNION
439 SELECT CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION) UNION SELECT CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(2 2, 3 3))') AS GEOMETRYCOLLECTION))
440 SELECT ST_ASTEXT(g1) FROM g;