Debian Codegraph @

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

raw
1 # Creating the spatial objects
2 CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
3 CREATE TABLE gis_linestring (fid INTEGER NOT NULL PRIMARY KEY, g LINESTRING);
4 CREATE TABLE gis_polygon (fid INTEGER NOT NULL PRIMARY KEY, g POLYGON);
5 CREATE TABLE gis_multi_point (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOINT);
6 CREATE TABLE gis_multi_linestring (fid INTEGER NOT NULL PRIMARY KEY,
7 g MULTILINESTRING);
8 CREATE TABLE gis_multi_polygon (fid INTEGER NOT NULL PRIMARY KEY,
9 g MULTIPOLYGON);
10 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY,
11 g GEOMETRYCOLLECTION);
12 # Inserting POINT Geometry Values
13 INSERT INTO gis_point VALUES
14 (101, POINT(1.1111,-2.2222)),
15 (102, POINT(10.0000,20.0000));
16 INSERT INTO gis_point VALUES
17 (103, POINT(1e308, 1e202));
18 # Displaying the inserted POINT Geometry Data
19 SELECT fid, ST_ASTEXT(g) FROM gis_point;
20 fid ST_ASTEXT(g)
21 101 POINT(1.1111 -2.2222)
22 102 POINT(10 20)
23 103 POINT(1e308 1e202)
24 # Inserting LINESTRING Geometry Values
25 INSERT INTO gis_linestring VALUES
26 (201, ST_LINEFROMTEXT('LINESTRING(0 2,2 4,4 8)'));
27 INSERT INTO gis_linestring VALUES
28 (202, ST_LINESTRINGFROMTEXT('LINESTRING(0 12,12 24,24 48)'));
29 INSERT INTO gis_linestring VALUES
30 (203, LINESTRING(POINT(0,0), POINT(-5,7),
31 POINT(-10,70)));
32 # Displaying the inserted LINESTRING Geometry Data
33 SELECT fid, ST_ASTEXT(g) FROM gis_linestring;
34 fid ST_ASTEXT(g)
35 201 LINESTRING(0 2,2 4,4 8)
36 202 LINESTRING(0 12,12 24,24 48)
37 203 LINESTRING(0 0,-5 7,-10 70)
38 # Inserting POLYGON Geometry Values
39 INSERT INTO gis_polygon VALUES
40 (301, ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5, 0 0))'));
41 INSERT INTO gis_polygon VALUES
42 (302, ST_POLYGONFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),
43 (2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'));
44 INSERT INTO gis_polygon VALUES
45 (303, POLYGON(LINESTRING(POINT(0,0), POINT(10,0),
46 POINT(10,10), POINT(0,10), POINT(0,0)), LINESTRING(POINT(4,4), POINT(4,6),
47 POINT(6,6), POINT(6,4), POINT(4,4))));
48 # Displaying the inserted POLYGON Geometry Data
49 SELECT fid, ST_ASTEXT(g) FROM gis_polygon;
50 fid ST_ASTEXT(g)
51 301 POLYGON((0 0,5 0,5 5,0 0))
52 302 POLYGON((0 0,10 0,10 10,0 10,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))
53 303 POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))
54 # Inserting MULTIPOINT Geometry Values
55 INSERT INTO gis_multi_point VALUES
56 (401, ST_MPOINTFROMTEXT('MULTIPOINT(0 0,5 5,10 10)'));
57 INSERT INTO gis_multi_point VALUES
58 (402, ST_MULTIPOINTFROMTEXT('MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308
59 1e308,-1e308 -1e308)'));
60 INSERT INTO gis_multi_point VALUES
61 (403, ST_MPOINTFROMTEXT('MULTIPOINT(1e308
62 1e308, 1e308 -1e308, -1e308 1e308, -1e308 -1e308, 1e308 1e308)'));
63 # Displaying the inserted MULTIPOINT Geometry Data
64 SELECT fid, ST_ASTEXT(g) FROM gis_multi_point;
65 fid ST_ASTEXT(g)
66 401 MULTIPOINT((0 0),(5 5),(10 10))
67 402 MULTIPOINT((1e308 1e308),(1e308 -1e308),(-1e308 1e308),(-1e308 -1e308))
68 403 MULTIPOINT((1e308 1e308),(1e308 -1e308),(-1e308 1e308),(-1e308 -1e308),(1e308 1e308))
69 # Inserting MULTILINESTRING Geometry Values
70 INSERT INTO gis_multi_linestring VALUES
71 (501, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))'));
72 INSERT INTO gis_multi_linestring VALUES
73 (502, MULTILINESTRING(LINESTRING(POINT(0,0),
74 POINT(12,12), POINT(24,24)),
75 LINESTRING(POINT(36,36), POINT(48,48), POINT(50,50))));
76 INSERT INTO gis_multi_linestring VALUES
77 (503, ST_MULTILINESTRINGFROMTEXT
78 ('MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))'));
79 # Displaying the inserted MULTILINESTRING Geometry Data
80 SELECT fid, ST_ASTEXT(g) FROM gis_multi_linestring;
81 fid ST_ASTEXT(g)
82 501 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
83 502 MULTILINESTRING((0 0,12 12,24 24),(36 36,48 48,50 50))
84 503 MULTILINESTRING((0 0,0 100),(0 0,100 0),(0 0,0 -100),(0 0,-100 0))
85 # Inserting MULTIPOLGYON Geometry Values
86 INSERT INTO gis_multi_polygon VALUES
87 (601, MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
88 POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))))),
89 (602, MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
90 POINT(10, 0), POINT(10,10), POINT(10, 0), POINT(0,0)),
91 LINESTRING(POINT(4,4),
92 POINT(4,6), POINT(6,6),
93 POINT(6,4), POINT(4,4))))),
94 (603, MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
95 POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))),
96 POLYGON(LINESTRING(POINT(0,0),
97 POINT(-5, 0), POINT(-5,-5), POINT(0 ,-5),
98 POINT(0,0)))));
99 # Displaying the inserted MULTIPOLYGON Geometry Data
100 SELECT fid, ST_ASTEXT(g) FROM gis_multi_polygon;
101 fid ST_ASTEXT(g)
102 601 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)))
103 602 MULTIPOLYGON(((0 0,10 0,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))
104 603 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((0 0,-5 0,-5 -5,0 -5,0 0)))
105 INSERT INTO gis_geometrycollection VALUES
106 (701, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')),
107 (702, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),
108 LINESTRING(0 0,10 10))')),
109 (703, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),
110 POLYGON((0 0,10 0,10 10,0 10,0 0)))'));
111 # Displaying the inserted GEOMETRYCOLLECTION Geometry Data
112 SELECT fid, ST_ASTEXT(g) FROM gis_geometrycollection;
113 fid ST_ASTEXT(g)
114 701 GEOMETRYCOLLECTION(POINT(0 0))
115 702 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
116 703 GEOMETRYCOLLECTION(POINT(5 5),POLYGON((0 0,10 0,10 10,0 10,0 0)))
117 #=======================================================================
118 # ST_SWAPXY(point)
119 #=======================================================================
120 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_point WHERE fid = 101;
121 ST_ASTEXT(ST_SWAPXY(g))
122 POINT(-2.2222 1.1111)
123 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_point WHERE fid = 102;
124 ST_ASTEXT(ST_SWAPXY(g))
125 POINT(20 10)
126 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_point WHERE fid = 103;
127 ST_ASTEXT(ST_SWAPXY(g))
128 POINT(1e202 1e308)
129 SELECT ST_ASTEXT(ST_SWAPXY(ST_POINTFROMTEXT(
130 'POINT(1.1111 -2.2222)')));
131 ST_ASTEXT(ST_SWAPXY(ST_POINTFROMTEXT(
132 'POINT(1.1111 -2.2222)')))
133 POINT(-2.2222 1.1111)
134 SELECT ST_ASTEXT(ST_SWAPXY(ST_POINTFROMTEXT(
135 'POINT(10.0000 20.0000)')));
136 ST_ASTEXT(ST_SWAPXY(ST_POINTFROMTEXT(
137 'POINT(10.0000 20.0000)')))
138 POINT(20 10)
139 SELECT ST_ASTEXT(ST_SWAPXY(ST_POINTFROMTEXT(
140 'POINT(1e308 1e202)')));
141 ST_ASTEXT(ST_SWAPXY(ST_POINTFROMTEXT(
142 'POINT(1e308 1e202)')))
143 POINT(1e202 1e308)
144 #=======================================================================
145 # ST_SWAPXY(linestring)
146 #=======================================================================
147 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_linestring WHERE fid = 201;
148 ST_ASTEXT(ST_SWAPXY(g))
149 LINESTRING(2 0,4 2,8 4)
150 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_linestring WHERE fid = 202;
151 ST_ASTEXT(ST_SWAPXY(g))
152 LINESTRING(12 0,24 12,48 24)
153 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_linestring WHERE fid = 203;
154 ST_ASTEXT(ST_SWAPXY(g))
155 LINESTRING(0 0,7 -5,70 -10)
156 SELECT ST_ASTEXT(ST_SWAPXY(ST_LINEFROMTEXT('LINESTRING(0 2,2 4,4 8)')));
157 ST_ASTEXT(ST_SWAPXY(ST_LINEFROMTEXT('LINESTRING(0 2,2 4,4 8)')))
158 LINESTRING(2 0,4 2,8 4)
159 SELECT ST_ASTEXT(ST_SWAPXY(ST_LINESTRINGFROMTEXT('LINESTRING(0 12,12 24,24 48)')));
160 ST_ASTEXT(ST_SWAPXY(ST_LINESTRINGFROMTEXT('LINESTRING(0 12,12 24,24 48)')))
161 LINESTRING(12 0,24 12,48 24)
162 SELECT ST_ASTEXT(ST_SWAPXY(LINESTRING(POINT(0,2), POINT(-5,7),
163 POINT(-10,70))));
164 ST_ASTEXT(ST_SWAPXY(LINESTRING(POINT(0,2), POINT(-5,7),
165 POINT(-10,70))))
166 LINESTRING(2 0,7 -5,70 -10)
167 #=======================================================================
168 # ST_SWAPXY(polygon)
169 #=======================================================================
170 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_polygon WHERE fid = 301;
171 ST_ASTEXT(ST_SWAPXY(g))
172 POLYGON((0 0,0 5,5 5,0 0))
173 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_polygon WHERE fid = 302;
174 ST_ASTEXT(ST_SWAPXY(g))
175 POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,4 2,4 4,2 4,2 2),(6 6,8 6,8 8,6 8,6 6))
176 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_polygon WHERE fid = 303;
177 ST_ASTEXT(ST_SWAPXY(g))
178 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4))
179 SELECT ST_ASTEXT(ST_SWAPXY(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5, 0 0))')));
180 ST_ASTEXT(ST_SWAPXY(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5, 0 0))')))
181 POLYGON((0 0,0 5,5 5,0 0))
182 SELECT ST_ASTEXT(ST_SWAPXY(ST_POLYGONFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),
183 (2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))')));
184 ST_ASTEXT(ST_SWAPXY(ST_POLYGONFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),
185 (2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))')))
186 POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,4 2,4 4,2 4,2 2),(6 6,8 6,8 8,6 8,6 6))
187 SELECT ST_ASTEXT(ST_SWAPXY(POLYGON(LINESTRING(POINT(0,0), POINT(10,0),
188 POINT(10,10), POINT(0,10), POINT(0,0)), LINESTRING(POINT(4,4), POINT(4,6),
189 POINT(6,6), POINT(6,4), POINT(4,4)))));
190 ST_ASTEXT(ST_SWAPXY(POLYGON(LINESTRING(POINT(0,0), POINT(10,0),
191 POINT(10,10), POINT(0,10), POINT(0,0)), LINESTRING(POINT(4,4), POINT(4,6),
192 POINT(6,6), POINT(6,4), POINT(4,4)))))
193 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4))
194 #=======================================================================
195 # ST_SWAPXY(multipoint)
196 #=======================================================================
197 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_point WHERE fid = 401;
198 ST_ASTEXT(ST_SWAPXY(g))
199 MULTIPOINT((0 0),(5 5),(10 10))
200 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_point WHERE fid = 402;
201 ST_ASTEXT(ST_SWAPXY(g))
202 MULTIPOINT((1e308 1e308),(-1e308 1e308),(1e308 -1e308),(-1e308 -1e308))
203 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_point WHERE fid = 403;
204 ST_ASTEXT(ST_SWAPXY(g))
205 MULTIPOINT((1e308 1e308),(-1e308 1e308),(1e308 -1e308),(-1e308 -1e308),(1e308 1e308))
206 SELECT ST_ASTEXT(ST_SWAPXY(ST_MPOINTFROMTEXT('MULTIPOINT(0 5,5 10,10 20)')));
207 ST_ASTEXT(ST_SWAPXY(ST_MPOINTFROMTEXT('MULTIPOINT(0 5,5 10,10 20)')))
208 MULTIPOINT((5 0),(10 5),(20 10))
209 SELECT ST_ASTEXT(ST_SWAPXY(ST_MPOINTFROMTEXT('MULTIPOINT(
210 1e308 1e208,1e308 -1e208,-1e308 1e208,-1e308 -1e208)')));
211 ST_ASTEXT(ST_SWAPXY(ST_MPOINTFROMTEXT('MULTIPOINT(
212 1e308 1e208,1e308 -1e208,-1e308 1e208,-1e308 -1e208)')))
213 MULTIPOINT((1e208 1e308),(-1e208 1e308),(1e208 -1e308),(-1e208 -1e308))
214 SELECT ST_ASTEXT(ST_SWAPXY(ST_MPOINTFROMTEXT(
215 'MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308 1e308,
216 -1e308 -1e308,1e308 1e308)')));
217 ST_ASTEXT(ST_SWAPXY(ST_MPOINTFROMTEXT(
218 'MULTIPOINT(1e308 1e308,1e308 -1e308,-1e308 1e308,
219 -1e308 -1e308,1e308 1e308)')))
220 MULTIPOINT((1e308 1e308),(-1e308 1e308),(1e308 -1e308),(-1e308 -1e308),(1e308 1e308))
221 #=======================================================================
222 # ST_SWAPXY(multilinestring)
223 #=======================================================================
224 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_linestring WHERE fid = 501;
225 ST_ASTEXT(ST_SWAPXY(g))
226 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
227 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_linestring WHERE fid = 502;
228 ST_ASTEXT(ST_SWAPXY(g))
229 MULTILINESTRING((0 0,12 12,24 24),(36 36,48 48,50 50))
230 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_linestring WHERE fid = 503;
231 ST_ASTEXT(ST_SWAPXY(g))
232 MULTILINESTRING((0 0,100 0),(0 0,0 100),(0 0,-100 0),(0 0,0 -100))
233 SELECT ST_ASTEXT(ST_SWAPXY(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4),
234 (6 6,8 8,10 10))')));
235 ST_ASTEXT(ST_SWAPXY(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4),
236 (6 6,8 8,10 10))')))
237 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))
238 SELECT ST_ASTEXT(ST_SWAPXY(MULTILINESTRING(
239 LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)), LINESTRING(POINT(36,36),
240 POINT(48,48), POINT(50,50)))));
241 ST_ASTEXT(ST_SWAPXY(MULTILINESTRING(
242 LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)), LINESTRING(POINT(36,36),
243 POINT(48,48), POINT(50,50)))))
244 MULTILINESTRING((0 0,12 12,24 24),(36 36,48 48,50 50))
245 SELECT ST_ASTEXT(ST_SWAPXY(
246 ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,0 100),(0 0,100 0),
247 (0 0,0 -100),(0 0,-100 0))')));
248 ST_ASTEXT(ST_SWAPXY(
249 ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,0 100),(0 0,100 0),
250 (0 0,0 -100),(0 0,-100 0))')))
251 MULTILINESTRING((0 0,100 0),(0 0,0 100),(0 0,-100 0),(0 0,0 -100))
252 #=======================================================================
253 # ST_SWAPXY(multipolygon)
254 #=======================================================================
255 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_polygon WHERE fid = 601;
256 ST_ASTEXT(ST_SWAPXY(g))
257 MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)))
258 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_polygon WHERE fid = 602;
259 ST_ASTEXT(ST_SWAPXY(g))
260 MULTIPOLYGON(((0 0,0 10,10 10,0 10,0 0),(4 4,6 4,6 6,4 6,4 4)))
261 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_multi_polygon WHERE fid = 603;
262 ST_ASTEXT(ST_SWAPXY(g))
263 MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((0 0,0 -5,-5 -5,-5 0,0 0)))
264 SELECT ST_ASTEXT(ST_SWAPXY(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
265 POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))))));
266 ST_ASTEXT(ST_SWAPXY(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
267 POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))))))
268 MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)))
269 SELECT ST_ASTEXT(ST_SWAPXY(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
270 POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)), LINESTRING(POINT(4,4),
271 POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))));
272 ST_ASTEXT(ST_SWAPXY(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
273 POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)), LINESTRING(POINT(4,4),
274 POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))
275 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)))
276 SELECT ST_ASTEXT(ST_SWAPXY(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
277 POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))),
278 POLYGON(LINESTRING(POINT(0,0), POINT(-5, 0), POINT(-5,-5), POINT(0, -5),
279 POINT(0,0))))));
280 ST_ASTEXT(ST_SWAPXY(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),
281 POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))),
282 POLYGON(LINESTRING(POINT(0,0), POINT(-5, 0), POINT(-5,-5), POINT(0, -5),
283 POINT(0,0))))))
284 MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((0 0,0 -5,-5 -5,-5 0,0 0)))
285 #=======================================================================
286 # ST_SWAPXY(geometrycollection)
287 #=======================================================================
288 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_geometrycollection WHERE fid = 701;
289 ST_ASTEXT(ST_SWAPXY(g))
290 GEOMETRYCOLLECTION(POINT(0 0))
291 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_geometrycollection WHERE fid = 702;
292 ST_ASTEXT(ST_SWAPXY(g))
293 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
294 SELECT ST_ASTEXT(ST_SWAPXY(g)) FROM gis_geometrycollection WHERE fid = 703;
295 ST_ASTEXT(ST_SWAPXY(g))
296 GEOMETRYCOLLECTION(POINT(5 5),POLYGON((0 0,0 10,10 10,10 0,0 0)))
297 SELECT ST_ASTEXT(ST_SWAPXY(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')));
298 ST_ASTEXT(ST_SWAPXY(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')))
299 GEOMETRYCOLLECTION(POINT(0 0))
300 SELECT ST_ASTEXT(ST_SWAPXY(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),
301 LINESTRING(0 0,10 10))')));
302 ST_ASTEXT(ST_SWAPXY(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),
303 LINESTRING(0 0,10 10))')))
304 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))
305 SELECT ST_ASTEXT(ST_SWAPXY(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),
306 POLYGON((0 0,10 0,10 10,0 10,0 0)))')));
307 ST_ASTEXT(ST_SWAPXY(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5),
308 POLYGON((0 0,10 0,10 10,0 10,0 0)))')))
309 GEOMETRYCOLLECTION(POINT(5 5),POLYGON((0 0,0 10,10 10,10 0,0 0)))
310 SELECT ST_ASTEXT(ST_SWAPXY(NULL));
311 ST_ASTEXT(ST_SWAPXY(NULL))
312 NULL
313 SELECT ST_ASTEXT(ST_SWAPXY());
314 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SWAPXY'
315 SELECT ST_SWAPXY('foobar');
316 ERROR 22023: Invalid GIS data provided to function st_swapxy.
317 SELECT ST_SWAPXY(x'0101000000');
318 ERROR 22023: Invalid GIS data provided to function st_swapxy.
319 SELECT ST_SWAPXY(x'010200000000000000');
320 ERROR 22023: Invalid GIS data provided to function st_swapxy.
321 # Final cleanup
322 DROP TABLE gis_point;
323 DROP TABLE gis_linestring;
324 DROP TABLE gis_polygon;
325 DROP TABLE gis_multi_point;
326 DROP TABLE gis_multi_linestring;
327 DROP TABLE gis_multi_polygon;
328 DROP TABLE gis_geometrycollection;
329 #
330 # WL#11096 Don't do Cartesian computations on geographic geometries
331 #
332 DO ST_SWAPXY(x'0A000000010100000000000000000000000000000000000000');
333 ERROR SR001: There's no spatial reference system with SRID 10.