Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # ST_IsSimple checks whether a geometry has anomalous geometric points #
4 # such as self intersection or self tangency, if so returns 0 else 1. #
5 # #
6 # Creation Date: 2015-01-27 #
7 # Author : Pavan Naik #
8 # #
9 ###############################################################################
10
11 ############################################################################################
12 # Code coverage test #
13 ############################################################################################
14 # Covering:
15 # sql/gis/functor.h:Unary_functor
16 # sql/gis/is_simple.cc
17 # sql/item_geofunc.cc:Item_func_st_issimple::val_int()
18
19 # Null
20 SELECT ST_ISSIMPLE(NULL);
21
22 # Cartesian
23 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(0 0)'));
24 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))'));
25 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)'));
26 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 0 1))'));
27 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 0, 0 0))'));
28 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 0, 0 0)))'));
29 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), POINT(0 1))'));
30
31 # Geographic
32 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
33 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326));
34 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)', 4326));
35 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 0 1))', 4326));
36 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 0, 0 0))', 4326));
37 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 0, 0 0)))', 4326));
38 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), POINT(0 1))', 4326));
39
40 # Projected
41 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(0 0)', 3857));
42 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 3857));
43 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0, 0 1)', 3857));
44 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 0 1))', 3857));
45 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 0, 0 0))', 3857));
46 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 0, 0 0)))', 3857));
47 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), POINT(0 1))', 3857));
48
49 ############################################################################################
50 # Creating the spatial objects #
51 ############################################################################################
52
53 --echo # Creating the spatial Geometry object
54 USE test;
55
56 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
57
58 ############################################################################################
59 # Inserting the values specific to the spatial objects #
60 ############################################################################################
61
62 ############################################################################################
63 # Inserting the values specific to the spatial objects #
64 ############################################################################################
65
66 # Geometric elements constructing a star and some of its elememts as base
67 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
68 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
69 SET @star_center= 'POINT(15 10)';
70 SET @star_top= 'POINT(15 25)';
71 SET @star_bottom_left= 'POINT(5 0)';
72 SET @star_bottom_right= 'POINT(25 0)';
73 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
74 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
75 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
76 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
77 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
78 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
79 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
80 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))';
81 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)))';
82 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))';
83 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))';
84
85 --echo # INSERT base star
86 --disable_warnings
87 INSERT INTO gis_geometrycollection VALUES
88 (100,ST_GEOMFROMTEXT(@star)),
89 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
90 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
91 (103,ST_GEOMFROMTEXT(@star_of_elems)),
92 (104,ST_GEOMFROMTEXT(@star_top)),
93 (105,ST_GEOMFROMTEXT(@star_center)),
94 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
95 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
96 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
97 (109,ST_GEOMFROMTEXT(@star_all_points)),
98 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
99 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
100 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
101 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
102 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
103 (115,ST_GEOMFROMTEXT(@star_collection_elems)),
104 (116,ST_GEOMFROMTEXT(@star_collection_multilinestr));
105 --enable_warnings
106
107 --echo # Checking the integrity of the above create/insert statements
108
109 --echo # 17 rows.
110 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
111
112 --echo #####################################################################################
113 --echo # ST_ISSIMPLE(geometry)
114 --echo #####################################################################################
115
116 --echo #====================================================================================
117 --echo # point
118 --echo #====================================================================================
119 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_center));
120
121 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_top));
122
123 SELECT ST_ISSIMPLE(g) FROM gis_geometrycollection WHERE fid=105;
124
125 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(0 0)'));
126
127 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(2.34 -2.34)'));
128
129 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(1e100 -1e100)'));
130
131 --echo #====================================================================================
132 --echo # multipoint
133 --echo #====================================================================================
134 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_all_points));
135
136 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_bottom_points));
137
138 SELECT ST_ISSIMPLE(g) FROM gis_geometrycollection WHERE fid=108;
139
140 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,1 1,-0 +0)'));
141
142 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0.0 -0,-0.0 0.000)'));
143
144 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0)'));
145
146 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0,0 0)'));
147
148 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1e100 -1e100,0.0001 0.000)'));
149
150 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1e100 1e100,1 1,1e100 1e100)'));
151
152 --echo #====================================================================================
153 --echo # linestring
154 --echo #====================================================================================
155 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_top_to_center));
156
157 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_line_horizontal));
158
159 SELECT ST_ISSIMPLE(g) FROM gis_geometrycollection WHERE fid=110;
160
161 --error ER_GIS_INVALID_DATA
162 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0)'));
163
164 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,-0.00 0)'));
165
166 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,1 1)'));
167
168 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,0 0)'));
169
170 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
171
172 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10,10 0,0 10)'));
173
174 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10,10 0,0 10,0 0)'));
175
176 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,1e100 1e100,0.0001 0.000)'));
177
178 # TODO Bug #33739281 Some gis functions give different results with gcc11 in optimized mode on ARM
179 # SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,1e100 1e100,-1e100 -1e100,0 0)'));
180
181 --echo #====================================================================================
182 --echo # multilinestring
183 --echo #====================================================================================
184 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_lines_near_vertical));
185
186 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_lines_near_horizontal));
187
188 SELECT ST_ISSIMPLE(g) FROM gis_geometrycollection WHERE fid=114;
189
190 --error ER_GIS_INVALID_DATA
191 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0))'));
192
193 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,1 1))'));
194
195 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 0),(1 1,3 3))'));
196
197 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0.00 0),(0.0 0,0 +0))'));
198
199 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))'));
200
201 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10,10 0,0 10))'));
202
203 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10),(10 0,0 10))'));
204
205 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10,0 0),(10 10,20 20))'));
206
207 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))'));
208
209 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1e100 -1e100,0.0001 0.000),(2 2,4 -9.002))'));
210
211 --echo #====================================================================================
212 --echo # polygon
213 --echo #====================================================================================
214 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star));
215
216 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_elem_vertical));
217
218 SELECT ST_ISSIMPLE(g) FROM gis_geometrycollection WHERE fid=100;
219
220 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,0 0))'));
221
222 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 0,0 5,5 5,0 0))'));
223
224 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 5,0 0))'));
225
226 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
227
228 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,5 10,0 0))'));
229
230 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,10 10,-10 10,0 0,10 -10,-10 -10,0 0))'));
231
232 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,-10 0,-10 -10,0 -10,0 0))'));
233
234 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'));
235
236 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0))'));
237
238 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0))'));
239
240 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8))'));
241
242 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4),(4 4,4 6,6 6,6 4,4 4))'));
243
244 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4),(6 6,6 8,8 8,8 6,6 6))'));
245
246 --echo #====================================================================================
247 --echo # multipolygon
248 --echo #====================================================================================
249 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_of_elems));
250
251 SELECT ST_ISSIMPLE(g) FROM gis_geometrycollection WHERE fid=103;
252
253 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))'));
254
255 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 0,0 5,5 5,0 0)))'));
256
257 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,0 5,5 5,0 0)))'));
258
259 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,5 10,0 0)))'));
260
261 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((3 3,3 6,6 6,6 3,3 3)))'));
262
263 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))'));
264
265 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0,-10 0,-10 -10,0 -10,0 0)))'));
266
267 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))'));
268
269 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4,4 4)))'));
270
271 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
272
273 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)))'));
274
275 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0)))'));
276
277 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8)))'));
278
279 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 0,5 10,10 10)),((0 10,0 20,5 10,0 10)))'));
280
281 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((4 4,4 6,6 6,6 4,4 4)))'));
282
283 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0)))'));
284
285 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,4 4)))'));
286
287 --echo #====================================================================================
288 --echo # geometrycollection
289 --echo #====================================================================================
290 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_collection_elems));
291
292 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_collection_multilinestr));
293
294 SELECT ST_ISSIMPLE(g) FROM gis_geometrycollection WHERE fid=115;
295
296 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()'));
297
298 --error ER_GIS_INVALID_DATA
299 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0))'));
300
301 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))'));
302
303 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),MULTIPOINT(0 0,0 0))'));
304
305 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),LINESTRING(0 0,10 10,10 0,0 0))'));
306
307 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),LINESTRING(0 0,10 10,10 0,0 10))'));
308
309 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),MULTILINESTRING((0 0,10 10),(10 10,20 20)))'));
310
311 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),MULTILINESTRING((0 0,10 10),(0 0,10 10,20 20)))'));
312
313 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),POINT(10 10))'));
314
315 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10))'));
316
317 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),POINT(10 10)))'));
318
319 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10),POINT(5 5))'));
320
321 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(5 0,5 10),POLYGON((0 0,0 10,10 10,10 0,0 0)))'));
322
323 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10,10 0),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
324
325 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
326 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)))'));
327
328 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),'
329 'MULTIPOINT(0 0,10 10),'
330 'LINESTRING(1 1,2 2,3 3),'
331 'MULTILINESTRING((0 0,0 10,10 10,10 0),(10 10,10 15,15 15,10 10)))'));
332
333 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))'));
334
335 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION('
336 'GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0)))))'));
337
338 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
339 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 15,15 15,15 10,10 10))))'));
340
341 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
342 'MULTIPOINT(0 0,10 10)),'
343 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
344 'MULTILINESTRING((0 0,0 10,10 10),(10 10,10 15,15 15))))'));
345
346 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
347 'MULTIPOINT(0 0,10 10)),'
348 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
349 'MULTILINESTRING((0 0,0 10,10 10),(10 10,10 15,15 15))),'
350 'GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
351 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((10 10,10 15,15 15,15 10,10 10)))))'));
352
353 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
354 'MULTIPOINT(0 0,10 10)),'
355 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
356 'MULTILINESTRING((0 0,0 10,10 10),(10 10,10 15,15 15))),'
357 'GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))'));
358
359 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
360 'LINESTRING(0 0,0 1,1 1,1 0,0 0),'
361 'POLYGON((0 0,0 10,10 10,10 0,0 0)),'
362 'MULTIPOINT(0 0,1 1,2 2,3 3),'
363 'MULTILINESTRING((0 0,0 10),(10 10,10 0)),'
364 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((10 10,10 15,15 15,15 10,10 10))))'));
365
366 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
367 'LINESTRING(0 0,1 1,1 0,0 1),'
368 'POLYGON((0 0,0 10,10 10,10 0,0 0)),'
369 'MULTIPOINT(0 0,1 1,2 2,3 3),'
370 'MULTILINESTRING((0 0,0 10),(10 10,10 0)),'
371 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((10 10,10 15,15 15,15 10,10 10))))'));
372
373 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
374 'LINESTRING(0 0,0 1,1 1,1 0,0 0),'
375 'POLYGON((0 0,0 10,10 10,10 0,0 0)),'
376 'MULTIPOINT(0 0,1 1,2 2,3 3,0 0),'
377 'MULTILINESTRING((0 0,0 10),(10 10,10 0)),'
378 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((10 10,10 15,15 15,15 10,10 10))))'));
379
380 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
381 'LINESTRING(0 0,0 1,1 1,1 0,0 0),'
382 'POLYGON((0 0,0 10,10 10,10 0,0 0)),'
383 'MULTIPOINT(0 0,1 1,2 2,3 3),'
384 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
385 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((10 10,10 15,15 15,15 10,10 10))))'));
386
387 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
388 'LINESTRING(0 0,0 1,1 1,1 0,0 0),'
389 'POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)),'
390 'MULTIPOINT(0 0,1 1,2 2,3 3),'
391 'MULTILINESTRING((0 0,10 0),(0 10,10 10)),'
392 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((10 10,10 15,15 15,15 10,10 10))))'));
393
394 --echo #####################################################################################
395 --echo # ST_ISSIMPLE(geometry) with different SRID values
396 --echo #####################################################################################
397
398 --error ER_DATA_OUT_OF_RANGE
399 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_center,-1024));
400
401 --error ER_DATA_OUT_OF_RANGE
402 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_all_points,-1));
403
404 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_top_to_center,0));
405
406 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_lines_near_vertical,4326));
407
408 --error ER_DATA_OUT_OF_RANGE
409 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_of_elems,4294967296));
410
411 --error ER_DATA_OUT_OF_RANGE
412 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT(@star_collection_elems,4294967295000));
413
414 --echo #####################################################################################
415 --echo # Invalid function calls
416 --echo #####################################################################################
417
418 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
419 SELECT ST_ISSIMPLE();
420
421 SELECT ST_ISSIMPLE(NULL);
422
423 --error ER_GIS_INVALID_DATA
424 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT()'));
425
426 --error ER_GIS_INVALID_DATA
427 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING()'));
428
429 --error ER_GIS_INVALID_DATA
430 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON(())'));
431
432 --error ER_GIS_INVALID_DATA
433 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOINT()'));
434
435 --error ER_GIS_INVALID_DATA
436 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTILINESTRING(())'));
437
438 --error ER_GIS_INVALID_DATA
439 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON((()))'));
440
441 --error ER_GIS_INVALID_DATA
442 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(a 0)'));
443
444 --error ER_GIS_INVALID_DATA
445 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(! 0)'));
446
447 --error ER_PARSE_ERROR
448 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT('!' 0)'));
449
450 --error ER_GIS_INVALID_DATA
451 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(12,34 0)'));
452
453 --error ER_GIS_INVALID_DATA
454 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'));
455
456 --error ER_GIS_INVALID_DATA
457 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'));
458
459 --error ER_PARSE_ERROR
460 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'));
461
462 --error ER_GIS_INVALID_DATA
463 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'));
464
465 --error ER_GIS_INVALID_DATA
466 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'));
467
468 --error ER_GIS_INVALID_DATA
469 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0))'));
470
471 --error ER_GIS_INVALID_DATA
472 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,2 2,4 4))'));
473
474 --error ER_GIS_INVALID_DATA
475 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,2 2,0 0))'));
476
477 --error ER_GIS_INVALID_DATA
478 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'));
479
480 --error ER_PARSE_ERROR
481 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'));
482
483 --error ER_GIS_INVALID_DATA
484 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'));
485
486 --error ER_GIS_INVALID_DATA
487 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5)),((0 0)))'));
488
489 --error ER_GIS_INVALID_DATA
490 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5)),((0 0,2 2,3 3)))'));
491
492 --error ER_GIS_INVALID_DATA
493 SELECT ST_ISSIMPLE(0x000000000200000000000000000000000000000000);
494
495 --error ER_GIS_INVALID_DATA
496 SELECT ST_ISSIMPLE(0x000000000600000001000000000200000002000000);
497
498 --error ER_GIS_INVALID_DATA
499 SELECT ST_ISSIMPLE(0x000000000200000001000000050000000000000000);
500
501 --echo # Clean up
502 DROP TABLE gis_geometrycollection;
503
504 --echo #
505 --echo # Bug #21841051 PREPARE STATEMENT RETURNS DIFFERENT NUMBER OF ROWS WHEN
506 --echo # EXECUTED SECOND TIME
507 --echo #
508
509 CREATE TABLE t1 (id INT, g GEOMETRY);
510 INSERT INTO t1 VALUES (2, ST_GeomFromText('POINT(0 0)'));
511 CREATE TABLE t2 (id INT);
512 INSERT INTO t2 VALUES (1), (3);
513
514 PREPARE stmt FROM 'SELECT ST_IsSimple(g) AS a1
515 FROM t1 RIGHT OUTER JOIN t2 ON (t1.id > t2.id) GROUP BY a1';
516
517 --sorted_result
518 EXECUTE stmt;
519 --sorted_result
520 EXECUTE stmt;
521
522 DEALLOCATE PREPARE stmt;
523 DROP TABLE t1, t2;
524
525 --echo #
526 --echo # WL#8579 Spatial Reference Systems
527 --echo #
528
529 --echo # SRID 0 (should pass)
530 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(0 0)', 0));
531
532 --echo # Projected SRS (should pass)
533 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(0 0)', 2000));
534
535 --echo # Geographic SRS (should pass)
536 SELECT ST_ISSIMPLE(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
537
538 --echo #
539 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
540 --echo #
541
542 --echo # Assume SRID 10 is not defined.
543 --error ER_SRS_NOT_FOUND
544 DO ST_ISSIMPLE(x'0A000000010100000000000000000000000000000000000000');