Debian Codegraph @

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

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