Debian Codegraph @

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

raw
1 #####################################################################
2 # #
3 # This test is for validating the functionality of the different #
4 # GeoJSON functions. #
5 # #
6 # Creation Date: 2014-07-08 #
7 # Author : Erik Frøseth #
8 # #
9 #####################################################################
10
11 #####################################################################
12 # ST_ASGEOJSON()
13 #####################################################################
14
15 --echo # Checking all valid GEOMETRY types
16 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"));
17
18 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(-10 -11)"));
19
20 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E+308 1.7976931348623157E+308)"));
21
22 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E-308 1.7976931348623157E-308)"));
23
24 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("LINESTRING(30 10, 10 30, 40 40)"));
25
26 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("LINESTRING(0 0, 0 10, 10 10, 10 0)"));
27
28 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POLYGON((30 10, 40 40, 20 40, 10 20, 30 10))"));
29
30 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POLYGON((35 10, 45 45, 15 40, 10 20, 35 10),"
31 "(20 30, 35 35, 30 20, 20 30))"));
32
33 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOINT(10 40, 40 30, 20 20, 30 10)"));
34
35 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOINT(0 0, 10 10, 20 20, 30 30, 40 40)"));
36
37 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTILINESTRING((10 10, 20 20, 10 40),"
38 "(40 40, 30 30, 40 20, 30 10))"));
39
40 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTILINESTRING((10 10, 20 20, 10 40),"
41 "(40 40, 30 30, 40 20, 30 10),"
42 "(10 10, 20 20, 50 50, 100 100))"));
43
44 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOLYGON(((40 40, 20 45, 45 30, 40 40)),"
45 "((20 35, 10 30, 10 10, 30 5, 45 20, 20 35)))"));
46
47 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOLYGON(((40 40, 20 45, 45 30, 40 40)),"
48 "((20 35, 10 30, 10 10, 30 5, 45 20, 20 35),"
49 "(30 20, 20 15, 20 25, 30 20)))"));
50
51 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION()"));
52
53 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 20)))"));
54
55 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))"));
56
57 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION( "
58 "GEOMETRYCOLLECTION(POINT(10 20)),"
59 "GEOMETRYCOLLECTION(LINESTRING(0 0, 100 100)),"
60 "GEOMETRYCOLLECTION(POLYGON((0 0, 0 10, 10 10, 0 0)))"
61 ")"
62 ));
63
64 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION( "
65 "POINT(4 6),"
66 "LINESTRING(4 6,7 10),"
67 "POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)),"
68 "MULTIPOINT (10 40, 40 30, 20 20, 30 10),"
69 "MULTILINESTRING ((10 10, 20 20, 10 40),"
70 "(40 40, 30 30, 40 20, 30 10)),"
71 "MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),"
72 "((15 5, 40 10, 10 20, 5 10, 15 5)))"
73 ")"
74 ));
75
76 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION( "
77 "POINT(4 6),"
78 "GEOMETRYCOLLECTION("
79 "POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)),"
80 "MULTIPOINT (10 40, 40 30, 20 20, 30 10),"
81 "MULTILINESTRING ((10 10, 20 20, 10 40),"
82 "(40 40, 30 30, 40 20, 30 10)),"
83 "MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),"
84 "((15 5, 40 10, 10 20, 5 10, 15 5)))"
85 "),"
86 "POINT(6 4)"
87 ")"
88 ));
89
90 --echo # Checking NULL as one or more of the arguments.
91 SELECT ST_ASGEOJSON(NULL);
92
93 SELECT ST_ASGEOJSON(NULL, NULL);
94 SELECT ST_ASGEOJSON(NULL, 10);
95 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"), NULL);
96
97 SELECT ST_ASGEOJSON(NULL, 10, 0);
98 SELECT ST_ASGEOJSON(NULL, NULL, 0);
99 SELECT ST_ASGEOJSON(NULL, 10, NULL);
100 SELECT ST_ASGEOJSON(NULL, NULL, NULL);
101 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"), NULL, 0);
102 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"), 10, NULL);
103 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"), NULL, NULL);
104
105 --echo # Checking options argument and maxdecimaldigits argument
106 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4326), 100, 2);
107 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4326), 100, 4);
108 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4326), 100, 6);
109 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 0), 100, 5);
110 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 0), 100, 2);
111 --error ER_DATA_OUT_OF_RANGE
112 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", -1), 100, 4);
113 --error ER_DATA_OUT_OF_RANGE
114 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", -1000), 100, 6);
115 --error ER_DATA_OUT_OF_RANGE
116 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4294967296), 100, 6);
117 --error ER_DATA_OUT_OF_RANGE
118 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4294967295123), 100, 7);
119
120 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), 0, 0);
121 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), 4, 7);
122 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), 10, 0);
123
124 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), 0);
125 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), 4);
126 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), 10);
127 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.123456789)", 0), 10000);
128 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.123456789)", 0), 1000000);
129 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.123456789)", 0), 2147483647);
130
131 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, 0);
132 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, 1);
133 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, 2);
134 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, 3);
135 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, 4);
136 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, 5);
137 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, 6);
138 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, 7);
139
140 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", "0"), 100, 1);
141 --error ER_DATA_OUT_OF_RANGE
142 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", "-1"), 100, 2);
143 --error ER_DATA_OUT_OF_RANGE
144 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", "-1000"), 100, 3);
145 --error ER_DATA_OUT_OF_RANGE
146 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", "4294967296"), 100, 5);
147 --error ER_DATA_OUT_OF_RANGE
148 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", "4294967295123"), 100, 6);
149 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", (CAST(4326 AS CHAR))), 100, 7);
150
151 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), "0", 1);
152 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), "4", 2);
153 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.123456789 11.123456789)", 0), "10", 3);
154 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), "10000", 4);
155 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), "1000000", 5);
156 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), "2147483647", 6);
157 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), (CAST(20 AS CHAR)), 7);
158
159 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10.1234567890123456789 11.1234567890123456789)", 0), 10, (CAST(7 AS CHAR)));
160
161 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", " 4326.34 "), 100, 1);
162 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", "*&$%4326"), 100, 2);
163 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 0), "12.34", 3);
164 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4326), "*&$%$123", 4);
165 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4236), 10, "06.34");
166 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4326), 10, "*&$%$123");
167
168 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOLYGON(((40 40, 20 45, 45 30, 40 40)),"
169 "((20 35, 10 30, 10 10, 30 5, 45 20, 20 35),"
170 "(30 20, 20 15, 20 25, 30 20)))"), 10, 1);
171
172 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION( "
173 "GEOMETRYCOLLECTION(POINT(10 20)),"
174 "GEOMETRYCOLLECTION(LINESTRING(0 0, 100 100)),"
175 "GEOMETRYCOLLECTION(POLYGON((0 0, 0 10, 10 10, 0 0)))"
176 ")"
177 ), 5, 1);
178
179 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION("
180 "POINT(4 6),"
181 "GEOMETRYCOLLECTION("
182 "POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)),"
183 "MULTIPOINT (10 40, 40 30, 20 20, 30 10),"
184 "MULTILINESTRING ((10 10, 20 20, 10 40),"
185 "(40 40, 30 30, 40 20, 30 10)),"
186 "MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),"
187 "((15 5, 40 10, 10 20, 5 10, 15 5)))"
188 "),"
189 "POINT(6 4)"
190 ")"
191 ), 10, 1 );
192
193 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION()"), 10, 1);
194
195 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E+308 1.7976931348623157E-308)"), 0, 1);
196
197 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E+308 1.7976931348623157E-308)"), 10, 1);
198
199 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E+308 1.7976931348623157E-308)"), 20, 1);
200
201 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E+308 1.7976931348623157E-308)"), 30, 1);
202
203 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E+308 1.7976931348623157E-308)"), 40, 1);
204
205 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E+308 1.7976931348623157E-308)"), 1000, 1);
206
207 --error ER_INCORRECT_TYPE
208 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT('POINT(1.2345678901234567890 2.345678901234567890)'), SUM(3));
209
210 --error ER_INCORRECT_TYPE
211 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT('POINT(1.2345678901234567890 2.345678901234567890)'), AVG(3));
212
213 # NOTE: Since ST_AsGeoJSON now ouputs the new JSON type,
214 # the character set will be decided by the JSON to_string
215 # function. As of writing, this is utf8mb4 regardless of the
216 # client character set.
217 --echo # Check that function outputs correct character set
218 SET NAMES 'ascii';
219 SELECT CHARSET(ST_ASGEOJSON(POINT(-1.42, 283.12)));
220
221 SET NAMES 'utf8';
222 SELECT CHARSET(ST_ASGEOJSON(POINT(-1.42, 283.12)));
223
224 --echo # Invalid function calls
225 --error ER_GIS_INVALID_DATA
226 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("1"));
227
228 --error ER_GIS_INVALID_DATA
229 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT"));
230
231 --error ER_GIS_INVALID_DATA
232 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT()"));
233
234 --error ER_GIS_INVALID_DATA
235 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10)"));
236
237 --error ER_GIS_INVALID_DATA
238 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(a b)"));
239
240 --error ER_GIS_INVALID_DATA
241 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 b)"));
242
243 --error ER_GIS_INVALID_DATA
244 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(a 11)"));
245
246 --error ER_GIS_INVALID_DATA
247 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10, 11)"));
248
249 --error ER_GIS_INVALID_DATA
250 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POLYGON((40 40, 20 45, 45 30, 40 40)"), 10);
251
252 --error ER_GIS_INVALID_DATA
253 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOLYGON(((40 40, 20 45, 45 30, 40 40)),"
254 "((20 35, 10 30, 10 10, 30 5, 45 20, 20 35),"), 10, 2);
255
256 --error ER_GIS_INVALID_DATA
257 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION( "
258 "GEOMETRYCOLLECTION(POINT(10 20)),"
259 "GEOMETRYCOLLECTION(LINESTRING(0 0, 100 100)),"
260 "GEOMETRYCOLLECTION(POLYGON((0 0, 0 10, 10 10, 0 0))),"
261 ")"
262 ));
263
264 --error ER_GIS_INVALID_DATA
265 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOINT()"), 10);
266
267 --error ER_GIS_INVALID_DATA
268 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTILINESTRING(())"), 10);
269
270 --error ER_GIS_INVALID_DATA
271 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOLYGON((()))"), 10);
272
273 --error ER_GIS_INVALID_DATA
274 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("LINESTRING(1)"), 10);
275
276 --error ER_GIS_INVALID_DATA
277 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTILINESTRING((0 0, 10 10),())"), 10);
278
279 --error ER_WRONG_VALUE_FOR_TYPE
280 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2, -1);
281
282 --error ER_WRONG_VALUE_FOR_TYPE
283 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2, -1000);
284
285 --error ER_WRONG_VALUE_FOR_TYPE
286 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2, 8);
287
288 --error ER_WRONG_VALUE_FOR_TYPE
289 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2, 1000);
290
291 --error ER_WRONG_VALUE_FOR_TYPE
292 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2, "-1");
293
294 --error ER_WRONG_VALUE_FOR_TYPE
295 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2, "-1000");
296
297 --error ER_WRONG_VALUE_FOR_TYPE
298 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2, "8");
299
300 --error ER_WRONG_VALUE_FOR_TYPE
301 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2, "1000");
302
303 --error ER_WRONG_VALUE_FOR_TYPE
304 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)", 4236), 10, "16.34");
305
306 --error ER_WRONG_VALUE_FOR_TYPE
307 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), -1, 0);
308
309 --error ER_WRONG_VALUE_FOR_TYPE
310 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), -1000, 0);
311
312 --error ER_WRONG_VALUE_FOR_TYPE
313 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2147483648, 0);
314
315 --error ER_WRONG_VALUE_FOR_TYPE
316 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2147483647000, 0);
317
318 --error ER_WRONG_VALUE_FOR_TYPE
319 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), "-1", 0);
320
321 --error ER_WRONG_VALUE_FOR_TYPE
322 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), "-1000", 0);
323
324 --error ER_WRONG_VALUE_FOR_TYPE
325 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), "2147483648", 0);
326
327 --error ER_WRONG_VALUE_FOR_TYPE
328 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), "2147483647000", 0);
329
330 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
331 SELECT ST_ASGEOJSON();
332
333 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
334 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"), 10, 0, 0);
335
336 --error ER_INCORRECT_TYPE
337 SELECT ST_ASGEOJSON(1);
338
339 --error ER_INCORRECT_TYPE
340 SELECT ST_ASGEOJSON(1, 2);
341
342 --error ER_INCORRECT_TYPE
343 SELECT ST_ASGEOJSON(1, 0, 1);
344
345 --error ER_INCORRECT_TYPE
346 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 2.1, 0);
347
348 --error ER_INCORRECT_TYPE
349 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 10, 0.1);
350
351 --error ER_INCORRECT_TYPE
352 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), (CAST(10 AS BINARY)), 0);
353
354 --error ER_INCORRECT_TYPE
355 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 10, (CAST(4 AS BINARY)));
356
357 --error ER_INCORRECT_TYPE
358 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), (CAST(10 AS DECIMAL)), 0);
359
360 --error ER_INCORRECT_TYPE
361 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 20)"), 10, (CAST(4 AS DECIMAL)));
362
363 --error ER_BAD_FIELD_ERROR
364 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"), abc, 0);
365
366 --error ER_BAD_FIELD_ERROR
367 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"), 0, abc);
368
369 --error ER_BAD_FIELD_ERROR
370 SELECT ST_ASGEOJSON("*&$%$123", abc, 0);
371
372 PREPARE stmt FROM "SELECT ST_ASGEOJSON(?, 10, 0)";
373 PREPARE stmt FROM "SELECT ST_ASGEOJSON(POINT(10, 10), ?, 0)";
374 PREPARE stmt FROM "SELECT ST_ASGEOJSON(POINT(10, 10), 10, ?)";
375 PREPARE stmt FROM "SELECT ST_ASGEOJSON(?, ?, 0)";
376 PREPARE stmt FROM "SELECT ST_ASGEOJSON(?, 10, ?)";
377 PREPARE stmt FROM "SELECT ST_ASGEOJSON(POINT(10, 10), ?, ?)";
378 PREPARE stmt FROM "SELECT ST_ASGEOJSON(?, ?, ?)";
379
380 CREATE TABLE t1 (g GEOMETRY);
381
382 --echo # Check that packet overflow is handled correctly.
383 SET @old_max_allowed_packet= @@global.max_allowed_packet;
384 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
385 " LINESTRING(1 2, 3 4, 5 6, 7 8, 9 10, 11 12, 13 14, 15 16, 17 18, 19 20, "
386 " 21 22, 23 24, 25 26, 27 28, 29 30, 31 32, 33 34, 35 36, 37 38, 39 40, "
387 " 41 42, 43 44, 45 46, 47 48, 49 50) "
388 ));
389 SELECT ST_ASTEXT(g) FROM t1;
390 UPDATE t1 SET g = GEOMETRYCOLLECTION(g, g, g, g, g, g, g, g, g, g);
391 UPDATE t1 SET g = GEOMETRYCOLLECTION(g, g, g, g, g, g, g, g, g, g);
392
393 SELECT LENGTH(ST_ASTEXT(g)) FROM t1;
394 SELECT LENGTH(ST_ASGEOJSON(g)) FROM t1;
395
396 SET @@global.max_allowed_packet = 27648;
397
398 # Make a new connection where max_allowed_packet takes effect
399 connect (con1, localhost, root,,);
400
401 SELECT LENGTH(ST_ASGEOJSON(g)) FROM t1;
402 SELECT ST_ASGEOJSON(g) FROM t1;
403
404 # Cleanup
405 disconnect con1;
406 --source include/wait_until_disconnected.inc
407 connection default;
408 SET @@global.max_allowed_packet = @old_max_allowed_packet;
409
410 DELETE FROM t1;
411 --error ER_CANT_CREATE_GEOMETRY_OBJECT
412 INSERT INTO t1 VALUES ("");
413 SELECT ST_ASGEOJSON(g) FROM t1;
414
415 DELETE FROM t1;
416 --error ER_CANT_CREATE_GEOMETRY_OBJECT
417 INSERT INTO t1 VALUES (0x00000000010200000000000000000024400000000000002440);
418 SELECT ST_ASGEOJSON(g) FROM t1;
419
420 DELETE FROM t1;
421 --error ER_CANT_CREATE_GEOMETRY_OBJECT
422 INSERT INTO t1 VALUES (0x00000000010300000000000000000024400000000000002440);
423 SELECT ST_ASGEOJSON(g) FROM t1;
424
425 DELETE FROM t1;
426 --error ER_CANT_CREATE_GEOMETRY_OBJECT
427 INSERT INTO t1 VALUES (0x00000000010300000000000000000024400000000000002440);
428 SELECT ST_ASGEOJSON(g) FROM t1;
429
430 DELETE FROM t1;
431 --error ER_CANT_CREATE_GEOMETRY_OBJECT
432 INSERT INTO t1 VALUES (0x0000000001040000000100000001010000000000000000000000000000);
433 SELECT ST_ASGEOJSON(g) FROM t1;
434
435 DELETE FROM t1;
436 --error ER_CANT_CREATE_GEOMETRY_OBJECT
437 INSERT INTO t1 VALUES (0x000000000107000000010000000107000000010000000101000000000000000000244000000000000024);
438 SELECT ST_ASGEOJSON(g) FROM t1;
439
440 DELETE FROM t1;
441 --error ER_CANT_CREATE_GEOMETRY_OBJECT
442 INSERT INTO t1 VALUES (0x00000000010300000001000000050000000000000000003E4000000000000024400000000000004440000000000000444000000000000034400000000000004440000000000000244000000000000034400000000000003E4000000000000024);
443 SELECT ST_ASGEOJSON(g) FROM t1;
444
445 DELETE FROM t1;
446 --error ER_CANT_CREATE_GEOMETRY_OBJECT
447 INSERT INTO t1 VALUES (0x00000000010300000001000000000000000000000000003E4000000000000024400000000000004440000000000000444000000000000034400000000000004440000000000000244000000000000034400000000000003E400000000000002440);
448 SELECT ST_ASGEOJSON(g) FROM t1;
449
450 DELETE FROM t1;
451 --error ER_CANT_CREATE_GEOMETRY_OBJECT
452 INSERT INTO t1 VALUES (0x00000000010200000001000000000000000000244000000000000024);
453 SELECT ST_ASGEOJSON(g) FROM t1;
454
455 DELETE FROM t1;
456 --error ER_CANT_CREATE_GEOMETRY_OBJECT
457 INSERT INTO t1 VALUES (0x0000000001050000000000000001020000000100000000000000000024400000000000003440);
458 SELECT ST_ASGEOJSON(g) FROM t1;
459
460 DELETE FROM t1;
461 --error ER_CANT_CREATE_GEOMETRY_OBJECT
462 INSERT INTO t1 VALUES (0x0000000001050000000200000001020000000100000000000000000024400000000000003440);
463 SELECT ST_ASGEOJSON(g) FROM t1;
464
465 DELETE FROM t1;
466 --error ER_CANT_CREATE_GEOMETRY_OBJECT
467 INSERT INTO t1 VALUES (0x000000000107000000010000000107000000010000000107000000010000000107000000010000000107000000010000000107000000010000000107000000);
468 SELECT ST_ASGEOJSON(g) FROM t1;
469
470 DROP TABLE t1;
471
472 #####################################################################
473 # ST_GEOMFROMGEOJSON()
474 #####################################################################
475
476 --echo # Checking all valid GeoJSON types
477 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
478 "{ \"type\": \"Point\", \"coordinates\": [102.0, 0.0]}"));
479
480 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
481 "{ \"type\": \"LineString\", \"coordinates\": "
482 "[ [102.0, 0.0], [103.0, 1.0], [104.0, 0.0], [105.0, 1.0] ] }"));
483
484 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
485 "{ \"type\": \"MultiPoint\", \"coordinates\": "
486 "[ [-105.01, 39.57],[-80.66, 35.0] ] }"));
487
488 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
489 " { \"type\": \"MultiLineString\", \"coordinates\": "
490 " [ "
491 " [ "
492 " [-101.5, 39.662], "
493 " [-101.75, 39.2415], "
494 " [-101.23, 39.2415], "
495 " [-101.749, 39.7984], "
496 " [-101.5, 39.011] "
497 " ], "
498 " [ "
499 " [-99.23, 38.6605], "
500 " [-99.56, 38.727], "
501 " [-99.25, 38.018] "
502 " ], "
503 " [ "
504 " [-98.499, 38.913], "
505 " [-98.499, 38.913], "
506 " [-98.38, 38.15], "
507 " [-97.5, 38.629] "
508 " ] "
509 " ] "
510 " }"));
511
512 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
513 " { \"type\": \"Polygon\", \"coordinates\": "
514 " [ "
515 " [ "
516 " [41.83, 71.01], "
517 " [56.95, 33.75], "
518 " [21.79, 36.56], "
519 " [41.83, 71.01] "
520 " ] "
521 " ] "
522 " }"));
523
524 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
525 " { \"type\": \"Polygon\", \"coordinates\": "
526 " [ "
527 " [ "
528 " [41.83, 71.01], "
529 " [56.95, 33.75], "
530 " [21.79, 36.56], "
531 " [41.83, 71.01] "
532 " ], "
533 " [ "
534 " [15.40, 15.40], "
535 " [15.40, 25.40], "
536 " [25.40, 25.40], "
537 " [15.40, 15.40] "
538 " ] "
539 " ] "
540 " }"));
541
542 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
543 " { \"type\": \"MultiPolygon\", \"coordinates\": "
544 " [ "
545 " [ "
546 " [ "
547 " [102.0, 2.0], "
548 " [103.0, 2.0], "
549 " [103.0, 3.0], "
550 " [102.0, 3.0], "
551 " [102.0, 2.0] "
552 " ] "
553 " ], "
554 " [ "
555 " [ "
556 " [100.0, 0.0], "
557 " [101.0, 0.0], "
558 " [101.0, 1.0], "
559 " [100.0, 1.0], "
560 " [100.0, 0.0] "
561 " ] "
562 " ] "
563 " ] "
564 " }"));
565
566 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
567 " { \"type\": \"MultiPolygon\", \"coordinates\": "
568 " [ "
569 " [ "
570 " [ "
571 " [102.0, 2.0], "
572 " [103.0, 2.0], "
573 " [103.0, 3.0], "
574 " [102.0, 3.0], "
575 " [102.0, 2.0] "
576 " ], "
577 " [ "
578 " [1.0, 0.0], "
579 " [0.0, 0.0], "
580 " [0.0, 1.0], "
581 " [1.0, 0.0] "
582 " ] "
583 " ], "
584 " [ "
585 " [ "
586 " [100.0, 0.0], "
587 " [101.0, 0.0], "
588 " [101.0, 1.0], "
589 " [100.0, 1.0], "
590 " [100.0, 0.0] "
591 " ] "
592 " ] "
593 " ] "
594 " }"));
595
596 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
597 " { \"type\": \"GeometryCollection\", \"geometries\": "
598 " [ ] "
599 " }"));
600
601 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
602 " { \"type\": \"GeometryCollection\", \"geometries\": "
603 " [ "
604 " { \"type\": \"GeometryCollection\", \"geometries\": "
605 " [ "
606 " { \"type\": \"GeometryCollection\", \"geometries\": "
607 " [ ] "
608 " } "
609 " ] "
610 " } "
611 " ] "
612 " }"));
613
614 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
615 " { \"type\": \"GeometryCollection\", \"geometries\": "
616 " [ "
617 " { \"type\": \"LineString\", \"coordinates\": "
618 " [ "
619 " [102.0, 0.0], "
620 " [103.0, 1.0], "
621 " [104.0, 0.0], "
622 " [105.0, 1.0] "
623 " ] "
624 " }, "
625 " { \"type\": \"LineString\", \"coordinates\": "
626 " [ "
627 " [102.0, 0.0], "
628 " [103.0, 1.0], "
629 " [104.0, 0.0], "
630 " [105.0, 1.0] "
631 " ] "
632 " } "
633 " ] "
634 " }"));
635
636 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
637 " { \"type\": \"GeometryCollection\", \"geometries\": "
638 " [ "
639 " { \"type\": \"LineString\", \"coordinates\": "
640 " [ "
641 " [102.0, 0.0], "
642 " [103.0, 1.0], "
643 " [104.0, 0.0], "
644 " [105.0, 1.0] "
645 " ] "
646 " }, "
647 " { \"type\": \"LineString\", \"coordinates\": "
648 " [ "
649 " [102.0, 0.0], "
650 " [103.0, 1.0], "
651 " [104.0, 0.0], "
652 " [105.0, 1.0] "
653 " ] "
654 " }, "
655 " { \"type\": \"Point\", \"coordinates\": "
656 " [102.0, 0.0] "
657 " } "
658 " ] "
659 " }"));
660
661 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
662 " { \"type\": \"GeometryCollection\", \"geometries\": "
663 " [ "
664 " { \"type\": \"Point\", \"coordinates\": "
665 " [102.0, 0.5] "
666 " }, "
667 " { \"type\": \"Point\", \"coordinates\": "
668 " [102.0, 0.5] "
669 " }, "
670 " { \"type\": \"GeometryCollection\", \"geometries\": "
671 " [ "
672 " { \"type\": \"Point\", \"coordinates\": "
673 " [102.0, 0.5] "
674 " }, "
675 " { \"type\": \"Point\", \"coordinates\": "
676 " [102.0, 0.5] "
677 " } "
678 " ] "
679 " }, "
680 " { \"type\": \"Point\", \"coordinates\": "
681 " [102.0, 0.5] "
682 " } "
683 " ] "
684 " }"));
685
686 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
687 " { \"type\": \"GeometryCollection\", \"geometries\": "
688 " [ "
689 " { \"type\": \"MultiPoint\", \"coordinates\": "
690 " [ "
691 " [-105.01, 39.57], "
692 " [-80.66, 35.0] "
693 " ] "
694 " }, "
695 " { \"type\": \"Point\", \"coordinates\": "
696 " [102.0, 0.5] "
697 " }, "
698 " { \"type\": \"Point\", \"coordinates\": "
699 " [102.0, 0.5] "
700 " }, "
701 " { \"type\": \"GeometryCollection\", \"geometries\": "
702 " [ "
703 " { \"type\": \"Point\", \"coordinates\": "
704 " [102.0, 0.5] "
705 " }, "
706 " { \"type\": \"Point\", \"coordinates\": "
707 " [102.0, 0.5] "
708 " } "
709 " ] "
710 " }, "
711 " { \"type\": \"Point\", \"coordinates\": "
712 " [102.0, 0.5] "
713 " } "
714 " ] "
715 " }"));
716
717 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
718 " { \"type\": \"GeometryCollection\", \"geometries\": "
719 " [ "
720 " { \"type\": \"Point\", \"coordinates\": "
721 " [-105.01621, 39.57422] "
722 " }, "
723 " { \"type\": \"MultiPoint\", \"coordinates\": "
724 " [ "
725 " [-105.01, 39.57], "
726 " [-80.66, 35.05] "
727 " ] "
728 " }, "
729 " { \"type\": \"LineString\", \"coordinates\": "
730 " [ "
731 " [-101.5, 39.662], "
732 " [-101.75, 39.2415], "
733 " [-101.64, 39.2415] "
734 " ] "
735 " }, "
736 " { \"type\": \"MultiLineString\", \"coordinates\": "
737 " [ "
738 " [ "
739 " [-101.5, 39.662], "
740 " [-101.75, 39.2415], "
741 " [-101.23, 39.2415], "
742 " [-101.749, 39.7984], "
743 " [-101.5, 39.011] "
744 " ], "
745 " [ "
746 " [-99.23, 38.6605], "
747 " [-99.56, 38.727], "
748 " [-99.25, 38.018] "
749 " ], "
750 " [ "
751 " [-98.499, 38.913], "
752 " [-98.499, 38.913], "
753 " [-98.38, 38.15], "
754 " [-97.5, 38.629] "
755 " ] "
756 " ] "
757 " }, "
758 " { \"type\": \"Polygon\", \"coordinates\": "
759 " [ "
760 " [ "
761 " [41.83,71.01], "
762 " [56.95,33.75], "
763 " [21.79,36.56], "
764 " [41.83,71.01] "
765 " ] "
766 " ] "
767 " }, "
768 " { \"type\": \"MultiPolygon\", \"coordinates\": "
769 " [ "
770 " [ "
771 " [ "
772 " [102.0, 2.0], "
773 " [103.0, 2.0], "
774 " [103.0, 3.0], "
775 " [102.0, 3.0], "
776 " [102.0, 2.0] "
777 " ] "
778 " ], "
779 " [ "
780 " [ "
781 " [100.0, 0.0], "
782 " [101.0, 0.0], "
783 " [101.0, 1.0], "
784 " [100.0, 1.0], "
785 " [100.0, 0.0] "
786 " ] "
787 " ] "
788 " ] "
789 " } "
790 " ] "
791 " }"));
792
793 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
794 " { "
795 " \"type\": \"Feature\", \"id\": \"stadium\", \"geometry\": "
796 " { \"type\": \"Point\", \"coordinates\": "
797 " [-104.99404, 39.75621] "
798 " }, "
799 " \"properties\": "
800 " { "
801 " \"name\": \"Coors Field\", "
802 " \"amenity\": \"Baseball Stadium\", "
803 " \"popupContent\": \"This is where the Rockies play!\" "
804 " } "
805 " }"));
806
807 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
808 " { \"type\": \"FeatureCollection\", \"features\": "
809 " [ "
810 " { \"type\": \"Feature\", \"geometry\": "
811 " { \"type\": \"Point\", \"coordinates\": "
812 " [-80.83775386582222, 35.24980190252168] "
813 " }, "
814 " \"properties\": "
815 " { "
816 " \"name\": \"DOUBLE OAKS CENTER\", "
817 " \"address\": \"1326 WOODWARD AV\" "
818 " } "
819 " }, "
820 " { \"type\": \"Feature\", \"geometry\": "
821 " { \"type\": \"Point\", \"coordinates\": "
822 " [-80.83827000459532, 35.25674709224663] "
823 " }, "
824 " \"properties\": "
825 " { "
826 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
827 " \"address\": \"2605 DOUBLE OAKS RD\" "
828 " } "
829 " } "
830 " ] "
831 " }"));
832
833 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
834 " { \"type\": \"FeatureCollection\", \"features\": "
835 " [ "
836 " { \"type\": \"Feature\", \"geometry\": "
837 " { \"type\": \"Point\", \"coordinates\": "
838 " [-80.83775386582222, 35.24980190252168] "
839 " }, "
840 " \"properties\": "
841 " { "
842 " \"name\": \"DOUBLE OAKS CENTER\", "
843 " \"address\": \"1326 WOODWARD AV\" "
844 " } "
845 " }, "
846 " { \"type\": \"Feature\", \"geometry\": "
847 " { \"type\": \"Point\", \"coordinates\": "
848 " [-80.83827000459532, 35.25674709224663] "
849 " }, "
850 " \"properties\": "
851 " { "
852 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
853 " \"address\": \"2605 DOUBLE OAKS RD\" "
854 " } "
855 " }, "
856 " { \"type\": \"Feature\", \"geometry\": "
857 " null, "
858 " \"properties\": "
859 " { "
860 " \"descr\": \"A NULL/EMPTY POINT\" "
861 " } "
862 " }, "
863 " { \"type\": \"Feature\", \"geometry\": "
864 " { \"type\": \"Point\", \"coordinates\": "
865 " [-87.83827000459532, 42.0] "
866 " }, "
867 " \"properties\": "
868 " { "
869 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
870 " \"address\": \"2605 DOUBLE OAKS RD\" "
871 " } "
872 " } "
873 " ] "
874 " }"));
875
876 --echo # Checking that E notation is supported.
877 # Force SRID 0 to avoid coordinate range check.
878 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
879 "{ \"type\": \"Point\", \"coordinates\": [1.23e3, 2.2e-1]}", 1, 0));
880
881 # Force SRID 0 to avoid coordinate range check.
882 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
883 "{ \"type\": \"Point\", \"coordinates\": [1e-300, 1e300]}", 1, 0));
884
885 # Force SRID 0 to avoid coordinate range check.
886 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
887 "{ \"type\": \"Point\", \"coordinates\": [1.7976931348623157E+308, -1.7976931348623157E+308]}", 1, 0));
888
889 --echo # Checking for NULL arguments and GeoJSON null objects
890 SELECT ST_GEOMFROMGEOJSON(NULL);
891
892 SELECT ST_GEOMFROMGEOJSON(NULL, 1);
893
894 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"Point\", \"coordinates\": [102.0, 0.0]}",
895 NULL);
896
897 SELECT ST_GEOMFROMGEOJSON(NULL, NULL, NULL);
898
899 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"Point\", \"coordinates\": [102.0, 0.0]}",
900 NULL, NULL);
901
902 SELECT ST_GEOMFROMGEOJSON(NULL, 1, NULL);
903
904 SELECT ST_GEOMFROMGEOJSON(NULL, NULL, 4326);
905
906 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"Point\", \"coordinates\": [102.0, 0.0]}",
907 1, NULL);
908
909 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"Point\", \"coordinates\": [102.0, 0.0]}",
910 NULL, 4326);
911
912 SELECT ST_GEOMFROMGEOJSON(NULL, 1, 4326);
913
914 SELECT ST_GEOMFROMGEOJSON(
915 " { \"type\": \"Feature\", \"geometry\": null, \"properties\": "
916 " { \"foo\": \"bar\" } "
917 " }");
918
919 --echo # Checking for case sensitivity/insensitivity
920 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
921 " { "
922 " \"type\": \"Feature\", \"GeOmEtRy\": "
923 " { \"TYPE\": \"Point\", \"COORDINATES\": "
924 " [-104.99404, 39.75621] "
925 " }, "
926 " \"PrOPERtiES\": "
927 " { "
928 " \"name\": \"Coors Field\", "
929 " \"amenity\": \"Baseball Stadium\", "
930 " \"popupContent\": \"This is where the Rockies play!\" "
931 " } "
932 " }"));
933
934 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
935 "{ \"TyPe\": \"Point\", \"cOoRdInAtEs\": [102.0, 0.0]}"));
936
937 --error ER_SRS_NOT_FOUND
938 SELECT ST_GEOMFROMGEOJSON(
939 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
940 " \"CRS\": "
941 " { \"TYPE\": \"name\", \"PROPERTIES\": "
942 " { \"NAME\": \"urn:ogc:def:crs:EPSG::1234\" } "
943 " } "
944 " }");
945
946 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
947 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
948 " \"crs\": "
949 " { \"type\": \"name\", \"properties\": "
950 " { \"name\": \"urn:ogc:def:crs:OGC:1.3:crs84\" } "
951 " } "
952 " }", 1));
953
954 --error ER_SRS_NOT_FOUND
955 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
956 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
957 " \"crs\": "
958 " { \"type\": \"name\", \"properties\": "
959 " { \"name\": \"urn:ogc:def:crs:OGC:1.3:crs84\" } "
960 " } "
961 " }", 1, 10));
962
963
964 --error ER_INVALID_GEOJSON_UNSPECIFIED
965 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
966 "{ \"type\": \"point\", \"coordinates\": [102.0, 0.0]}"));
967
968 --error ER_INVALID_GEOJSON_UNSPECIFIED
969 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
970 "{ \"type\": \"multiPoint\", \"coordinates\": [102.0, 0.0]}"));
971
972 --error ER_INVALID_GEOJSON_UNSPECIFIED
973 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
974 "{ \"type\": \"Linestring\", \"coordinates\": [102.0, 0.0]}"));
975
976 --error ER_INVALID_GEOJSON_UNSPECIFIED
977 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
978 "{ \"type\": \"multiLinestring\", \"coordinates\": [102.0, 0.0]}"));
979
980 --error ER_INVALID_GEOJSON_UNSPECIFIED
981 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
982 "{ \"type\": \"polygon\", \"coordinates\": [102.0, 0.0]}"));
983
984 --error ER_INVALID_GEOJSON_UNSPECIFIED
985 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
986 "{ \"type\": \"MultiPolyGoN\", \"coordinates\": [102.0, 0.0]}"));
987
988 --error ER_INVALID_GEOJSON_UNSPECIFIED
989 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
990 "{ \"type\": \"GEOMETRYCOLLECTION\", \"coordinates\": [102.0, 0.0]}"));
991
992 --echo # Checking invalid/incorrect JSON and GeoJSON inputs
993 --error ER_INVALID_JSON_TEXT_IN_PARAM
994 SELECT ST_GEOMFROMGEOJSON("");
995
996 --error ER_INVALID_GEOJSON_MISSING_MEMBER
997 SELECT ST_GEOMFROMGEOJSON("{}");
998
999 --error ER_INVALID_JSON_TEXT_IN_PARAM
1000 SELECT ST_GEOMFROMGEOJSON("()");
1001
1002 --error ER_INVALID_GEOJSON_UNSPECIFIED
1003 SELECT ST_GEOMFROMGEOJSON("[]");
1004
1005 --error ER_INVALID_JSON_TEXT_IN_PARAM
1006 SELECT ST_GEOMFROMGEOJSON("NULL");
1007
1008 --error ER_INVALID_GEOJSON_UNSPECIFIED
1009 SELECT ST_GEOMFROMGEOJSON(
1010 "{ "
1011 " \"type\": \"FeatureCollection\", "
1012 " \"features\": [ "
1013 " { "
1014 " \"type\": \"FeatureCollection\", "
1015 " \"features\": [] "
1016 " }, "
1017 " { "
1018 " \"type\": \"Feature\", "
1019 " \"geometry\": { \"type\": \"Point\", \"coordinates\": [10, 10] }, "
1020 " \"properties\": null "
1021 " } "
1022 " ] "
1023 "}");
1024
1025 --error ER_INCORRECT_TYPE
1026 SELECT ST_GEOMFROMGEOJSON(CAST(
1027 "{ "
1028 " \"type\": \"FeatureCollection\", "
1029 " \"features\": [ "
1030 " { "
1031 " \"type\": \"FeatureCollection\", "
1032 " \"features\": [] "
1033 " }, "
1034 " { "
1035 " \"type\": \"Feature\", "
1036 " \"geometry\": { \"type\": \"Point\", \"coordinates\": [10, 10] }, "
1037 " \"properties\": null "
1038 " } "
1039 " ] "
1040 "}" AS BINARY));
1041
1042 --error ER_INCORRECT_TYPE
1043 SELECT ST_GEOMFROMGEOJSON(CAST(
1044 "{ "
1045 " \"type\": \"FeatureCollection\", "
1046 " \"features\": [ "
1047 " { "
1048 " \"type\": \"FeatureCollection\", "
1049 " \"features\": [] "
1050 " }, "
1051 " { "
1052 " \"type\": \"Feature\", "
1053 " \"geometry\": { \"type\": \"Point\", \"coordinates\": [10, 10] }, "
1054 " \"properties\": null "
1055 " } "
1056 " ] "
1057 "}" AS DATE));
1058
1059 --echo # Checking correct handling of different coordinate dimensions (option one (default option))
1060 --error ER_INVALID_GEOJSON_UNSPECIFIED
1061 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1062 "{ \"type\": \"Point\", \"coordinates\": [] }"));
1063
1064 --error ER_INVALID_GEOJSON_UNSPECIFIED
1065 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1066 "{ \"type\": \"Point\", \"coordinates\": [10] }"));
1067
1068 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1069 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }"));
1070
1071 --error ER_DIMENSION_UNSUPPORTED
1072 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1073 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }"));
1074
1075 --error ER_DIMENSION_UNSUPPORTED
1076 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1077 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }"));
1078
1079 --error ER_INVALID_GEOJSON_UNSPECIFIED
1080 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1081 "{ \"type\": \"Point\", \"coordinates\": [] }", 1));
1082
1083 --error ER_INVALID_GEOJSON_UNSPECIFIED
1084 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1085 "{ \"type\": \"Point\", \"coordinates\": [10] }", 1));
1086
1087 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1088 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1));
1089
1090 --error ER_DIMENSION_UNSUPPORTED
1091 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1092 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", 1));
1093
1094 --error ER_DIMENSION_UNSUPPORTED
1095 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1096 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", 1));
1097
1098 --error ER_INVALID_GEOJSON_UNSPECIFIED
1099 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1100 "{ \"type\": \"Point\", \"coordinates\": [] }", "1"));
1101
1102 --error ER_INVALID_GEOJSON_UNSPECIFIED
1103 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1104 "{ \"type\": \"Point\", \"coordinates\": [10] }", "1"));
1105
1106 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1107 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "1"));
1108
1109 --error ER_DIMENSION_UNSUPPORTED
1110 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1111 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", "1"));
1112
1113 --error ER_DIMENSION_UNSUPPORTED
1114 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1115 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", "1"));
1116
1117 --echo # Checking correct handling of different coordinate dimensions (option two)
1118 --error ER_INVALID_GEOJSON_UNSPECIFIED
1119 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1120 "{ \"type\": \"Point\", \"coordinates\": [] }", 2));
1121
1122 --error ER_INVALID_GEOJSON_UNSPECIFIED
1123 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1124 "{ \"type\": \"Point\", \"coordinates\": [10] }", 2));
1125
1126 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1127 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 2));
1128
1129 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1130 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", 2));
1131
1132 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1133 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", 2));
1134
1135 --error ER_INVALID_GEOJSON_UNSPECIFIED
1136 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1137 "{ \"type\": \"Point\", \"coordinates\": [] }", "2"));
1138
1139 --error ER_INVALID_GEOJSON_UNSPECIFIED
1140 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1141 "{ \"type\": \"Point\", \"coordinates\": [10] }", "2"));
1142
1143 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1144 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "2"));
1145
1146 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1147 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", "2"));
1148
1149 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1150 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", "2"));
1151
1152 --echo # Checking correct handling of different coordinate dimensions (option three)
1153 --error ER_INVALID_GEOJSON_UNSPECIFIED
1154 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1155 "{ \"type\": \"Point\", \"coordinates\": [] }", 3));
1156
1157 --error ER_INVALID_GEOJSON_UNSPECIFIED
1158 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1159 "{ \"type\": \"Point\", \"coordinates\": [10] }", 3));
1160
1161 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1162 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 3));
1163
1164 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1165 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", 3));
1166
1167 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1168 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", 3));
1169
1170 --error ER_INVALID_GEOJSON_UNSPECIFIED
1171 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1172 "{ \"type\": \"Point\", \"coordinates\": [] }", "3"));
1173
1174 --error ER_INVALID_GEOJSON_UNSPECIFIED
1175 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1176 "{ \"type\": \"Point\", \"coordinates\": [10] }", "3"));
1177
1178 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1179 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "3"));
1180
1181 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1182 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", "3"));
1183
1184 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1185 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", "3"));
1186
1187 --echo # Checking correct handling of different coordinate dimensions (option four)
1188 --error ER_INVALID_GEOJSON_UNSPECIFIED
1189 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1190 "{ \"type\": \"Point\", \"coordinates\": [] }", 4));
1191
1192 --error ER_INVALID_GEOJSON_UNSPECIFIED
1193 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1194 "{ \"type\": \"Point\", \"coordinates\": [10] }", 4));
1195
1196 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1197 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 4));
1198
1199 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1200 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", 4));
1201
1202 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1203 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", 4));
1204
1205 --error ER_INVALID_GEOJSON_UNSPECIFIED
1206 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1207 "{ \"type\": \"Point\", \"coordinates\": [] }", "4"));
1208
1209 --error ER_INVALID_GEOJSON_UNSPECIFIED
1210 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1211 "{ \"type\": \"Point\", \"coordinates\": [10] }", "4"));
1212
1213 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1214 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "4"));
1215
1216 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1217 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", "4"));
1218
1219 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1220 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", "4"));
1221
1222 --echo # Checking with valid ST_SRID value
1223 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1224 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, 0));
1225
1226 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1227 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", 2, 0));
1228
1229 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1230 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20] }", 3, 0));
1231
1232 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1233 "{ \"type\": \"Point\", \"coordinates\": [10, 15, 20, 25] }", 4, 0));
1234
1235 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1236 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, "0"));
1237
1238 --error ER_INCORRECT_TYPE
1239 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1240 "{ \"type\": \"Point\", \"coordinates\": [102.0, 0.0]}", SUM(1), SUM(4326)));
1241
1242 --error ER_INCORRECT_TYPE
1243 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1244 "{ \"type\": \"Point\", \"coordinates\": [102.0, 0.0]}", AVG(1), AVG(4326)));
1245
1246 -- echo # Various GeoJSON specification details
1247 # Name must be a string.
1248 --error ER_INVALID_JSON_TEXT_IN_PARAM
1249 SELECT ST_GEOMFROMGEOJSON("{ type: \"Point\", \"coordinates\": [42, 42] }");
1250
1251 # Root must be geometry, feature or feature collection.
1252 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1253 SELECT ST_GEOMFROMGEOJSON(
1254 " { \"label\": \"foo\", \"data\": "
1255 " { \"type\": \"Point\", \"coordinates\": "
1256 " [10, 12] "
1257 " } "
1258 " }");
1259
1260 # Objects MUST have member with name "type" of type string.
1261 --error ER_INVALID_JSON_TEXT_IN_PARAM
1262 SELECT ST_GEOMFROMGEOJSON("{ \"type\": Point, \"coordinates\": [10, 10] }");
1263
1264 --error ER_INVALID_GEOJSON_WRONG_TYPE
1265 SELECT ST_GEOMFROMGEOJSON("{ \"type\": [ \"Point\" ], \"coordinates\": [10, 10] }");
1266
1267 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1268 SELECT ST_GEOMFROMGEOJSON("{ \"typ\": \"Point\", \"coordinates\": [10, 10] }");
1269
1270 --echo # Checking "type" member with invalid string
1271 --error ER_INVALID_GEOJSON_UNSPECIFIED
1272 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"point\", \"coordinates\": [10, 10] }");
1273
1274 --error ER_INVALID_GEOJSON_UNSPECIFIED
1275 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"POINT\", \"coordinates\": [10, 10] }");
1276
1277 --error ER_INVALID_GEOJSON_UNSPECIFIED
1278 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1279 "{ \"type\": \"linestring\", \"coordinates\": "
1280 "[ [102.0, 0.0], [103.0, 1.0], [104.0, 0.0], [105.0, 1.0] ] }"));
1281
1282 --error ER_INVALID_GEOJSON_UNSPECIFIED
1283 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1284 "{ \"type\": \"LINESTRING\", \"coordinates\": "
1285 "[ [102.0, 0.0], [103.0, 1.0], [104.0, 0.0], [105.0, 1.0] ] }"));
1286
1287 --error ER_INVALID_GEOJSON_UNSPECIFIED
1288 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1289 " { \"type\": \"polygon\", \"coordinates\": "
1290 " [ "
1291 " [ "
1292 " [41.83, 71.01], "
1293 " [56.95, 33.75], "
1294 " [21.79, 36.56], "
1295 " [41.83, 71.01] "
1296 " ] "
1297 " ] "
1298 " }"));
1299
1300 --error ER_INVALID_GEOJSON_UNSPECIFIED
1301 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1302 " { \"type\": \"POLYGON\", \"coordinates\": "
1303 " [ "
1304 " [ "
1305 " [41.83, 71.01], "
1306 " [56.95, 33.75], "
1307 " [21.79, 36.56], "
1308 " [41.83, 71.01] "
1309 " ] "
1310 " ] "
1311 " }"));
1312
1313 --error ER_INVALID_GEOJSON_UNSPECIFIED
1314 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1315 "{ \"type\": \"multipoint\", \"coordinates\": "
1316 "[ [-105.01,39.57],[-80.66,35.0] ] }"));
1317
1318 --error ER_INVALID_GEOJSON_UNSPECIFIED
1319 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1320 "{ \"type\": \"MULTIPOINT\", \"coordinates\": "
1321 "[ [-105.01,39.57],[-80.66,35.0] ] }"));
1322
1323 --error ER_INVALID_GEOJSON_UNSPECIFIED
1324 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1325 " { \"type\": \"multilinestring\", \"coordinates\": "
1326 " [ "
1327 " [ "
1328 " [-101.5, 39.662], "
1329 " [-101.75, 39.2415], "
1330 " [-101.23, 39.2415], "
1331 " [-101.749, 39.7984], "
1332 " [-101.5, 39.011] "
1333 " ], "
1334 " [ "
1335 " [-99.23, 38.6605], "
1336 " [-99.56, 38.727], "
1337 " [-99.25, 38.018] "
1338 " ], "
1339 " [ "
1340 " [-98.499, 38.913], "
1341 " [-98.499, 38.913], "
1342 " [-98.38, 38.15], "
1343 " [-97.5, 38.629] "
1344 " ] "
1345 " ] "
1346 " }"));
1347
1348 --error ER_INVALID_GEOJSON_UNSPECIFIED
1349 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1350 " { \"type\": \"MULTILINESTRING\", \"coordinates\": "
1351 " [ "
1352 " [ "
1353 " [-101.5, 39.662], "
1354 " [-101.75, 39.2415], "
1355 " [-101.23, 39.2415], "
1356 " [-101.749, 39.7984], "
1357 " [-101.5, 39.011] "
1358 " ], "
1359 " [ "
1360 " [-99.23, 38.6605], "
1361 " [-99.56, 38.727], "
1362 " [-99.25, 38.018] "
1363 " ], "
1364 " [ "
1365 " [-98.499, 38.913], "
1366 " [-98.499, 38.913], "
1367 " [-98.38, 38.15], "
1368 " [-97.5, 38.629] "
1369 " ] "
1370 " ] "
1371 " }"));
1372
1373 --error ER_INVALID_GEOJSON_UNSPECIFIED
1374 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1375 " { \"type\": \"multipolygon\", \"coordinates\": "
1376 " [ "
1377 " [ "
1378 " [ "
1379 " [102.0, 2.0], "
1380 " [103.0, 2.0], "
1381 " [103.0, 3.0], "
1382 " [102.0, 3.0], "
1383 " [102.0, 2.0] "
1384 " ] "
1385 " ], "
1386 " [ "
1387 " [ "
1388 " [100.0, 0.0], "
1389 " [101.0, 0.0], "
1390 " [101.0, 1.0], "
1391 " [100.0, 1.0], "
1392 " [100.0, 0.0] "
1393 " ] "
1394 " ] "
1395 " ] "
1396 " }"));
1397
1398 --error ER_INVALID_GEOJSON_UNSPECIFIED
1399 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1400 " { \"type\": \"MULTIPOLYGON\", \"coordinates\": "
1401 " [ "
1402 " [ "
1403 " [ "
1404 " [102.0, 2.0], "
1405 " [103.0, 2.0], "
1406 " [103.0, 3.0], "
1407 " [102.0, 3.0], "
1408 " [102.0, 2.0] "
1409 " ] "
1410 " ], "
1411 " [ "
1412 " [ "
1413 " [100.0, 0.0], "
1414 " [101.0, 0.0], "
1415 " [101.0, 1.0], "
1416 " [100.0, 1.0], "
1417 " [100.0, 0.0] "
1418 " ] "
1419 " ] "
1420 " ] "
1421 " }"));
1422
1423 --error ER_INVALID_GEOJSON_UNSPECIFIED
1424 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1425 " { \"type\": \"geometrycollection\", \"geometries\": "
1426 " [ "
1427 " { \"type\": \"LineString\", \"coordinates\": "
1428 " [ "
1429 " [102.0, 0.0], "
1430 " [103.0, 1.0], "
1431 " [104.0, 0.0], "
1432 " [105.0, 1.0] "
1433 " ] "
1434 " }, "
1435 " { \"type\": \"LineString\", \"coordinates\": "
1436 " [ "
1437 " [102.0, 0.0], "
1438 " [103.0, 1.0], "
1439 " [104.0, 0.0], "
1440 " [105.0, 1.0] "
1441 " ] "
1442 " } "
1443 " ] "
1444 " }"));
1445
1446 --error ER_INVALID_GEOJSON_UNSPECIFIED
1447 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1448 " { \"type\": \"GEOMETRYCOLLECTION\", \"geometries\": "
1449 " [ "
1450 " { \"type\": \"LineString\", \"coordinates\": "
1451 " [ "
1452 " [102.0, 0.0], "
1453 " [103.0, 1.0], "
1454 " [104.0, 0.0], "
1455 " [105.0, 1.0] "
1456 " ] "
1457 " }, "
1458 " { \"type\": \"LineString\", \"coordinates\": "
1459 " [ "
1460 " [102.0, 0.0], "
1461 " [103.0, 1.0], "
1462 " [104.0, 0.0], "
1463 " [105.0, 1.0] "
1464 " ] "
1465 " } "
1466 " ] "
1467 " }"));
1468
1469 --error ER_INVALID_GEOJSON_UNSPECIFIED
1470 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1471 " { "
1472 " \"type\": \"feature\", \"id\": \"stadium\", \"geometry\": "
1473 " { \"type\": \"Point\", \"coordinates\": "
1474 " [-104.99404, 39.75621] "
1475 " }, "
1476 " \"properties\": "
1477 " { "
1478 " \"name\": \"Coors Field\", "
1479 " \"amenity\": \"Baseball Stadium\", "
1480 " \"popupContent\": \"This is where the Rockies play!\" "
1481 " } "
1482 " }"));
1483
1484 --error ER_INVALID_GEOJSON_UNSPECIFIED
1485 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1486 " { "
1487 " \"type\": \"FEATURE\", \"id\": \"stadium\", \"geometry\": "
1488 " { \"type\": \"Point\", \"coordinates\": "
1489 " [-104.99404, 39.75621] "
1490 " }, "
1491 " \"properties\": "
1492 " { "
1493 " \"name\": \"Coors Field\", "
1494 " \"amenity\": \"Baseball Stadium\", "
1495 " \"popupContent\": \"This is where the Rockies play!\" "
1496 " } "
1497 " }"));
1498
1499 --error ER_INVALID_GEOJSON_UNSPECIFIED
1500 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1501 " { \"type\": \"featurecollection\", \"features\": "
1502 " [ "
1503 " { \"type\": \"Feature\", \"geometry\": "
1504 " { \"type\": \"Point\", \"coordinates\": "
1505 " [-80.83775386582222, 35.24980190252168] "
1506 " }, "
1507 " \"properties\": "
1508 " { "
1509 " \"name\": \"DOUBLE OAKS CENTER\", "
1510 " \"address\": \"1326 WOODWARD AV\" "
1511 " } "
1512 " }, "
1513 " { \"type\": \"Feature\", \"geometry\": "
1514 " { \"type\": \"Point\", \"coordinates\": "
1515 " [-80.83827000459532, 35.25674709224663] "
1516 " }, "
1517 " \"properties\": "
1518 " { "
1519 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
1520 " \"address\": \"2605 DOUBLE OAKS RD\" "
1521 " } "
1522 " } "
1523 " ] "
1524 " }"));
1525
1526 --error ER_INVALID_GEOJSON_UNSPECIFIED
1527 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1528 " { \"type\": \"FEATURECOLLECTION\", \"features\": "
1529 " [ "
1530 " { \"type\": \"Feature\", \"geometry\": "
1531 " { \"type\": \"Point\", \"coordinates\": "
1532 " [-80.83775386582222, 35.24980190252168] "
1533 " }, "
1534 " \"properties\": "
1535 " { "
1536 " \"name\": \"DOUBLE OAKS CENTER\", "
1537 " \"address\": \"1326 WOODWARD AV\" "
1538 " } "
1539 " }, "
1540 " { \"type\": \"Feature\", \"geometry\": "
1541 " { \"type\": \"Point\", \"coordinates\": "
1542 " [-80.83827000459532, 35.25674709224663] "
1543 " }, "
1544 " \"properties\": "
1545 " { "
1546 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
1547 " \"address\": \"2605 DOUBLE OAKS RD\" "
1548 " } "
1549 " } "
1550 " ] "
1551 " }"));
1552
1553 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1554 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"Feature\", \"coordinates\": [10, 10] }");
1555
1556 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1557 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"FeatureCollection\", \"coordinates\": [10, 10] }");
1558
1559 # Geometry other than GeometryCollection must have member "coordinates" which is
1560 # always an array.
1561 --error ER_INVALID_GEOJSON_WRONG_TYPE
1562 SELECT ST_GEOMFROMGEOJSON(
1563 "{ \"type\": \"Point\",\"coordinates\": \"[42, 42]\" }");
1564
1565 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1566 SELECT ST_GEOMFROMGEOJSON(
1567 "{ \"type\": \"Point\",\"cordinates\": [42, 42] }");
1568
1569 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1570 SELECT ST_GEOMFROMGEOJSON(
1571 "{ \"type\": \"Point\",\"cordinates\": \"42, 42\" }");
1572
1573 # A geometry collection must have a member with the name "geometries". The value
1574 # corresponding to "geometries" is an array. Each element in this array is a
1575 # GeoJSON geometry object.
1576 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1577 SELECT ST_GEOMFROMGEOJSON(
1578 " { \"type\": \"GeometryCollection\", \"geometrie\": "
1579 " [ "
1580 " { \"type\": \"Point\", \"coordinates\": "
1581 " [0, 0] "
1582 " } "
1583 " ] "
1584 " }");
1585
1586 --error ER_INVALID_GEOJSON_WRONG_TYPE
1587 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"GeometryCollection\", \"geometries\": { \"type\": \"Point\", \"coordinates\": [0, 0] } }");
1588
1589 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1590 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"Feature\", \"geometry\": { \"type\": \"Point\", \"coordinates\": [0, 0] } }");
1591
1592 # Test CRS parsing
1593 # If no CRS found, set ST_SRID to 4326
1594 --echo # Testing CRS Parsing and ST_SRID handling
1595 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1596 "{ \"type\": \"Point\", \"coordinates\": [10, 20] }"));
1597
1598 --error ER_SRS_NOT_FOUND
1599 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1600 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1601 " \"crs\": "
1602 " { \"type\": \"name\", \"properties\": "
1603 " { \"name\": \"urn:ogc:def:crs:EPSG::1234\" } "
1604 " } "
1605 " }"));
1606
1607 --error ER_SRS_NOT_FOUND
1608 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1609 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1610 " \"crs\": "
1611 " { \"type\": \"name\", \"properties\": "
1612 " { \"name\": \"urn:ogc:def:crs:EPSG::1\" } "
1613 " } "
1614 " }"));
1615
1616 --error ER_SRS_NOT_FOUND
1617 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1618 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1619 " \"crs\": "
1620 " { \"type\": \"name\", \"properties\": "
1621 " { \"name\": \"urn:ogc:def:crs:EPSG::4294967295\" } "
1622 " } "
1623 " }"));
1624
1625 --error ER_SRS_NOT_FOUND
1626 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1627 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1628 " \"crs\": "
1629 " { \"type\": \"name\", \"properties\": "
1630 " { \"name\": \"EPSG:234\" } "
1631 " } "
1632 " }"));
1633
1634 --error ER_SRS_NOT_FOUND
1635 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1636 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1637 " \"crs\": "
1638 " { \"type\": \"name\", \"properties\": "
1639 " { \"name\": \"EPSG:1\" } "
1640 " } "
1641 " }"));
1642
1643 --error ER_SRS_NOT_FOUND
1644 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1645 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1646 " \"crs\": "
1647 " { \"type\": \"name\", \"properties\": "
1648 " { \"name\": \"EPSG:4294967295\" } "
1649 " } "
1650 " }"));
1651
1652 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1653 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1654 " \"crs\": null "
1655 " }"));
1656
1657 --error ER_INVALID_GEOJSON_UNSPECIFIED
1658 SELECT ST_GEOMFROMGEOJSON(
1659 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1660 " \"crs\": "
1661 " { \"type\": \"name\", \"properties\": "
1662 " { \"name\": \"EPSG:4294967296\" } "
1663 " } "
1664 " }");
1665
1666 --error ER_INVALID_GEOJSON_UNSPECIFIED
1667 SELECT ST_GEOMFROMGEOJSON(
1668 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1669 " \"crs\": "
1670 " { \"type\": \"name\", \"properties\": "
1671 " { \"name\": \"EPSG:0\" } "
1672 " } "
1673 " }");
1674
1675 --error ER_INVALID_GEOJSON_UNSPECIFIED
1676 SELECT ST_GEOMFROMGEOJSON(
1677 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1678 " \"crs\": "
1679 " { \"type\": \"name\", \"properties\": "
1680 " { \"name\": \"EPSG:-1\" } "
1681 " } "
1682 " }");
1683
1684 --error ER_INVALID_GEOJSON_UNSPECIFIED
1685 SELECT ST_GEOMFROMGEOJSON(
1686 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1687 " \"crs\": "
1688 " { \"type\": \"name\", \"properties\": "
1689 " { \"name\": \"EPSG:-2147483648\" } "
1690 " } "
1691 " }");
1692
1693 --error ER_INVALID_GEOJSON_UNSPECIFIED
1694 SELECT ST_GEOMFROMGEOJSON(
1695 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1696 " \"crs\": "
1697 " { \"type\": \"name\", \"properties\": "
1698 " { \"name\": \"urn:ogc:def:crs:EPSG::0\" } "
1699 " } "
1700 " }");
1701
1702 --error ER_INVALID_GEOJSON_UNSPECIFIED
1703 SELECT ST_GEOMFROMGEOJSON(
1704 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1705 " \"crs\": "
1706 " { \"type\": \"name\", \"properties\": "
1707 " { \"name\": \"urn:ogc:def:crs:EPSG::-1\" } "
1708 " } "
1709 " }");
1710
1711 --error ER_INVALID_GEOJSON_UNSPECIFIED
1712 SELECT ST_GEOMFROMGEOJSON(
1713 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1714 " \"crs\": "
1715 " { \"type\": \"name\", \"properties\": "
1716 " { \"name\": \"urn:ogc:def:crs:EPSG::-2147483648\" } "
1717 " } "
1718 " }");
1719
1720 --error ER_INVALID_GEOJSON_UNSPECIFIED
1721 SELECT ST_GEOMFROMGEOJSON(
1722 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1723 " \"crs\": "
1724 " { \"type\": \"name\", \"properties\": "
1725 " { \"name\": \"urn:ogc:def:crs:EPSG:4326\" } "
1726 " } "
1727 " }");
1728
1729 --error ER_INVALID_GEOJSON_UNSPECIFIED
1730 SELECT ST_GEOMFROMGEOJSON(
1731 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1732 " \"crs\": "
1733 " { \"type\": \"name\", \"properties\": "
1734 " { \"name\": \"ogc:def:crs:EPSG::4326\" } "
1735 " } "
1736 " }");
1737
1738 --error ER_INVALID_GEOJSON_UNSPECIFIED
1739 SELECT ST_GEOMFROMGEOJSON(
1740 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1741 " \"crs\": "
1742 " { \"type\": \"name\", \"properties\": "
1743 " { \"name\": \"ogc:def:crs:EPSG::\" } "
1744 " } "
1745 " }");
1746
1747 --error ER_INVALID_GEOJSON_UNSPECIFIED
1748 SELECT ST_GEOMFROMGEOJSON(
1749 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1750 " \"crs\": "
1751 " { \"type\": \"name\", \"properties\": "
1752 " { \"name\": \"urn:ogc:def:crs:EPSG::\" } "
1753 " } "
1754 " }");
1755
1756 --error ER_INVALID_GEOJSON_UNSPECIFIED
1757 SELECT ST_GEOMFROMGEOJSON(
1758 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1759 " \"crs\": "
1760 " { \"type\": \"name\", \"properties\": "
1761 " { \"name\": \"\" } "
1762 " } "
1763 " }");
1764
1765 --error ER_INVALID_GEOJSON_UNSPECIFIED
1766 SELECT ST_GEOMFROMGEOJSON(
1767 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1768 " \"crs\": "
1769 " { \"type\": \"name\", \"properties\": "
1770 " { \"name\": \"EPSG=1\" } "
1771 " } "
1772 " }");
1773
1774 --error ER_INVALID_GEOJSON_UNSPECIFIED
1775 SELECT ST_GEOMFROMGEOJSON(
1776 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1777 " \"crs\": "
1778 " { \"type\": \"name\", \"properties\": "
1779 " { \"name\": \":1\" } "
1780 " } "
1781 " }");
1782
1783 --error ER_INVALID_GEOJSON_UNSPECIFIED
1784 SELECT ST_GEOMFROMGEOJSON(
1785 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1786 " \"crs\": "
1787 " { \"type\": \"name\", \"properties\": "
1788 " { \"name\": \"EPS:1\" } "
1789 " } "
1790 " }");
1791
1792 --error ER_INVALID_GEOJSON_UNSPECIFIED
1793 SELECT ST_GEOMFROMGEOJSON(
1794 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1795 " \"crs\": "
1796 " { \"type\": \"link\", \"properties\": "
1797 " { \"href\": \"http://example.com/crs/42\", "
1798 " \"type\": \"proj4\" "
1799 " } "
1800 " } "
1801 " }");
1802
1803 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1804 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1805 " \"crs\": "
1806 " { \"type\": \"name\", \"properties\": "
1807 " { \"name\": \"EPS:1\" } "
1808 " } "
1809 " } ", 1 , 4326 ));
1810
1811 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1812 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1813 " \"crs\": "
1814 " { \"type\": \"name\", \"properties\": "
1815 " { \"name\": \"urn:ogc:def:crs:EPSG::1\" } "
1816 " } "
1817 " }", 1, 0));
1818
1819 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1820 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1821 " \"crs\": "
1822 " { \"type\": \"name\", \"properties\": "
1823 " { \"name\": \"urn:ogc:def:crs:EPSG::0\" } "
1824 " } "
1825 " }", 1, 4326));
1826
1827 --error ER_INVALID_GEOJSON_UNSPECIFIED
1828 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1829 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1830 " \"crs\": "
1831 " { \"type\": \"name\", \"properties\": "
1832 " { \"name\": \"urn:ogc:def:crs:OGC:1.3:CRS100\" } "
1833 " } "
1834 " }", 1));
1835
1836 --error ER_INVALID_GEOJSON_UNSPECIFIED
1837 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1838 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1839 " \"crs\": "
1840 " { \"type\": \"name\", \"properties\": "
1841 " { \"name\": \"urn:ogc:def:crs:OGC:1.30:CRS84\" } "
1842 " } "
1843 " }", 1));
1844
1845 --error ER_INVALID_JSON_TEXT_IN_PARAM
1846 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1847 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1848 " \"crs\": "
1849 " { \"type\": \"name\", \"properties\": "
1850 " { : \"urn:ogc:def:crs:OGC:1.3:CRS84\" } "
1851 " } "
1852 " }", 1));
1853
1854 --error ER_INVALID_JSON_TEXT_IN_PARAM
1855 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1856 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1857 " \"crs\": "
1858 " { \"type\": \"name\", \"properties\": "
1859 " { \"name\": { \"urn:ogc:def:crs:OGC:1.3:CRS84\" } } "
1860 " } "
1861 " }", 1));
1862
1863 --error ER_INVALID_JSON_TEXT_IN_PARAM
1864 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1865 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1866 " \"crs\": "
1867 " { \"type\": \"name\": "
1868 " { \"name\": \"urn:ogc:def:crs:OGC:1.3:CRS84\" } "
1869 " } "
1870 " }", 1));
1871
1872 --error ER_INVALID_JSON_TEXT_IN_PARAM
1873 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1874 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1875 " \"crs\": "
1876 " { \"type\": \"properties\": "
1877 " { \"name\": \"urn:ogc:def:crs:OGC:1.3:CRS84\" } "
1878 " } "
1879 " }", 1));
1880
1881 --error ER_INVALID_GEOJSON_UNSPECIFIED
1882 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1883 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1884 " \"crs\": "
1885 " { \"type\": \"name\", \"properties\": "
1886 " { \"name\": \" \" } "
1887 " } "
1888 " }", 1));
1889
1890 --error ER_INVALID_GEOJSON_WRONG_TYPE
1891 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1892 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1893 " \"crs\": "
1894 " [ "
1895 " { \"type\": \"name\", \"properties\": "
1896 " { \"name\": \"urn:ogc:def:crs:EPSG::1\" } "
1897 " } "
1898 " ] "
1899 " }", 1));
1900
1901 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1902 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1903 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
1904 " \"crs\": "
1905 " { \"type\": \"name\", \"properties\": "
1906 " { } "
1907 " } "
1908 " }", 1));
1909
1910 --error ER_INVALID_GEOJSON_CRS_NOT_TOP_LEVEL
1911 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
1912 " { \"type\": \"GeometryCollection\", \"geometries\": "
1913 " [ "
1914 " { \"type\": \"LineString\", \"coordinates\": "
1915 " [ "
1916 " [102.0, 0.0], "
1917 " [103.0, 1.0], "
1918 " [104.0, 0.0], "
1919 " [105.0, 1.0] "
1920 " ], "
1921 " \"crs\": "
1922 " { \"type\": \"name\", \"properties\": "
1923 " { \"name\": \"urn:ogc:def:crs:EPSG::2000\" } "
1924 " } "
1925 " }, "
1926 " { \"type\": \"LineString\", \"coordinates\": "
1927 " [ "
1928 " [102.0, 0.0], "
1929 " [103.0, 1.0], "
1930 " [104.0, 0.0], "
1931 " [105.0, 1.0] "
1932 " ], "
1933 " \"crs\": "
1934 " { \"type\": \"name\", \"properties\": "
1935 " { \"name\": \"urn:ogc:def:crs:EPSG::4326\" } "
1936 " } "
1937 " } "
1938 " ] "
1939 " }"));
1940
1941 --error ER_INVALID_GEOJSON_MISSING_MEMBER
1942 SELECT ST_GEOMFROMGEOJSON(
1943 "{ \"type\": \"Point\", \"coordinates\": [10, 20], \"crs\": { } }");
1944
1945 --error ER_INVALID_GEOJSON_WRONG_TYPE
1946 SELECT ST_GEOMFROMGEOJSON(
1947 " { \"type\": \"Point\", \"coordinates\": [10, \"20\"] } ");
1948
1949 --error ER_WRONG_VALUE_FOR_TYPE
1950 SELECT ST_GEOMFROMGEOJSON("", -9223372036854775808);
1951
1952 --error ER_WRONG_VALUE_FOR_TYPE
1953 SELECT ST_GEOMFROMGEOJSON("", 9223372036854775807);
1954
1955 --error ER_WRONG_VALUE_FOR_TYPE
1956 SELECT ST_GEOMFROMGEOJSON("", 9223372036854775808);
1957
1958 --error ER_DATA_OUT_OF_RANGE
1959 SELECT ST_GEOMFROMGEOJSON("", 1, -9223372036854775808);
1960
1961 --error ER_DATA_OUT_OF_RANGE
1962 SELECT ST_GEOMFROMGEOJSON("", 1, 9223372036854775807);
1963
1964 --error ER_DATA_OUT_OF_RANGE
1965 SELECT ST_GEOMFROMGEOJSON("", 1, 9223372036854775808);
1966
1967 --echo # Checking invalid/incorrect option parameter input
1968 --error ER_WRONG_VALUE_FOR_TYPE
1969 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1970 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 0));
1971
1972 --error ER_WRONG_VALUE_FOR_TYPE
1973 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1974 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", -10));
1975
1976 --error ER_WRONG_VALUE_FOR_TYPE
1977 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1978 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", -1000));
1979
1980 --error ER_WRONG_VALUE_FOR_TYPE
1981 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1982 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 5));
1983
1984 --error ER_WRONG_VALUE_FOR_TYPE
1985 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1986 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 100));
1987
1988 --error ER_WRONG_VALUE_FOR_TYPE
1989 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1990 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 10000));
1991
1992 --error ER_WRONG_VALUE_FOR_TYPE
1993 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1994 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "0"));
1995
1996 --error ER_WRONG_VALUE_FOR_TYPE
1997 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
1998 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "-10"));
1999
2000 --error ER_WRONG_VALUE_FOR_TYPE
2001 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2002 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "-1000"));
2003
2004 --error ER_WRONG_VALUE_FOR_TYPE
2005 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2006 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "5"));
2007
2008 --error ER_WRONG_VALUE_FOR_TYPE
2009 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2010 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "100"));
2011
2012 --error ER_WRONG_VALUE_FOR_TYPE
2013 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2014 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", "10000"));
2015
2016 --error ER_INCORRECT_TYPE
2017 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2018 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1.1));
2019
2020 --error ER_INCORRECT_TYPE
2021 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2022 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", (CAST(1 AS DECIMAL))));
2023
2024 --error ER_INCORRECT_TYPE
2025 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2026 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", (CAST(1 AS BINARY))));
2027
2028 --error ER_BAD_FIELD_ERROR
2029 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2030 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", a));
2031
2032 --echo # Checking invalid/incorrect ST_SRID parameter input
2033 --error ER_DATA_OUT_OF_RANGE
2034 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2035 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, -1));
2036
2037 --error ER_DATA_OUT_OF_RANGE
2038 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2039 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, -1000));
2040
2041 --error ER_DATA_OUT_OF_RANGE
2042 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2043 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, 4294967296));
2044
2045 --error ER_DATA_OUT_OF_RANGE
2046 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2047 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, 4294967295000));
2048
2049 --error ER_DATA_OUT_OF_RANGE
2050 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2051 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, "-1"));
2052
2053 --error ER_DATA_OUT_OF_RANGE
2054 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2055 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, "-1000"));
2056
2057 --error ER_DATA_OUT_OF_RANGE
2058 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2059 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, "4294967296"));
2060
2061 --error ER_DATA_OUT_OF_RANGE
2062 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2063 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, "4294967295000"));
2064
2065 --error ER_INCORRECT_TYPE
2066 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2067 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, 1.1));
2068
2069 --error ER_INCORRECT_TYPE
2070 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2071 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, (CAST(1 AS DECIMAL))));
2072
2073 --error ER_INCORRECT_TYPE
2074 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2075 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, (CAST(1 AS BINARY))));
2076
2077 --error ER_BAD_FIELD_ERROR
2078 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2079 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, a));
2080
2081 --echo # Invalid function calls
2082 --error ER_INVALID_GEOJSON_WRONG_TYPE
2083 SELECT ST_GEOMFROMGEOJSON("{ \"type\": \"Feature\", \"geometry\": [10, 20] }");
2084
2085 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
2086 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON());
2087
2088 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
2089 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2090 "{ \"type\": \"Point\", \"coordinates\": [10, 15] }", 1, 0, 2));
2091
2092 --error ER_INVALID_JSON_TEXT_IN_PARAM
2093 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2094 "{ \"type\":: \"Point\", \"coordinates\": [10, 15] }", 1, 0));
2095
2096 --error ER_INVALID_GEOJSON_WRONG_TYPE
2097 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2098 "{ \"type\": [ \"Point\" ], \"coordinates\": [10, 15] }", 1, 0));
2099
2100 --error ER_INVALID_JSON_TEXT_IN_PARAM
2101 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2102 "{ \"type\": }", 1, 0));
2103
2104 --error ER_INVALID_GEOJSON_UNSPECIFIED
2105 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2106 "{ \"type\": \"Geometry\", \"coordinates\": [10, 15] }", 1, 0));
2107
2108 --error ER_INVALID_JSON_TEXT_IN_PARAM
2109 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2110 "{ \"type\": { \"Point\" }, \"coordinates\": [10, 15] }", 1, 0));
2111
2112 --error ER_DIMENSION_UNSUPPORTED
2113 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2114 "{ \"type\": \"LineString\", \"coordinates\": [[100.0, 0.0, 1.0, 2.0], [101.0, 0.0]] }"));
2115
2116 --error ER_DIMENSION_UNSUPPORTED
2117 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2118 " { \"type\": \"Polygon\", \"coordinates\": "
2119 " [ "
2120 " [ "
2121 " [100.0, 0.0, 1.0], "
2122 " [101.0, 0.0], "
2123 " [101.0, 1.0], "
2124 " [100.0, 0.0] "
2125 " ] "
2126 " ] "
2127 " }"));
2128
2129 --error ER_INVALID_GEOJSON_MISSING_MEMBER
2130 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2131 " { "
2132 " \"type\": \"Feature\", \"Point\": "
2133 " { \"type\": \"Point\", \"coordinates\": "
2134 " [-104.99404, 39.75621] "
2135 " }, "
2136 " \"properties\": "
2137 " { "
2138 " \"name\": \"Coors Field\", "
2139 " \"amenity\": \"Baseball Stadium\", "
2140 " \"popupContent\": \"This is where the Rockies play!\" "
2141 " } "
2142 " }"));
2143
2144 --error ER_INVALID_JSON_TEXT_IN_PARAM
2145 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2146 " { "
2147 " \"type\": \"Feature\", \"name\": , \"geometry\": "
2148 " { \"type\": \"Point\", \"coordinates\": "
2149 " [-104.99404, 39.75621] "
2150 " }, "
2151 " \"properties\": "
2152 " { "
2153 " \"name\": \"Coors Field\", "
2154 " \"amenity\": \"Baseball Stadium\", "
2155 " \"popupContent\": \"This is where the Rockies play!\" "
2156 " } "
2157 " }"));
2158
2159 --error ER_INVALID_JSON_TEXT_IN_PARAM
2160 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2161 " { "
2162 " \"type\": \"Feature\", \"geometry\": "
2163 " { \"type\": \"Point\", \"coordinates\": "
2164 " [-104.99404, 39.75621] "
2165 " }, "
2166 " \"properties\": "
2167 " { "
2168 " \"name\": \"Coors Field\", \"abc\", "
2169 " \"amenity\": \"Baseball Stadium\", "
2170 " \"popupContent\": \"This is where the Rockies play!\" "
2171 " } "
2172 " }"));
2173
2174 --error ER_INVALID_JSON_TEXT_IN_PARAM
2175 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2176 " { "
2177 " \"type\": \"Feature\", \"geometry\": "
2178 " { \"type\": \"Point\", \"coordinates\": "
2179 " [-104.99404, 39.75621] "
2180 " }, "
2181 " \"properties\": "
2182 " { "
2183 " \"name\": \"Coors Field\", "
2184 " \"amenity\": \"Baseball Stadium\", "
2185 " \"type\": \"Point\", \"coordinates\": "
2186 " } "
2187 " }"));
2188
2189 --error ER_INVALID_JSON_TEXT_IN_PARAM
2190 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2191 " { "
2192 " \"type\": \"Feature\", \"geometry\": "
2193 " { \"type\": \"Point\", \"coordinates\": "
2194 " [-104.99404, 39.75621] "
2195 " }, "
2196 " \"properties\": "
2197 " { "
2198 " \"name\": \"Coors Field\", "
2199 " \"amenity\": \"Baseball Stadium\", "
2200 " { \"type\": \"Point\", \"coordinates\": "
2201 " [-104.99404, 39.75621] "
2202 " }, "
2203 " } "
2204 " }"));
2205
2206 --error ER_INVALID_GEOJSON_UNSPECIFIED
2207 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2208 " { \"type\": \"Polygon\", \"coordinates\": "
2209 " [ "
2210 " [ "
2211 " [1, 1] "
2212 " ] "
2213 " ] "
2214 " }"));
2215
2216 --error ER_INVALID_GEOJSON_UNSPECIFIED
2217 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2218 " { \"type\": \"Polygon\", \"coordinates\": "
2219 " [ "
2220 " [ "
2221 " [1, 1], "
2222 " [2, 2] "
2223 " ] "
2224 " ] "
2225 " }"));
2226
2227 --error ER_INVALID_GEOJSON_UNSPECIFIED
2228 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2229 " { \"type\": \"Polygon\", \"coordinates\": "
2230 " [ "
2231 " [ "
2232 " [1, 1], "
2233 " [2, 2], "
2234 " [3, 3] "
2235 " ] "
2236 " ] "
2237 " }"));
2238
2239 --error ER_INVALID_GEOJSON_UNSPECIFIED
2240 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2241 " { \"type\": \"Polygon\", \"coordinates\": "
2242 " [ "
2243 " [ "
2244 " [1, 1], "
2245 " [1, 4], "
2246 " [4, 4], "
2247 " [1, 1] "
2248 " ], "
2249 " [ "
2250 " [2, 2] "
2251 " ] "
2252 " ] "
2253 " }"));
2254
2255 --error ER_INVALID_GEOJSON_UNSPECIFIED
2256 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2257 " { \"type\": \"Polygon\", \"coordinates\": "
2258 " [ "
2259 " [ "
2260 " [1, 1], "
2261 " [1, 4], "
2262 " [4, 4], "
2263 " [1, 1] "
2264 " ], "
2265 " [ "
2266 " [2, 2], "
2267 " [2, 3] "
2268 " ] "
2269 " ] "
2270 " }"));
2271
2272 --error ER_INVALID_GEOJSON_UNSPECIFIED
2273 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2274 " { \"type\": \"Polygon\", \"coordinates\": "
2275 " [ "
2276 " [ "
2277 " [1, 1], "
2278 " [1, 4], "
2279 " [4, 4], "
2280 " [1, 1] "
2281 " ], "
2282 " [ "
2283 " [2, 2], "
2284 " [2, 3], "
2285 " [3, 3] "
2286 " ] "
2287 " ] "
2288 " }"));
2289
2290 --error ER_INVALID_GEOJSON_UNSPECIFIED
2291 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2292 " { \"type\": \"Polygon\", \"coordinates\": "
2293 " [ "
2294 " [ "
2295 " [1, 1], "
2296 " 1, "
2297 " [4, 4], "
2298 " [1, 1] "
2299 " ], "
2300 " [ "
2301 " [2, 2], "
2302 " [2, 3], "
2303 " [3, 3] "
2304 " ] "
2305 " ] "
2306 " }"));
2307
2308 --error ER_INVALID_GEOJSON_UNSPECIFIED
2309 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2310 " { \"type\": \"Polygon\", \"coordinates\": "
2311 " [ "
2312 " [ "
2313 " [1, 1], "
2314 " [1, 4], "
2315 " [4, 4], "
2316 " [1, 1] "
2317 " ], "
2318 " [ "
2319 " [2, 2], "
2320 " 0, "
2321 " [3, 3] "
2322 " ] "
2323 " ] "
2324 " }"));
2325
2326 --error ER_DIMENSION_UNSUPPORTED
2327 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
2328 " { \"type\": \"Polygon\", \"coordinates\": "
2329 " [ "
2330 " [ "
2331 " [1, 1], "
2332 " [2, 2, 2], "
2333 " [3, 3, 3, 3], "
2334 " [1, 1] "
2335 " ] "
2336 " ] "
2337 " }"));
2338
2339 --error ER_INVALID_JSON_TEXT_IN_PARAM
2340 SELECT ST_GEOMFROMGEOJSON(
2341 "{ "
2342 " \"type\" : \"firstName\": \"John\" "
2343 "} "
2344 );
2345
2346 PREPARE stmt FROM "SELECT ST_GEOMFROMGEOJSON(?, 0, 0)";
2347 PREPARE stmt FROM "SELECT ST_GEOMFROMGEOJSON('', ?, 0)";
2348 PREPARE stmt FROM "SELECT ST_GEOMFROMGEOJSON('', 0, ?)";
2349 PREPARE stmt FROM "SELECT ST_GEOMFROMGEOJSON(?, ?, 0)";
2350 PREPARE stmt FROM "SELECT ST_GEOMFROMGEOJSON(?, 0, ?)";
2351 PREPARE stmt FROM "SELECT ST_GEOMFROMGEOJSON('', ?, ?)";
2352 PREPARE stmt FROM "SELECT ST_GEOMFROMGEOJSON(?, ?, ?)";
2353
2354 --error ER_INVALID_JSON_TEXT_IN_PARAM
2355 SELECT ST_GEOMFROMGEOJSON("{}foo");
2356
2357 --error ER_INVALID_JSON_TEXT_IN_PARAM
2358 SELECT ST_GEOMFROMGEOJSON("[12 foo 13]");
2359
2360 --error ER_INVALID_JSON_TEXT_IN_PARAM
2361 SELECT ST_GEOMFROMGEOJSON("{ \"type\": nul123 } ");
2362
2363 --error ER_INVALID_GEOJSON_MISSING_MEMBER
2364 SELECT ST_GEOMFROMGEOJSON("{ \"true\": true, \"false\": false } ");
2365
2366 --error ER_INVALID_JSON_TEXT_IN_PARAM
2367 SELECT ST_GEOMFROMGEOJSON("{ \"true\": tru123 } ");
2368
2369 --error ER_INVALID_JSON_TEXT_IN_PARAM
2370 SELECT ST_GEOMFROMGEOJSON("{ \"false\": fals123 } ");
2371
2372 --error ER_INVALID_JSON_TEXT_IN_PARAM
2373 SELECT ST_GEOMFROMGEOJSON("{ \"hex\": \"\\u0Aa\" } ");
2374
2375 --error ER_INVALID_GEOJSON_MISSING_MEMBER
2376 SELECT ST_GEOMFROMGEOJSON("{ \"hex\": \"\\\\0000b\" } ");
2377
2378 --error ER_INVALID_JSON_TEXT_IN_PARAM
2379 SELECT ST_GEOMFROMGEOJSON("{ \"hex\": \"\\uD811b\" } ");
2380
2381 --error ER_INVALID_JSON_TEXT_IN_PARAM
2382 SELECT ST_GEOMFROMGEOJSON("{ \"hex\": \"\\uD811\\uDB99\" } ");
2383
2384 --error ER_INVALID_GEOJSON_MISSING_MEMBER
2385 SELECT ST_GEOMFROMGEOJSON("{ \"hex\": \"\\uD811\\uDC01\" } ");
2386
2387 --error ER_INVALID_JSON_TEXT_IN_PARAM
2388 SELECT ST_GEOMFROMGEOJSON("{ \"hex\": \"\\e000G\" } ");
2389
2390 --error ER_INVALID_JSON_TEXT_IN_PARAM
2391 SELECT ST_GEOMFROMGEOJSON("{ \"test ");
2392
2393 --error ER_INVALID_JSON_TEXT_IN_PARAM
2394 SELECT ST_GEOMFROMGEOJSON("{ \"\nabel\": 123 ");
2395
2396 --error ER_INVALID_GEOJSON_UNSPECIFIED
2397 SELECT ST_GEOMFROMGEOJSON("[ -2147483651, 4294967395 ] ");
2398
2399 --error ER_INVALID_GEOJSON_UNSPECIFIED
2400 SELECT ST_GEOMFROMGEOJSON("[ -9223372036854775900, 184467440737095516700] ");
2401
2402 --error ER_INVALID_JSON_TEXT_IN_PARAM
2403 SELECT ST_GEOMFROMGEOJSON("["
2404 "900000000000000000000000000000000000000000000000000000000000000000000000000000"
2405 "000000000000000000000000000000000000000000000000000000000000000000000000000000"
2406 "000000000000000000000000000000000000000000000000000000000000000000000000000000"
2407 "000000000000000000000000000000000000000000000000000000000000000000000000000"
2408 "]");
2409
2410 --error ER_INVALID_JSON_TEXT_IN_PARAM
2411 SELECT ST_GEOMFROMGEOJSON("[ 1. ] ");
2412
2413 --error ER_INVALID_JSON_TEXT_IN_PARAM
2414 SELECT ST_GEOMFROMGEOJSON("[ 1e1000 ] ");
2415
2416 --error ER_INVALID_JSON_TEXT_IN_PARAM
2417 SELECT ST_GEOMFROMGEOJSON("[ 1e ] ");
2418
2419 --error ER_INVALID_GEOJSON_UNSPECIFIED
2420 SELECT ST_GEOMFROMGEOJSON("[ -92233720368547759, 1844674407370955167] ");
2421
2422 --error ER_INVALID_GEOJSON_UNSPECIFIED
2423 SELECT ST_GEOMFROMGEOJSON("[ -214748365, 429496739 ] ");
2424
2425 --error ER_INVALID_GEOJSON_UNSPECIFIED
2426 SELECT ST_GEOMFROMGEOJSON("[ -0 ]");
2427
2428 --error ER_INVALID_JSON_TEXT_IN_PARAM
2429 SELECT ST_GEOMFROMGEOJSON("{ \"\\u0000\" }");
2430
2431 --error ER_INVALID_JSON_TEXT_IN_PARAM
2432 SELECT ST_GEOMFROMGEOJSON("{ \"\\u06FF\" }");
2433
2434 --error ER_INVALID_JSON_TEXT_IN_PARAM
2435 SELECT ST_GEOMFROMGEOJSON("{ \"\\uFFFF\" }");
2436
2437 # Force SRID 0 to avoid coordinate range check.
2438 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON("{ \"type\": \"Point\", \"coordinates\": [4294967295, 9223372036854775807] }", 1, 0));
2439
2440 # Force SRID 0 to avoid coordinate range check.
2441 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON("{ \"type\": \"Point\", \"coordinates\": [18446744073709551615, 9223372036854775807] }", 1, 0));
2442
2443 --error ER_INVALID_JSON_TEXT_IN_PARAM
2444 SELECT ST_AsGeoJSON(ST_GeomFromGeoJSON('{"type":"Point","coordinates":[2e308,-0]}'));
2445
2446 #####################################################################
2447 # BUG#19341961
2448 #####################################################################
2449
2450 --echo # Checking that Point with wrong coordinate array depth are invalidated.
2451 --error ER_INVALID_GEOJSON_UNSPECIFIED
2452 SELECT ST_GEOMFROMGEOJSON(
2453 "{ "
2454 " \"type\": \"Point\", "
2455 " \"coordinates\": [ ] "
2456 "} "
2457 );
2458
2459 --error ER_INVALID_GEOJSON_UNSPECIFIED
2460 SELECT ST_GEOMFROMGEOJSON(
2461 "{ "
2462 " \"type\": \"Point\", "
2463 " \"coordinates\": [ [ 1, 2 ] ] "
2464 "} "
2465 );
2466
2467 --error ER_INVALID_GEOJSON_UNSPECIFIED
2468 SELECT ST_GEOMFROMGEOJSON(
2469 "{ "
2470 " \"type\": \"Point\", "
2471 " \"coordinates\": [ [ ] ] "
2472 "} "
2473 );
2474
2475 --error ER_INVALID_GEOJSON_UNSPECIFIED
2476 SELECT ST_GEOMFROMGEOJSON(
2477 "{ "
2478 " \"type\": \"Point\", "
2479 " \"coordinates\": [ [ [ ] ] ] "
2480 "} "
2481 );
2482
2483 --echo # Checking that LineString with wrong coordinate
2484 --echo # array depth are invalidated.
2485 --error ER_INVALID_GEOJSON_UNSPECIFIED
2486 SELECT ST_GEOMFROMGEOJSON(
2487 "{ "
2488 " \"type\": \"LineString\", "
2489 " \"coordinates\": [ ] "
2490 "} "
2491 );
2492
2493 --error ER_INVALID_GEOJSON_UNSPECIFIED
2494 SELECT ST_GEOMFROMGEOJSON(
2495 "{ "
2496 " \"type\": \"LineString\", "
2497 " \"coordinates\": [ [ ] ] "
2498 "} "
2499 );
2500
2501 --error ER_INVALID_GEOJSON_UNSPECIFIED
2502 SELECT ST_GEOMFROMGEOJSON(
2503 "{ "
2504 " \"type\": \"LineString\", "
2505 " \"coordinates\": [ 101.0, 1.0 ] "
2506 "} "
2507 );
2508
2509 --error ER_INVALID_GEOJSON_UNSPECIFIED
2510 SELECT ST_GEOMFROMGEOJSON(
2511 "{ "
2512 " \"type\": \"LineString\", "
2513 " \"coordinates\": [ [ [ 101.0, 1.0 ] ] ] "
2514 "} "
2515 );
2516
2517 --echo # Checking that Polygon with wrong coordinate
2518 --echo # array depth are invalidated.
2519 --error ER_INVALID_GEOJSON_UNSPECIFIED
2520 SELECT ST_GEOMFROMGEOJSON(
2521 "{ "
2522 " \"type\": \"Polygon\", "
2523 " \"coordinates\": [ ] "
2524 "} "
2525 );
2526
2527 --error ER_INVALID_GEOJSON_UNSPECIFIED
2528 SELECT ST_GEOMFROMGEOJSON(
2529 "{ "
2530 " \"type\": \"Polygon\", "
2531 " \"coordinates\": [ [ ] ] "
2532 "} "
2533 );
2534
2535 --error ER_INVALID_GEOJSON_UNSPECIFIED
2536 SELECT ST_GEOMFROMGEOJSON(
2537 "{ "
2538 " \"type\": \"Polygon\", "
2539 " \"coordinates\": [ [ [ ] ] ] "
2540 "} "
2541 );
2542
2543 --error ER_INVALID_GEOJSON_UNSPECIFIED
2544 SELECT ST_GEOMFROMGEOJSON(
2545 "{ "
2546 " \"type\": \"Polygon\", "
2547 " \"coordinates\": [ [ [ [ ] ] ] ] "
2548 "} "
2549 );
2550
2551 --error ER_INVALID_GEOJSON_UNSPECIFIED
2552 SELECT ST_GEOMFROMGEOJSON(
2553 "{ "
2554 " \"type\": \"Polygon\", "
2555 " \"coordinates\": [ 100.0, 0.0 ] "
2556 "} "
2557 );
2558
2559 --error ER_INVALID_GEOJSON_UNSPECIFIED
2560 SELECT ST_GEOMFROMGEOJSON(
2561 "{ "
2562 " \"type\": \"Polygon\", "
2563 " \"coordinates\": [ [ 100.0, 0.0 ] ] "
2564 "} "
2565 );
2566
2567 --error ER_INVALID_GEOJSON_UNSPECIFIED
2568 SELECT ST_GEOMFROMGEOJSON(
2569 "{ "
2570 " \"type\": \"Polygon\", "
2571 " \"coordinates\": [ [ [ [ 100.0, 0.0 ] ] ] ] "
2572 "} "
2573 );
2574
2575 --error ER_INVALID_GEOJSON_UNSPECIFIED
2576 SELECT ST_GEOMFROMGEOJSON(
2577 "{ "
2578 " \"type\": \"Polygon\", "
2579 " \"coordinates\": [ [ [ [ ] ] ] ] "
2580 "} "
2581 );
2582
2583 --echo # Checking that Polygon rings with less than four points are invalidated.
2584 --error ER_INVALID_GEOJSON_UNSPECIFIED
2585 SELECT ST_GEOMFROMGEOJSON(
2586 "{ "
2587 " \"type\": \"Polygon\", "
2588 " \"coordinates\": [ [ [ 100.0, 0.0 ] ] ] "
2589 "} "
2590 );
2591
2592 --error ER_INVALID_GEOJSON_UNSPECIFIED
2593 SELECT ST_GEOMFROMGEOJSON(
2594 "{ "
2595 " \"type\": \"Polygon\", "
2596 " \"coordinates\": "
2597 " [ [ "
2598 " [ 100.0, 0.0 ], "
2599 " [ 100.0, 0.0 ] "
2600 " ] ] "
2601 "} "
2602 );
2603
2604 --error ER_INVALID_GEOJSON_UNSPECIFIED
2605 SELECT ST_GEOMFROMGEOJSON(
2606 "{ "
2607 " \"type\": \"Polygon\", "
2608 " \"coordinates\": "
2609 " [ [ "
2610 " [ 100.0, 0.0 ], "
2611 " [ 100.0, 0.0 ], "
2612 " [ 100.0, 0.0 ] "
2613 " ] ] "
2614 "} "
2615 );
2616
2617 --echo # Checking that Polygons with unclosed rings are invalidated.
2618 --error ER_INVALID_GEOJSON_UNSPECIFIED
2619 SELECT ST_GEOMFROMGEOJSON(
2620 "{ "
2621 " \"type\": \"Polygon\", "
2622 " \"coordinates\": "
2623 " [ [ "
2624 " [ 100.0, 0.0 ], "
2625 " [ 101.0, 0.0 ], "
2626 " [ 102.0, 0.0 ], "
2627 " [ 100.1, 0.0 ] "
2628 " ] ] "
2629 "} "
2630 );
2631
2632 --error ER_INVALID_GEOJSON_UNSPECIFIED
2633 SELECT ST_GEOMFROMGEOJSON(
2634 "{ "
2635 " \"type\": \"Polygon\", "
2636 " \"coordinates\": "
2637 " [ [ "
2638 " [ 100.0, 0.0 ], "
2639 " [ 101.0, 0.0 ], "
2640 " [ 102.0, 0.0 ], "
2641 " [ 100.0, 0.1 ] "
2642 " ] ] "
2643 "} "
2644 );
2645
2646 --error ER_INVALID_GEOJSON_UNSPECIFIED
2647 SELECT ST_GEOMFROMGEOJSON(
2648 "{ "
2649 " \"type\": \"Polygon\", "
2650 " \"coordinates\": "
2651 " [ "
2652 " [ "
2653 " [ 100.0, 0.0 ], "
2654 " [ 101.0, 0.0 ], "
2655 " [ 102.0, 0.0 ], "
2656 " [ 100.0, 0.0 ] "
2657 " ], "
2658 " [ "
2659 " [ 10.0, 2.0 ], "
2660 " [ 11.0, 2.2 ], "
2661 " [ 12.0, 2.3 ], "
2662 " [ 10.0, 2.1 ] "
2663 " ] "
2664 " ] "
2665 "} "
2666 );
2667
2668 --error ER_INVALID_GEOJSON_UNSPECIFIED
2669 SELECT ST_GEOMFROMGEOJSON(
2670 "{ "
2671 " \"type\": \"Polygon\", "
2672 " \"coordinates\": "
2673 " [ "
2674 " [ "
2675 " [ 100.0, 0.0 ], "
2676 " [ 101.0, 0.0 ], "
2677 " [ 102.0, 0.0 ], "
2678 " [ 100.0, 0.0 ] "
2679 " ], "
2680 " [ "
2681 " [ 10.0, 2.0 ], "
2682 " [ 11.0, 2.2 ], "
2683 " [ 12.0, 2.3 ], "
2684 " [ 10.1, 2.0 ] "
2685 " ] "
2686 " ] "
2687 "} "
2688 );
2689
2690 --echo # Checking that MultiPoint with wrong coordinate
2691 --echo # array depth are invalidated.
2692 --error ER_INVALID_GEOJSON_UNSPECIFIED
2693 SELECT ST_GEOMFROMGEOJSON(
2694 "{ "
2695 " \"type\": \"MultiPoint\", "
2696 " \"coordinates\": [ ] "
2697 "} "
2698 );
2699
2700 --error ER_INVALID_GEOJSON_UNSPECIFIED
2701 SELECT ST_GEOMFROMGEOJSON(
2702 "{ "
2703 " \"type\": \"MultiPoint\", "
2704 " \"coordinates\": [ [ ] ] "
2705 "} "
2706 );
2707
2708 --error ER_INVALID_GEOJSON_UNSPECIFIED
2709 SELECT ST_GEOMFROMGEOJSON(
2710 "{ "
2711 " \"type\": \"MultiPoint\", "
2712 " \"coordinates\": [ [ [ ] ] ] "
2713 "} "
2714 );
2715
2716 --error ER_INVALID_GEOJSON_UNSPECIFIED
2717 SELECT ST_GEOMFROMGEOJSON(
2718 "{ "
2719 " \"type\": \"MultiPoint\", "
2720 " \"coordinates\": [ 100.0, 0.0 ] "
2721 "} "
2722 );
2723
2724 --error ER_INVALID_GEOJSON_UNSPECIFIED
2725 SELECT ST_GEOMFROMGEOJSON(
2726 "{ "
2727 " \"type\": \"MultiPoint\", "
2728 " \"coordinates\": [ [ [ 100.0, 0.0 ] ] ] "
2729 "} "
2730 );
2731
2732 --echo # Checking that MultiLineString with wrong coordinate
2733 --echo # array depth are invalidated.
2734 --error ER_INVALID_GEOJSON_UNSPECIFIED
2735 SELECT ST_GEOMFROMGEOJSON(
2736 "{ "
2737 " \"type\": \"MultiLineString\", "
2738 " \"coordinates\": [ ] "
2739 "} "
2740 );
2741
2742 --error ER_INVALID_GEOJSON_UNSPECIFIED
2743 SELECT ST_GEOMFROMGEOJSON(
2744 "{ "
2745 " \"type\": \"MultiLineString\", "
2746 " \"coordinates\": [ [ ] ] "
2747 "} "
2748 );
2749
2750 --error ER_INVALID_GEOJSON_UNSPECIFIED
2751 SELECT ST_GEOMFROMGEOJSON(
2752 "{ "
2753 " \"type\": \"MultiLineString\", "
2754 " \"coordinates\": [ [ [ ] ] ] "
2755 "} "
2756 );
2757
2758 --error ER_INVALID_GEOJSON_UNSPECIFIED
2759 SELECT ST_GEOMFROMGEOJSON(
2760 "{ "
2761 " \"type\": \"MultiLineString\", "
2762 " \"coordinates\": [ [ [ [ ] ] ] ] "
2763 "} "
2764 );
2765
2766 --error ER_INVALID_GEOJSON_UNSPECIFIED
2767 SELECT ST_GEOMFROMGEOJSON(
2768 "{ "
2769 " \"type\": \"MultiLineString\", "
2770 " \"coordinates\": [ 100.0, 0.0 ] "
2771 "} "
2772 );
2773
2774 --error ER_INVALID_GEOJSON_UNSPECIFIED
2775 SELECT ST_GEOMFROMGEOJSON(
2776 "{ "
2777 " \"type\": \"MultiLineString\", "
2778 " \"coordinates\": [ [ 100.0, 0.0 ] ] "
2779 "} "
2780 );
2781
2782 --error ER_INVALID_GEOJSON_UNSPECIFIED
2783 SELECT ST_GEOMFROMGEOJSON(
2784 "{ "
2785 " \"type\": \"MultiLineString\", "
2786 " \"coordinates\": [ [ [ [ 100.0, 0.0 ] ] ] ] "
2787 "} "
2788 );
2789
2790 --echo # Checking that MultiPolygon with wrong coordinate
2791 --echo # array depth are invalidated.
2792 --error ER_INVALID_GEOJSON_UNSPECIFIED
2793 SELECT ST_GEOMFROMGEOJSON(
2794 "{ "
2795 " \"type\": \"MultiPolygon\", "
2796 " \"coordinates\": [ ] "
2797 "} "
2798 );
2799
2800 --error ER_INVALID_GEOJSON_UNSPECIFIED
2801 SELECT ST_GEOMFROMGEOJSON(
2802 "{ "
2803 " \"type\": \"MultiPolygon\", "
2804 " \"coordinates\": [ [ ] ] "
2805 "} "
2806 );
2807
2808 --error ER_INVALID_GEOJSON_UNSPECIFIED
2809 SELECT ST_GEOMFROMGEOJSON(
2810 "{ "
2811 " \"type\": \"MultiPolygon\", "
2812 " \"coordinates\": [ [ [ ] ] ] "
2813 "} "
2814 );
2815
2816 --error ER_INVALID_GEOJSON_UNSPECIFIED
2817 SELECT ST_GEOMFROMGEOJSON(
2818 "{ "
2819 " \"type\": \"MultiPolygon\", "
2820 " \"coordinates\": [ [ [ [ ] ] ] ] "
2821 "} "
2822 );
2823
2824 --error ER_INVALID_GEOJSON_UNSPECIFIED
2825 SELECT ST_GEOMFROMGEOJSON(
2826 "{ "
2827 " \"type\": \"MultiPolygon\", "
2828 " \"coordinates\": [ 102.0, 2.0 ] "
2829 "} "
2830 );
2831
2832 --error ER_INVALID_GEOJSON_UNSPECIFIED
2833 SELECT ST_GEOMFROMGEOJSON(
2834 "{ "
2835 " \"type\": \"MultiPolygon\", "
2836 " \"coordinates\": "
2837 " [ "
2838 " [ 102.0, 2.0 ], "
2839 " [ 103.0, 2.0 ], "
2840 " [ 103.0, 3.0 ], "
2841 " [ 102.0, 3.0 ], "
2842 " [ 102.0, 2.0 ], "
2843 " [ 100.0, 0.0 ], "
2844 " [ 101.0, 0.0 ], "
2845 " [ 101.0, 1.0 ], "
2846 " [ 100.0, 1.0 ], "
2847 " [ 100.0, 0.0 ] "
2848 " ] "
2849 "} "
2850 );
2851
2852 --error ER_INVALID_GEOJSON_UNSPECIFIED
2853 SELECT ST_GEOMFROMGEOJSON(
2854 "{ "
2855 " \"type\": \"MultiPolygon\", "
2856 " \"coordinates\": "
2857 " [ "
2858 " [ "
2859 " [ 102.0, 2.0 ], "
2860 " [ 103.0, 2.0 ], "
2861 " [ 103.0, 3.0 ], "
2862 " [ 102.0, 3.0 ], "
2863 " [ 102.0, 2.0 ] "
2864 " ], "
2865 " [ "
2866 " [ 100.0, 0.0 ], "
2867 " [ 101.0, 0.0 ], "
2868 " [ 101.0, 1.0 ], "
2869 " [ 100.0, 1.0 ], "
2870 " [ 100.0, 0.0 ] "
2871 " ] "
2872 " ] "
2873 "} "
2874 );
2875
2876 --error ER_INVALID_GEOJSON_UNSPECIFIED
2877 SELECT ST_GEOMFROMGEOJSON(
2878 "{ "
2879 " \"type\": \"MultiPolygon\", "
2880 " \"coordinates\": "
2881 " [ "
2882 " [ "
2883 " [ "
2884 " [ "
2885 " [ 102.0, 2.0 ], "
2886 " [ 103.0, 2.0 ], "
2887 " [ 103.0, 3.0 ], "
2888 " [ 102.0, 3.0 ], "
2889 " [ 102.0, 2.0 ] "
2890 " ] "
2891 " ] "
2892 " ], "
2893 " [ "
2894 " [ 100.0, 0.0 ], "
2895 " [ 101.0, 0.0 ], "
2896 " [ 101.0, 1.0 ], "
2897 " [ 100.0, 1.0 ], "
2898 " [ 100.0, 0.0 ] "
2899 " ] "
2900 " ] "
2901 "} "
2902 );
2903
2904 --echo # Checking that MultiPolygon rings with less than four points
2905 --echo # are invalidated.
2906 --error ER_INVALID_GEOJSON_UNSPECIFIED
2907 SELECT ST_GEOMFROMGEOJSON(
2908 "{ "
2909 " \"type\": \"MultiPolygon\", "
2910 " \"coordinates\": [ [ [ [ 102.0, 2.0 ] ] ] ] "
2911 "} "
2912 );
2913
2914 --error ER_INVALID_GEOJSON_UNSPECIFIED
2915 SELECT ST_GEOMFROMGEOJSON(
2916 "{ "
2917 " \"type\": \"MultiPolygon\", "
2918 " \"coordinates\": "
2919 " [ "
2920 " [ "
2921 " [ "
2922 " [ 103.0, 3.0 ], "
2923 " [ 102.0, 2.0 ] "
2924 " ] "
2925 " ] "
2926 " ] "
2927 "} "
2928 );
2929
2930 --error ER_INVALID_GEOJSON_UNSPECIFIED
2931 SELECT ST_GEOMFROMGEOJSON(
2932 "{ "
2933 " \"type\": \"MultiPolygon\", "
2934 " \"coordinates\": "
2935 " [ "
2936 " [ "
2937 " [ "
2938 " [ 102.0, 2.0 ], "
2939 " [ 103.0, 3.0 ], "
2940 " [ 102.0, 2.0 ] "
2941 " ] "
2942 " ] "
2943 " ] "
2944 "} "
2945 );
2946
2947 --echo # Checking that MultiPolygon with unclosed rings are invalidated.
2948 --error ER_INVALID_GEOJSON_UNSPECIFIED
2949 SELECT ST_GEOMFROMGEOJSON(
2950 "{ "
2951 " \"type\": \"MultiPolygon\", "
2952 " \"coordinates\": "
2953 " [ "
2954 " [ "
2955 " [ "
2956 " [ 102.0, 2.0 ], "
2957 " [ 103.0, 2.0 ], "
2958 " [ 103.0, 3.0 ], "
2959 " [ 102.1, 2.0 ] "
2960 " ] "
2961 " ] "
2962 " ] "
2963 "} "
2964 );
2965
2966 --error ER_INVALID_GEOJSON_UNSPECIFIED
2967 SELECT ST_GEOMFROMGEOJSON(
2968 "{ "
2969 " \"type\": \"MultiPolygon\", "
2970 " \"coordinates\": "
2971 " [ "
2972 " [ "
2973 " [ "
2974 " [ 102.0, 2.0 ], "
2975 " [ 103.0, 2.0 ], "
2976 " [ 103.0, 3.0 ], "
2977 " [ 102.0, 2.1 ] "
2978 " ] "
2979 " ] "
2980 " ] "
2981 "} "
2982 );
2983
2984 #####################################################################
2985 # Bug#19342661
2986 #####################################################################
2987
2988 --echo # Checking that GeometryCollection with non-objects in array
2989 --echo # are invalidated.
2990 --error ER_INVALID_GEOJSON_WRONG_TYPE
2991 SELECT ST_GEOMFROMGEOJSON(
2992 "{ "
2993 " \"type\": \"GeometryCollection\", "
2994 " \"geometries\": [ [ ] ] "
2995 "} "
2996 );
2997
2998 --error ER_INVALID_GEOJSON_WRONG_TYPE
2999 SELECT ST_GEOMFROMGEOJSON(
3000 "{ "
3001 " \"type\": \"GeometryCollection\", "
3002 " \"geometries\": [10, 20] "
3003 "} "
3004 );
3005
3006 --error ER_INVALID_GEOJSON_WRONG_TYPE
3007 SELECT ST_GEOMFROMGEOJSON(
3008 "{ "
3009 " \"type\": \"GeometryCollection\", "
3010 " \"geometries\": [\"foo\", \"bar\"] "
3011 "} "
3012 );
3013
3014 --error ER_INVALID_JSON_TEXT_IN_PARAM
3015 SELECT ST_GEOMFROMGEOJSON(
3016 "{ "
3017 " \"type\": \"GeometryCollection\", "
3018 " \"geometries\": [ foo ] "
3019 "} "
3020 );
3021
3022 --error ER_INVALID_GEOJSON_WRONG_TYPE
3023 SELECT ST_GEOMFROMGEOJSON(
3024 "{ "
3025 " \"type\": \"GeometryCollection\", "
3026 " \"geometries\": [ null ] "
3027 "} "
3028 );
3029
3030 --error ER_INVALID_GEOJSON_WRONG_TYPE
3031 SELECT ST_GEOMFROMGEOJSON(
3032 "{ "
3033 " \"type\": \"GeometryCollection\", "
3034 " \"geometries\": "
3035 " [ "
3036 " { \"type\": \"Point\", \"coordinates\": [1, 2] }, "
3037 " [ ] "
3038 " ] "
3039 "} "
3040 );
3041
3042 --echo # Nested GeoJSON functions
3043 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(10 11)"), 5, 0)));
3044
3045 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(-10 -11)"), 5, 1)));
3046
3047 # Force SRID 0 to avoid coordinate range check.
3048 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E+308 1.7976931348623157E+308)"), 100, 2), 1, 0));
3049
3050 # Force SRID 0 to avoid coordinate range check.
3051 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("POINT(1.7976931348623157E-308 1.7976931348623157E-308)"), 100, 3), 1, 0));
3052
3053 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("LINESTRING(30 10, 10 30, 40 40)"), 10, 4)));
3054
3055 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("LINESTRING(0 0, 0 10, 10 10, 10 0)"), 10, 5)));
3056
3057 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("POLYGON((30 10, 40 40, 20 40, 10 20,30 10))"), 20, 6)));
3058
3059 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("POLYGON((35 10, 45 45, 15 40, 10 20, 35 10),"
3060 "(20 30, 35 35, 30 20,20 30))"), 20, 7)));
3061
3062 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOINT(10 40, 40 30, 20 20, 30 10)"))));
3063
3064 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOINT(0 0, 10 10, 20 20, 30 30, 40 40)"))));
3065
3066 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTILINESTRING((10 10, 20 20, 10 40),"
3067 "(40 40, 30 30, 40 20, 30 10))"))));
3068
3069 # Force SRID 0 to avoid coordinate range check.
3070 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTILINESTRING((10 10, 20 20, 10 40),"
3071 "(40 40, 30 30, 40 20, 30 10),"
3072 "(10 10, 20 20, 50 50, 100 100))")), 1, 0));
3073
3074 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOLYGON(((40 40, 20 45, 45 30, 40 40)),"
3075 "((20 35, 10 30, 10 10, 30 5, 45 20, 20 35)))"))));
3076
3077 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("MULTIPOLYGON(((40 40, 20 45, 45 30, 40 40)),"
3078 "((20 35, 10 30, 10 10, 30 5, 45 20, 20 35),"
3079 "(30 20, 20 15, 20 25, 30 20)))"))));
3080
3081 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION()"))));
3082
3083 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 20)))"))));
3084
3085 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))"))));
3086
3087 # Force SRID 0 to avoid coordinate range check.
3088 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION( "
3089 "GEOMETRYCOLLECTION(POINT(10 20)),"
3090 "GEOMETRYCOLLECTION(LINESTRING(0 0, 100 100)),"
3091 "GEOMETRYCOLLECTION(POLYGON((0 0, 0 10, 10 10, 0 0)))"
3092 ")"
3093 )), 1, 0));
3094
3095 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION( "
3096 "POINT(4 6),"
3097 "LINESTRING(4 6,7 10),"
3098 "POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)),"
3099 "MULTIPOINT (10 40, 40 30, 20 20, 30 10),"
3100 "MULTILINESTRING ((10 10, 20 20, 10 40),"
3101 "(40 40, 30 30, 40 20, 30 10)),"
3102 "MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),"
3103 "((15 5, 40 10, 10 20, 5 10, 15 5)))"
3104 ")"
3105 ))));
3106
3107 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(ST_ASGEOJSON(ST_GEOMFROMTEXT("GEOMETRYCOLLECTION( "
3108 "POINT(4 6),"
3109 "GEOMETRYCOLLECTION("
3110 "POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10)),"
3111 "MULTIPOINT (10 40, 40 30, 20 20, 30 10),"
3112 "MULTILINESTRING ((10 10, 20 20, 10 40),"
3113 "(40 40, 30 30, 40 20, 30 10)),"
3114 "MULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)),"
3115 "((15 5, 40 10, 10 20, 5 10, 15 5)))"
3116 "),"
3117 "POINT(6 4)"
3118 ")"
3119 ))));
3120
3121 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3122 "{ \"type\": \"Point\", \"coordinates\": [102.0, 0.0]}"));
3123
3124 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3125 "{ \"type\": \"LineString\", \"coordinates\": "
3126 "[ [102.0, 0.0], [103.0, 1.0], [104.0, 0.0], [105.0, 1.0] ] }"));
3127
3128 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3129 "{ \"type\": \"MultiPoint\", \"coordinates\": "
3130 "[ [-105.01, 39.57],[-80.66, 35.0] ] }"));
3131
3132 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3133 " { \"type\": \"MultiLineString\", \"coordinates\": "
3134 " [ "
3135 " [ "
3136 " [-101.5, 39.662], "
3137 " [-101.75, 39.2415], "
3138 " [-101.23, 39.2415], "
3139 " [-101.749, 39.7984], "
3140 " [-101.5, 39.011] "
3141 " ], "
3142 " [ "
3143 " [-99.23, 38.6605], "
3144 " [-99.56, 38.727], "
3145 " [-99.25, 38.018] "
3146 " ], "
3147 " [ "
3148 " [-98.499, 38.913], "
3149 " [-98.499, 38.913], "
3150 " [-98.38, 38.15], "
3151 " [-97.5, 38.629] "
3152 " ] "
3153 " ] "
3154 " }"));
3155
3156 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3157 " { \"type\": \"Polygon\", \"coordinates\": "
3158 " [ "
3159 " [ "
3160 " [41.83, 71.01], "
3161 " [56.95, 33.75], "
3162 " [21.79, 36.56], "
3163 " [41.83, 71.01] "
3164 " ] "
3165 " ] "
3166 " }"));
3167
3168 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3169 " { \"type\": \"Polygon\", \"coordinates\": "
3170 " [ "
3171 " [ "
3172 " [41.83, 71.01], "
3173 " [56.95, 33.75], "
3174 " [21.79, 36.56], "
3175 " [41.83, 71.01] "
3176 " ], "
3177 " [ "
3178 " [15.40, 15.40], "
3179 " [15.40, 25.40], "
3180 " [25.40, 25.40], "
3181 " [15.40, 15.40] "
3182 " ] "
3183 " ] "
3184 " }"));
3185
3186 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3187 " { \"type\": \"MultiPolygon\", \"coordinates\": "
3188 " [ "
3189 " [ "
3190 " [ "
3191 " [102.0, 2.0], "
3192 " [103.0, 2.0], "
3193 " [103.0, 3.0], "
3194 " [102.0, 3.0], "
3195 " [102.0, 2.0] "
3196 " ] "
3197 " ], "
3198 " [ "
3199 " [ "
3200 " [100.0, 0.0], "
3201 " [101.0, 0.0], "
3202 " [101.0, 1.0], "
3203 " [100.0, 1.0], "
3204 " [100.0, 0.0] "
3205 " ] "
3206 " ] "
3207 " ] "
3208 " }"));
3209
3210 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3211 " { \"type\": \"MultiPolygon\", \"coordinates\": "
3212 " [ "
3213 " [ "
3214 " [ "
3215 " [102.0, 2.0], "
3216 " [103.0, 2.0], "
3217 " [103.0, 3.0], "
3218 " [102.0, 3.0], "
3219 " [102.0, 2.0] "
3220 " ], "
3221 " [ "
3222 " [1.0, 0.0], "
3223 " [0.0, 0.0], "
3224 " [0.0, 1.0], "
3225 " [1.0, 0.0] "
3226 " ] "
3227 " ], "
3228 " [ "
3229 " [ "
3230 " [100.0, 0.0], "
3231 " [101.0, 0.0], "
3232 " [101.0, 1.0], "
3233 " [100.0, 1.0], "
3234 " [100.0, 0.0] "
3235 " ] "
3236 " ] "
3237 " ] "
3238 " }"));
3239
3240 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3241 " { \"type\": \"GeometryCollection\", \"geometries\": "
3242 " [ ] "
3243 " }"));
3244
3245 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3246 " { \"type\": \"GeometryCollection\", \"geometries\": "
3247 " [ "
3248 " { \"type\": \"GeometryCollection\", \"geometries\": "
3249 " [ "
3250 " { \"type\": \"GeometryCollection\", \"geometries\": "
3251 " [ ] "
3252 " } "
3253 " ] "
3254 " } "
3255 " ] "
3256 " }"));
3257
3258 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3259 " { \"type\": \"GeometryCollection\", \"geometries\": "
3260 " [ "
3261 " { \"type\": \"LineString\", \"coordinates\": "
3262 " [ "
3263 " [102.0, 0.0], "
3264 " [103.0, 1.0], "
3265 " [104.0, 0.0], "
3266 " [105.0, 1.0] "
3267 " ] "
3268 " }, "
3269 " { \"type\": \"LineString\", \"coordinates\": "
3270 " [ "
3271 " [102.0, 0.0], "
3272 " [103.0, 1.0], "
3273 " [104.0, 0.0], "
3274 " [105.0, 1.0] "
3275 " ] "
3276 " } "
3277 " ] "
3278 " }"));
3279
3280 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3281 " { \"type\": \"GeometryCollection\", \"geometries\": "
3282 " [ "
3283 " { \"type\": \"LineString\", \"coordinates\": "
3284 " [ "
3285 " [102.0, 0.0], "
3286 " [103.0, 1.0], "
3287 " [104.0, 0.0], "
3288 " [105.0, 1.0] "
3289 " ] "
3290 " }, "
3291 " { \"type\": \"LineString\", \"coordinates\": "
3292 " [ "
3293 " [102.0, 0.0], "
3294 " [103.0, 1.0], "
3295 " [104.0, 0.0], "
3296 " [105.0, 1.0] "
3297 " ] "
3298 " }, "
3299 " { \"type\": \"Point\", \"coordinates\": "
3300 " [102.0, 0.0] "
3301 " } "
3302 " ] "
3303 " }"));
3304
3305 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3306 " { \"type\": \"GeometryCollection\", \"geometries\": "
3307 " [ "
3308 " { \"type\": \"Point\", \"coordinates\": "
3309 " [102.0, 0.5] "
3310 " }, "
3311 " { \"type\": \"Point\", \"coordinates\": "
3312 " [102.0, 0.5] "
3313 " }, "
3314 " { \"type\": \"GeometryCollection\", \"geometries\": "
3315 " [ "
3316 " { \"type\": \"Point\", \"coordinates\": "
3317 " [102.0, 0.5] "
3318 " }, "
3319 " { \"type\": \"Point\", \"coordinates\": "
3320 " [102.0, 0.5] "
3321 " } "
3322 " ] "
3323 " }, "
3324 " { \"type\": \"Point\", \"coordinates\": "
3325 " [102.0, 0.5] "
3326 " } "
3327 " ] "
3328 " }"));
3329
3330 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3331 " { \"type\": \"GeometryCollection\", \"geometries\": "
3332 " [ "
3333 " { \"type\": \"MultiPoint\", \"coordinates\": "
3334 " [ "
3335 " [-105.01, 39.57], "
3336 " [-80.66, 35.0] "
3337 " ] "
3338 " }, "
3339 " { \"type\": \"Point\", \"coordinates\": "
3340 " [102.0, 0.5] "
3341 " }, "
3342 " { \"type\": \"Point\", \"coordinates\": "
3343 " [102.0, 0.5] "
3344 " }, "
3345 " { \"type\": \"GeometryCollection\", \"geometries\": "
3346 " [ "
3347 " { \"type\": \"Point\", \"coordinates\": "
3348 " [102.0, 0.5] "
3349 " }, "
3350 " { \"type\": \"Point\", \"coordinates\": "
3351 " [102.0, 0.5] "
3352 " } "
3353 " ] "
3354 " }, "
3355 " { \"type\": \"Point\", \"coordinates\": "
3356 " [102.0, 0.5] "
3357 " } "
3358 " ] "
3359 " }"));
3360
3361 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3362 " { \"type\": \"GeometryCollection\", \"geometries\": "
3363 " [ "
3364 " { \"type\": \"Point\", \"coordinates\": "
3365 " [-105.01621, 39.57422] "
3366 " }, "
3367 " { \"type\": \"MultiPoint\", \"coordinates\": "
3368 " [ "
3369 " [-105.01, 39.57], "
3370 " [-80.66, 35.05] "
3371 " ] "
3372 " }, "
3373 " { \"type\": \"LineString\", \"coordinates\": "
3374 " [ "
3375 " [-101.5, 39.662], "
3376 " [-101.75, 39.2415], "
3377 " [-101.64, 39.2415] "
3378 " ] "
3379 " }, "
3380 " { \"type\": \"MultiLineString\", \"coordinates\": "
3381 " [ "
3382 " [ "
3383 " [-101.5, 39.662], "
3384 " [-101.75, 39.2415], "
3385 " [-101.23, 39.2415], "
3386 " [-101.749, 39.7984], "
3387 " [-101.5, 39.011] "
3388 " ], "
3389 " [ "
3390 " [-99.23, 38.6605], "
3391 " [-99.56, 38.727], "
3392 " [-99.25, 38.018] "
3393 " ], "
3394 " [ "
3395 " [-98.499, 38.913], "
3396 " [-98.499, 38.913], "
3397 " [-98.38, 38.15], "
3398 " [-97.5, 38.629] "
3399 " ] "
3400 " ] "
3401 " }, "
3402 " { \"type\": \"Polygon\", \"coordinates\": "
3403 " [ "
3404 " [ "
3405 " [41.83,71.01], "
3406 " [56.95,33.75], "
3407 " [21.79,36.56], "
3408 " [41.83,71.01] "
3409 " ] "
3410 " ] "
3411 " }, "
3412 " { \"type\": \"MultiPolygon\", \"coordinates\": "
3413 " [ "
3414 " [ "
3415 " [ "
3416 " [102.0, 2.0], "
3417 " [103.0, 2.0], "
3418 " [103.0, 3.0], "
3419 " [102.0, 3.0], "
3420 " [102.0, 2.0] "
3421 " ] "
3422 " ], "
3423 " [ "
3424 " [ "
3425 " [100.0, 0.0], "
3426 " [101.0, 0.0], "
3427 " [101.0, 1.0], "
3428 " [100.0, 1.0], "
3429 " [100.0, 0.0] "
3430 " ] "
3431 " ] "
3432 " ] "
3433 " } "
3434 " ] "
3435 " }"));
3436
3437 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3438 " { "
3439 " \"type\": \"Feature\", \"id\": \"stadium\", \"geometry\": "
3440 " { \"type\": \"Point\", \"coordinates\": "
3441 " [-104.99404, 39.75621] "
3442 " }, "
3443 " \"properties\": "
3444 " { "
3445 " \"name\": \"Coors Field\", "
3446 " \"amenity\": \"Baseball Stadium\", "
3447 " \"popupContent\": \"This is where the Rockies play!\" "
3448 " } "
3449 " }"));
3450
3451 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3452 " { \"type\": \"FeatureCollection\", \"features\": "
3453 " [ "
3454 " { \"type\": \"Feature\", \"geometry\": "
3455 " { \"type\": \"Point\", \"coordinates\": "
3456 " [-80.83775386582222, 35.24980190252168] "
3457 " }, "
3458 " \"properties\": "
3459 " { "
3460 " \"name\": \"DOUBLE OAKS CENTER\", "
3461 " \"address\": \"1326 WOODWARD AV\" "
3462 " } "
3463 " }, "
3464 " { \"type\": \"Feature\", \"geometry\": "
3465 " { \"type\": \"Point\", \"coordinates\": "
3466 " [-80.83827000459532, 35.25674709224663] "
3467 " }, "
3468 " \"properties\": "
3469 " { "
3470 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
3471 " \"address\": \"2605 DOUBLE OAKS RD\" "
3472 " } "
3473 " } "
3474 " ] "
3475 " }"));
3476
3477 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3478 " { \"type\": \"FeatureCollection\", \"features\": "
3479 " [ "
3480 " { \"type\": \"Feature\", \"geometry\": "
3481 " { \"type\": \"Point\", \"coordinates\": "
3482 " [-80.83775386582222, 35.24980190252168] "
3483 " }, "
3484 " \"properties\": "
3485 " { "
3486 " \"name\": \"DOUBLE OAKS CENTER\", "
3487 " \"address\": \"1326 WOODWARD AV\" "
3488 " } "
3489 " }, "
3490 " { \"type\": \"Feature\", \"geometry\": "
3491 " { \"type\": \"Point\", \"coordinates\": "
3492 " [-80.83827000459532, 35.25674709224663] "
3493 " }, "
3494 " \"properties\": "
3495 " { "
3496 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
3497 " \"address\": \"2605 DOUBLE OAKS RD\" "
3498 " } "
3499 " }, "
3500 " { \"type\": \"Feature\", \"geometry\": "
3501 " null, "
3502 " \"properties\": "
3503 " { "
3504 " \"descr\": \"A NULL/EMPTY POINT\" "
3505 " } "
3506 " }, "
3507 " { \"type\": \"Feature\", \"geometry\": "
3508 " { \"type\": \"Point\", \"coordinates\": "
3509 " [-87.83827000459532, 42.0] "
3510 " }, "
3511 " \"properties\": "
3512 " { "
3513 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
3514 " \"address\": \"2605 DOUBLE OAKS RD\" "
3515 " } "
3516 " } "
3517 " ] "
3518 " }"));
3519
3520 # Force SRID 0 to avoid coordinate range check.
3521 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3522 "{ \"type\": \"Point\", \"coordinates\": [1.23e3, 2.2e-1]}", 1, 0));
3523
3524 # Force SRID 0 to avoid coordinate range check.
3525 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3526 "{ \"type\": \"Point\", \"coordinates\": [1e-300, 1e300]}", 1, 0));
3527
3528 # Force SRID 0 to avoid coordinate range check.
3529 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3530 "{ \"type\": \"Point\", \"coordinates\": [1.7976931348623157E+308, -1.7976931348623157E+308]}", 1, 0));
3531
3532 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3533 "{ \"type\": \"Point\", \"coordinates\": [10, 20] }"));
3534
3535 --error ER_SRS_NOT_FOUND
3536 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3537 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3538 " \"crs\": "
3539 " { \"type\": \"name\", \"properties\": "
3540 " { \"name\": \"urn:ogc:def:crs:EPSG::1234\" } "
3541 " } "
3542 " }"), 5, 0);
3543
3544 --error ER_SRS_NOT_FOUND
3545 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3546 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3547 " \"crs\": "
3548 " { \"type\": \"name\", \"properties\": "
3549 " { \"name\": \"urn:ogc:def:crs:EPSG::1\" } "
3550 " } "
3551 " }"), 5, 1);
3552
3553 --error ER_SRS_NOT_FOUND
3554 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3555 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3556 " \"crs\": "
3557 " { \"type\": \"name\", \"properties\": "
3558 " { \"name\": \"urn:ogc:def:crs:EPSG::4294967295\" } "
3559 " } "
3560 " }"), 5, 2);
3561
3562 --error ER_SRS_NOT_FOUND
3563 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3564 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3565 " \"crs\": "
3566 " { \"type\": \"name\", \"properties\": "
3567 " { \"name\": \"EPSG:234\" } "
3568 " } "
3569 " }"), 5, 3);
3570
3571 --error ER_SRS_NOT_FOUND
3572 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3573 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3574 " \"crs\": "
3575 " { \"type\": \"name\", \"properties\": "
3576 " { \"name\": \"EPSG:1\" } "
3577 " } "
3578 " }"), 5, 5);
3579
3580 --error ER_SRS_NOT_FOUND
3581 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3582 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3583 " \"crs\": "
3584 " { \"type\": \"name\", \"properties\": "
3585 " { \"name\": \"EPSG:4294967295\" } "
3586 " } "
3587 " }"), 5, 7);
3588
3589 SELECT ST_ASGEOJSON(ST_GEOMFROMGEOJSON(
3590 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3591 " \"crs\": null "
3592 " }"));
3593
3594 --echo # Check that GeomFromGeoJSON can read data from a JSON field.
3595
3596 CREATE TABLE json_tbl
3597 (
3598 id INT NOT NULL AUTO_INCREMENT,
3599 json_value JSON,
3600 PRIMARY KEY (id)
3601 );
3602
3603 INSERT INTO json_tbl (json_value) VALUES
3604 ('{ "type": "Point", "coordinates": [100.0, 0.0] }'),
3605 ('{
3606 "type": "LineString",
3607 "coordinates":
3608 [ [100.0, 0.0], [101.0, 1.0] ]
3609 }'),
3610 ('{
3611 "type": "Polygon",
3612 "coordinates":
3613 [ [ [100.0, 0.0], [101.0, 0.0], [101.0, 1.0], [100.0, 1.0], [100.0, 0.0] ] ]
3614 }'),
3615 ('{
3616 "type": "Polygon",
3617 "coordinates": [
3618 [ [100.0, 0.0], [101.0, 0.0], [101.0, 1.0], [100.0, 1.0], [100.0, 0.0] ],
3619 [ [100.2, 0.2], [100.8, 0.2], [100.8, 0.8], [100.2, 0.8], [100.2, 0.2] ]
3620 ]
3621 }'),
3622 ('{
3623 "type": "MultiPoint",
3624 "coordinates": [ [100.0, 0.0], [101.0, 1.0] ]
3625 }'),
3626 ('{ "type": "Point", "coordinates": [-12.144, 13.736489] }');
3627
3628 SELECT ST_AsText(ST_GeomFromGeoJSON(json_value)) FROM json_tbl;
3629 DROP TABLE json_tbl;
3630
3631 #####################################################################
3632 # Bug#19342661
3633 #####################################################################
3634 --echo # Checking that member and type names with extra ending does not get
3635 --echo # accepted/validated.
3636
3637 --error ER_INVALID_GEOJSON_MISSING_MEMBER
3638 SELECT ST_GEOMFROMGEOJSON(
3639 "{ "
3640 " \"type1234567890\": \"Point\", "
3641 " \"coordinates\": [102, 11] "
3642 "} "
3643 );
3644
3645 --error ER_INVALID_GEOJSON_MISSING_MEMBER
3646 SELECT ST_GEOMFROMGEOJSON(
3647 "{ "
3648 " \"type \": \"Point\", "
3649 " \"coordinates\": [102, 11] "
3650 "} "
3651 );
3652
3653 --error ER_INVALID_GEOJSON_UNSPECIFIED
3654 SELECT ST_GEOMFROMGEOJSON(
3655 "{ "
3656 " \"type\": \"Point \", "
3657 " \"coordinates\": [102, 11] "
3658 "} "
3659 );
3660
3661 --error ER_INVALID_GEOJSON_UNSPECIFIED
3662 SELECT ST_GEOMFROMGEOJSON(
3663 "{ "
3664 " \"type\": \"Pointt\", "
3665 " \"coordinates\": [102, 11] "
3666 "} "
3667 );
3668
3669 --error ER_INVALID_GEOJSON_MISSING_MEMBER
3670 SELECT ST_GEOMFROMGEOJSON(
3671 "{ "
3672 " \"type\": \"Point\", "
3673 " \"coordinates \": [102, 11] "
3674 "} "
3675 );
3676
3677 --error ER_INVALID_GEOJSON_MISSING_MEMBER
3678 SELECT ST_GEOMFROMGEOJSON(
3679 "{ "
3680 " \"type\": \"Point\", "
3681 " \"coordinatess\": [102, 11] "
3682 "} "
3683 );
3684
3685 #####################################################################
3686 # Bug#19499584
3687 #####################################################################
3688 --echo # Check that rapidjson parses decimal numbers with trailing zeroes
3689 --echo # correctly.
3690
3691 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3692 "{ "
3693 " \"type\": \"Point\", "
3694 " \"coordinates\": [102.0000, 11] "
3695 "} "
3696 ));
3697
3698 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3699 "{ "
3700 " \"type\": \"Point\", "
3701 " \"coordinates\": [102.00000, 11] "
3702 "} "
3703 ));
3704
3705 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3706 "{ "
3707 " \"type\": \"Point\", "
3708 " \"coordinates\": [102.000000, 11] "
3709 "} "
3710 ));
3711
3712 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3713 "{ "
3714 " \"type\": \"Point\", "
3715 " \"coordinates\": [10.0000, 11] "
3716 "} "
3717 ));
3718
3719 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3720 "{ "
3721 " \"type\": \"Point\", "
3722 " \"coordinates\": [10.00000, 11] "
3723 "} "
3724 ));
3725
3726 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3727 "{ "
3728 " \"type\": \"Point\", "
3729 " \"coordinates\": [10.000000, 11] "
3730 "} "
3731 ));
3732
3733 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3734 "{ "
3735 " \"type\": \"Point\", "
3736 " \"coordinates\": [10.00000000000000000000000000000000000, 11] "
3737 "} "
3738 ));
3739
3740 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3741 "{ "
3742 " \"type\": \"Point\", "
3743 " \"coordinates\": [102, 11.0000] "
3744 "} "
3745 ));
3746
3747 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3748 "{ "
3749 " \"type\": \"Point\", "
3750 " \"coordinates\": [102, 11.00000] "
3751 "} "
3752 ));
3753
3754 SELECT ST_ASTEXT(ST_GEOMFROMGEOJSON(
3755 "{ "
3756 " \"type\": \"Point\", "
3757 " \"coordinates\": [102, 11.000000] "
3758 "} "
3759 ));
3760
3761 #####################################################################
3762 # Bug#19657747
3763 #####################################################################
3764 --error ER_WRONG_VALUE_FOR_TYPE
3765 SELECT ST_ASGEOJSON(POINT(1, 1), -9223372036854775808);
3766
3767 --error ER_WRONG_VALUE_FOR_TYPE
3768 SELECT ST_ASGEOJSON(POINT(1, 1), 10, -9223372036854775808);
3769
3770 --error ER_WRONG_VALUE_FOR_TYPE
3771 SELECT ST_ASGEOJSON(POINT(1, 1), 18446744073709551615);
3772
3773 --error ER_WRONG_VALUE_FOR_TYPE
3774 SELECT ST_ASGEOJSON(POINT(1, 1), 10, 18446744073709551615);
3775
3776 --error ER_DATA_OUT_OF_RANGE
3777 SELECT ST_GEOMFROMGEOJSON('{"type":"Point", "coordinates":[10, 20]}', 1, -9223372036854775808);
3778
3779 --error ER_WRONG_VALUE_FOR_TYPE
3780 SELECT ST_GEOMFROMGEOJSON('{"type":"Point", "coordinates":[10, 20]}', -9223372036854775808);
3781
3782 --error ER_DATA_OUT_OF_RANGE
3783 SELECT ST_GEOMFROMGEOJSON('{"type":"Point", "coordinates":[10, 20]}', 1, 18446744073709551615);
3784
3785 --error ER_WRONG_VALUE_FOR_TYPE
3786 SELECT ST_GEOMFROMGEOJSON('{"type":"Point", "coordinates":[10, 20]}', 18446744073709551615);
3787
3788 # These will be of incorrect type, since they are recogniced as decimals.
3789 --error ER_INCORRECT_TYPE
3790 SELECT ST_ASGEOJSON(POINT(1, 1), -9223372036854775809);
3791
3792 --error ER_INCORRECT_TYPE
3793 SELECT ST_ASGEOJSON(POINT(1, 1), 10, -9223372036854775809);
3794
3795 --error ER_INCORRECT_TYPE
3796 SELECT ST_ASGEOJSON(POINT(1, 1), 18446744073709551616);
3797
3798 --error ER_INCORRECT_TYPE
3799 SELECT ST_ASGEOJSON(POINT(1, 1), 10, 18446744073709551616);
3800
3801 --error ER_INCORRECT_TYPE
3802 SELECT ST_GEOMFROMGEOJSON('{"type":"Point", "coordinates":[10, 20]}', 1, -9223372036854775809);
3803
3804 --error ER_INCORRECT_TYPE
3805 SELECT ST_GEOMFROMGEOJSON('{"type":"Point", "coordinates":[10, 20]}', -9223372036854775809);
3806
3807 --error ER_INCORRECT_TYPE
3808 SELECT ST_GEOMFROMGEOJSON('{"type":"Point", "coordinates":[10, 20]}', 1, 18446744073709551616);
3809
3810 --error ER_INCORRECT_TYPE
3811 SELECT ST_GEOMFROMGEOJSON('{"type":"Point", "coordinates":[10, 20]}', 18446744073709551616);
3812
3813 #########################
3814 # Bug#20416705 #
3815 #########################
3816 CREATE TABLE geojson(
3817 gid INT NOT NULL AUTO_INCREMENT,
3818 geojson_value TEXT,
3819 PRIMARY KEY (`gid`)
3820 );
3821
3822 INSERT INTO geojson (geojson_value) VALUES
3823 (ST_AsGeoJSON(ST_GeomFromText('POINT(10 11)', 4326), 100, 2)),
3824 (ST_AsGeoJSON(ST_GeomFromText('POINT(-1.324 66.231)', 0), 100, 2)),
3825 (ST_AsGeoJSON(ST_GeomFromText('POINT(98.344 -23.001)', 0), 100, 2)),
3826 (ST_AsGeoJSON(ST_GeomFromText('POINT(0.0 0.0)', 0), 100, 2));
3827
3828 SELECT ST_AsText(ST_GeomFromGeoJSON(geojson_value)) FROM geojson;
3829
3830 SELECT ST_SRID(ST_GeomFromGeoJSON(geojson_value)) FROM geojson;
3831
3832 DROP TABLE geojson;
3833
3834 --echo #
3835 --echo # Bug#21384048 ASSERTION FAILED: N >= 0 && N <= 308
3836 --echo # IN RAPIDJSON::INTERNAL::FASTPATH
3837 --echo #
3838 --error ER_INVALID_GEOJSON_UNSPECIFIED
3839 SELECT ST_GEOMFROMGEOJSON('1E-36181012216111515851075235238');
3840 --error ER_INVALID_GEOJSON_UNSPECIFIED
3841 SELECT ST_GEOMFROMGEOJSON('-1E-36181012216111515851075235238');
3842 --error ER_INVALID_JSON_TEXT_IN_PARAM
3843 SELECT ST_GEOMFROMGEOJSON('1E+36181012216111515851075235238');
3844 --error ER_INVALID_JSON_TEXT_IN_PARAM
3845 SELECT ST_GEOMFROMGEOJSON('-1E+36181012216111515851075235238');
3846
3847
3848 --echo #
3849 --echo # Bug#21389101 ST_GEOMFROMGEOJSON: STACK OVERFLOW IN
3850 --echo # RAPIDJSON::GENERICREADER
3851 --echo #
3852
3853 --error ER_JSON_DOCUMENT_TOO_DEEP
3854 SELECT ST_GeomFromGeoJSON(REPEAT('[', 1000));
3855
3856 --error ER_JSON_DOCUMENT_TOO_DEEP
3857 SELECT ST_GeomFromGeoJSON(REPEAT('{"foo":', 1000));
3858
3859
3860 --echo #
3861 --echo # Bug#21616810 CONNECTION HANG OR ASSERTION 0 IN
3862 --echo # THD::SEND_STATEMENT_STATUS, SQL_CLASS.CC
3863 --echo #
3864
3865 CREATE TABLE t (a INT) ENGINE=InnoDB;
3866 INSERT INTO t (a) VALUES (0), (1);
3867 SELECT 1 FROM t GROUP BY ST_AsGeoJSON(NULL, "1", NULL);
3868 SELECT 1 FROM t GROUP BY ST_AsGeoJSON(NULL, 5, 0);
3869 DROP TABLE t;
3870
3871 --echo #
3872 --echo # Bug#22804853 ST_GEOMFROMGEOJSON: ASSERTION FAILED: 0, FILE FILESORT.CC
3873 --echo #
3874
3875 CREATE TABLE t (a INT) ENGINE=InnoDB;
3876 INSERT INTO t VALUES (1), (2);
3877 --error ER_GIS_INVALID_DATA
3878 SELECT DISTINCT SQL_BIG_RESULT ST_GeomFromGeoJSON('1', 1, ST_SRID(a)) FROM t;
3879 DROP TABLE t;
3880
3881 --echo #
3882 --echo # Bug#22912800 ST_ASGEOJSON() DOESN'T WORK WITH SESSION VARIABLES
3883 --echo #
3884
3885 SET @geometry := ST_GeomFromText("POINT(4.9 52.366667)");
3886 SELECT ST_AsGeoJSON(@geometry);
3887
3888 --echo #
3889 --echo # Bug#22930020 INVALID DATA FOR ST_GEOMFROMGEOJSON() IS HARD TO DIAGNOSE
3890 --echo #
3891
3892 CREATE TABLE t1 (col1 JSON);
3893
3894 INSERT INTO t1 (col1) VALUES
3895 ('{ "type": "Feature", "geometry": null, "properties": {} }');
3896
3897 ALTER TABLE t1 ADD COLUMN `col2` geometry
3898 GENERATED ALWAYS AS (ST_GeomFromGeoJSON(col1->'$.geometry')) VIRTUAL;
3899
3900 SELECT * FROM t1;
3901
3902 SELECT ST_GeomFromGeoJSON(CAST('null' AS JSON));
3903 SELECT ST_GeomFromGeoJSON('null');
3904 --error ER_INVALID_JSON_TEXT_IN_PARAM
3905 SELECT ST_GeomFromGeoJSON('Null');
3906
3907 DROP TABLE t1;
3908
3909 --echo #
3910 --echo # WL#8579 Spatial Reference Systems
3911 --echo #
3912
3913 --echo # SRID 0 (should pass)
3914 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT('POINT(0 0)', 0));
3915 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
3916 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3917 " \"crs\": "
3918 " { \"type\": \"name\", \"properties\": "
3919 " { \"name\": \"urn:ogc:def:crs:OGC:1.3:crs84\" } "
3920 " } "
3921 " }", 1, 0));
3922
3923 --echo # Projected SRS (should pass)
3924 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT('POINT(0 0)', 2000));
3925 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
3926 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3927 " \"crs\": "
3928 " { \"type\": \"name\", \"properties\": "
3929 " { \"name\": \"urn:ogc:def:crs:OGC:1.3:crs84\" } "
3930 " } "
3931 " }", 1, 2000));
3932
3933 --echo # Geographic SRS (should pass)
3934 SELECT ST_ASGEOJSON(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
3935 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
3936 " { \"type\": \"Point\", \"coordinates\": [10, 20], "
3937 " \"crs\": "
3938 " { \"type\": \"name\", \"properties\": "
3939 " { \"name\": \"urn:ogc:def:crs:OGC:1.3:crs84\" } "
3940 " } "
3941 " }", 1, 4326));
3942
3943 --echo #
3944 --echo # Bug #26941370 ST_GEOMFROMGEOJSON ALLOWS OUT-OF-RANGE COORDINATES
3945 --echo #
3946
3947 --error ER_LONGITUDE_OUT_OF_RANGE
3948 SELECT ST_AsText(
3949 ST_GeomFromGeoJSON('{"type": "Point", "coordinates":[-180.0, 0.0]}')
3950 );
3951
3952 SELECT ST_AsText(
3953 ST_GeomFromGeoJSON('{"type": "Point", "coordinates":[-179.99999999999, 0.0]}')
3954 );
3955
3956 SELECT ST_AsText(
3957 ST_GeomFromGeoJSON('{"type": "Point", "coordinates":[180.0, 0.0]}')
3958 );
3959
3960 --error ER_LONGITUDE_OUT_OF_RANGE
3961 SELECT ST_AsText(
3962 ST_GeomFromGeoJSON('{"type": "Point", "coordinates":[180.000000000001, 0.0]}')
3963 );
3964
3965 --error ER_LATITUDE_OUT_OF_RANGE
3966 SELECT ST_AsText(
3967 ST_GeomFromGeoJSON('{"type": "Point", "coordinates":[0.0, -90.000000000001]}')
3968 );
3969
3970 SELECT ST_AsText(
3971 ST_GeomFromGeoJSON('{"type": "Point", "coordinates":[0.0, -90.0]}')
3972 );
3973
3974 SELECT ST_AsText(
3975 ST_GeomFromGeoJSON('{"type": "Point", "coordinates":[0.0, 90.0]}')
3976 );
3977
3978 --error ER_LATITUDE_OUT_OF_RANGE
3979 SELECT ST_AsText(
3980 ST_GeomFromGeoJSON('{"type": "Point", "coordinates":[0.0, 90.0000000000001]}')
3981 );
3982
3983 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
3984 " { \"type\": \"FeatureCollection\", "
3985 " \"features\": "
3986 " [ "
3987 " { \"type\": \"Feature\", \"geometry\": "
3988 " { \"type\": \"Point\", \"coordinates\": "
3989 " [-80.83775386582222, 35.24980190252168] "
3990 " }, "
3991 " \"properties\": "
3992 " { "
3993 " \"name\": \"DOUBLE OAKS CENTER\", "
3994 " \"address\": \"1326 WOODWARD AV\" "
3995 " } "
3996 " }, "
3997 " { \"type\": \"Feature\", \"geometry\": "
3998 " { \"type\": \"Point\", \"coordinates\": "
3999 " [-80.83827000459532, 35.25674709224663] "
4000 " }, "
4001 " \"properties\": "
4002 " { "
4003 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
4004 " \"address\": \"2605 DOUBLE OAKS RD\" "
4005 " } "
4006 " }, "
4007 " { \"type\": \"Feature\", \"geometry\": "
4008 " null, "
4009 " \"properties\": "
4010 " { "
4011 " \"descr\": \"A NULL/EMPTY POINT\" "
4012 " } "
4013 " }, "
4014 " { \"type\": \"Feature\", \"geometry\": "
4015 " { \"type\": \"Point\", "
4016 " \"crs\": "
4017 " { \"type\": \"name\", \"properties\": "
4018 " { \"name\": \"EPSG:4326\" } "
4019 " }, "
4020 " \"coordinates\": "
4021 " [-87.83827000459532, 42.0] "
4022 " }, "
4023 " \"properties\": "
4024 " { "
4025 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
4026 " \"address\": \"2605 DOUBLE OAKS RD\" "
4027 " } "
4028 " } "
4029 " ] "
4030 " }")) AS srid;
4031
4032 --error ER_INVALID_GEOJSON_CRS_NOT_TOP_LEVEL
4033 SELECT ST_SRID(ST_GEOMFROMGEOJSON(
4034 " { \"type\": \"FeatureCollection\", "
4035 " \"features\": "
4036 " [ "
4037 " { \"type\": \"Feature\", \"geometry\": "
4038 " { \"type\": \"Point\", \"coordinates\": "
4039 " [-80.83775386582222, 35.24980190252168] "
4040 " }, "
4041 " \"properties\": "
4042 " { "
4043 " \"name\": \"DOUBLE OAKS CENTER\", "
4044 " \"address\": \"1326 WOODWARD AV\" "
4045 " } "
4046 " }, "
4047 " { \"type\": \"Feature\", \"geometry\": "
4048 " { \"type\": \"Point\", \"coordinates\": "
4049 " [-80.83827000459532, 35.25674709224663] "
4050 " }, "
4051 " \"properties\": "
4052 " { "
4053 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
4054 " \"address\": \"2605 DOUBLE OAKS RD\" "
4055 " } "
4056 " }, "
4057 " { \"type\": \"Feature\", \"geometry\": "
4058 " null, "
4059 " \"properties\": "
4060 " { "
4061 " \"descr\": \"A NULL/EMPTY POINT\" "
4062 " } "
4063 " }, "
4064 " { \"type\": \"Feature\", \"geometry\": "
4065 " { \"type\": \"Point\", "
4066 " \"crs\": "
4067 " { \"type\": \"name\", \"properties\": "
4068 " { \"name\": \"EPSG:2000\" } "
4069 " }, "
4070 " \"coordinates\": "
4071 " [-87.83827000459532, 42.0] "
4072 " }, "
4073 " \"properties\": "
4074 " { "
4075 " \"name\": \"DOUBLE OAKS NEIGHBORHOOD PARK\", "
4076 " \"address\": \"2605 DOUBLE OAKS RD\" "
4077 " } "
4078 " } "
4079 " ] "
4080 " }")) AS srid;
4081
4082 --echo #
4083 --echo # Bug#32047630: MISSING ERROR PROPAGATION IN JSON FUNCTIONS
4084 --echo #
4085
4086 # Used to cause an assert failure.
4087 --error ER_GIS_INVALID_DATA
4088 SELECT JSON_ARRAY(ST_ASGEOJSON(ST_GEOMFROMTEXT('')), 1);
4089
4090 # Exercise a previously untested error path.
4091 --error ER_GIS_INVALID_DATA
4092 SELECT JSON_ARRAY(ST_ASGEOJSON(0x00), 1);