Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # ST_IsValid checks whether a geometry is valid. #
4 # The validity is defined by OGC standard documents. #
5 # #
6 # Creation Date: 2014-12-01 #
7 # Author : Pavan Naik #
8 # #
9 ###############################################################################
10
11
12 ############################################################################################
13 # Creating the spatial objects #
14 ############################################################################################
15
16 --echo # Creating the spatial Geometry object
17 USE test;
18
19 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
20
21 ############################################################################################
22 # Inserting the values specific to the spatial objects #
23 ############################################################################################
24
25 # Geometric elements constructing a star and some of its elememts as base
26 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
27 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
28 SET @star_center= 'POINT(15 10)';
29 SET @star_top= 'POINT(15 25)';
30 SET @star_bottom_left= 'POINT(5 0)';
31 SET @star_bottom_right= 'POINT(25 0)';
32 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
33 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
34 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
35 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
36 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
37 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
38 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
39 SET @star= 'POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))';
40 SET @star_of_elems='MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))';
41 SET @star_collection_elems='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
42 SET @star_collection_multilinestr='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),MULTILINESTRING((25 0,0 15,15 30,0 5)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
43
44 --echo # INSERT base star
45 --disable_warnings
46 INSERT INTO gis_geometrycollection VALUES
47 (100,ST_GEOMFROMTEXT(@star)),
48 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
49 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
50 (103,ST_GEOMFROMTEXT(@star_of_elems)),
51 (104,ST_GEOMFROMTEXT(@star_top)),
52 (105,ST_GEOMFROMTEXT(@star_center)),
53 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
54 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
55 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
56 (109,ST_GEOMFROMTEXT(@star_all_points)),
57 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
58 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
59 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
60 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
61 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
62 (115,ST_GEOMFROMTEXT(@star_collection_elems)),
63 (116,ST_GEOMFROMTEXT(@star_collection_multilinestr));
64 --enable_warnings
65
66 --echo # Checking the integrity of the above create/insert statements
67
68 --echo # 17 rows.
69 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
70
71 --echo #####################################################################################
72 --echo # ST_ISVALID(geometry)
73 --echo #####################################################################################
74
75 --echo #====================================================================================
76 --echo # point
77 --echo #====================================================================================
78 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_center));
79
80 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_top));
81
82 SELECT ST_ISVALID(g) FROM gis_geometrycollection WHERE fid=105;
83
84 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(2.34 -2.34)'));
85
86 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(1e308 -1e308)'));
87
88 --echo #====================================================================================
89 --echo # multipoint
90 --echo #====================================================================================
91 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_all_points));
92
93 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_bottom_points));
94
95 SELECT ST_ISVALID(g) FROM gis_geometrycollection WHERE fid=108;
96
97 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)'));
98
99 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0,0 0)'));
100
101 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1e308 -1e308,0.0001 0.000)'));
102
103 --echo #====================================================================================
104 --echo # linestring
105 --echo #====================================================================================
106 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_top_to_center));
107
108 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_line_horizontal));
109
110 SELECT ST_ISVALID(g) FROM gis_geometrycollection WHERE fid=110;
111
112 --error ER_GIS_INVALID_DATA
113 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING(0 0)'));
114
115 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING(0 0,-0.00 0,0.0 0)'));
116
117 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
118
119 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING(1 -1,1e308 -1e308,0.0001 0.000)'));
120
121 --echo #====================================================================================
122 --echo # multilinestring
123 --echo #====================================================================================
124 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_lines_near_vertical));
125
126 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_lines_near_horizontal));
127
128 SELECT ST_ISVALID(g) FROM gis_geometrycollection WHERE fid=114;
129
130 --error ER_GIS_INVALID_DATA
131 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTILINESTRING((0 0))'));
132
133 --error ER_GIS_INVALID_DATA
134 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,2 2),(3 3))'));
135
136 --error ER_GIS_INVALID_DATA
137 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0.00 0),(0.0 0))'));
138
139 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'));
140
141 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'));
142
143 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1e308 -1e308,0.0001 0.000),(2 2,4 -9.002))'));
144
145 --echo #====================================================================================
146 --echo # polygon
147 --echo #====================================================================================
148 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star));
149
150 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_elem_vertical));
151
152 SELECT ST_ISVALID(g) FROM gis_geometrycollection WHERE fid=100;
153
154 --error ER_GIS_INVALID_DATA
155 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0))'));
156
157 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,0 0))'));
158
159 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0))'));
160
161 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0,-10 0,-10 -10,0 -10,0 0))'));
162
163 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4))'));
164
165 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(0 0,0 10,10 10,10 0,0 0))'));
166
167 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4,4 4),(0 0,0 10,10 10,10 0,0 0))'));
168
169 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4,4 4),(8 8,8 10,10 10,10 8,8 8))'));
170
171 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,6 4,6 6,4 6,4 4),(4 4,4 6,6 6,6 4,4 4))'));
172
173 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,6 4,6 6,4 6,4 4),(6 6,6 8,8 8,8 6,6 6))'));
174
175 --echo #====================================================================================
176 --echo # multipolygon
177 --echo #====================================================================================
178 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_of_elems));
179
180 SELECT ST_ISVALID(g) FROM gis_geometrycollection WHERE fid=103;
181
182 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))'));
183
184 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 1 1, 1 1, 1 1, 1 1)))'));
185
186 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))'));
187
188 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))'));
189
190 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0)),((4 4,4 6,6 6,6 4,4 4,4 4)))'));
191
192 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
193
194 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0),(0 0,0 10,10 10,10 0,0 0)))'));
195
196 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4,4 4),(0 0,0 10,10 10,10 0,0 0)))'));
197
198 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4,4 4),(8 8,8 10,10 10,10 8,8 8)))'));
199
200 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 0,5 10,10 10)),((0 10,0 20,5 10,0 10)))'));
201
202 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4,4 4)))'));
203
204 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0,0 0)))'));
205
206 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,4 6,6 6,4 4)))'));
207
208 --echo #====================================================================================
209 --echo # geometrycollection
210 --echo #====================================================================================
211 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_collection_elems));
212
213 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_collection_multilinestr));
214
215 SELECT ST_ISVALID(g) FROM gis_geometrycollection WHERE fid=115;
216
217 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'));
218
219 --error ER_GIS_INVALID_DATA
220 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0))'));
221
222 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))'));
223
224 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10))'));
225
226 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10)))'));
227
228 --error ER_GIS_INVALID_DATA
229 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0),POINT(10 10))'));
230
231 --error ER_GIS_INVALID_DATA
232 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0),GEOMETRYCOLLECTION())'));
233
234 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 1,2 2,0 0)),GEOMETRYCOLLECTION())'));
235
236 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),POLYGON((0 0,10 10,100 100,0 0)))'));
237
238 --error ER_GIS_INVALID_DATA
239 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0),POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
240
241 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
242 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)))'));
243
244 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),'
245 'MULTIPOINT(0 0,10 10),'
246 'LINESTRING(1 1,2 2,3 3),'
247 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)))'));
248
249 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)))'));
250
251 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION('
252 'GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)))))'));
253
254 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
255 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0)),((10 10,10 15,15 15,15 10,10 10))))'));
256
257 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
258 'MULTIPOINT(0 0,10 10)),'
259 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
260 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10))))'));
261
262 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
263 'MULTIPOINT(0 0,10 10)),'
264 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
265 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10))),'
266 'GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
267 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0)),((10 10,10 15,15 15,15 10,10 10)))))'));
268
269 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
270 'MULTIPOINT(0 0,10 10)),'
271 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
272 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10))),'
273 'GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))'));
274
275 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
276 'LINESTRING(1 1,2 2,3 3),'
277 'POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
278 'MULTIPOINT(0 0,10 10),'
279 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)),'
280 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,0 0)),((10 10,10 15,15 15,15 10,10 10))))'));
281
282 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((-7 -2,-9 3,-2 -8),(3 7,5 6,-7 -9,7 -1,-2 -8,2 9,4 6,-5 -5)),'
283 'MULTILINESTRING((2 -2,2 -3,2 -1,-10 7,1 -2,-2 0,-9 -2,10 5,-7 -8,-9 -1,1 -1,-2 3,5 -9,-8 -9,-10 -9)),'
284 'MULTIPOINT(-7 -5,6 9,7 4))'));
285
286 --echo #####################################################################################
287 --echo # Invalid function calls
288 --echo #####################################################################################
289
290 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
291 SELECT ST_ISVALID();
292
293 SELECT ST_ISVALID(NULL);
294
295 --error ER_GIS_INVALID_DATA
296 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT()'));
297
298 --error ER_GIS_INVALID_DATA
299 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING()'));
300
301 --error ER_GIS_INVALID_DATA
302 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON(())'));
303
304 --error ER_GIS_INVALID_DATA
305 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOINT()'));
306
307 --error ER_GIS_INVALID_DATA
308 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTILINESTRING(())'));
309
310 --error ER_GIS_INVALID_DATA
311 SELECT ST_ISVALID(ST_GEOMFROMTEXT('MULTIPOLYGON((()))'));
312
313 --error ER_GIS_INVALID_DATA
314 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(a 0)'));
315
316 --error ER_GIS_INVALID_DATA
317 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(! 0)'));
318
319 --error ER_PARSE_ERROR
320 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT('!' 0)'));
321
322 --error ER_GIS_INVALID_DATA
323 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(12,34 0)'));
324
325 --error ER_GIS_INVALID_DATA
326 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'));
327
328 --error ER_GIS_INVALID_DATA
329 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'));
330
331 --error ER_PARSE_ERROR
332 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'));
333
334 --error ER_GIS_INVALID_DATA
335 SELECT ST_ISVALID(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'));
336
337 --error ER_GIS_INVALID_DATA
338 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'));
339
340 --error ER_GIS_INVALID_DATA
341 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'));
342
343 --error ER_PARSE_ERROR
344 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'));
345
346 --error ER_GIS_INVALID_DATA
347 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'));
348
349 --error ER_DATA_OUT_OF_RANGE
350 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_center,-1024));
351
352 --error ER_DATA_OUT_OF_RANGE
353 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_all_points,-1));
354
355 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_lines_near_vertical,4236));
356
357 --error ER_SRS_NOT_FOUND
358 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_elem_vertical,4294967295));
359
360 --error ER_DATA_OUT_OF_RANGE
361 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_of_elems,4294967297));
362
363 --error ER_DATA_OUT_OF_RANGE
364 SELECT ST_ISVALID(ST_GEOMFROMTEXT(@star_collection_elems,4294967295000));
365
366 # This is an example of a working wkb, first the SRID, specification it is
367 # littleendian, and is a point with coordinates (0,0)
368 SELECT ST_ISVALID( x'e6100000010100000000000000000000000000000000000000');
369
370 --error ER_GIS_INVALID_DATA
371 SELECT ST_ISVALID( x'e6100000020000000100000000000000000000000000000000');
372
373 --error ER_GIS_INVALID_DATA
374 SELECT ST_ISVALID( x'00000000000001000001010000000000000000000000000000');
375
376 --error ER_GIS_INVALID_DATA
377 SELECT ST_ISVALID( x'e6100000060100000000000000000000000000000000000000');
378
379 --error ER_GIS_INVALID_DATA
380 SELECT ST_ISVALID(0x000000000600000001000000000200000002000000);
381
382 --error ER_GIS_INVALID_DATA
383 SELECT ST_ISVALID(0x000000000200000001000000050000000000000000);
384
385 --error ER_SRS_NOT_FOUND
386 SELECT ST_ISVALID(0x010300000002000000010300000002000000050000);
387
388 --error ER_SRS_NOT_FOUND
389 SELECT ST_ISVALID(0x010400000002000000010100000000000000000000);
390
391 --echo # Clean up
392 DROP TABLE gis_geometrycollection;
393
394 --echo ########################################################################
395 --echo # BUG#21927394 ST_ISVALID() RETURNS FALSE WITH VALID POLYGON GEOMETRY
396 --echo ########################################################################
397 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((72.8714768817168
398 -167.0048853643874,9274.40641550926 3433.5957427942167,-58.09039811390054
399 187.50989457746405,-81.09039811390053 179.50989457746405,-207.99999999999997
400 135.36742435621204,-208 1,-208 0,-208 -276.9111154485375,49.8714768817168
401 -176.0048853643874,72.8714768817168 -167.0048853643874))'));
402
403 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POLYGON((-200 0,-207.99999999999997
404 135.36742435621204,-208 1,-208 0,-208 -276.9111154485375,-200 0))'));
405
406 --echo #
407 --echo # WL#8579 Spatial Reference Systems
408 --echo #
409
410 --echo # SRID 0 (should pass)
411 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(0 0)', 0));
412
413 --echo # Projected SRS (should pass)
414 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(0 0)', 2000));
415
416 --echo # Geographic SRS (shall pass)
417 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
418
419 --echo # Verify that ST_IsValid() returns NULL if at least one of its parameters
420 --echo # is NULL
421 SELECT ST_ISVALID(NULL);
422 --echo # Verify that ST_IsValid() doesn't return NULL if its arguments are not
423 --echo # NULL
424 SELECT ST_ISVALID(ST_GEOMFROMTEXT('POINT(0 0)',4053));
425 --echo # Verify that ST_IsValid() returns ER_GIS_INVALID_DATA error if geometry
426 --echo # argument is not syntactically well-formed geometry
427 --error ER_GIS_INVALID_DATA
428 DO ST_ISVALID(X'FF');
429 --echo # Verify that ST_IsValid() returns 1 with empty geometry input
430 SELECT ST_ISVALID( ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY','4326'));
431 --echo # Verify that ST_IsValid() returns 1 if the input is geometrically valid
432 SELECT ST_ISVALID( ST_GEOMFROMTEXT('POINT(1 1)',4053));
433 SELECT ST_ISVALID( ST_GEOMFROMTEXT('POINT(1 1)'));
434 SELECT ST_ISVALID( ST_GEOMFROMTEXT('POINT(1 1)',4326));
435 SELECT ST_ISVALID( ST_GEOMFROMTEXT('POLYGON((0 0,0 1,1 1,1 0,0 0),(0.25 0.25,0.75 0.25, 0.25 0.75, 0.25 0.25))',4053));
436 SELECT ST_ISVALID( ST_GEOMFROMTEXT('POLYGON((0 0,0 1,1 1,1 0,0 0),(0.25 0.25,0.75 0.25, 0.25 0.75, 0.25 0.25))',4326));
437 --echo # Verify that ST_IsValid() returns 0 if input is geometrically invalid
438 SELECT ST_ISVALID( ST_GEOMFROMTEXT('POLYGON((0 0,0 1,1 1,1 0,0 0),(0.25 0.25,1.75 0.25, 0.25 0.75, 0.25 0.25))',4053));
439 SELECT ST_ISVALID( ST_GEOMFROMTEXT('POLYGON((0 0,0 1,1 1,1 0,0 0),(0.25 0.25,1.75 0.25, 0.25 0.75, 0.25 0.25))',4326));
440 --echo # Verify that ST_IsValid() returns
441 --echo # ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE error with a geometry in a
442 --echo # geographic SRS and a longitude value is not in the range (-180,180]
443 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
444 DO ST_ISVALID(X'D50F0000010100000000000000000070400000000000000000');
445 --echo # Verify that ST_IsValid() returns
446 --echo # ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE error with a geometry in
447 --echo # geographic SRS and a latitude value is not in the range [-90,90]
448 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
449 DO ST_ISVALID(X'D50F0000010100000000000000000000000000000000008040');
450 --echo # If a multipoint is made up of valid points it should be valid.
451 SELECT ST_ISVALID(ST_GEOMFROMTEXT('multipoint((0 0),(1 1))',4053 )) AS RESULT;
452 SELECT ST_IsValid(ST_GeomFromText('MULTIPOLYGON(((9 11,14 84,43 54,9 11)),((-144
453 -58,-142 -6,-4 -70,-144 -58)))', '4326', 'axis-order=long-lat')) AS RESULT;
454 SELECT ST_ISVALID(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 1,1 1,1 0,0 0),(0.25 0.25,0.75 0.25, 0.25 0.75, 0.25 0.25)),POINT(1 1))',4053)) as result;
455 SELECT ST_IsValid(ST_GeomFromText('GEOMETRYCOLLECTION(MULTIPOLYGON(((9 11,14 84,43 54,9 11)),((-144
456 -58,-142 -6,-4 -70,-144 -58))), point( 1 1))', '4326', 'axis-order=long-lat')) AS RESULT;