Debian Codegraph @

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

raw
1 # This test tests the GIS functions that take as arguments a Well-Known Text (WKT)
2 # representation and, optionally, a spatial reference system identifier (SRID).
3 # They return the corresponding geometry.
4 #
5 # Creation Date : 2016-03-16
6 # Author : Pavan Naik
7 #
8
9 SET @wkt_pt = 'POINT(0 0)';
10 SET @wkt_ln = 'LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10)';
11 SET @wkt_py = 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))';
12 SET @wkt_mpt = 'MULTIPOINT(0 0,2 2,4 4,6 6)';
13 SET @wkt_mln = 'MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))';
14 SET @wkt_mpy = 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
15 '((10 10,10 12,12 12,12 10,10 10)))';
16 SET @wkt_gc = 'GEOMETRYCOLLECTION('
17 'POINT(0 0),'
18 'LINESTRING(0 0,10 10),'
19 'POLYGON((0 0,0 10,10 10,10 0, 0 0)),'
20 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
21 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
22 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))';
23
24 --echo #
25 --echo # Functions that accept a WKT value of any geometry type.
26 --echo #
27
28 --echo # ST_GeomFromText()
29 SELECT ST_AsText(ST_GeomFromText(@wkt_pt));
30 SELECT ST_AsText(ST_GeomFromText(@wkt_ln));
31 SELECT ST_AsText(ST_GeomFromText(@wkt_py));
32 SELECT ST_AsText(ST_GeomFromText(@wkt_mpt));
33 SELECT ST_AsText(ST_GeomFromText(@wkt_mln));
34 SELECT ST_AsText(ST_GeomFromText(@wkt_mpy));
35 SELECT ST_AsText(ST_GeomFromText(@wkt_gc));
36
37 --echo # ST_GeometryFromText()
38 SELECT ST_AsText(ST_GeometryFromText(@wkt_pt));
39 SELECT ST_AsText(ST_GeometryFromText(@wkt_ln));
40 SELECT ST_AsText(ST_GeometryFromText(@wkt_py));
41 SELECT ST_AsText(ST_GeometryFromText(@wkt_mpt));
42 SELECT ST_AsText(ST_GeometryFromText(@wkt_mln));
43 SELECT ST_AsText(ST_GeometryFromText(@wkt_mpy));
44 SELECT ST_AsText(ST_GeometryFromText(@wkt_gc));
45
46 --echo #
47 --echo # Function that accepts a WKT value of Point geometry
48 --echo #
49
50 --echo # ST_PointFromText()
51 SELECT ST_AsText(ST_PointFromText(@wkt_pt));
52
53 --echo #
54 --echo # Functions that accept a WKT value of LineString geometry
55 --echo #
56
57 --echo # ST_LineFromText()
58 SELECT ST_AsText(ST_LineFromText(@wkt_ln));
59
60 --echo # ST_LineStringFromText()
61 SELECT ST_AsText(ST_LineStringFromText(@wkt_ln));
62
63 --echo #
64 --echo # Functions that accept a WKT value of Polygon geometry
65 --echo #
66
67 --echo # ST_PolyFromText()
68 SELECT ST_AsText(ST_PolyFromText(@wkt_py));
69
70 --echo # ST_PolygonFromText()
71 SELECT ST_AsText(ST_PolygonFromText(@wkt_py));
72
73 --echo #
74 --echo # Functions that accept a WKT value of MultiPoint geometry
75 --echo #
76
77 --echo # ST_MPointFromText()
78 SELECT ST_AsText(ST_MPointFromText(@wkt_mpt));
79
80 --echo # ST_MultiPointFromText()
81 SELECT ST_AsText(ST_MultiPointFromText(@wkt_mpt));
82
83 --echo #
84 --echo # Functions that accept a WKT value of MultiLineString geometry
85 --echo #
86
87 --echo # ST_MLineFromText()
88 SELECT ST_AsText(ST_MLineFromText(@wkt_mln));
89
90 --echo # ST_MultiLineStringFromText()
91 SELECT ST_AsText(ST_MultiLineStringFromText(@wkt_mln));
92
93 --echo #
94 --echo # Functions that accept a WKT value of MultiPolygon geometry
95 --echo #
96
97 --echo # ST_MPolyFromText()
98 SELECT ST_AsText(ST_MPolyFromText(@wkt_mpy));
99
100 --echo # ST_MultiPolygonFromText()
101 SELECT ST_AsText(ST_MultiPolygonFromText(@wkt_mpy));
102
103 --echo #
104 --echo # Functions that accept a WKT value of GeometryCollection geometry
105 --echo #
106
107 --echo # ST_GeomCollFromTxt()
108 SELECT ST_AsText(ST_GeomCollFromTxt(@wkt_gc));
109
110 --echo # ST_GeomCollFromText()
111 SELECT ST_AsText(ST_GeomCollFromText(@wkt_gc));
112
113 --echo # ST_GeometryCollectionFromText()
114 SELECT ST_AsText(ST_GeometryCollectionFromText(@wkt_gc));
115
116 --echo #
117 --echo # Invalid function calls
118 --echo #
119
120 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
121 SELECT ST_GeomFromText();
122
123 SELECT ST_GeomFromText(NULL);
124
125 --error ER_GIS_INVALID_DATA
126 SELECT ST_GeomFromText('POINT()');
127
128 --error ER_GIS_INVALID_DATA
129 SELECT ST_GeomFromText('LINESTRING(0 0,! 10)');
130
131 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
132 SELECT ST_GeometryFromText();
133
134 SELECT ST_GeometryFromText(NULL);
135
136 --error ER_GIS_INVALID_DATA
137 SELECT ST_GeometryFromText('POINT(! 0)');
138
139 --error ER_GIS_INVALID_DATA
140 SELECT ST_GeometryFromText('POLYGON((0 0,0 10,10 10,10 0,0 0)');
141
142 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
143 SELECT ST_PointFromText();
144
145 SELECT ST_PointFromText(NULL);
146
147 --error ER_GIS_INVALID_DATA
148 SELECT ST_PointFromText('POINT()');
149
150 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
151 SELECT ST_LineFromText();
152
153 SELECT ST_LineFromText(NULL);
154
155 --error ER_GIS_INVALID_DATA
156 SELECT ST_LineFromText('LINESTRING(a a,b b)');
157
158 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
159 SELECT ST_LineStringFromText();
160
161 SELECT ST_LineStringFromText(NULL);
162
163 --error ER_GIS_INVALID_DATA
164 SELECT ST_LineStringFromText('LINESTRING(1 1,1 b)');
165
166 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
167 SELECT ST_PolyFromText();
168
169 SELECT ST_PolyFromText(NULL);
170
171 --error ER_GIS_INVALID_DATA
172 SELECT ST_PolyFromText('POLYGON(())');
173
174 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
175 SELECT ST_PolygonFromText();
176
177 SELECT ST_PolygonFromText(NULL);
178
179 --error ER_GIS_INVALID_DATA
180 SELECT ST_PolygonFromText('POLYGON((0 0,0 5,5 5,5 0,0 0),())');
181
182 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
183 SELECT ST_MPointFromText();
184
185 SELECT ST_MPointFromText(NULL);
186
187 --error ER_GIS_INVALID_DATA
188 SELECT ST_MPointFromText('MULTIPOINT(0 0,1)');
189
190 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
191 SELECT ST_MultiPointFromText();
192
193 SELECT ST_MultiPointFromText(NULL);
194
195 --error ER_GIS_INVALID_DATA
196 SELECT ST_MultiPointFromText('MULTIPOINT(0 0,1 1 1)');
197
198 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
199 SELECT ST_MLineFromText();
200
201 SELECT ST_MLineFromText(NULL);
202
203 --error ER_GIS_INVALID_DATA
204 SELECT ST_MLineFromText('MULTILINESTRING((0 0,1),())');
205
206 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
207 SELECT ST_MultiLineStringFromText();
208
209 SELECT ST_MultiLineStringFromText(NULL);
210
211 --error ER_GIS_INVALID_DATA
212 SELECT ST_MultiLineStringFromText('MULTILINESTRING((0 0,1),(1 1,2 2)');
213
214 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
215 SELECT ST_MPolyFromText();
216
217 SELECT ST_MPolyFromText(NULL);
218
219 --error ER_GIS_INVALID_DATA
220 SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0,1)),(()))');
221
222 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
223 SELECT ST_MultiPolygonFromText();
224
225 SELECT ST_MultiPolygonFromText(NULL);
226
227 --error ER_GIS_INVALID_DATA
228 SELECT ST_MultiPolygonFromText('MULTIPOLYGON(((0 0,0 1,1 1,1 0,0 0)),(2 2,2 3,3 3,3 2,2 2))');
229
230 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
231 SELECT ST_GeomCollFromTxt();
232
233 SELECT ST_GeomCollFromTxt(NULL);
234
235 --error ER_GIS_INVALID_DATA
236 SELECT ST_GeomCollFromTxt('GEOMETRYCOLLECTION(POINT())');
237
238 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
239 SELECT ST_GeomCollFromText();
240
241 SELECT ST_GeomCollFromText(NULL);
242
243 --error ER_GIS_INVALID_DATA
244 SELECT ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(a a))');
245
246 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
247 SELECT ST_GeometryCollectionFromText();
248
249 SELECT ST_GeometryCollectionFromText(NULL);
250
251 --error ER_GIS_INVALID_DATA
252 SELECT ST_GeometryCollectionFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,1 1)');
253
254 --echo #
255 --echo # WL#8579 Spatial Reference Systems
256 --echo #
257
258 DELIMITER |;
259 CREATE PROCEDURE gis_wkt_funcs(IN srid INT)
260 BEGIN
261 SET @wkt_pt = 'POINT(0 0)';
262 SET @wkt_ln = 'LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10)';
263 SET @wkt_py = 'POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))';
264 SET @wkt_mpt = 'MULTIPOINT(0 0,2 2,4 4,6 6)';
265 SET @wkt_mln = 'MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))';
266 SET @wkt_mpy = 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
267 '((10 10,10 12,12 12,12 10,10 10)))';
268 SET @wkt_gc = 'GEOMETRYCOLLECTION('
269 'POINT(0 0),'
270 'LINESTRING(0 0,10 10),'
271 'POLYGON((0 0,0 10,10 10,10 0, 0 0)),'
272 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
273 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
274 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))';
275
276 # GIS WKT functions
277 DO ST_GeomFromText(@wkt_pt, srid);
278 DO ST_GeometryFromText(@wkt_pt, srid);
279
280 DO ST_PointFromText(@wkt_pt, srid);
281
282 DO ST_LineFromText(@wkt_ln, srid);
283 DO ST_LineStringFromText(@wkt_ln, srid);
284
285 DO ST_PolyFromText(@wkt_py, srid);
286 DO ST_PolygonFromText(@wkt_py, srid);
287
288 DO ST_MPointFromText(@wkt_mpt, srid);
289 DO ST_MultiPointFromText(@wkt_mpt, srid);
290
291 DO ST_MLineFromText(@wkt_mln, srid);
292 DO ST_MultiLineStringFromText(@wkt_mln, srid);
293
294 DO ST_MPolyFromText(@wkt_mpy, srid);
295 DO ST_MultiPolygonFromText(@wkt_mpy, srid);
296
297 DO ST_GeomCollFromTxt(@wkt_gc, srid);
298 DO ST_GeomCollFromText(@wkt_gc, srid);
299 DO ST_GeometryCollectionFromText(@wkt_gc, srid);
300 END |
301 DELIMITER ;|
302
303 --echo # SRID 0 (should pass)
304 CALL gis_wkt_funcs(0);
305
306 --echo # Projected SRS (should pass)
307 CALL gis_wkt_funcs(2000);
308
309 --echo # Geographic SRS (should pass)
310 CALL gis_wkt_funcs(4326);
311
312 --echo # Undefined SRS (should fail)
313 # Assume SRID 19000000 is undefined
314 --error ER_SRS_NOT_FOUND
315 CALL gis_wkt_funcs(19000000);
316
317 --echo # Clean up
318 DROP PROCEDURE gis_wkt_funcs;
319
320 --echo #
321 --echo # Bug #23632147 MYSQL USES INVALID WKT FOR EMPTY GEOMETRYCOLLECTION
322 --echo #
323
324 --error ER_GIS_INVALID_DATA
325 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POINT EMPTY'));
326 --error ER_GIS_INVALID_DATA
327 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POINT()'));
328 --error ER_GIS_INVALID_DATA
329 SELECT ST_ASTEXT(ST_GEOMFROMTEXT(' POINT EMPTY '));
330 --error ER_GIS_INVALID_DATA
331 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POINT EMPTY()'));
332 --error ER_GIS_INVALID_DATA
333 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POINT EMPT'));
334 --error ER_GIS_INVALID_DATA
335 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POINT EMPTYNESS'));
336
337 --error ER_GIS_INVALID_DATA
338 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('LINESTRING EMPTY'));
339 --error ER_GIS_INVALID_DATA
340 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('LINESTRING()'));
341 --error ER_GIS_INVALID_DATA
342 SELECT ST_ASTEXT(ST_GEOMFROMTEXT(' LINESTRING EMPTY '));
343 --error ER_GIS_INVALID_DATA
344 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('LINESTRING EMPTY()'));
345 --error ER_GIS_INVALID_DATA
346 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('LINESTRING EMPT'));
347 --error ER_GIS_INVALID_DATA
348 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('LINESTRING EMPTYNESS'));
349
350 --error ER_GIS_INVALID_DATA
351 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POLYGON EMPTY'));
352 --error ER_GIS_INVALID_DATA
353 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POLYGON()'));
354 --error ER_GIS_INVALID_DATA
355 SELECT ST_ASTEXT(ST_GEOMFROMTEXT(' POLYGON EMPTY '));
356 --error ER_GIS_INVALID_DATA
357 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POLYGON EMPTY()'));
358 --error ER_GIS_INVALID_DATA
359 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POLYGON EMPT'));
360 --error ER_GIS_INVALID_DATA
361 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('POLYGON EMPTYNESS'));
362
363 --error ER_GIS_INVALID_DATA
364 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOINT EMPTY'));
365 --error ER_GIS_INVALID_DATA
366 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOINT()'));
367 --error ER_GIS_INVALID_DATA
368 SELECT ST_ASTEXT(ST_GEOMFROMTEXT(' MULTIPOINT EMPTY '));
369 --error ER_GIS_INVALID_DATA
370 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOINT EMPTY()'));
371 --error ER_GIS_INVALID_DATA
372 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOINT EMPT'));
373 --error ER_GIS_INVALID_DATA
374 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOINT EMPTYNESS'));
375
376 --error ER_GIS_INVALID_DATA
377 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTILINESTRING EMPTY'));
378 --error ER_GIS_INVALID_DATA
379 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTILINESTRING()'));
380 --error ER_GIS_INVALID_DATA
381 SELECT ST_ASTEXT(ST_GEOMFROMTEXT(' MULTILINESTRING EMPTY '));
382 --error ER_GIS_INVALID_DATA
383 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTILINESTRING EMPTY()'));
384 --error ER_GIS_INVALID_DATA
385 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTILINESTRING EMPT'));
386 --error ER_GIS_INVALID_DATA
387 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTILINESTRING EMPTYNESS'));
388
389 --error ER_GIS_INVALID_DATA
390 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOLYGON EMPTY'));
391 --error ER_GIS_INVALID_DATA
392 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOLYGON()'));
393 --error ER_GIS_INVALID_DATA
394 SELECT ST_ASTEXT(ST_GEOMFROMTEXT(' MULTIPOLYGON EMPTY '));
395 --error ER_GIS_INVALID_DATA
396 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOLYGON EMPTY()'));
397 --error ER_GIS_INVALID_DATA
398 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOLYGON EMPT'));
399 --error ER_GIS_INVALID_DATA
400 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('MULTIPOLYGON EMPTYNESS'));
401
402 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
403 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'));
404 SELECT ST_ASTEXT(ST_GEOMFROMTEXT(' GEOMETRYCOLLECTION EMPTY '));
405 --error ER_GIS_INVALID_DATA
406 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY()'));
407 --error ER_GIS_INVALID_DATA
408 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPT'));
409 --error ER_GIS_INVALID_DATA
410 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTYNESS'));
411 SELECT ST_ASTEXT(ST_GEOMFROMTEXT(
412 'GEOMETRYCOLLECTION(
413 GEOMETRYCOLLECTION(
414 GEOMETRYCOLLECTION EMPTY,
415 GEOMETRYCOLLECTION ()
416 )
417 )'
418 ));
419
420 --echo ########################################################################
421 --echo # Inserting testing SRS values in spatial reference table
422 --echo ########################################################################
423
424 --echo # Inserting geographical srs with long-lat ordering
425 CREATE SPATIAL REFERENCE SYSTEM 30000000 NAME 'TEST30000000' DEFINITION 'GEOGCS["SIRGAS 1995",DATUM["Sistema de Referencia Geocentrico para America del Sur 1995",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6170"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["LONG",EAST],AXIS["LAT",NORTH],AUTHORITY["EPSG","30000000"]]';
426
427 --echo # Inserting geographical srs with lat-long ordering
428 CREATE SPATIAL REFERENCE SYSTEM 30100000 NAME 'TEST30100000' DEFINITION 'GEOGCS["SIRGAS 1995",DATUM["Sistema de Referencia Geocentrico para America del Sur 1995",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6170"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["LAT",NORTH],AXIS["LONG",EAST],AUTHORITY["EPSG","30100000"]]';
429
430 --echo # Inserting projected srs with northing-easting ordering
431 CREATE SPATIAL REFERENCE SYSTEM 30200000 NAME 'TEST30200000' DEFINITION 'PROJCS["NAD83(NSRS2007) / Virginia Lambert",GEOGCS["NAD83(NSRS2007)",DATUM["NAD83 (National Spatial Reference System 2007)",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6759"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Long",EAST],AUTHORITY["EPSG","4759"]],PROJECTION["Lambert Conic Conformal (2SP)",AUTHORITY["EPSG","9802"]],PARAMETER["Latitude of false origin",36,AUTHORITY["EPSG","8821"]],PARAMETER["Longitude of false origin",-79.5,AUTHORITY["EPSG","8822"]],PARAMETER["Latitude of 1st standard parallel",37,AUTHORITY["EPSG","8823"]],PARAMETER["Latitude of 2nd standard parallel",39.5,AUTHORITY["EPSG","8824"]],PARAMETER["Easting at false origin",0,AUTHORITY["EPSG","8826"]],PARAMETER["Northing at false origin",0,AUTHORITY["EPSG","8827"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",NORTH],AXIS["Y",EAST],AUTHORITY["EPSG","30200000"]]';
432
433 --echo # Inserting projected srs with easting-northing ordering
434 CREATE SPATIAL REFERENCE SYSTEM 30300000 NAME 'TEST30300000' DEFINITION 'PROJCS["NAD83(NSRS2007) / Virginia Lambert",GEOGCS["NAD83(NSRS2007)",DATUM["NAD83 (National Spatial Reference System 2007)",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6759"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Long",EAST],AUTHORITY["EPSG","4759"]],PROJECTION["Lambert Conic Conformal (2SP)",AUTHORITY["EPSG","9802"]],PARAMETER["Latitude of false origin",36,AUTHORITY["EPSG","8821"]],PARAMETER["Longitude of false origin",-79.5,AUTHORITY["EPSG","8822"]],PARAMETER["Latitude of 1st standard parallel",37,AUTHORITY["EPSG","8823"]],PARAMETER["Latitude of 2nd standard parallel",39.5,AUTHORITY["EPSG","8824"]],PARAMETER["Easting at false origin",0,AUTHORITY["EPSG","8826"]],PARAMETER["Northing at false origin",0,AUTHORITY["EPSG","8827"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","30300000"]]';
435
436
437 --echo ########################################################################
438 --echo # Retrieving geometrycollections with the ST_GEOMCOLLFROMTEXT function
439 --echo #
440 --echo ########################################################################
441
442 --echo # Retrieve values with long lat ordering.
443 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
444 POLYGON((0 0,10 0,10 10,0 10,0 0)),
445 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
446 ((0 0,-2 -2,0 -2, 0 0))))', 30000000,'axis-order=long-lat'));
447
448 --echo # Retrieve values with lat-long ordering.
449 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
450 POLYGON((0 0,0 10,10 10,10 0,0 0)),
451 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
452 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order=lat-long'));
453
454 --echo # Retrieve values with SRID-defined ordering.
455 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
456 POLYGON((0 0,0 10,10 10,10 0,0 0)),
457 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
458 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,'axis-order=srid-defined'));
459
460 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
461 POLYGON((0 0,10 0,10 10,0 10,0 0)),
462 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
463 ((0 0,-2 -2,0 -2, 0 0))))', 30300000,'axis-order=srid-defined'));
464
465
466 --echo ########################################################################
467 --echo # Retrieving geometrycollections with the ST_GEOMCOLLFROMTXT function
468 --echo #
469 --echo ########################################################################
470
471 --echo # Retrieve values with long lat ordering.
472 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTXT('GEOMETRYCOLLECTION(POINT(3 5),
473 POLYGON((0 0,10 0,10 10,0 10,0 0)),
474 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
475 ((0 0,-2 -2,0 -2, 0 0))))', 30000000,'axis-order=long-lat'));
476
477 --echo # Retrieve values with lat-long ordering.
478 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTXT('GEOMETRYCOLLECTION(POINT(3 5),
479 POLYGON((0 0,0 10,10 10,10 0,0 0)),
480 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
481 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order=lat-long'));
482
483 --echo # Retrieve values with SRID-defined ordering.
484 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTXT('GEOMETRYCOLLECTION(POINT(3 5),
485 POLYGON((0 0,0 10,10 10,10 0,0 0)),
486 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
487 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,'axis-order=srid-defined'));
488
489 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTXT('GEOMETRYCOLLECTION(POINT(3 5),
490 POLYGON((0 0,10 0,10 10,0 10,0 0)),
491 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
492 ((0 0,-2 -2,0 -2, 0 0))))', 30300000,'axis-order=srid-defined'));
493
494
495 --echo ########################################################################
496 --echo # Retrieving geometrycollections with the ST_GEOMETRYCOLLECTIONFROMTEXT
497 --echo # function
498 --echo ########################################################################
499
500 --echo # Retrieve values with long lat ordering.
501 SELECT ST_ASTEXT(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
502 POLYGON((0 0,10 0,10 10,0 10,0 0)),
503 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
504 ((0 0,-2 -2,0 -2, 0 0))))', 30000000,'axis-order=long-lat'));
505
506 --echo # Retrieve values with lat-long ordering.
507 SELECT ST_ASTEXT(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
508 POLYGON((0 0,0 10,10 10,10 0,0 0)),
509 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
510 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order=lat-long'));
511
512 --echo # Retrieve values with SRID-defined ordering.
513 SELECT ST_ASTEXT(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
514 POLYGON((0 0,0 10,10 10,10 0,0 0)),
515 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
516 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,'axis-order=srid-defined'));
517
518 SELECT ST_ASTEXT(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
519 POLYGON((0 0,10 0,10 10,0 10,0 0)),
520 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
521 ((0 0,-2 -2,0 -2, 0 0))))', 30300000,'axis-order=srid-defined'));
522
523
524 --echo ########################################################################
525 --echo # Retrieving geometrycollections with the ST_GEOMETRYFROMTEXT function
526 --echo #
527 --echo ########################################################################
528
529 --echo # Retrieve values with long lat ordering.
530 SELECT ST_ASTEXT(ST_GEOMETRYFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
531 POLYGON((0 0,10 0,10 10,0 10,0 0)),
532 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
533 ((0 0,-2 -2,0 -2, 0 0))))', 30000000,'axis-order=long-lat'));
534
535 --echo # Retrieve values with lat-long ordering.
536 SELECT ST_ASTEXT(ST_GEOMETRYFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
537 POLYGON((0 0,0 10,10 10,10 0,0 0)),
538 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
539 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order=lat-long'));
540
541 --echo # Retrieve values with SRID-defined ordering.
542 SELECT ST_ASTEXT(ST_GEOMETRYFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
543 POLYGON((0 0,0 10,10 10,10 0,0 0)),
544 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
545 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,'axis-order=srid-defined'));
546
547 SELECT ST_ASTEXT(ST_GEOMETRYFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
548 POLYGON((0 0,10 0,10 10,0 10,0 0)),
549 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
550 ((0 0,-2 -2,0 -2, 0 0))))', 30300000,'axis-order=srid-defined'));
551
552
553 --echo ########################################################################
554 --echo # Retrieving geometrycollections with the ST_GEOMFROMTEXT function
555 --echo #
556 --echo ########################################################################
557
558 --echo # Retrieve values with long lat ordering.
559 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
560 POLYGON((0 0,10 0,10 10,0 10,0 0)),
561 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
562 ((0 0,-2 -2,0 -2, 0 0))))', 30000000,'axis-order=long-lat'));
563
564 --echo # Retrieve values with lat-long ordering.
565 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
566 POLYGON((0 0,0 10,10 10,10 0,0 0)),
567 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
568 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order=lat-long'));
569
570 --echo # Retrieve values with SRID-defined ordering.
571 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
572 POLYGON((0 0,0 10,10 10,10 0,0 0)),
573 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
574 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,'axis-order=srid-defined'));
575
576 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
577 POLYGON((0 0,10 0,10 10,0 10,0 0)),
578 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
579 ((0 0,-2 -2,0 -2, 0 0))))', 30300000,'axis-order=srid-defined'));
580
581
582 --echo ########################################################################
583 --echo # Retrieving linestrings with the ST_LINEFROMTEXT function
584 --echo #
585 --echo ########################################################################
586
587 --echo # Retrieve values with long lat ordering.
588 SELECT ST_ASTEXT(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)', 30100000,
589 'axis-order=long-lat'));
590
591 --echo # Retrieve values with lat-long ordering.
592 SELECT ST_ASTEXT(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)', 30100000,
593 'axis-order=lat-long'));
594
595 --echo # Retrieve values with SRID-defined ordering.
596 SELECT ST_ASTEXT(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)', 30100000,
597 'axis-order=srid-defined'));
598 SELECT ST_ASTEXT(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)', 30000000,
599 'axis-order=srid-defined'));
600
601
602 --echo ########################################################################
603 --echo # Retrieving linestrings with the ST_LINESTRINGFROMTEXT function
604 --echo #
605 --echo ########################################################################
606
607 --echo # Retrieve values with long lat ordering.
608 SELECT ST_ASTEXT(ST_LINESTRINGFROMTEXT('LINESTRING(0 5,5 10,10 15)', 30100000,
609 'axis-order=long-lat'));
610
611 --echo # Retrieve values with lat-long ordering.
612 SELECT ST_ASTEXT(ST_LINESTRINGFROMTEXT('LINESTRING(0 5,5 10,10 15)', 30100000,
613 'axis-order=lat-long'));
614
615 --echo # Retrieve values with SRID-defined ordering.
616 SELECT ST_ASTEXT(ST_LINESTRINGFROMTEXT('LINESTRING(0 5,5 10,10 15)', 30100000,
617 'axis-order=srid-defined'));
618 SELECT ST_ASTEXT(ST_LINESTRINGFROMTEXT('LINESTRING(0 5,5 10,10 15)', 30000000,
619 'axis-order=srid-defined'));
620
621
622 --echo ########################################################################
623 --echo # Retrieving multistrings with the ST_MLINEFROMTEXT function
624 --echo #
625 --echo ########################################################################
626
627 --echo # Retrieve values with long lat ordering.
628 SELECT ST_ASTEXT(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),
629 (8 11,11 14,14 17))', 30000000,'axis-order=long-lat'));
630
631 --echo # Retrieve values with lat-long ordering.
632 SELECT ST_ASTEXT(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),
633 (8 11,11 14,14 17))', 30100000,'axis-order=lat-long'));
634
635 --echo # Retrieve values with SRID-defined ordering.
636 SELECT ST_ASTEXT(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),
637 (8 11,11 14,14 17))', 30200000,'axis-order=srid-defined'));
638 SELECT ST_ASTEXT(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),
639 (8 11,11 14,14 17))', 30300000,'axis-order=srid-defined'));
640
641
642 --echo ########################################################################
643 --echo # Retrieving multipoints with the ST_MPOINTFROMTEXT function
644 --echo #
645 --echo ########################################################################
646
647 --echo # Retrieve values with long lat ordering.
648 SELECT ST_ASTEXT(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',
649 30000000,'axis-order=long-lat'));
650
651 --echo # Retrieve values with lat-long ordering.
652 SELECT ST_ASTEXT(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',
653 30100000,'axis-order=lat-long'));
654
655 --echo # Retrieve values with SRID-defined ordering.
656 SELECT ST_ASTEXT(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',
657 30200000,'axis-order=srid-defined'));
658 SELECT ST_ASTEXT(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',
659 30300000,'axis-order=srid-defined'));
660
661
662 --echo ########################################################################
663 --echo # Retrieving multipolygons with the ST_MPOLYFROMTEXT function
664 --echo #
665 --echo ########################################################################
666
667 --echo # Retrieve values with long lat ordering.
668 SELECT ST_ASTEXT(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),
669 (4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))', 30000000,
670 'axis-order=long-lat'));
671
672 --echo # Retrieve values with lat-long ordering.
673 SELECT ST_ASTEXT(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),
674 (4 4,6 4,6 6,4 6, 4 4)),((0 0,-2 -2,-2 0, 0 0)))', 30100000,
675 'axis-order=lat-long'));
676
677 --echo # Retrieve values with SRID-defined ordering.
678 SELECT ST_ASTEXT(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),
679 (4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))', 30200000,
680 'axis-order=srid-defined'));
681 SELECT ST_ASTEXT(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),
682 (4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))', 30300000,
683 'axis-order=srid-defined'));
684
685
686 --echo ########################################################################
687 --echo # Retrieving multistrings with the ST_MULTILINESTRINGFROMTEXT function
688 --echo #
689 --echo ########################################################################
690
691 --echo # Retrieve values with long lat ordering.
692 SELECT ST_ASTEXT(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),
693 (8 11,11 14,14 17))', 30000000,'axis-order=long-lat'));
694
695 --echo # Retrieve values with lat-long ordering.
696 SELECT ST_ASTEXT(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),
697 (8 11,11 14,14 17))', 30100000,'axis-order=lat-long'));
698
699 --echo # Retrieve values with SRID-defined ordering.
700 SELECT ST_ASTEXT(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),
701 (8 11,11 14,14 17))', 30200000,'axis-order=srid-defined'));
702 SELECT ST_ASTEXT(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),
703 (8 11,11 14,14 17))', 30300000,'axis-order=srid-defined'));
704
705
706 --echo ########################################################################
707 --echo # Retrieving multipoints with the ST_MULTIPOINTFROMTEXT function
708 --echo #
709 --echo ########################################################################
710
711 --echo # Retrieve values with long lat ordering.
712 SELECT ST_ASTEXT(ST_MULTIPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2),
713 (4 9))', 30000000,'axis-order=long-lat'));
714
715 --echo # Retrieve values with lat-long ordering.
716 SELECT ST_ASTEXT(ST_MULTIPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2),
717 (4 9))', 30100000,'axis-order=lat-long'));
718
719 --echo # Retrieve values with SRID-defined ordering.
720 SELECT ST_ASTEXT(ST_MULTIPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2),
721 (4 9))', 30200000,'axis-order=srid-defined'));
722 SELECT ST_ASTEXT(ST_MULTIPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2),
723 (4 9))', 30300000,'axis-order=srid-defined'));
724
725
726 --echo ########################################################################
727 --echo # Retrieving multipolygons with the ST_MULTIPOLYGONFROMTEXT function
728 --echo #
729 --echo ########################################################################
730
731 --echo # Retrieve values with long lat ordering.
732 SELECT ST_ASTEXT(ST_MULTIPOLYGONFROMTEXT(
733 'MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0), (4 4,4 6,6 6,6 4, 4 4)),
734 ((0 0,-2 -2,0 -2, 0 0)))', 30000000, 'axis-order=long-lat'));
735
736 --echo # Retrieve values with lat-long ordering.
737 SELECT ST_ASTEXT(ST_MULTIPOLYGONFROMTEXT(
738 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0), (4 4,6 4,6 6,4 6, 4 4)),
739 ((0 0,-2 -2,-2 0, 0 0)))', 30100000, 'axis-order=lat-long'));
740
741 --echo # Retrieve values with SRID-defined ordering.
742 SELECT ST_ASTEXT(ST_MULTIPOLYGONFROMTEXT(
743 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0), (4 4,4 6,6 6,6 4, 4 4)),
744 ((0 0,-2 -2,0 -2, 0 0)))', 30200000, 'axis-order=srid-defined'));
745 SELECT ST_ASTEXT(ST_MULTIPOLYGONFROMTEXT(
746 'MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0), (4 4,4 6,6 6,6 4, 4 4)),
747 ((0 0,-2 -2,0 -2, 0 0)))', 30300000, 'axis-order=srid-defined'));
748
749
750 --echo ########################################################################
751 --echo # Retrieving points with the ST_POINTFROMTEXT function
752 --echo #
753 --echo ########################################################################
754
755 --echo # When the geometry is in a projected spatial reference system,
756 --echo # the coordinates are interpreted as in the order they appear in the geometry.
757
758 --echo # Retrieve values with long lat ordering.
759 SELECT ST_ASTEXT(ST_POINTFROMTEXT('point(1 2)',30300000, 'axis-order=long-lat'));
760
761 --echo # Retrieve values with lat-long ordering.
762 SELECT ST_ASTEXT(ST_POINTFROMTEXT('point(1 2)',30100000, 'axis-order=lat-long'));
763
764 --echo # Retrieve values with SRID-defined ordering.
765 SELECT ST_ASTEXT(ST_POINTFROMTEXT('point(1 2)',30200000, 'axis-order=srid-defined'));
766 SELECT ST_ASTEXT(ST_POINTFROMTEXT('point(1 2)',30100000, 'axis-order=srid-defined'));
767
768
769 --echo ########################################################################
770 --echo # Retrieving polygons with the ST_POLYFROMTEXT function
771 --echo #
772 --echo ########################################################################
773
774 --echo # Retrieve values with long lat ordering.
775 SELECT ST_ASTEXT(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))', 30000000,
776 'axis-order=long-lat'));
777
778 --echo # Retrieve values with lat-long ordering.
779 SELECT ST_ASTEXT(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))', 30100000,
780 'axis-order=lat-long'));
781
782 --echo # Retrieve values with SRID-defined ordering.
783 SELECT ST_ASTEXT(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))', 30200000,
784 'axis-order=srid-defined'));
785 SELECT ST_ASTEXT(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))', 30300000,
786 'axis-order=srid-defined'));
787
788
789 --echo ########################################################################
790 --echo # Retrieving polygons with the ST_POLYGONFROMTEXT function
791 --echo #
792 --echo ########################################################################
793
794 --echo # Retrieve values with long lat ordering.
795 SELECT ST_ASTEXT(ST_POLYGONFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))', 30000000,
796 'axis-order=long-lat'));
797
798 --echo # Retrieve values with lat-long ordering.
799 SELECT ST_ASTEXT(ST_POLYGONFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))', 30100000,
800 'axis-order=lat-long'));
801
802 --echo # Retrieve values with SRID-defined ordering.
803 SELECT ST_ASTEXT(ST_POLYGONFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))', 30200000,
804 'axis-order=srid-defined'));
805 SELECT ST_ASTEXT(ST_POLYGONFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))', 30300000,
806 'axis-order=srid-defined'));
807
808
809 --echo # ######################################################################
810 --echo # Options upper and lower case testing
811 --echo # ######################################################################
812
813 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
814 POLYGON((0 0,10 0,10 10,0 10,0 0)),
815 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
816 ((0 0,-2 -2,0 -2, 0 0))))', 30000000,'axis-order=Long-Lat'));
817
818 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
819 POLYGON((0 0,0 10,10 10,10 0,0 0)),
820 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
821 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axiS-Order=Lat-lonG'));
822
823 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
824 POLYGON((0 0,0 10,10 10,10 0,0 0)),
825 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
826 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,'AXis-orDer=srid-defined'));
827
828
829 --echo ########################################################################
830 --echo # Error testing
831 --echo ########################################################################
832
833 --echo # Test with too many options.
834
835 --error ER_DUPLICATE_OPTION_KEY
836 SELECT ST_ASTEXT(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),
837 (4 4,6 4,6 6,4 6, 4 4)),((0 0,-2 -2,-2 0, 0 0)))', 30300000,
838 'axis-order=srid-defined, axis-order=lat-long'));
839
840 --echo # Test with invalid options key.
841 --error ER_INVALID_OPTION_KEY
842 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
843 POLYGON((0 0,0 10,10 10,10 0,0 0)),
844 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
845 ((0 0,-2 -2,-2 0, 0 0))))', 30300000,'axix-order=srid-defined'));
846
847 --error ER_INVALID_OPTION_KEY
848 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
849 POLYGON((0 0,0 10,10 10,10 0,0 0)),
850 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
851 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,'axix-order=lat-long'));
852
853 --error ER_INVALID_OPTION_KEY
854 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
855 POLYGON((0 0,0 10,10 10,10 0,0 0)),
856 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
857 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axix-order=lat-long'));
858
859 --echo # Test with invalid options value
860 --error ER_INVALID_OPTION_VALUE
861 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
862 POLYGON((0 0,0 10,10 10,10 0,0 0)),
863 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
864 ((0 0,-2 -2,-2 0, 0 0))))', 30300000,'axis-order=srid-dfined'));
865
866 --error ER_INVALID_OPTION_VALUE
867 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
868 POLYGON((0 0,0 10,10 10,10 0,0 0)),
869 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
870 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,'axis-order=lat-bong'));
871
872 --error ER_INVALID_OPTION_VALUE
873 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
874 POLYGON((0 0,0 10,10 10,10 0,0 0)),
875 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
876 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order=lat-shwong'));
877
878 --echo # Test with both invalid option and invalid value
879 --error ER_INVALID_OPTION_KEY
880 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
881 POLYGON((0 0,10 0,10 10,0 10,0 0)),
882 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
883 ((0 0,-2 -2,0 -2, 0 0))))', 30100000,'axis-border=lat-shwong'));
884
885 --echo # Testing for badly formed options argument.
886 --error ER_INVALID_OPTION_KEY_VALUE_PAIR
887 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
888 POLYGON((0 0,0 10,10 10,10 0,0 0)),
889 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
890 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order srid-defined'));
891
892 --error ER_INVALID_OPTION_START_CHARACTER
893 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
894 POLYGON((0 0,0 10,10 10,10 0,0 0)),
895 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
896 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'=axis-order srid-defined'));
897
898 --error ER_INVALID_OPTION_END_CHARACTER
899 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
900 POLYGON((0 0,0 10,10 10,10 0,0 0)),
901 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
902 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order=srid-defined='));
903
904 --error ER_INVALID_OPTION_CHARACTERS
905 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
906 POLYGON((0 0,0 10,10 10,10 0,0 0)),
907 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
908 ((0 0,-2 -2,-2 0, 0 0))))', 30100000,'axis-order== srid-defined'));
909
910
911 --echo # ######################################################################
912 --echo # Empty string and white space testing
913 --echo # ######################################################################
914
915 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
916 POLYGON((0 0,10 0,10 10,0 10,0 0)),
917 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),
918 ((0 0,-2 -2,0 -2, 0 0))))', 30000000,''));
919
920 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
921 POLYGON((0 0,0 10,10 10,10 0,0 0)),
922 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
923 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,' '));
924
925 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5),
926 POLYGON((0 0,0 10,10 10,10 0,0 0)),
927 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6, 4 4)),
928 ((0 0,-2 -2,-2 0, 0 0))))', 30200000,' axis-order = srid-defined '));
929
930 --echo # ######################################################################
931 --echo # NULL value testing
932 --echo # ######################################################################
933
934 --echo # NULL value testing: Should return NULL if either or both parameters is NULL
935
936 SELECT ST_ASTEXT(ST_POINTFROMTEXT(NULL,30300000, 'axis-order=long-lat'));
937 SELECT ST_ASTEXT(ST_POINTFROMTEXT('point(1 2)', NULL, 'axis-order=lat-long'));
938 SELECT ST_ASTEXT(ST_POINTFROMTEXT('point(1 2)', 30200000, NULL));
939 SELECT ST_ASTEXT(ST_POINTFROMTEXT('point(1 2)', NULL, NULL));
940 SELECT ST_ASTEXT(ST_POINTFROMTEXT(NULL, NULL, NULL));
941
942 --echo #
943 --echo # Bug #25818451 ASAN HEAP-USE-AFTER-FREE WITH GEOMETRY + STRING
944 --echo #
945
946 SET @c:=REPEAT('a',128);
947 SET @f:=0x336f;
948 SET @s:=REPLACE("DO ST_ASTEXT(LEFT(@c,@f));","'",'"');
949 PREPARE s FROM @s;
950 --error ER_GIS_INVALID_DATA
951 EXECUTE s;
952 DROP PREPARE s;
953
954 ######################################################################
955 # WL#9449 Restrict range of geographic coordinates in import functions
956 ######################################################################
957
958 --echo ##########################################################
959 --echo # Inserting testing SRS values in spatial reference table
960 --echo ##########################################################
961
962 --echo # Inserting geographical srs with long-lat ordering
963 CREATE SPATIAL REFERENCE SYSTEM 32000000 NAME 'TEST32000000' DEFINITION 'GEOGCS["SIRGAS 1995",DATUM["Sistema de Referencia Geocentrico para America del Sur 1995",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6170"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["LONG",EAST],AXIS["LAT",NORTH],AUTHORITY["EPSG","32000000"]]';
964
965 --echo # Inserting geographical srs with lat-long ordering
966 CREATE SPATIAL REFERENCE SYSTEM 32100000 NAME 'TEST32100000' DEFINITION 'GEOGCS["SIRGAS 1995",DATUM["Sistema de Referencia Geocentrico para America del Sur 1995",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6170"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["LAT",NORTH],AXIS["LONG",EAST],AUTHORITY["EPSG","32100000"]]';
967
968 --echo # Inserting projected srs with northing-easting ordering
969 CREATE SPATIAL REFERENCE SYSTEM 32200000 NAME 'TEST32200000' DEFINITION 'PROJCS["NAD83(NSRS2007) / Virginia Lambert",GEOGCS["NAD83(NSRS2007)",DATUM["NAD83 (National Spatial Reference System 2007)",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6759"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Long",EAST],AUTHORITY["EPSG","4759"]],PROJECTION["Lambert Conic Conformal (2SP)",AUTHORITY["EPSG","9802"]],PARAMETER["Latitude of false origin",36,AUTHORITY["EPSG","8821"]],PARAMETER["Longitude of false origin",-79.5,AUTHORITY["EPSG","8822"]],PARAMETER["Latitude of 1st standard parallel",37,AUTHORITY["EPSG","8823"]],PARAMETER["Latitude of 2nd standard parallel",39.5,AUTHORITY["EPSG","8824"]],PARAMETER["Easting at false origin",0,AUTHORITY["EPSG","8826"]],PARAMETER["Northing at false origin",0,AUTHORITY["EPSG","8827"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",NORTH],AXIS["Y",EAST],AUTHORITY["EPSG","32200000"]]';
970
971 --echo #########################################################################
972 --echo # Test with geometries with geographic SRS with long-lat ordering outside
973 --echo # valid range.
974 --echo #########################################################################
975
976 --error ER_LONGITUDE_OUT_OF_RANGE
977 SELECT ST_POINTFROMTEXT('POINT(-200 10)',32000000);
978 --error ER_LONGITUDE_OUT_OF_RANGE
979 SELECT ST_LINEFROMTEXT('LINESTRING(0 5,194 10,10 15)',32000000);
980 --error ER_LONGITUDE_OUT_OF_RANGE
981 SELECT ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,-300 5,0 0))',32000000);
982 --error ER_LONGITUDE_OUT_OF_RANGE
983 SELECT ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (798 2), (-344 9))',32000000);
984 --error ER_LONGITUDE_OUT_OF_RANGE
985 SELECT ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(744 11,11 14,14 17))',32000000);
986 --error ER_LONGITUDE_OUT_OF_RANGE
987 SELECT ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,350 0,350 350,0 350,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))',32000000);
988 --error ER_LONGITUDE_OUT_OF_RANGE
989 SELECT ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(-199 5), POLYGON((0 0,10 0,10 10,0 10,0 0)), MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0))))',32000000);
990
991 --echo #########################################################################
992 --echo # Test with geometries with geographic SRS with lat-long ordering outside
993 --echo # valid range (same geometries as above, but with different error since
994 --echo # coordinates are flipped).
995 --echo #########################################################################
996
997 --error ER_LATITUDE_OUT_OF_RANGE
998 SELECT ST_POINTFROMTEXT('POINT(-200 10)',32100000);
999 --error ER_LATITUDE_OUT_OF_RANGE
1000 SELECT ST_LINEFROMTEXT('LINESTRING(0 5,194 10,10 15)',32100000);
1001 --error ER_LATITUDE_OUT_OF_RANGE
1002 SELECT ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,-300 5,0 0))',32100000);
1003 --error ER_LATITUDE_OUT_OF_RANGE
1004 SELECT ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (798 2), (4 9))',32100000);
1005 --error ER_LATITUDE_OUT_OF_RANGE
1006 SELECT ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(744 11,11 14,14 17))',32100000);
1007 --error ER_LATITUDE_OUT_OF_RANGE
1008 SELECT ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,350 0,350 350,0 350,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))',32100000);
1009 --error ER_LATITUDE_OUT_OF_RANGE
1010 SELECT ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(-199 5), POLYGON((0 0,10 0,10 10,0 10,0 0)), MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0))))',32100000);
1011
1012 --echo ##############################
1013 --echo # Miscellaneous error testing
1014 --echo ##############################
1015
1016 --error ER_LATITUDE_OUT_OF_RANGE
1017 SELECT ST_POINTFROMTEXT('POINT(-91 10)',32100000);
1018 --error ER_LONGITUDE_OUT_OF_RANGE
1019 SELECT ST_POINTFROMTEXT('POINT(10 -182)',32100000);
1020 --error ER_LONGITUDE_OUT_OF_RANGE
1021 SELECT ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(744 11,11 91,14 17))',32000000);
1022 --error ER_LATITUDE_OUT_OF_RANGE
1023 SELECT ST_MLINEFROMTEXT('MULTILINESTRING((0 95,2 4,4 6),(744 11,11 91,14 17))',32000000);
1024
1025 --echo ###################
1026 --echo # Edge case testing
1027 --echo ###################
1028
1029 SELECT ST_ASTEXT(ST_POINTFROMTEXT('POINT(-90.0000000 10)',32100000));
1030 SELECT ST_ASTEXT(ST_POINTFROMTEXT('POINT(10 -180.000000)',32100000));
1031
1032 SELECT ST_ASTEXT(ST_POINTFROMTEXT('POINT(90.0000000 10)',32100000));
1033 SELECT ST_ASTEXT(ST_POINTFROMTEXT('POINT(10 180.000000)',32100000));
1034
1035 --error ER_LATITUDE_OUT_OF_RANGE
1036 SELECT ST_POINTFROMTEXT('POINT(-90.0000001 10)',32100000);
1037 --error ER_LONGITUDE_OUT_OF_RANGE
1038 SELECT ST_POINTFROMTEXT('POINT(10 -180.0000001)',32100000);
1039
1040 --error ER_LATITUDE_OUT_OF_RANGE
1041 SELECT ST_POINTFROMTEXT('POINT(90.0000001 10)',32100000);
1042 --error ER_LONGITUDE_OUT_OF_RANGE
1043 SELECT ST_POINTFROMTEXT('POINT(10 180.0000001)',32100000);
1044
1045 --echo #################################################################
1046 --echo # Test that range restriction does not apply to projected spatial
1047 --echo # reference systems
1048 --echo #################################################################
1049
1050 SELECT ST_ASTEXT(ST_POINTFROMTEXT('POINT(-200 10)',32200000));
1051 SELECT ST_ASTEXT(ST_LINEFROMTEXT('LINESTRING(0 5,194 10,10 15)',32200000));
1052 SELECT ST_ASTEXT(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,-300 5,0 0))',32200000));
1053 SELECT ST_ASTEXT(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (798 2), (4 9))',32200000));
1054 SELECT ST_ASTEXT(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(744 11,11 14,14 17))',32200000));
1055 SELECT ST_ASTEXT(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,350 0,350 350,0 350,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))',32200000));
1056 SELECT ST_ASTEXT(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(-199 5), POLYGON((0 0,10 0,10 10,0 10,0 0)), MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0))))',32200000));
1057
1058 --echo ########################################################
1059 --echo # Test with empty GEOMETRYCOLLECTION with geographic SRS
1060 --echo ########################################################
1061
1062 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()', 32000000));
1063 SELECT ST_ASTEXT(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()', 32100000));
1064
1065 # Cleanup.
1066 DROP SPATIAL REFERENCE SYSTEM 30000000;
1067 DROP SPATIAL REFERENCE SYSTEM 30100000;
1068 DROP SPATIAL REFERENCE SYSTEM 30200000;
1069 DROP SPATIAL REFERENCE SYSTEM 30300000;
1070 DROP SPATIAL REFERENCE SYSTEM 32000000;
1071 DROP SPATIAL REFERENCE SYSTEM 32100000;
1072 DROP SPATIAL REFERENCE SYSTEM 32200000;
1073
1074 --echo #
1075 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
1076 --echo #
1077
1078 --echo # Assume SRID 10 is not defined. Should raise warning.
1079 DO ST_ASTEXT(x'0A000000010100000000000000000000000000000000000000');
1080 DO ST_ASWKT(x'0A000000010100000000000000000000000000000000000000');
1081
1082 --echo #
1083 --echo # Bug #27427677 SIG 11 IN STRING::APPEND() METHOD,
1084 --echo # SQL-COMMON/SQL_STRING.CC:535
1085 --echo #
1086
1087 CREATE TABLE t1(c1 GEOMETRY);
1088 INSERT INTO t1 VALUES (ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 0))'));
1089 SELECT ST_AsText(c1) AS f1 FROM t1 ORDER BY f1;
1090 DROP TABLE t1;