Debian Codegraph @

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

raw
1 ##########################################################
2 # Inserting testing SRS values in spatial reference table
3 ##########################################################
4 # Inserting geographical srs with long-lat ordering
5 CREATE SPATIAL REFERENCE SYSTEM 30400000 NAME 'TEST30400000' DEFINITION 'GEOGCS["SIRGAS 1995",DATUM["Sistema de Referencia Geocentrico para America del Sur 1995",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6170"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["LONG",EAST],AXIS["LAT",NORTH],AUTHORITY["EPSG","30400000"]]';
6 # Inserting geographical srs with lat-long ordering
7 CREATE SPATIAL REFERENCE SYSTEM 30500000 NAME 'TEST30500000' DEFINITION 'GEOGCS["SIRGAS 1995",DATUM["Sistema de Referencia Geocentrico para America del Sur 1995",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6170"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["LAT",NORTH],AXIS["LONG",EAST],AUTHORITY["EPSG","30500000"]]';
8 # Inserting projected srs with northing-easting ordering
9 CREATE SPATIAL REFERENCE SYSTEM 30600000 NAME 'TEST30600000' DEFINITION 'PROJCS["NAD83(NSRS2007) / Virginia Lambert",GEOGCS["NAD83(NSRS2007)",DATUM["NAD83 (National Spatial Reference System 2007)",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6759"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Long",EAST],AUTHORITY["EPSG","4759"]],PROJECTION["Lambert Conic Conformal (2SP)",AUTHORITY["EPSG","9802"]],PARAMETER["Latitude of false origin",36,AUTHORITY["EPSG","8821"]],PARAMETER["Longitude of false origin",-79.5,AUTHORITY["EPSG","8822"]],PARAMETER["Latitude of 1st standard parallel",37,AUTHORITY["EPSG","8823"]],PARAMETER["Latitude of 2nd standard parallel",39.5,AUTHORITY["EPSG","8824"]],PARAMETER["Easting at false origin",0,AUTHORITY["EPSG","8826"]],PARAMETER["Northing at false origin",0,AUTHORITY["EPSG","8827"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",NORTH],AXIS["Y",EAST],AUTHORITY["EPSG","30600000"]]';
10 # Inserting projected srs with easting-northing ordering
11 CREATE SPATIAL REFERENCE SYSTEM 30700000 NAME 'TEST30700000' DEFINITION 'PROJCS["NAD83(NSRS2007) / Virginia Lambert",GEOGCS["NAD83(NSRS2007)",DATUM["NAD83 (National Spatial Reference System 2007)",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6759"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Long",EAST],AUTHORITY["EPSG","4759"]],PROJECTION["Lambert Conic Conformal (2SP)",AUTHORITY["EPSG","9802"]],PARAMETER["Latitude of false origin",36,AUTHORITY["EPSG","8821"]],PARAMETER["Longitude of false origin",-79.5,AUTHORITY["EPSG","8822"]],PARAMETER["Latitude of 1st standard parallel",37,AUTHORITY["EPSG","8823"]],PARAMETER["Latitude of 2nd standard parallel",39.5,AUTHORITY["EPSG","8824"]],PARAMETER["Easting at false origin",0,AUTHORITY["EPSG","8826"]],PARAMETER["Northing at false origin",0,AUTHORITY["EPSG","8827"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","30700000"]]';
12 # Creating the spatial objects
13 CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
14 CREATE TABLE gis_linestring (fid INTEGER NOT NULL PRIMARY KEY, g LINESTRING);
15 CREATE TABLE gis_polygon (fid INTEGER NOT NULL PRIMARY KEY, g POLYGON);
16 CREATE TABLE gis_multi_point (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOINT);
17 CREATE TABLE gis_multi_linestring (fid INTEGER NOT NULL PRIMARY KEY, g MULTILINESTRING);
18 CREATE TABLE gis_multi_polygon (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOLYGON);
19 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRYCOLLECTION);
20 # Inserting POINT Geometry Values with different SRID types
21 INSERT INTO gis_point VALUES
22 (101, ST_SRID(ST_POINTFROMTEXT('POINT(5 10)',0), 30400000)),
23 (102, ST_SRID(ST_POINTFROMTEXT('POINT(5 10)',0), 30500000)),
24 (103, ST_SRID(ST_POINTFROMTEXT('POINT(5 10)',0), 30600000)),
25 (104, ST_SRID(ST_POINTFROMTEXT('POINT(5 10)',0), 30700000)),
26 (105, ST_SRID(ST_POINTFROMTEXT('POINT(5 10)',0), 0));
27 # Inserting LINESTRING Geometry Values with different SRID types
28 INSERT INTO gis_linestring VALUES
29 (201, ST_SRID(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)',0), 30400000)),
30 (202, ST_SRID(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)',0), 30500000)),
31 (203, ST_SRID(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)',0), 30600000)),
32 (204, ST_SRID(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)',0), 30700000)),
33 (205, ST_SRID(ST_LINEFROMTEXT('LINESTRING(0 5,5 10,10 15)',0), 0));
34 # Inserting POLYGON Geometry Values with different SRID types
35 INSERT INTO gis_polygon VALUES
36 (301, ST_SRID(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))',0), 30400000)),
37 (302, ST_SRID(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))',0), 30500000)),
38 (303, ST_SRID(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))',0), 30600000)),
39 (304, ST_SRID(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))',0), 30700000)),
40 (305, ST_SRID(ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))',0), 0));
41 # Inserting MULTIPOINT Geometry Values with different SRID types
42 INSERT INTO gis_multi_point VALUES
43 (401, ST_SRID(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',0), 30400000)),
44 (402, ST_SRID(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',0), 30500000)),
45 (403, ST_SRID(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',0), 30600000)),
46 (404, ST_SRID(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',0), 30700000)),
47 (405, ST_SRID(ST_MPOINTFROMTEXT('MULTIPOINT((0 2), (5 7), (8 2), (4 9))',0), 0));
48 # Inserting MULTILINESTRING Geometry Values with different SRID types
49 INSERT INTO gis_multi_linestring VALUES
50 (501, ST_SRID(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))',0), 30400000)),
51 (502, ST_SRID(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))',0), 30500000)),
52 (503, ST_SRID(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))',0), 30600000)),
53 (504, ST_SRID(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))',0), 30700000)),
54 (505, ST_SRID(ST_MLINEFROMTEXT('MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))',0), 0));
55 # Inserting MULTIPOLYGON Geometry Values with different SRID types
56 INSERT INTO gis_multi_polygon VALUES
57 (601, ST_SRID(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))',0), 30400000)),
58 (602, ST_SRID(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))',0), 30500000)),
59 (603, ST_SRID(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))',0), 30600000)),
60 (604, ST_SRID(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))',0), 30700000)),
61 (605, ST_SRID(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0)))',0), 0));
62 # Inserting GEOMETRYCOLLECTION Geometry Values with different SRID types
63 INSERT INTO gis_geometrycollection VALUES
64 (701, ST_SRID(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5), POLYGON((0 0,10 0,10 10,0 10,0 0)), MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0))))',0), 30400000)),
65 (702, ST_SRID(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5), POLYGON((0 0,10 0,10 10,0 10,0 0)), MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0))))',0), 30500000)),
66 (703, ST_SRID(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5), POLYGON((0 0,10 0,10 10,0 10,0 0)), MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0))))',0), 30600000)),
67 (704, ST_SRID(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5), POLYGON((0 0,10 0,10 10,0 10,0 0)), MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0))))',0), 30700000)),
68 (705, ST_SRID(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(3 5), POLYGON((0 0,10 0,10 10,0 10,0 0)), MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4, 4 4)),((0 0,-2 -2,0 -2, 0 0))))',0), 0));
69 #####################################################################
70 # Retrieving geometries with ST_ASTEXT with no parameter
71 # (Should thus be retrieved with the SRID default axis ordering)
72 #####################################################################
73 # Retrieve all values from gis_point
74 SELECT ST_ASTEXT(g) FROM gis_point
75 ORDER BY fid;
76 ST_ASTEXT(g)
77 POINT(5 10)
78 POINT(10 5)
79 POINT(5 10)
80 POINT(5 10)
81 POINT(5 10)
82 # Retrieve all values from gis_linestring
83 SELECT ST_ASTEXT(g) FROM gis_linestring
84 ORDER BY fid;
85 ST_ASTEXT(g)
86 LINESTRING(0 5,5 10,10 15)
87 LINESTRING(5 0,10 5,15 10)
88 LINESTRING(0 5,5 10,10 15)
89 LINESTRING(0 5,5 10,10 15)
90 LINESTRING(0 5,5 10,10 15)
91 # Retrieve all values from gis_polygon
92 SELECT ST_ASTEXT(g) FROM gis_polygon
93 ORDER BY fid;
94 ST_ASTEXT(g)
95 POLYGON((0 0,5 0,5 5,0 5,0 0))
96 POLYGON((0 0,0 5,5 5,5 0,0 0))
97 POLYGON((0 0,5 0,5 5,0 5,0 0))
98 POLYGON((0 0,5 0,5 5,0 5,0 0))
99 POLYGON((0 0,5 0,5 5,0 5,0 0))
100 # Retrieve all values from gis_multi_point
101 SELECT ST_ASTEXT(g) FROM gis_multi_point
102 ORDER BY fid;
103 ST_ASTEXT(g)
104 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
105 MULTIPOINT((2 0),(7 5),(2 8),(9 4))
106 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
107 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
108 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
109 # Retrieve all values from gis_multi_linestring
110 SELECT ST_ASTEXT(g) FROM gis_multi_linestring
111 ORDER BY fid;
112 ST_ASTEXT(g)
113 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
114 MULTILINESTRING((2 0,4 2,6 4),(11 8,14 11,17 14))
115 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
116 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
117 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
118 # Retrieve all values from gis_multi_polygon
119 SELECT ST_ASTEXT(g) FROM gis_multi_polygon
120 ORDER BY fid;
121 ST_ASTEXT(g)
122 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
123 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0)))
124 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
125 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
126 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
127 # Retrieve all values from gis_geometrycollection
128 SELECT ST_ASTEXT(g) FROM gis_geometrycollection
129 ORDER BY fid;
130 ST_ASTEXT(g)
131 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
132 GEOMETRYCOLLECTION(POINT(5 3),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0))))
133 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
134 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
135 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
136 #####################################################################
137 # Retrieving geometries with ST_ASTEXT with lat-long axis ordering
138 # (Default SRID axis order should thus be overridden)
139 #####################################################################
140 # Retrieve all values from gis_point
141 SELECT ST_ASTEXT(g, 'axis-order=lat-long') FROM gis_point
142 ORDER BY fid;
143 ST_ASTEXT(g, 'axis-order=lat-long')
144 POINT(10 5)
145 POINT(10 5)
146 POINT(5 10)
147 POINT(5 10)
148 POINT(5 10)
149 # Retrieve all values from gis_linestring
150 SELECT ST_ASTEXT(g, 'axis-order=lat-long') FROM gis_linestring ORDER BY fid;
151 ST_ASTEXT(g, 'axis-order=lat-long')
152 LINESTRING(5 0,10 5,15 10)
153 LINESTRING(5 0,10 5,15 10)
154 LINESTRING(0 5,5 10,10 15)
155 LINESTRING(0 5,5 10,10 15)
156 LINESTRING(0 5,5 10,10 15)
157 # Retrieve all values from gis_polygon
158 SELECT ST_ASTEXT(g, 'axis-order=lat-long') FROM gis_polygon
159 ORDER BY fid;
160 ST_ASTEXT(g, 'axis-order=lat-long')
161 POLYGON((0 0,0 5,5 5,5 0,0 0))
162 POLYGON((0 0,0 5,5 5,5 0,0 0))
163 POLYGON((0 0,5 0,5 5,0 5,0 0))
164 POLYGON((0 0,5 0,5 5,0 5,0 0))
165 POLYGON((0 0,5 0,5 5,0 5,0 0))
166 # Retrieve all values from gis_multi_point
167 SELECT ST_ASTEXT(g, 'axis-order=lat-long') FROM gis_multi_point ORDER BY fid;
168 ST_ASTEXT(g, 'axis-order=lat-long')
169 MULTIPOINT((2 0),(7 5),(2 8),(9 4))
170 MULTIPOINT((2 0),(7 5),(2 8),(9 4))
171 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
172 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
173 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
174 # Retrieve all values from gis_multi_linestring
175 SELECT ST_ASTEXT(g, 'axis-order=lat-long') FROM gis_multi_linestring ORDER BY fid;
176 ST_ASTEXT(g, 'axis-order=lat-long')
177 MULTILINESTRING((2 0,4 2,6 4),(11 8,14 11,17 14))
178 MULTILINESTRING((2 0,4 2,6 4),(11 8,14 11,17 14))
179 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
180 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
181 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
182 # Retrieve all values from gis_multi_polygon
183 SELECT ST_ASTEXT(g, 'axis-order=lat-long') FROM gis_multi_polygon ORDER BY fid;
184 ST_ASTEXT(g, 'axis-order=lat-long')
185 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0)))
186 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0)))
187 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
188 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
189 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
190 # Retrieve all values from gis_geometrycollection
191 SELECT ST_ASTEXT(g, 'axis-order=lat-long') FROM gis_geometrycollection ORDER BY fid;
192 ST_ASTEXT(g, 'axis-order=lat-long')
193 GEOMETRYCOLLECTION(POINT(5 3),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0))))
194 GEOMETRYCOLLECTION(POINT(5 3),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0))))
195 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
196 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
197 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
198 #####################################################################
199 # Retrieving geometries with ST_ASTEXT with long-lat axis ordering
200 # (Default SRID axis order should thus be overridden)
201 #####################################################################
202 # Retrieve all values from gis_point
203 SELECT ST_ASTEXT(g, 'axis-order=long-lat') FROM gis_point
204 ORDER BY fid;
205 ST_ASTEXT(g, 'axis-order=long-lat')
206 POINT(5 10)
207 POINT(5 10)
208 POINT(5 10)
209 POINT(5 10)
210 POINT(5 10)
211 # Retrieve all values from gis_linestring
212 SELECT ST_ASTEXT(g, 'axis-order=long-lat') FROM gis_linestring ORDER BY fid;
213 ST_ASTEXT(g, 'axis-order=long-lat')
214 LINESTRING(0 5,5 10,10 15)
215 LINESTRING(0 5,5 10,10 15)
216 LINESTRING(0 5,5 10,10 15)
217 LINESTRING(0 5,5 10,10 15)
218 LINESTRING(0 5,5 10,10 15)
219 # Retrieve all values from gis_polygon
220 SELECT ST_ASTEXT(g, 'axis-order=long-lat') FROM gis_polygon
221 ORDER BY fid;
222 ST_ASTEXT(g, 'axis-order=long-lat')
223 POLYGON((0 0,5 0,5 5,0 5,0 0))
224 POLYGON((0 0,5 0,5 5,0 5,0 0))
225 POLYGON((0 0,5 0,5 5,0 5,0 0))
226 POLYGON((0 0,5 0,5 5,0 5,0 0))
227 POLYGON((0 0,5 0,5 5,0 5,0 0))
228 # Retrieve all values from gis_multi_point
229 SELECT ST_ASTEXT(g, 'axis-order=long-lat') FROM gis_multi_point ORDER BY fid;
230 ST_ASTEXT(g, 'axis-order=long-lat')
231 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
232 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
233 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
234 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
235 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
236 # Retrieve all values from gis_multi_linestring
237 SELECT ST_ASTEXT(g, 'axis-order=long-lat') FROM gis_multi_linestring ORDER BY fid;
238 ST_ASTEXT(g, 'axis-order=long-lat')
239 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
240 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
241 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
242 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
243 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
244 # Retrieve all values from gis_multi_polygon
245 SELECT ST_ASTEXT(g, 'axis-order=long-lat') FROM gis_multi_polygon ORDER BY fid;
246 ST_ASTEXT(g, 'axis-order=long-lat')
247 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
248 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
249 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
250 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
251 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
252 # Retrieve all values from gis_geometrycollection
253 SELECT ST_ASTEXT(g, 'axis-order=long-lat') FROM gis_geometrycollection ORDER BY fid;
254 ST_ASTEXT(g, 'axis-order=long-lat')
255 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
256 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
257 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
258 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
259 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
260 #####################################################################
261 # Retrieving geometries with ST_ASTEXT with srid-default axis ordering
262 # (Default SRID coordination should thus not be overridden)
263 #####################################################################
264 # Retrieve all values from gis_point
265 SELECT ST_ASTEXT(g, 'axis-order=srid-defined') FROM gis_point
266 ORDER BY fid;
267 ST_ASTEXT(g, 'axis-order=srid-defined')
268 POINT(5 10)
269 POINT(10 5)
270 POINT(5 10)
271 POINT(5 10)
272 POINT(5 10)
273 # Retrieve all values from gis_linestring
274 SELECT ST_ASTEXT(g, 'axis-order=srid-defined') FROM gis_linestring ORDER BY fid;
275 ST_ASTEXT(g, 'axis-order=srid-defined')
276 LINESTRING(0 5,5 10,10 15)
277 LINESTRING(5 0,10 5,15 10)
278 LINESTRING(0 5,5 10,10 15)
279 LINESTRING(0 5,5 10,10 15)
280 LINESTRING(0 5,5 10,10 15)
281 # Retrieve all values from gis_polygon
282 SELECT ST_ASTEXT(g, 'axis-order=srid-defined') FROM gis_polygon ORDER BY fid;
283 ST_ASTEXT(g, 'axis-order=srid-defined')
284 POLYGON((0 0,5 0,5 5,0 5,0 0))
285 POLYGON((0 0,0 5,5 5,5 0,0 0))
286 POLYGON((0 0,5 0,5 5,0 5,0 0))
287 POLYGON((0 0,5 0,5 5,0 5,0 0))
288 POLYGON((0 0,5 0,5 5,0 5,0 0))
289 # Retrieve all values from gis_multi_point
290 SELECT ST_ASTEXT(g, 'axis-order=srid-defined') FROM gis_multi_point ORDER BY fid;
291 ST_ASTEXT(g, 'axis-order=srid-defined')
292 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
293 MULTIPOINT((2 0),(7 5),(2 8),(9 4))
294 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
295 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
296 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
297 # Retrieve all values from gis_multi_linestring
298 SELECT ST_ASTEXT(g, 'axis-order=srid-defined') FROM gis_multi_linestring ORDER BY fid;
299 ST_ASTEXT(g, 'axis-order=srid-defined')
300 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
301 MULTILINESTRING((2 0,4 2,6 4),(11 8,14 11,17 14))
302 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
303 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
304 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
305 # Retrieve all values from gis_multi_polygon
306 SELECT ST_ASTEXT(g, 'axis-order=srid-defined') FROM gis_multi_polygon ORDER BY fid;
307 ST_ASTEXT(g, 'axis-order=srid-defined')
308 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
309 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0)))
310 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
311 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
312 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
313 # Retrieve all values from gis_geometrycollection
314 SELECT ST_ASTEXT(g, 'axis-order=srid-defined') FROM gis_geometrycollection ORDER BY fid;
315 ST_ASTEXT(g, 'axis-order=srid-defined')
316 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
317 GEOMETRYCOLLECTION(POINT(5 3),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0))))
318 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
319 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
320 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
321 ##########################################################################
322 # Retrieving geometries with ST_ASTEXT with empty axis ordering parameter
323 # (Default SRID coordination should thus be used)
324 ##########################################################################
325 # Retrieve all values from gis_point
326 SELECT ST_ASTEXT(g, '') FROM gis_point
327 ORDER BY fid;
328 ST_ASTEXT(g, '')
329 POINT(5 10)
330 POINT(10 5)
331 POINT(5 10)
332 POINT(5 10)
333 POINT(5 10)
334 # Retrieve all values from gis_linestring
335 SELECT ST_ASTEXT(g, '') FROM gis_linestring
336 ORDER BY fid;
337 ST_ASTEXT(g, '')
338 LINESTRING(0 5,5 10,10 15)
339 LINESTRING(5 0,10 5,15 10)
340 LINESTRING(0 5,5 10,10 15)
341 LINESTRING(0 5,5 10,10 15)
342 LINESTRING(0 5,5 10,10 15)
343 # Retrieve all values from gis_polygon
344 SELECT ST_ASTEXT(g, '') FROM gis_polygon
345 ORDER BY fid;
346 ST_ASTEXT(g, '')
347 POLYGON((0 0,5 0,5 5,0 5,0 0))
348 POLYGON((0 0,0 5,5 5,5 0,0 0))
349 POLYGON((0 0,5 0,5 5,0 5,0 0))
350 POLYGON((0 0,5 0,5 5,0 5,0 0))
351 POLYGON((0 0,5 0,5 5,0 5,0 0))
352 # Retrieve all values from gis_multi_point
353 SELECT ST_ASTEXT(g, '') FROM gis_multi_point
354 ORDER BY fid;
355 ST_ASTEXT(g, '')
356 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
357 MULTIPOINT((2 0),(7 5),(2 8),(9 4))
358 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
359 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
360 MULTIPOINT((0 2),(5 7),(8 2),(4 9))
361 # Retrieve all values from gis_multi_linestring
362 SELECT ST_ASTEXT(g, '') FROM gis_multi_linestring
363 ORDER BY fid;
364 ST_ASTEXT(g, '')
365 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
366 MULTILINESTRING((2 0,4 2,6 4),(11 8,14 11,17 14))
367 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
368 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
369 MULTILINESTRING((0 2,2 4,4 6),(8 11,11 14,14 17))
370 # Retrieve all values from gis_multi_polygon
371 SELECT ST_ASTEXT(g, '') FROM gis_multi_polygon
372 ORDER BY fid;
373 ST_ASTEXT(g, '')
374 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
375 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0)))
376 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
377 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
378 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0)))
379 # Retrieve all values from gis_geometrycollection
380 SELECT ST_ASTEXT(g, '') FROM gis_geometrycollection
381 ORDER BY fid;
382 ST_ASTEXT(g, '')
383 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
384 GEOMETRYCOLLECTION(POINT(5 3),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0))))
385 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
386 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
387 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
388 ################################
389 # Specific cases testing
390 # ##############################
391 # Test with combined lowercase and uppercase characters in optional parameter
392 SELECT ST_ASTEXT(g, 'aXIs-oRDer=sriD-dEFineD') FROM gis_geometrycollection ORDER BY fid;
393 ST_ASTEXT(g, 'aXIs-oRDer=sriD-dEFineD')
394 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
395 GEOMETRYCOLLECTION(POINT(5 3),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0))))
396 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
397 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
398 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
399 # Test with combined lowercase, uppercase and whitespaces in optional parameter
400 SELECT ST_ASTEXT(g, ' aXIs-oRDer=sriD-dEFineD ') FROM gis_geometrycollection ORDER BY fid;
401 ST_ASTEXT(g, ' aXIs-oRDer=sriD-dEFineD ')
402 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
403 GEOMETRYCOLLECTION(POINT(5 3),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0))))
404 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
405 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
406 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
407 # Test with only whitespaces in optional parameter (Should return same as empty string)
408 SELECT ST_ASTEXT(g, ' ') FROM gis_geometrycollection
409 ORDER BY fid;
410 ST_ASTEXT(g, ' ')
411 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
412 GEOMETRYCOLLECTION(POINT(5 3),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,-2 0,0 0))))
413 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
414 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
415 GEOMETRYCOLLECTION(POINT(3 5),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,0 -2,0 0))))
416 ##########################
417 # Error testing
418 # ########################
419 # Test with badly formed options string
420 SELECT ST_ASTEXT(g, 'axis-order srid-defined') FROM gis_geometrycollection;
421 ERROR 22023: The string 'axis-order srid-defined' is not a valid key = value pair in function st_astext.
422 SELECT ST_ASTEXT(g, '=axis-order srid-defined') FROM gis_geometrycollection;
423 ERROR 22023: The options argument in function st_astext starts with the invalid character '='.
424 SELECT ST_ASWKT(g, 'axis-order=srid-defined, axis-order=lat-long') FROM gis_geometrycollection;
425 ERROR 22023: Duplicate option key 'axis-order' in funtion 'st_astext'.
426 # Test with too many options
427 SELECT ST_ASTEXT(g, 'axis-order=srid-defined, axis-order2=lat-long') FROM gis_geometrycollection;
428 ERROR 22023: Invalid option key 'axis-order2' in function st_astext.
429 # Test with invalid options value
430 SELECT ST_ASTEXT(g, 'axis-order=invalid-option') FROM gis_geometrycollection;
431 ERROR 22023: Invalid value 'invalid-option' for option 'axis-order' in function 'st_astext'.
432 # Test with too many function parameters
433 SELECT ST_ASTEXT(g, 'axis-order=long-lat', POINT(2, 4)) FROM gis_geometrycollection;
434 ERROR 42000: Incorrect parameter count in the call to native function 'ST_ASTEXT'
435 # Test with too invalid start and end characters in substring
436 SELECT ST_ASTEXT(POINT(4, 2), 'axis-order=test,=long-lathello,=test');
437 ERROR 22023: The options argument in function st_astext starts with the invalid character '='.
438 SELECT ST_ASTEXT(POINT(4, 2), 'axis-order=long-lat=, axis-order=lat-long');
439 ERROR 22023: The options argument in function st_astext ends with the invalid character '='.
440 # Test with both invalid option and invalid value
441 SELECT ST_ASTEXT(g, 'invalid_option=invalid-value') FROM gis_geometrycollection;
442 ERROR 22023: Invalid option key 'invalid_option' in function st_astext.
443 SELECT ST_ASWKT(g, 'axis-order=invalid-option') FROM gis_geometrycollection;
444 ERROR 22023: Invalid value 'invalid-option' for option 'axis-order' in function 'st_astext'.
445 # Test with SRID value 0
446 SELECT ST_ASWKT(ST_POINTFROMTEXT('POINT(4 2)', 0));
447 ST_ASWKT(ST_POINTFROMTEXT('POINT(4 2)', 0))
448 POINT(4 2)
449 # NULL value testing: Should return NULL if either or both parameters of
450 # ST_ASTEXT/ST_WKT is NULL
451 SELECT ST_ASTEXT(NULL, 'axis-order=srid-defined');
452 ST_ASTEXT(NULL, 'axis-order=srid-defined')
453 NULL
454 SELECT ST_ASTEXT(POINT(0, 0), NULL);
455 ST_ASTEXT(POINT(0, 0), NULL)
456 NULL
457 SELECT ST_ASTEXT(NULL, NULL);
458 ST_ASTEXT(NULL, NULL)
459 NULL
460 DROP TABLE gis_point;
461 DROP TABLE gis_linestring;
462 DROP TABLE gis_polygon;
463 DROP TABLE gis_multi_point;
464 DROP TABLE gis_multi_linestring;
465 DROP TABLE gis_multi_polygon;
466 DROP TABLE gis_geometrycollection;
467 DROP SPATIAL REFERENCE SYSTEM 30400000;
468 DROP SPATIAL REFERENCE SYSTEM 30500000;
469 DROP SPATIAL REFERENCE SYSTEM 30600000;
470 DROP SPATIAL REFERENCE SYSTEM 30700000;