Debian Codegraph @

mysql-test/suite/gis/r/spatial_utility_function_isvalid.result

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