Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # This test is aimed to focus on the properties and attributes of the #
4 # following Geometry classes. #
5 # #
6 # 1. Point #
7 # 2. LineString #
8 # 3. Polygon #
9 # 4. MultiPoint #
10 # 5. MultiLineString #
11 # 6. MultiPolygon #
12 # 7. GeometryCollection #
13 # #
14 # Creation Date: 2015-01-13 #
15 # Author : Pavan Naik #
16 # #
17 ###############################################################################
18
19
20 ############################################################################################
21 # Creating the spatial objects #
22 ############################################################################################
23
24 --echo # Creating the spatial objects
25 USE test;
26
27 CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
28 CREATE TABLE gis_linestring (fid INTEGER NOT NULL PRIMARY KEY, g LINESTRING);
29 CREATE TABLE gis_polygon (fid INTEGER NOT NULL PRIMARY KEY, g POLYGON);
30 CREATE TABLE gis_multi_point (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOINT);
31 CREATE TABLE gis_multi_linestring (fid INTEGER NOT NULL PRIMARY KEY, g MULTILINESTRING);
32 CREATE TABLE gis_multi_polygon (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOLYGON);
33 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRYCOLLECTION);
34
35 ############################################################################################
36 # Inserting POINT Geometry values #
37 ############################################################################################
38
39 --echo # Inserting POINT Geometry Values
40
41 INSERT INTO gis_point VALUES
42 (101, ST_POINTFROMTEXT('POINT(0 0)')),
43 (102, ST_POINTFROMTEXT('POINT(1 0)')),
44 (103, ST_POINTFROMTEXT('POINT(0 1)')),
45 (104, ST_POINTFROMTEXT('POINT(1 1)')),
46 (105, ST_POINTFROMTEXT('POINT(-1 1)'));
47
48 INSERT INTO gis_point VALUES
49 (106, ST_POINTFROMWKB(ST_ASWKB(POINT(0,0)))),
50 (107, ST_POINTFROMWKB(ST_ASWKB(POINT(10,0)))),
51 (108, ST_POINTFROMWKB(ST_ASWKB(POINT(0,10)))),
52 (109, ST_POINTFROMWKB(ST_ASWKB(POINT(-10,0)))),
53 (110, ST_POINTFROMWKB(ST_ASWKB(POINT(0,-10))));
54
55 INSERT INTO gis_point VALUES
56 (111, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1 1)')))),
57 (112, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1e308 1e308)')))),
58 (113, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1e308 -1e308)')))),
59 (114, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1e308 1e308)')))),
60 (115, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(-1e308 -1e308)'))));
61
62 --echo # Displaying the inserted POINT Geometry Data
63 SELECT fid, ST_ASTEXT(g) FROM gis_point;
64
65 --echo # Checking the integrity of the above insert statements
66 SELECT COUNT(g) FROM gis_point;
67
68 SELECT COUNT(ST_ASTEXT(g)) FROM gis_point;
69
70 SELECT COUNT(DISTINCT(g)) FROM gis_point;
71
72 SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_point;
73
74 ############################################################################################
75 # Inserting LINESTRING Geometry values #
76 ############################################################################################
77
78 --echo # Inserting LINESTRING Geometry Values
79
80 INSERT INTO gis_linestring VALUES
81 (201, ST_LINEFROMTEXT('LINESTRING(0 0,5 5)')),
82 (202, ST_LINEFROMTEXT('LINESTRING(0 0,2 2,4 4)')),
83 (203, ST_LINEFROMTEXT('LINESTRING(0 0,5 5,10 10)'));
84
85 INSERT INTO gis_linestring VALUES
86 (204, ST_LINESTRINGFROMTEXT('LINESTRING(10 10,5 5)')),
87 (205, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,12 12,24 24)')),
88 (206, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,50 50,100 100)'));
89
90 INSERT INTO gis_linestring VALUES
91 (207, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
92 (208, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,10))))),
93 (209, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)))));
94
95 INSERT INTO gis_linestring VALUES
96 (210, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
97 (211, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-50,-50), POINT(10,-10))))),
98 (212, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(1e308,1e308), POINT(1e308,-1e308)))));
99
100 INSERT INTO gis_linestring VALUES
101 (213, ST_LINEFROMWKB(ST_ASWKB(ST_LINEFROMTEXT('LINESTRING(1e308 1e308,1e308 -1e308)')))),
102 (214, ST_LINEFROMWKB(ST_ASWKB(ST_LINEFROMTEXT('LINESTRING(1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)')))),
103 (215, ST_LINESTRINGFROMWKB(ST_ASWKB(ST_LINESTRINGFROMTEXT('LINESTRING(10 10,10 -10,-10 -10,-10 10,10 10)'))));
104
105 --echo # Displaying the inserted LINESTRING Geometry Data
106 SELECT fid, ST_ASTEXT(g) FROM gis_linestring;
107
108 --echo # Checking the integrity of the above insert statements
109 SELECT COUNT(g) FROM gis_linestring;
110
111 SELECT COUNT(ST_ASTEXT(g)) FROM gis_linestring;
112
113 SELECT COUNT(DISTINCT(g)) FROM gis_linestring;
114
115 SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_linestring;
116
117 ############################################################################################
118 # Inserting POLYGON Geometry values #
119 ############################################################################################
120
121 --echo # Inserting POLYGON Geometry Values
122
123 INSERT INTO gis_polygon VALUES
124 (301, ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5, 0 0))')),
125 (302, ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')),
126 (303, ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
127
128 INSERT INTO gis_polygon VALUES
129 (304, ST_POLYGONFROMTEXT('POLYGON((0 0,0 50,50 50,50 0,0 0))')),
130 (305, ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')),
131 (306, ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'));
132
133 INSERT INTO gis_polygon VALUES
134 (307, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))),
135 (308, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)))))),
136 (309, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
137 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))));
138
139 INSERT INTO gis_polygon VALUES
140 (310, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))),
141 (311, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(10,15), POINT(15,15), POINT(15,10), POINT(10,10)))))),
142 (312, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(10,20), POINT(20,20), POINT(20,10), POINT(10,10)),
143 LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))));
144
145 INSERT INTO gis_polygon VALUES
146 (313, ST_POLYFROMWKB(ST_ASWKB(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,5 5,0 0))')))),
147 (314, ST_POLYFROMWKB(ST_ASWKB(ST_POLYGONFROMTEXT('POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 10,10 -10,10 0))')))),
148 (315, ST_POLYGONFROMWKB(ST_ASWKB(ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'))));
149
150 --echo # Displaying the inserted POLYGON Geometry Data
151 SELECT fid, ST_ASTEXT(g) FROM gis_polygon;
152
153 --echo # Checking the integrity of the above insert statements
154 SELECT COUNT(g) FROM gis_polygon;
155
156 SELECT COUNT(ST_ASTEXT(g)) FROM gis_polygon;
157
158 SELECT COUNT(DISTINCT(g)) FROM gis_polygon;
159
160 SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_polygon;
161
162 ############################################################################################
163 # Inserting MULTIPOINT Geometry values #
164 ############################################################################################
165
166 --echo # Inserting MULTIPOINT Geometry Values
167
168 INSERT INTO gis_multi_point VALUES
169 (401, ST_MPOINTFROMTEXT('MULTIPOINT(0 0)')),
170 (402, ST_MPOINTFROMTEXT('MULTIPOINT(0 0,2 2,4 4)')),
171 (403, ST_MPOINTFROMTEXT('MULTIPOINT(0 0,5 5,10 10)'));
172
173 INSERT INTO gis_multi_point VALUES
174 (404, ST_MULTIPOINTFROMTEXT('MULTIPOINT(0 0,100 100)')),
175 (405, ST_MULTIPOINTFROMTEXT('MULTIPOINT(0 0,1e308 1e308)')),
176 (406, ST_MULTIPOINTFROMTEXT('MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308 1e308,-1e308 -1e308)'));
177
178 INSERT INTO gis_multi_point VALUES
179 (407, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
180 (408, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(10,10))))),
181 (409, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)))));
182
183 INSERT INTO gis_multi_point VALUES
184 (410, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
185 (411, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(1e308,1e308))))),
186 (412, ST_MULTIPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308), POINT(-1e308,-1e308)))));
187
188 INSERT INTO gis_multi_point VALUES
189 (413, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(0 0)')))),
190 (414, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(0 0,1e308 1e308,-1e308 -1e308)')))),
191 (415, ST_MPOINTFROMWKB(ST_ASWKB(ST_MPOINTFROMTEXT('MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308 1e308,-1e308 -1e308,1e308 1e308)'))));
192
193 --echo # Displaying the inserted MULTIPOINT Geometry Data
194 SELECT fid, ST_ASTEXT(g) FROM gis_multi_point;
195
196 --echo # Checking the integrity of the above insert statements
197 SELECT COUNT(g) FROM gis_multi_point;
198
199 SELECT COUNT(ST_ASTEXT(g)) FROM gis_multi_point;
200
201 SELECT COUNT(DISTINCT(g)) FROM gis_multi_point;
202
203 SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_multi_point;
204
205 ############################################################################################
206 # Inserting MULTILINESTRING Geometry values #
207 ############################################################################################
208
209 --echo # Inserting MULTILINESTRING Geometry Values
210
211 INSERT INTO gis_multi_linestring VALUES
212 (501, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2))')),
213 (502, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4))')),
214 (503, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))'));
215
216 INSERT INTO gis_multi_linestring VALUES
217 (504, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,100 100,-100 -100))')),
218 (505, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1e308 1e308,-1e308 -1e308))')),
219 (506, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1e308 1e308,-1e308 -1e308),(1e308 -1e308,-1e308 1e308))'));
220
221 INSERT INTO gis_multi_linestring VALUES
222 (507, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2)))))),
223 (508, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)))))),
224 (509, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)),
225 LINESTRING(POINT(6,6), POINT(8,8), POINT(10,10))))));
226
227 INSERT INTO gis_multi_linestring VALUES
228 (510, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)))))),
229 (511, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1,1), POINT(2,2)))))),
230 (512, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)),
231 LINESTRING(POINT(36,36), POINT(48,48), POINT(50,50))))));
232
233 INSERT INTO gis_multi_linestring VALUES
234 (513, ST_MLINEFROMWKB(ST_ASWKB(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 10),(0 10,10 0))')))),
235 (514, ST_MLINEFROMWKB(ST_ASWKB(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0))')))),
236 (515, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))'))));
237
238 --echo # Displaying the inserted MULTILINESTRING Geometry Data
239 SELECT fid, ST_ASTEXT(g) FROM gis_multi_linestring;
240
241 --echo # Checking the integrity of the above insert statements
242 SELECT COUNT(g) FROM gis_multi_linestring;
243
244 SELECT COUNT(ST_ASTEXT(g)) FROM gis_multi_linestring;
245
246 SELECT COUNT(DISTINCT(g)) FROM gis_multi_linestring;
247
248 SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_multi_linestring;
249
250 ############################################################################################
251 # Inserting MULTIPOLYGON Geometry values #
252 ############################################################################################
253
254 --echo # Inserting MULTIPOLGYON Geometry Values
255
256 INSERT INTO gis_multi_polygon VALUES
257 (601, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)))')),
258 (602, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5)))')),
259 (603, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
260
261 INSERT INTO gis_multi_polygon VALUES
262 (604, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5, 0 0)))')),
263 (605, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,0 -2,-2 -2, 0 0)))')),
264 (606, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0)))'));
265
266 INSERT INTO gis_multi_polygon VALUES
267 (607, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))))))),
268 (608, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
269 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
270 (609, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))),
271 POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
272
273 INSERT INTO gis_multi_polygon VALUES
274 (610, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0))))))),
275 (611, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(10,10), POINT(20,10), POINT(20,20), POINT(10,20), POINT(10,10)),
276 LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))))),
277 (612, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
278 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
279 POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
280
281 INSERT INTO gis_multi_polygon VALUES
282 (613, ST_MPOLYFROMWKB(ST_ASWKB(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,5 5,5 -5,0 0)),((0 0,-5 5,-5 -5,0 0)))')))),
283 (614, ST_MPOLYFROMWKB(ST_ASWKB(ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))')))),
284 (615, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 0,5 -5,0 0)))'))));
285
286 --echo # Displaying the inserted MULTIPOLYGON Geometry Data
287 SELECT fid, ST_ASTEXT(g) FROM gis_multi_polygon;
288
289 --echo # Checking the integrity of the above insert statements
290 SELECT COUNT(g) FROM gis_multi_polygon;
291
292 SELECT COUNT(ST_ASTEXT(g)) FROM gis_multi_polygon;
293
294 SELECT COUNT(DISTINCT(g)) FROM gis_multi_polygon;
295
296 SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_multi_polygon;
297
298 ############################################################################################
299 # Inserting GEOMETRYCOLLECTION Geometry values #
300 ############################################################################################
301
302 --echo # Inserting GEOMETRYCOLLECTION Geometry Values
303
304 INSERT INTO gis_geometrycollection VALUES
305 (701, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')),
306 (702, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
307 (703, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5), POLYGON((0 0,0 10,10 10,10 0,0 0)))'));
308
309 INSERT INTO gis_geometrycollection VALUES
310 (704, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
311 (705, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
312 'LINESTRING(0 0,10 10),'
313 'POLYGON((0 0,0 10,10 10,10 0, 0 0)))')),
314 (706, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),'
315 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
316 'MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),'
317 '((0 0,-10 0,-10 -10,0 -10,0 0))))'));
318
319 INSERT INTO gis_geometrycollection VALUES
320 (707, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0))))),
321 (708, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
322 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
323 POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
324 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
325 (709, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(0,0), POINT(5,5), POINT(10,10)),
326 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
327 LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
328 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
329 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
330 POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
331
332 INSERT INTO gis_geometrycollection VALUES
333 (710, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
334 LINESTRING(POINT(0,0), POINT(100,100)))))),
335 (711, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(10,10),
336 LINESTRING(POINT(10,10), POINT(12,12), POINT(14,14), POINT(16,16), POINT(18,18)),
337 POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
338 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
339 (712, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(10,10), POINT(15,15), POINT(20,20)),
340 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
341 LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
342 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,10), POINT(10,10), POINT(10,0), POINT(0,0)),
343 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
344 POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
345
346 INSERT INTO gis_geometrycollection VALUES
347 (713, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
348 'POINT(0 0),'
349 'LINESTRING(0 0,10 10),'
350 'POLYGON((0 0,0 10,10 10,10 0, 0 0)),'
351 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
352 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
353 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))')))),
354 (714, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
355 'GEOMETRYCOLLECTION('
356 'POINT(0 0)),'
357 'GEOMETRYCOLLECTION('
358 'LINESTRING(0 0,10 10)),'
359 'GEOMETRYCOLLECTION('
360 'POLYGON((0 0,0 10,10 10,10 0, 0 0))),'
361 'GEOMETRYCOLLECTION('
362 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10)),'
363 'GEOMETRYCOLLECTION('
364 'MULTILINESTRING((0 0,10 10),(0 10,10 0))),'
365 'GEOMETRYCOLLECTION('
366 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))))')))),
367 (715, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
368 'GEOMETRYCOLLECTION(),'
369 'POINT(0 0),'
370 'GEOMETRYCOLLECTION('
371 'LINESTRING(0 0,10 10),'
372 'GEOMETRYCOLLECTION('
373 'GEOMETRYCOLLECTION())),'
374 'GEOMETRYCOLLECTION(),'
375 'GEOMETRYCOLLECTION('
376 'GEOMETRYCOLLECTION()),'
377 'POLYGON((0 0,0 10,10 10,10 0, 0 0)),'
378 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
379 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
380 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))'))));
381
382 --echo # Displaying the inserted GEOMETRYCOLLECTION Geometry Data
383 SELECT fid, ST_ASTEXT(g) FROM gis_geometrycollection;
384
385 --echo # Checking the integrity of the above insert statements
386 SELECT COUNT(g) FROM gis_geometrycollection;
387
388 SELECT COUNT(ST_ASTEXT(g)) FROM gis_geometrycollection;
389
390 SELECT COUNT(DISTINCT(g)) FROM gis_geometrycollection;
391
392 SELECT COUNT(DISTINCT(ST_ASTEXT(g))) FROM gis_geometrycollection;
393
394 ############################################################################################
395 # POINT geometry property functions #
396 ############################################################################################
397
398 --echo #====================================================================================
399 --echo # ST_X(point)
400 --echo #====================================================================================
401
402 SELECT ST_X(ST_POINTFROMTEXT('POINT(0 0)'));
403
404 SELECT ST_X(ST_POINTFROMTEXT('POINT(10 10)'));
405
406 SELECT ST_X(ST_POINTFROMTEXT('POINT(1e308 1e308)'));
407
408 SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))));
409
410 SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))));
411
412 SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))));
413
414 --echo #====================================================================================
415 --echo # ST_Y(point)
416 --echo #====================================================================================
417
418 SELECT ST_Y(ST_POINTFROMTEXT('POINT(0 0)'));
419
420 SELECT ST_Y(ST_POINTFROMTEXT('POINT(10 10)'));
421
422 SELECT ST_Y(ST_POINTFROMTEXT('POINT(1e308 1e308)'));
423
424 SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1.1111,-1.1111))));
425
426 SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(10.0000,10.0000))));
427
428 SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(-1e308,-1e308))));
429
430 ############################################################################################
431 # LINESTRING geometry property functions #
432 ############################################################################################
433
434 --echo #====================================================================================
435 --echo # ST_ISCLOSED(linestring)
436 --echo #====================================================================================
437
438 SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'));
439
440 SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,2 2,0 0)'));
441
442 SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0)'));
443
444 SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
445
446 SELECT ST_ISCLOSED(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)))));
447
448 SELECT ST_ISCLOSED(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10), POINT(0,0)))));
449
450 SELECT ST_ISCLOSED(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))));
451
452 SELECT ST_ISCLOSED(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))));
453
454 --echo #====================================================================================
455 --echo # ST_LENGTH(linestring)
456 --echo #====================================================================================
457
458 SELECT ST_LENGTH(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'));
459
460 SELECT ST_LENGTH(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
461
462 SELECT ST_LENGTH(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))));
463
464 SELECT ST_LENGTH(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))));
465
466 SELECT ST_LENGTH(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))));
467
468 SELECT ST_LENGTH(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))));
469
470 --echo # Cartesian SRS
471 SELECT ST_LENGTH(ST_GEOMFROMTEXT('LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10, 10 10)', 2000));
472
473 --echo # Geographic SRS
474 --echo # Different result on Windows and Linux, need to use ROUND
475 SELECT ROUND(ST_LENGTH(ST_GEOMFROMTEXT('LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10, 10 10)', 4326)),7);
476
477 --echo # Infinite Linestring
478 --error ER_DATA_OUT_OF_RANGE
479 SELECT ST_LENGTH(ST_GEOMFROMTEXT('LINESTRING(1e-300 0,1e300 0,1e-300 0,1e300 0,1e-300 0, 1e300 0, 1e-300 0)', 0));
480
481 --echo #====================================================================================
482 --echo # ST_NUMPOINTS(linestring)
483 --echo #====================================================================================
484
485 SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'));
486
487 SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)'));
488
489 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)'));
490
491 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'));
492
493 SELECT ST_NUMPOINTS(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))));
494
495 SELECT ST_NUMPOINTS(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))));
496
497 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))));
498
499 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))));
500
501 --echo #====================================================================================
502 --echo # ST_STARTPOINT(linestring)
503 --echo #====================================================================================
504
505 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)')));
506
507 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)')));
508
509 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)')));
510
511 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')));
512
513 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10))))));
514
515 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0))))));
516
517 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10))))));
518
519 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0))))));
520
521 --echo #====================================================================================
522 --echo # ST_ENDPOINT(linestring)
523 --echo #====================================================================================
524
525 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)')));
526
527 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)')));
528
529 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)')));
530
531 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')));
532
533 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10))))));
534
535 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0))))));
536
537 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10))))));
538
539 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0))))));
540
541 --echo #====================================================================================
542 --echo # ST_POINTN(linestring, number)
543 --echo #====================================================================================
544
545 SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,2 2)'), 1));
546
547 SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,1e308 1e308)'), 2));
548
549 SELECT ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(1e308 1e308,-1e308 -1e308)'), 2));
550
551 SELECT ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)'), 3));
552
553 SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-10,-10)))), 3));
554
555 SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5), POINT(-5,5), POINT(0,0)))), 4));
556
557 SELECT ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10)))), 4));
558
559 SELECT ST_ASTEXT(ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(10,10), POINT(10,0), POINT(0,10), POINT(0,0)))), 4));
560
561 ############################################################################################
562 # POLYGON geometry property functions #
563 ############################################################################################
564
565 --echo #====================================================================================
566 --echo # ST_NUMINTERIORRINGS(polygon)
567 --echo #====================================================================================
568
569 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'));
570
571 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'));
572
573 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'));
574
575 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))'));
576
577 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0))))));
578
579 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
580 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))));
581
582 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
583 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
584 LINESTRING(POINT(8,8), POINT(8,10), POINT(10,10), POINT(10,8), POINT(8,8))))));
585
586 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110))))));
587
588 --echo #====================================================================================
589 --echo # ST_EXTERIORRING(polygon)
590 --echo #====================================================================================
591
592 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')));
593
594 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')));
595
596 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))')));
597
598 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))')));
599
600 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0)))))));
601
602 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
603 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)))))));
604
605 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
606 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
607 LINESTRING(POINT(8,8), POINT(8,10), POINT(10,10), POINT(10,8), POINT(8,8)))))));
608
609 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110)))))));
610
611 --echo #====================================================================================
612 --echo # ST_INTERIORRINGN(polygon, number)
613 --echo #====================================================================================
614
615 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))'), 1));
616
617 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))'), 1));
618
619 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), 2));
620
621 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 -115,-115 -115,-115 0,0 0))'), 1));
622
623 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(0,0))))), 1));
624
625 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
626 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))), 1));
627
628 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,15), POINT(15,15), POINT(15,0), POINT(0,0)),
629 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)),
630 LINESTRING(POINT(8,8), POINT(8,10), POINT(10,10), POINT(10,8), POINT(8,8))))), 2));
631
632 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(110,110), POINT(110,5), POINT(5,5), POINT(110,110))))), 2));
633
634 ############################################################################################
635 # MULTULINESTRING geometry property functions #
636 ############################################################################################
637
638 --echo #====================================================================================
639 --echo # ST_ISCLOSED(multilinestring)
640 --echo #====================================================================================
641
642 SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0))'));
643
644 SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0),(0 0,-10 0,0 0))'));
645
646 SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,0 0),(0 0,-10 -10,0 0))'));
647
648 SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0,0 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))'));
649
650 SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(0,0))))));
651
652 SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e308,1e308))))));
653
654 SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(10,10), POINT(0,0)),
655 LINESTRING(POINT(1e308,1e308), POINT(-1e308,-1e308), POINT(1e308,1e308))))));
656
657 SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e10,1e10))))));
658
659 --echo #====================================================================================
660 --echo # ST_LENGTH(multilinestring)
661 --echo #====================================================================================
662
663 SELECT ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0))'));
664
665 SELECT ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0,0 0),(0 0,-10 0,0 0))'));
666
667 SELECT ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,0 0),(0 0,-10 -10,0 0))'));
668
669 SELECT ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))'));
670
671 SELECT ST_LENGTH(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(0,0))))));
672
673 SELECT ST_LENGTH(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1e10,1e10))))));
674
675 --echo # Cartesian SRS
676 SELECT ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))', 2000));
677
678 --echo # Geographic SRS
679 SELECT ROUND(ST_LENGTH(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,5 0),(0 0,0 5),(0 0,-5 0),(0 0,0 -5))', 4326)), 7);
680
681 ############################################################################################
682 # GEOMETRYCOLLECTION geometry property functions #
683 ############################################################################################
684
685 --echo #====================================================================================
686 --echo # ST_NUMGEOMETRIES(geometrycollection)
687 --echo #====================================================================================
688 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'));
689
690 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
691 'POINT(0 0),'
692 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
693 'POLYGON((0 0,0 5,5 5,5 0,0 0)))'));
694
695 SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
696 'MULTIPOINT(0 0),'
697 'MULTILINESTRING((0 0,5 5,10 10),'
698 '(0 0,-5 -5,-10 -10)),'
699 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),'
700 '((5 5,5 10,10 10,10 5,5 5))))'));
701
702 SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
703 'POINT(0 0),'
704 'GEOMETRYCOLLECTION(),'
705 'GEOMETRYCOLLECTION('
706 'GEOMETRYCOLLECTION()),'
707 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10))'));
708
709 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
710 POINT(10,10),
711 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
712 POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
713 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)))))));
714
715 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
716 MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
717 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
718 LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
719 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
720 POLYGON(LINESTRING(POINT(2,2), POINT(2,13), POINT(13,13), POINT(13,2), POINT(2,2)),
721 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))));
722
723 SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
724 POINT(0,0),
725 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
726 POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
727 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
728 MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
729 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
730 LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
731 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
732 POLYGON(LINESTRING(POINT(2,2), POINT(2,3), POINT(3,3), POINT(3,2), POINT(2,2))))))));
733
734 --echo #====================================================================================
735 --echo # ST_GEOMETRYN(geometrycollection, number)
736 --echo #====================================================================================
737 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'), 1));
738
739 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
740 'POINT(0 0),'
741 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
742 'POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 2));
743
744 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
745 'MULTIPOINT(0 0),'
746 'MULTILINESTRING((0 0,5 5,10 10),'
747 '(0 0,-5 -5,-10 -10)),'
748 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),'
749 '((5 5,5 10,10 10,10 5,5 5))))'), 3));
750
751 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION('
752 'POINT(0 0),'
753 'GEOMETRYCOLLECTION(),'
754 'GEOMETRYCOLLECTION('
755 'GEOMETRYCOLLECTION()),'
756 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10))'), 2));
757
758 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
759 POINT(10,10),
760 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
761 POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
762 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4)))))), 2));
763 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
764 MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
765 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
766 LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
767 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
768 POLYGON(LINESTRING(POINT(2,2), POINT(2,13), POINT(13,13), POINT(13,2), POINT(2,2)),
769 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))), 3));
770
771 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
772 POINT(0,0),
773 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
774 POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
775 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
776 MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
777 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
778 LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
779 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
780 POLYGON(LINESTRING(POINT(2,2), POINT(2,3), POINT(3,3), POINT(3,2), POINT(2,2))))))), 2));
781
782 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
783 POINT(0,0),
784 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
785 POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
786 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
787 MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
788 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
789 LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
790 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
791 POLYGON(LINESTRING(POINT(2,2), POINT(2,3), POINT(3,3), POINT(3,2), POINT(2,2))))))), 5));
792
793 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(
794 POINT(0,0),
795 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)),
796 POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
797 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
798 MULTIPOINT(POINT(1e308,1e308), POINT(-1e308,1e308), POINT(1e308,-1e308)),
799 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(5,5), POINT(10,10)),
800 LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,-10))),
801 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(1,0), POINT(0,0))),
802 POLYGON(LINESTRING(POINT(2,2), POINT(2,3), POINT(3,3), POINT(3,2), POINT(2,2))))))), 6));
803
804 ############################################################################################
805 # Invalid functions calls #
806 ############################################################################################
807
808 --echo #====================================================================================
809 --echo # ST_X(point)
810 --echo #====================================================================================
811
812 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
813 SELECT ST_X();
814
815 SELECT ST_X(NULL);
816
817 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
818 SELECT ST_X(ST_POINTFROMWKB());
819
820 SELECT ST_X(ST_POINTFROMWKB(NULL));
821
822 --error ER_PARSE_ERROR
823 SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1))));
824
825 --error ER_BAD_FIELD_ERROR
826 SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(1,a))));
827
828 --error ER_BAD_FIELD_ERROR
829 SELECT ST_X(ST_POINTFROMWKB(ST_ASWKB(POINT(a,b))));
830
831 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
832 SELECT ST_X(ST_POINTFROMTEXT());
833
834 --error ER_GIS_INVALID_DATA
835 SELECT ST_X(ST_POINTFROMTEXT('NULL'));
836
837 --error ER_GIS_INVALID_DATA
838 SELECT ST_X(ST_POINTFROMTEXT('POINT()'));
839
840 --error ER_GIS_INVALID_DATA
841 SELECT ST_X(ST_POINTFROMTEXT('POINT(1)'));
842
843 --error ER_GIS_INVALID_DATA
844 SELECT ST_X(ST_POINTFROMTEXT('POINT(a 1)'));
845
846 --error ER_GIS_INVALID_DATA
847 SELECT ST_X(ST_POINTFROMTEXT('POINT(1 1,2)'));
848
849 --error ER_PARSE_ERROR
850 SELECT ST_X(ST_POINTFROMTEXT('POINT('!' 0)'));
851
852 --echo #====================================================================================
853 --echo # ST_Y(point)
854 --echo #====================================================================================
855
856 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
857 SELECT ST_Y();
858
859 SELECT ST_Y(NULL);
860
861 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
862 SELECT ST_Y(ST_POINTFROMWKB());
863
864 SELECT ST_Y(ST_POINTFROMWKB(NULL));
865
866 --error ER_PARSE_ERROR
867 SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1))));
868
869 --error ER_BAD_FIELD_ERROR
870 SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(1,a))));
871
872 --error ER_BAD_FIELD_ERROR
873 SELECT ST_Y(ST_POINTFROMWKB(ST_ASWKB(POINT(a,b))));
874
875 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
876 SELECT ST_Y(ST_POINTFROMTEXT());
877
878 --error ER_GIS_INVALID_DATA
879 SELECT ST_Y(ST_POINTFROMTEXT('NULL'));
880
881 --error ER_GIS_INVALID_DATA
882 SELECT ST_Y(ST_POINTFROMTEXT('POINT()'));
883
884 --error ER_GIS_INVALID_DATA
885 SELECT ST_Y(ST_POINTFROMTEXT('POINT(1)'));
886
887 --error ER_GIS_INVALID_DATA
888 SELECT ST_Y(ST_POINTFROMTEXT('POINT(a 1)'));
889
890 --error ER_GIS_INVALID_DATA
891 SELECT ST_Y(ST_POINTFROMTEXT('POINT(1 1,2)'));
892
893 --error ER_PARSE_ERROR
894 SELECT ST_Y(ST_POINTFROMTEXT('POINT('!' 0)'));
895
896 --echo #====================================================================================
897 --echo # ST_ISCLOSED(linestring)
898 --echo #====================================================================================
899
900 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
901 SELECT ST_ISCLOSED();
902
903 SELECT ST_ISCLOSED(NULL);
904
905 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
906 SELECT ST_ISCLOSED(ST_LINEFROMWKB());
907
908 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
909 SELECT ST_ISCLOSED(ST_LINEFROMWKB(LINESTRING(POINT(0,0), POINT(2,2))), 2);
910
911 --error ER_BAD_FIELD_ERROR
912 SELECT ST_ISCLOSED(ST_LINESTRINGFROMWKB(LINESTRING(POINT(a,1), POINT(2,2))));
913
914 --error ER_BAD_FIELD_ERROR
915 SELECT ST_ISCLOSED(ST_LINESTRINGFROMWKB(LINESTRING(POINT(a,1), POINT(2,b))));
916
917 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
918 SELECT ST_ISCLOSED(ST_LINEFROMTEXT());
919
920 --error ER_GIS_INVALID_DATA
921 SELECT ST_ISCLOSED(ST_LINEFROMTEXT('NULL'));
922
923 --error ER_GIS_INVALID_DATA
924 SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING()'));
925
926 --error ER_GIS_INVALID_DATA
927 SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0)'));
928
929 --error ER_GIS_INVALID_DATA
930 SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'));
931
932 --error ER_GIS_INVALID_DATA
933 SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'));
934
935 --error ER_PARSE_ERROR
936 SELECT ST_ISCLOSED(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'));
937
938
939 --echo #====================================================================================
940 --echo # ST_NUMPOINTS(linestring)
941 --echo #====================================================================================
942
943 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
944 SELECT ST_NUMPOINTS();
945
946 SELECT ST_NUMPOINTS(NULL);
947
948 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
949 SELECT ST_NUMPOINTS(ST_LINEFROMWKB());
950
951 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
952 SELECT ST_NUMPOINTS(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2)))), 2);
953
954 --error ER_BAD_FIELD_ERROR
955 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,2)))));
956
957 --error ER_BAD_FIELD_ERROR
958 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,b)))));
959
960 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
961 SELECT ST_NUMPOINTS(ST_LINEFROMTEXT());
962
963 --error ER_GIS_INVALID_DATA
964 SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('NULL'));
965
966 --error ER_GIS_INVALID_DATA
967 SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING()'));
968
969 --error ER_GIS_INVALID_DATA
970 SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0)'));
971
972 --error ER_GIS_INVALID_DATA
973 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'));
974
975 --error ER_GIS_INVALID_DATA
976 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'));
977
978 --error ER_PARSE_ERROR
979 SELECT ST_NUMPOINTS(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'));
980
981 --echo #====================================================================================
982 --echo # ST_STARTPOINT(linestring)
983 --echo #====================================================================================
984
985 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
986 SELECT ST_STARTPOINT();
987
988 SELECT ST_STARTPOINT(NULL);
989
990 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
991 SELECT ST_STARTPOINT(ST_LINEFROMWKB());
992
993 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
994 SELECT ST_STARTPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2)))), 2);
995
996 --error ER_BAD_FIELD_ERROR
997 SELECT ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,2)))));
998
999 --error ER_BAD_FIELD_ERROR
1000 SELECT ST_STARTPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,b)))));
1001
1002 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1003 SELECT ST_STARTPOINT(ST_LINEFROMTEXT());
1004
1005 --error ER_GIS_INVALID_DATA
1006 SELECT ST_STARTPOINT(ST_LINEFROMTEXT('NULL'));
1007
1008 --error ER_GIS_INVALID_DATA
1009 SELECT ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING()'));
1010
1011 --error ER_GIS_INVALID_DATA
1012 SELECT ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0)'));
1013
1014 --error ER_GIS_INVALID_DATA
1015 SELECT ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'));
1016
1017 --error ER_GIS_INVALID_DATA
1018 SELECT ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'));
1019
1020 --error ER_PARSE_ERROR
1021 SELECT ST_STARTPOINT(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'));
1022
1023 --echo #====================================================================================
1024 --echo # ST_ENDPOINT(linestring)
1025 --echo #====================================================================================
1026
1027 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1028 SELECT ST_ENDPOINT();
1029
1030 SELECT ST_ENDPOINT(NULL);
1031
1032 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1033 SELECT ST_ENDPOINT(ST_LINEFROMWKB());
1034
1035 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1036 SELECT ST_ENDPOINT(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2)))), 2);
1037
1038 --error ER_BAD_FIELD_ERROR
1039 SELECT ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,2)))));
1040
1041 --error ER_BAD_FIELD_ERROR
1042 SELECT ST_ENDPOINT(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,b)))));
1043
1044 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1045 SELECT ST_ENDPOINT(ST_LINEFROMTEXT());
1046
1047 --error ER_GIS_INVALID_DATA
1048 SELECT ST_ENDPOINT(ST_LINEFROMTEXT('NULL'));
1049
1050 --error ER_GIS_INVALID_DATA
1051 SELECT ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING()'));
1052
1053 --error ER_GIS_INVALID_DATA
1054 SELECT ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0)'));
1055
1056 --error ER_GIS_INVALID_DATA
1057 SELECT ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'));
1058
1059 --error ER_GIS_INVALID_DATA
1060 SELECT ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'));
1061
1062 --error ER_PARSE_ERROR
1063 SELECT ST_ENDPOINT(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'));
1064
1065 --echo #====================================================================================
1066 --echo # ST_POINTN(linestring, number)
1067 --echo #====================================================================================
1068
1069 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1070 SELECT ST_POINTN();
1071
1072 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1073 SELECT ST_POINTN(NULL);
1074
1075 SELECT ST_POINTN(NULL, 1);
1076
1077 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1078 SELECT ST_POINTN(ST_LINEFROMWKB());
1079
1080 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1081 SELECT ST_POINTN(ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2)))));
1082
1083 --error ER_BAD_FIELD_ERROR
1084 SELECT ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,2)))), 1);
1085
1086 --error ER_BAD_FIELD_ERROR
1087 SELECT ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(a,1), POINT(2,b)))), 1);
1088
1089 --error ER_BAD_FIELD_ERROR
1090 SELECT ST_POINTN(ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(1,1), POINT(2,2)))), a);
1091
1092 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1093 SELECT ST_POINTN(ST_LINEFROMTEXT());
1094
1095 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1096 SELECT ST_POINTN(ST_LINEFROMTEXT('NULL'));
1097
1098 --error ER_GIS_INVALID_DATA
1099 SELECT ST_POINTN(ST_LINEFROMTEXT('NULL'), 1);
1100
1101 --error ER_GIS_INVALID_DATA
1102 SELECT ST_POINTN(ST_LINEFROMTEXT('LINESTRING()'), 2);
1103
1104 --error ER_GIS_INVALID_DATA
1105 SELECT ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0)'), 3);
1106
1107 --error ER_GIS_INVALID_DATA
1108 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(1 2,1'), 4);
1109
1110 --error ER_GIS_INVALID_DATA
1111 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(1 1,2 2,a 3)'), 5);
1112
1113 --error ER_PARSE_ERROR
1114 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING('!' 0,1 1,2 2)'), 6);
1115
1116 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 0);
1117
1118 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), -1);
1119
1120 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), -1024);
1121
1122 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 10000);
1123
1124 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 1234567890);
1125
1126 SELECT ST_POINTN(ST_LINESTRINGFROMTEXT('LINESTRING(0 0,1 1,2 2)'), 'a');
1127
1128 --echo #====================================================================================
1129 --echo # ST_NUMINTERIORRINGS(polygon)
1130 --echo #====================================================================================
1131
1132 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1133 SELECT ST_NUMINTERIORRINGS();
1134
1135 SELECT ST_NUMINTERIORRINGS(NULL);
1136
1137 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1138 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMWKB());
1139
1140 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1141 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(0,0))))), 1);
1142
1143 --error ER_BAD_FIELD_ERROR
1144 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(0,1), POINT(1,1), POINT(0,0))))));
1145
1146 --error ER_BAD_FIELD_ERROR
1147 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(b,1), POINT(1,1), POINT(0,0))))));
1148
1149 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1150 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT());
1151
1152 --error ER_GIS_INVALID_DATA
1153 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('NULL'));
1154
1155 --error ER_GIS_INVALID_DATA
1156 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON(())'));
1157
1158 --error ER_GIS_INVALID_DATA
1159 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0))'));
1160
1161 --error ER_GIS_INVALID_DATA
1162 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,0 4,4 4,0 0)'));
1163
1164 --error ER_GIS_INVALID_DATA
1165 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,2 0,2))'));
1166
1167 --error ER_GIS_INVALID_DATA
1168 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON((0 0,0 5,5 a,0 0))'));
1169
1170 --error ER_PARSE_ERROR
1171 SELECT ST_NUMINTERIORRINGS(ST_POLYGONFROMTEXT('POLYGON(('!' 0,2 0,2 4,0 0))'));
1172
1173 --echo #====================================================================================
1174 --echo # ST_EXTERIORRING(polygon)
1175 --echo #====================================================================================
1176
1177 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1178 SELECT ST_EXTERIORRING();
1179
1180 SELECT ST_EXTERIORRING(NULL);
1181
1182 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1183 SELECT ST_EXTERIORRING(ST_POLYFROMWKB());
1184
1185 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1186 SELECT ST_EXTERIORRING(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(0,0))))), 1);
1187
1188 --error ER_BAD_FIELD_ERROR
1189 SELECT ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(0,1), POINT(1,1), POINT(0,0))))));
1190
1191 --error ER_BAD_FIELD_ERROR
1192 SELECT ST_EXTERIORRING(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(b,1), POINT(1,1), POINT(0,0))))));
1193
1194 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1195 SELECT ST_EXTERIORRING(ST_POLYFROMTEXT());
1196
1197 --error ER_GIS_INVALID_DATA
1198 SELECT ST_EXTERIORRING(ST_POLYFROMTEXT('NULL'));
1199
1200 --error ER_GIS_INVALID_DATA
1201 SELECT ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON(())'));
1202
1203 --error ER_GIS_INVALID_DATA
1204 SELECT ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0))'));
1205
1206 --error ER_GIS_INVALID_DATA
1207 SELECT ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,0 4,4 4,0 0)'));
1208
1209 --error ER_GIS_INVALID_DATA
1210 SELECT ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,2 0,2))'));
1211
1212 --error ER_GIS_INVALID_DATA
1213 SELECT ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON((0 0,0 5,5 a,0 0))'));
1214
1215 --error ER_PARSE_ERROR
1216 SELECT ST_EXTERIORRING(ST_POLYGONFROMTEXT('POLYGON(('!' 0,2 0,2 4,0 0))'));
1217
1218 --echo #====================================================================================
1219 --echo # ST_INTERIORRINGN(polygon, number)
1220 --echo #====================================================================================
1221
1222 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1223 SELECT ST_INTERIORRINGN();
1224
1225 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1226 SELECT ST_INTERIORRINGN(NULL);
1227
1228 SELECT ST_INTERIORRINGN(NULL, 1);
1229
1230 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1231 SELECT ST_INTERIORRINGN(ST_POLYFROMWKB());
1232
1233 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1234 SELECT ST_INTERIORRINGN(ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(0,0))))));
1235
1236 --error ER_BAD_FIELD_ERROR
1237 SELECT ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(0,1), POINT(1,1), POINT(0,0))))), 1);
1238
1239 --error ER_BAD_FIELD_ERROR
1240 SELECT ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(a,0), POINT(b,1), POINT(1,1), POINT(0,0))))), 1);
1241
1242 --error ER_BAD_FIELD_ERROR
1243 SELECT ST_INTERIORRINGN(ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(0,1), POINT(1,1), POINT(0,0))))), a);
1244
1245 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1246 SELECT ST_INTERIORRINGN(ST_POLYFROMTEXT());
1247
1248 --error ER_GIS_INVALID_DATA
1249 SELECT ST_INTERIORRINGN(ST_POLYFROMTEXT('NULL'), 1);
1250
1251 --error ER_GIS_INVALID_DATA
1252 SELECT ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON(())'), 2);
1253
1254 --error ER_GIS_INVALID_DATA
1255 SELECT ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0))'), 3);
1256
1257 --error ER_GIS_INVALID_DATA
1258 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 4,4 4,0 0)'), 4);
1259
1260 --error ER_GIS_INVALID_DATA
1261 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,2 0,2))'), 5);
1262
1263 --error ER_GIS_INVALID_DATA
1264 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 5,5 a,0 0))'), 6);
1265
1266 --error ER_PARSE_ERROR
1267 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON(('!' 0,2 0,2 4,0 0))'), 7);
1268
1269 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 0);
1270
1271 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), -1);
1272
1273 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), -1024);
1274
1275 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 10000);
1276
1277 SELECT ST_INTERIORRINGN(ST_POLYGONFROMTEXT('POLYGON((0 0,0 2,2 2,0 0))'), 123456789);
1278
1279 --echo #====================================================================================
1280 --echo # ST_ISCLOSED(multilinestring)
1281 --echo #====================================================================================
1282
1283 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1284 SELECT ST_ISCLOSED();
1285
1286 SELECT ST_ISCLOSED(NULL);
1287
1288 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1289 SELECT ST_ISCLOSED(ST_MLINEFROMWKB());
1290
1291 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1292 SELECT ST_ISCLOSED(ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(1,1), POINT(2,2))))), 1);
1293
1294 --error ER_BAD_FIELD_ERROR
1295 SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(1,1), POINT(2,2), POINT(3,3), POINT(a,4))))));
1296
1297 --error ER_BAD_FIELD_ERROR
1298 SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(1,1), POINT(2,2)), LINESTRING(POINT(3,3), POINT(a,4))))));
1299
1300 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1301 SELECT ST_ISCLOSED(ST_POLYFROMTEXT());
1302
1303 --error ER_GIS_INVALID_DATA
1304 SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('NULL'));
1305
1306 --error ER_GIS_INVALID_DATA
1307 SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING(())'));
1308
1309 --error ER_GIS_INVALID_DATA
1310 SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((1 1,2 2),()'));
1311
1312 --error ER_GIS_INVALID_DATA
1313 SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((1 1,2 2,3 3)'));
1314
1315 --error ER_GIS_INVALID_DATA
1316 SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1 1,2 3,3 3,4))'));
1317
1318 --error ER_GIS_INVALID_DATA
1319 SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((1 1,2 2,3 3,4 a))'));
1320
1321 --error ER_PARSE_ERROR
1322 SELECT ST_ISCLOSED(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING(('!' 1,2 2,3 3,4 4'));
1323
1324 --echo #====================================================================================
1325 --echo # ST_LENGTH(multilinestring)
1326 --echo #====================================================================================
1327
1328 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1329 SELECT ST_LENGTH();
1330
1331 SELECT ST_LENGTH(NULL);
1332
1333 --echo #====================================================================================
1334 --echo # ST_NUMGEOMETRIES(geometrycollection)
1335 --echo #====================================================================================
1336
1337 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1338 SELECT ST_NUMGEOMETRIES();
1339
1340 SELECT ST_NUMGEOMETRIES(NULL);
1341
1342 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1343 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB());
1344
1345 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1346 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(1,1), POINT(2,2))))), 1);
1347
1348 --error ER_BAD_FIELD_ERROR
1349 SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(a,1), POINT(2,2))))));
1350
1351 --error ER_BAD_FIELD_ERROR
1352 SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,b), LINESTRING(POINT(a,1), POINT(2,2))))));
1353
1354 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1355 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT());
1356
1357 --error ER_GIS_INVALID_DATA
1358 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('NULL'));
1359
1360 --error ER_GIS_INVALID_DATA
1361 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(1)'));
1362
1363 --error ER_GIS_INVALID_DATA
1364 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0))'));
1365
1366 --error ER_GIS_INVALID_DATA
1367 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2)'));
1368
1369 --error ER_GIS_INVALID_DATA
1370 SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2))'));
1371
1372 --error ER_GIS_INVALID_DATA
1373 SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 a))'));
1374
1375 --error ER_PARSE_ERROR
1376 SELECT ST_NUMGEOMETRIES(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 '!'))'));
1377
1378 --echo #====================================================================================
1379 --echo # ST_GEOMETRYN(geometrycollection, number)
1380 --echo #====================================================================================
1381
1382 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1383 SELECT ST_GEOMETRYN();
1384
1385 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1386 SELECT ST_GEOMETRYN(NULL);
1387
1388 SELECT ST_GEOMETRYN(NULL, 1);
1389
1390 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1391 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMWKB());
1392
1393 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1394 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(1,1), POINT(2,2))))));
1395
1396 --error ER_BAD_FIELD_ERROR
1397 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(a,1), POINT(2,2))))), 1);
1398
1399 --error ER_BAD_FIELD_ERROR
1400 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,b), LINESTRING(POINT(a,1), POINT(2,2))))), 1);
1401
1402 --error ER_BAD_FIELD_ERROR
1403 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0), LINESTRING(POINT(1,1), POINT(2,2))))), A);
1404
1405 --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
1406 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT());
1407
1408 --error ER_GIS_INVALID_DATA
1409 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('NULL'), 1);
1410
1411 --error ER_GIS_INVALID_DATA
1412 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(1)'), 2);
1413
1414 --error ER_GIS_INVALID_DATA
1415 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0))'), 3);
1416
1417 --error ER_GIS_INVALID_DATA
1418 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2)'), 4);
1419
1420 --error ER_GIS_INVALID_DATA
1421 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2))'), 5);
1422
1423 --error ER_GIS_INVALID_DATA
1424 SELECT ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 a))'), 6);
1425
1426 --error ER_PARSE_ERROR
1427 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 '!'))'), 7);
1428
1429 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 0);
1430
1431 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), -1);
1432
1433 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), -1024);
1434
1435 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 10000);
1436
1437 SELECT ST_GEOMETRYN(ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(1 1,2 2))'), 123456789);
1438
1439 ############################################################################################
1440 # Checking the procedure to work with Point and MultiPoint properties #
1441 ############################################################################################
1442
1443 --echo # Check procedure to work with Point and MultiPoint properties
1444
1445 DELIMITER |;
1446 CREATE PROCEDURE point_attri()
1447 BEGIN
1448 SELECT ST_X(ST_POINTFROMTEXT('POINT(0 0)'));
1449 SELECT ST_X(ST_POINTFROMTEXT('POINT(1.1111 -1.1111)'));
1450 SELECT ST_X(ST_POINTFROMTEXT('POINT(1e308 1e308)'));
1451 SELECT ST_Y(ST_POINTFROMTEXT('POINT(0 0)'));
1452 SELECT ST_Y(ST_POINTFROMTEXT('POINT(1.1111 -1.1111)'));
1453 SELECT ST_Y(ST_POINTFROMTEXT('POINT(1e308 1e308)'));
1454 END |
1455 DELIMITER ;|
1456
1457 --echo # Call the proc
1458 CALL point_attri;
1459
1460 --echo # Dropping the created procedure
1461 DROP PROCEDURE point_attri;
1462
1463 ############################################################################################
1464 # Checking the procedure to work with Linestring and MultiLinestring properties #
1465 ############################################################################################
1466
1467 --echo # Check procedure to work with Linestring and MultiLineString properties
1468
1469 DELIMITER |;
1470 CREATE PROCEDURE line_attri()
1471 BEGIN
1472 SELECT ST_ISCLOSED(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)'));
1473 SELECT ST_NUMPOINTS(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)'));
1474 SELECT ST_LENGTH(ST_LINEFROMTEXT('LINESTRING(0 0,10 0,0 0,-10 0,0 0,0 10,0 0,0 -10,0 0)'));
1475 SELECT ST_ASTEXT(ST_STARTPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,0 0)')));
1476 SELECT ST_ASTEXT(ST_ENDPOINT(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,3 3,0 0)')));
1477 SELECT ST_ASTEXT(ST_POINTN(ST_LINEFROMTEXT('LINESTRING(0 0,1 1,2 2,3 3,4 4,5 5,6 6,7 7,8 8,9 9)'), 8));
1478 SELECT ST_ISCLOSED(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,1 1,2 2,0 0),(0 0,-1 -1,-2 -2,0 0))'));
1479 SELECT ST_LENGTH(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 0),(0 0,0 10),(0 0,-10 0),(0 0,0 -10))'));
1480 END |
1481 DELIMITER ;|
1482
1483 --echo # Call the proc
1484 CALL line_attri;
1485
1486 --echo # Dropping the created procedure
1487 DROP PROCEDURE line_attri;
1488
1489 ############################################################################################
1490 # Checking the procedure to work with Polygon and MultiPolygon properties #
1491 ############################################################################################
1492
1493 DELIMITER |;
1494 CREATE PROCEDURE poly_attri()
1495 BEGIN
1496 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'));
1497 SELECT ST_NUMINTERIORRINGS(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'));
1498 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))')));
1499 SELECT ST_ASTEXT(ST_EXTERIORRING(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))')));
1500 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))'), 1));
1501 SELECT ST_ASTEXT(ST_INTERIORRINGN(ST_POLYFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'), 2));
1502 END |
1503 DELIMITER ;|
1504
1505 --echo # Call the proc
1506 CALL poly_attri;
1507
1508 --echo # Dropping the created procedure
1509 DROP PROCEDURE poly_attri;
1510
1511 ############################################################################################
1512 # Checking the procedure to work with GeometryCollection properties #
1513 ############################################################################################
1514
1515 DELIMITER |;
1516 CREATE PROCEDURE geom_coll_attri()
1517 BEGIN
1518 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
1519 'POINT(0 0),'
1520 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
1521 'POLYGON((0 0,0 5,5 5,5 0,0 0)))'));
1522 SELECT ST_NUMGEOMETRIES(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
1523 'POINT(0 0),'
1524 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
1525 'GEOMETRYCOLLECTION('
1526 'GEOMETRYCOLLECTION()),'
1527 'POLYGON((0 0,0 5,5 5,5 0,0 0)))'));
1528 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
1529 'POINT(0 0),'
1530 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
1531 'POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 3));
1532 SELECT ST_ASTEXT(ST_GEOMETRYN(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
1533 'POINT(0 0),'
1534 'LINESTRING(0 0,2 2,4 4,6 6,8 8,10 10),'
1535 'GEOMETRYCOLLECTION('
1536 'GEOMETRYCOLLECTION()),'
1537 'POLYGON((0 0,0 5,5 5,5 0,0 0)))'), 3));
1538 END |
1539 DELIMITER ;|
1540
1541 --echo # Call the proc
1542 CALL geom_coll_attri;
1543
1544 --echo # Dropping the created procedure
1545 DROP PROCEDURE geom_coll_attri;
1546
1547 --echo # Final cleanup
1548 DROP TABLE gis_point;
1549 DROP TABLE gis_linestring;
1550 DROP TABLE gis_polygon;
1551 DROP TABLE gis_multi_point;
1552 DROP TABLE gis_multi_linestring;
1553 DROP TABLE gis_multi_polygon;
1554 DROP TABLE gis_geometrycollection;
1555
1556 --echo #
1557 --echo # WL#8579 Spatial Reference Systems
1558 --echo #
1559
1560 --echo # SRID 0 (should pass)
1561 SELECT ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 0));
1562
1563 --echo # Projected SRS (should pass)
1564 SELECT ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 2000));
1565
1566 --echo # Geographic SRS (should pass)
1567 SELECT ST_LENGTH(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
1568
1569 --echo #
1570 --echo # WL#8579 Spatial Reference Systems
1571 --echo # GIS functions that do not depend on any SRS
1572 --echo #
1573
1574 DELIMITER |;
1575 CREATE PROCEDURE geom_prop_func(IN srid INT)
1576 BEGIN
1577 SET @pt_geom = ST_GEOMFROMTEXT('POINT(10 20)', srid);
1578 SET @ln_geom = ST_GEOMFROMTEXT('LINESTRING(0 0,2 2,4 4,6 6,8 8, 10 10)', srid);
1579 SET @py_geom = ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))', srid);
1580 SET @gc_geom = ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
1581 'POINT(0 0),'
1582 'LINESTRING(0 0,10 10),'
1583 'POLYGON((0 0,0 10,10 10,10 0, 0 0)),'
1584 'MULTIPOINT(0 0,2 2,4 4,6 6,8 8,10 10),'
1585 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
1586 'MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))', srid);
1587
1588 # GIS geometry property functions that do not depend on any SRS
1589 DO ST_SRID(@pt_geom);
1590 DO ST_ISEMPTY(@pt_geom);
1591 DO ST_DIMENSION(@pt_geom);
1592 DO ST_GEOMETRYTYPE(@pt_geom);
1593
1594 DO ST_X(@pt_geom);
1595 DO ST_Y(@pt_geom);
1596
1597 DO ST_ISCLOSED(@ln_geom);
1598 DO ST_NUMPOINTS(@ln_geom);
1599 DO ST_ENDPOINT(@ln_geom);
1600 DO ST_POINTN(@ln_geom, 2);
1601 DO ST_STARTPOINT(@ln_geom);
1602
1603 DO ST_NUMINTERIORRING(@py_geom);
1604 DO ST_NUMINTERIORRINGS(@py_geom);
1605 DO ST_EXTERIORRING(@py_geom);
1606 DO ST_INTERIORRINGN(@py_geom, 1);
1607
1608 DO ST_NUMGEOMETRIES(@gc_geom);
1609 DO ST_GEOMETRYN(@gc_geom, 1);
1610 END |
1611 DELIMITER ;|
1612
1613 --echo # SRID 0 (should pass)
1614 CALL geom_prop_func(0);
1615
1616 --echo # Projected SRS (should pass)
1617 CALL geom_prop_func(2000);
1618
1619 --echo # Geographic SRS (should fail)
1620 --error ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS
1621 CALL geom_prop_func(4326);
1622
1623 # clean up
1624
1625 DROP PROCEDURE geom_prop_func;
1626
1627 --echo #
1628 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
1629 --echo #
1630
1631 --echo # Assume SRID 10 is not defined.
1632 --error ER_SRS_NOT_FOUND
1633 DO ST_ISCLOSED(x'0A0000000102000000020000000000000000000000000000000000000000000000000000000000000000000000');
1634 --error ER_SRS_NOT_FOUND
1635 DO ST_LENGTH(x'0A0000000102000000020000000000000000000000000000000000000000000000000000000000000000000000');
1636 --error ER_SRS_NOT_FOUND
1637 DO ST_SRID(ST_GEOMFROMTEXT('LINESTRING(0 0, 10 10)'), 10);
1638 --error ER_SRS_NOT_FOUND
1639 DO ST_DIMENSION(x'0A000000010100000000000000000000000000000000000000');
1640 --error ER_SRS_NOT_FOUND
1641 DO ST_ENDPOINT(x'0A0000000102000000020000000000000000000000000000000000000000000000000000000000000000000000');
1642 --error ER_SRS_NOT_FOUND
1643 DO ST_EXTERIORRING(x'0A0000000103000000010000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');
1644 --error ER_SRS_NOT_FOUND
1645 DO ST_GEOMETRYN(x'0A000000010700000001000000010100000000000000000000000000000000000000', 1);
1646 --error ER_SRS_NOT_FOUND
1647 DO ST_INTERIORRINGN(x'0A0000000103000000010000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', 1);
1648 --error ER_SRS_NOT_FOUND
1649 DO ST_ISEMPTY(x'0A000000010100000000000000000000000000000000000000');
1650 --error ER_SRS_NOT_FOUND
1651 DO ST_NUMGEOMETRIES(x'0A000000010700000001000000010100000000000000000000000000000000000000');
1652 --error ER_SRS_NOT_FOUND
1653 DO ST_NUMINTERIORRING(x'0A0000000103000000010000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');
1654 --error ER_SRS_NOT_FOUND
1655 DO ST_NUMINTERIORRINGS(x'0A0000000103000000010000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');
1656 --error ER_SRS_NOT_FOUND
1657 DO ST_NUMPOINTS(x'0A000000010400000001000000010100000000000000000000000000000000000000');
1658 --error ER_SRS_NOT_FOUND
1659 DO ST_NUMPOINTS(x'0A000000010400000001000000010100000000000000000000000000000000000000');
1660 --error ER_SRS_NOT_FOUND
1661 DO ST_POINTN(x'0A000000010400000001000000010100000000000000000000000000000000000000', 1);
1662 --error ER_SRS_NOT_FOUND
1663 DO ST_STARTPOINT(x'0A0000000102000000020000000000000000000000000000000000000000000000000000000000000000000000');
1664 --error ER_SRS_NOT_FOUND
1665 DO ST_X(x'0A000000010100000000000000000000000000000000000000');
1666 --error ER_SRS_NOT_FOUND
1667 DO ST_Y(x'0A000000010100000000000000000000000000000000000000');
1668
1669
1670 SET @LINE = ST_GEOMFROMTEXT( 'LINESTRING(0 0 , 1 1 )', 4326);
1671 SET @MLINE = ST_GEOMFROMTEXT( 'MULTILINESTRING((0 0 , 1 1 ))', 4326);
1672 --replace_numeric_round 5
1673 SELECT ST_LENGTH( @LINE, 'METRE');
1674 --replace_numeric_round 5
1675 SELECT ST_LENGTH( @MLINE, 'METRE');
1676 --error ER_UNIT_NOT_FOUND
1677 SELECT ST_LENGTH( @LINE, 'METER');
1678 SELECT ST_LENGTH( @LINE, NULL);
1679 SELECT ST_LENGTH( NULL, 'FOOT');
1680 SET @LINE = ST_GEOMFROMTEXT( 'LINESTRING(0 0 , 1 1 )', 32167);
1681 SELECT ST_LENGTH( @LINE);
1682 --replace_numeric_round 5
1683 SELECT ST_LENGTH( @LINE, 'METRE');