Debian Codegraph @

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

raw
1 # This test test the ST_Transform function
2
3 --echo #
4 --echo # NULL values.
5 --echo #
6
7 --echo # At least one NULL parameter. Should return NULL.
8 SELECT ST_TRANSFORM(NULL, NULL);
9 SELECT ST_TRANSFORM(NULL, 4326);
10 SELECT ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), NULL);
11
12 --echo #
13 --echo # Invalid parameters.
14 --echo #
15
16 --echo # Invalid geometry. Should raise error.
17 --error ER_GIS_INVALID_DATA
18 DO ST_TRANSFORM(x'00000000DEADBEEF', 4326);
19
20 --echo # Non-existing SRID. Should raise error.
21 # Assume SRID 1000000000 is undefined.
22 --error ER_SRS_NOT_FOUND
23 DO ST_TRANSFORM(
24 x'94007735010100000000000000000000000000000000000000',
25 4326
26 );
27 --error ER_SRS_NOT_FOUND
28 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000000000);
29
30 --echo #
31 --echo # Transformation to/from SRID 0.
32 --echo #
33
34 --echo # Transformation from SRID 0 to SRID 0 is a no-op. Should return true.
35 SELECT
36 ST_EQUALS(
37 ST_GEOMFROMTEXT('POINT(0 0)'),
38 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)'), 0)
39 ) AS is_noop;
40
41 --echo # Transformation between SRID 0 and geographic SRS. Should raise error.
42 # Ellipsoidal:
43 --error ER_TRANSFORM_SOURCE_SRS_NOT_SUPPORTED
44 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)'), 4326);
45 --error ER_TRANSFORM_TARGET_SRS_NOT_SUPPORTED
46 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 0);
47 # Spherical:
48 --error ER_TRANSFORM_SOURCE_SRS_NOT_SUPPORTED
49 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)'), 4047);
50 --error ER_TRANSFORM_TARGET_SRS_NOT_SUPPORTED
51 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4047), 0);
52
53 --echo # Transformation between SRID 0 and projected SRS. Should raise error.
54 --error ER_TRANSFORM_SOURCE_SRS_NOT_SUPPORTED
55 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)'), 3857);
56 --error ER_TRANSFORM_TARGET_SRS_NOT_SUPPORTED
57 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 3857), 0);
58
59 --echo #
60 --echo # Transformation between geographic SRSs.
61 --echo #
62
63 --echo # Transformation of every geometry type. Should succeed.
64 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 3819);
65 DO ST_TRANSFORM(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)', 4326), 3819);
66 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 0 0))', 4326), 3819);
67 DO ST_TRANSFORM(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))', 4326), 3819);
68 DO ST_TRANSFORM(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326), 3819);
69 DO ST_TRANSFORM(ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1))', 4326), 3819);
70 DO ST_TRANSFORM(
71 ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))', 4326),
72 3819
73 );
74
75 --echo # Beginning of tests to verify that WGS 84 is recognized.
76
77 --echo # WGS 84 with no authority codes. Should raise error.
78 CREATE SPATIAL REFERENCE SYSTEM 1000004326
79 NAME 'foo'
80 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]';
81 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
82 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
83 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
84 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
85 DROP SPATIAL REFERENCE SYSTEM 1000004326;
86
87 --echo # WGS 84 with no authority codes exept EPSG 4326 for the entire SRS.
88 --echo # Should succeed.
89 CREATE SPATIAL REFERENCE SYSTEM 1000004326
90 NAME 'foo'
91 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
92 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
93 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
94 DROP SPATIAL REFERENCE SYSTEM 1000004326;
95
96 --echo # WGS 84 with incorrect authority code. Should raise error.
97 CREATE SPATIAL REFERENCE SYSTEM 1000004326
98 NAME 'foo'
99 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","0"]]';
100 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
101 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
102 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
103 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
104 DROP SPATIAL REFERENCE SYSTEM 1000004326;
105
106 --echo # WGS 84 with authority code for the spheroid. Should succeed.
107 CREATE SPATIAL REFERENCE SYSTEM 1000004326
108 NAME 'foo'
109 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
110 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
111 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
112 DROP SPATIAL REFERENCE SYSTEM 1000004326;
113
114 --echo # WGS 84 with incorrect authority code for the spheroid. Should raise
115 --echo # error.
116 CREATE SPATIAL REFERENCE SYSTEM 1000004326
117 NAME 'foo'
118 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","0"]]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
119 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
120 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
121 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
122 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
123 DROP SPATIAL REFERENCE SYSTEM 1000004326;
124
125 --echo # WGS 84 with incorrect semi-major axis. Should raise error.
126 CREATE SPATIAL REFERENCE SYSTEM 1000004326
127 NAME 'foo'
128 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",1378137,298.257223563,AUTHORITY["EPSG","7030"]]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
129 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
130 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
131 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
132 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
133 DROP SPATIAL REFERENCE SYSTEM 1000004326;
134
135 --echo # WGS 84 with incorrect inverse flattening. Should raise error.
136 CREATE SPATIAL REFERENCE SYSTEM 1000004326
137 NAME 'foo'
138 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,198.257223563,AUTHORITY["EPSG","7030"]]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
139 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
140 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
141 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
142 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
143 DROP SPATIAL REFERENCE SYSTEM 1000004326;
144
145 --echo # WGS 84 with authority code for the datum. Should succeed.
146 CREATE SPATIAL REFERENCE SYSTEM 1000004326
147 NAME 'foo'
148 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
149 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
150 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
151 DROP SPATIAL REFERENCE SYSTEM 1000004326;
152
153 --echo # WGS 84 with incorrect authority code for the datum. Should raise error.
154 CREATE SPATIAL REFERENCE SYSTEM 1000004326
155 NAME 'foo'
156 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563],AUTHORITY["EPSG","0"]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
157 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
158 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
159 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
160 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
161 DROP SPATIAL REFERENCE SYSTEM 1000004326;
162
163 --echo # WGS 84 with authority code for the prime meridian. Should succeed.
164 CREATE SPATIAL REFERENCE SYSTEM 1000004326
165 NAME 'foo'
166 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
167 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
168 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
169 DROP SPATIAL REFERENCE SYSTEM 1000004326;
170
171 --echo # WGS 84 with incorrect authority code for the prime meridian. Should
172 --echo # raise error.
173 CREATE SPATIAL REFERENCE SYSTEM 1000004326
174 NAME 'foo'
175 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","0"]],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
176 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
177 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
178 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
179 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
180 DROP SPATIAL REFERENCE SYSTEM 1000004326;
181
182 --echo # WGS 84 with incorrect prime meridian. Should raise error.
183 CREATE SPATIAL REFERENCE SYSTEM 1000004326
184 NAME 'foo'
185 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",1,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
186 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
187 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
188 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
189 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
190 DROP SPATIAL REFERENCE SYSTEM 1000004326;
191
192 --echo # WGS 84 with authority code for the unit. Should succeed.
193 CREATE SPATIAL REFERENCE SYSTEM 1000004326
194 NAME 'foo'
195 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
196 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
197 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
198 DROP SPATIAL REFERENCE SYSTEM 1000004326;
199
200 --echo # WGS 84 with incorrect authority code for the unit. Should raise error.
201 CREATE SPATIAL REFERENCE SYSTEM 1000004326
202 NAME 'foo'
203 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","0"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
204 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
205 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
206 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
207 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
208 DROP SPATIAL REFERENCE SYSTEM 1000004326;
209
210 --echo # WGS 84 with incorrect unit. Should raise error.
211 CREATE SPATIAL REFERENCE SYSTEM 1000004326
212 NAME 'foo'
213 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.01,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]';
214 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
215 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
216 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
217 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
218 DROP SPATIAL REFERENCE SYSTEM 1000004326;
219
220 --echo # WGS 84 with incorrect axes. Should raise error.
221 CREATE SPATIAL REFERENCE SYSTEM 1000004326
222 NAME 'foo'
223 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lon",EAST],AXIS["Lat",NORTH],AUTHORITY["EPSG","4326"]]';
224 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
225 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
226 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
227 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
228 DROP SPATIAL REFERENCE SYSTEM 1000004326;
229
230 --echo # End of tests to verify that WGS 84 is recognized.
231
232 --echo # Geographic SRS with TOWGS84 clause. Should succeed.
233 CREATE SPATIAL REFERENCE SYSTEM 1000004326
234 NAME 'foo'
235 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]';
236 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
237 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
238 DROP SPATIAL REFERENCE SYSTEM 1000004326;
239
240 --echo # Spherical SRS with TOWGS84 clause. Should succeed.
241 CREATE SPATIAL REFERENCE SYSTEM 1000004326
242 NAME 'foo'
243 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]';
244 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326);
245 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326);
246 DROP SPATIAL REFERENCE SYSTEM 1000004326;
247
248 --echo # Prime meridian 1 degree East of Greenwich.
249 CREATE SPATIAL REFERENCE SYSTEM 1000004326
250 NAME 'foo'
251 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["foo",1],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]';
252 --replace_numeric_round 15
253 SELECT
254 ST_ASTEXT(
255 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326)
256 ) AS lon_should_be_plus_one;
257 SELECT
258 ST_ASTEXT(
259 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326)
260 ) AS lon_should_be_minus_one;
261 DROP SPATIAL REFERENCE SYSTEM 1000004326;
262
263 --echo # Prime meridian 1 degree West of Greenwich.
264 CREATE SPATIAL REFERENCE SYSTEM 1000004326
265 NAME 'foo'
266 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["foo",-1],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]';
267 --replace_numeric_round 15
268 SELECT
269 ST_ASTEXT(
270 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326)
271 ) AS lon_should_be_minus_one;
272 SELECT
273 ST_ASTEXT(
274 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326)
275 ) AS lon_should_be_plus_one;
276 DROP SPATIAL REFERENCE SYSTEM 1000004326;
277
278 --echo # Prime meridian 180 degrees East of Greenwich.
279 CREATE SPATIAL REFERENCE SYSTEM 1000004326
280 NAME 'foo'
281 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["foo",180],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]';
282 SELECT
283 ST_ASTEXT(
284 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326)
285 ) AS lon_should_be_180;
286 # Because of floating point computations, -180 is not converted to 180, even
287 # though the range is (-180, 180].
288 SELECT
289 ST_ASTEXT(
290 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326)
291 ) AS lon_should_be_minus_180;
292 DROP SPATIAL REFERENCE SYSTEM 1000004326;
293
294 --echo # Prime meridian 180 degrees West of Greenwich.
295 CREATE SPATIAL REFERENCE SYSTEM 1000004326
296 NAME 'foo'
297 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["foo",-180],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]';
298 # Because of floating point computations, -180 is not converted to 180, even
299 # though the range is (-180, 180].
300 SELECT
301 ST_ASTEXT(
302 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326)
303 ) AS lon_should_be_minus_180;
304 SELECT
305 ST_ASTEXT(
306 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326)
307 ) AS lon_should_be_180;
308 DROP SPATIAL REFERENCE SYSTEM 1000004326;
309
310 --echo # Transformation between degrees and gradians.
311 CREATE SPATIAL REFERENCE SYSTEM 1000004326
312 NAME 'foo'
313 DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["Greenwich",0],UNIT["grad",0.01570796326794895],AXIS["Lat",NORTH],AXIS["Lon",EAST]]';
314 SELECT
315 ST_ASTEXT(
316 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326)
317 ) AS should_be_0_0;
318 SELECT
319 ST_ASTEXT(
320 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326)
321 ) AS should_be_0_0;
322 SELECT
323 ST_ASTEXT(
324 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(100 100)', 1000004326), 4326)
325 ) AS should_be_90_90;
326 SELECT
327 ST_ASTEXT(
328 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(90 90)', 4326), 1000004326)
329 ) AS should_be_100_100;
330 SELECT
331 ST_ASTEXT(
332 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-100 -100)', 1000004326), 4326)
333 ) AS should_be_minus_90_minus_90;
334 SELECT
335 ST_ASTEXT(
336 ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-90 -90)', 4326), 1000004326)
337 ) AS should_be_minus_100_minus_100;
338 DROP SPATIAL REFERENCE SYSTEM 1000004326;
339
340 --echo # Transformations between European Datum 1950 (ED50) and WGS 84.
341 --echo # Positions in Western Europe will be further North and East in ED50 than
342 --echo # in WGS 84.
343
344 --echo # Trondheim.
345 --replace_numeric_round 6
346 SELECT
347 ST_ASTEXT(
348 ST_TRANSFORM(
349 ST_GEOMFROMTEXT('POINT(63.4269121428687 10.3969184885902)', 4326),
350 4230
351 )
352 ) AS ED50;
353 --replace_numeric_round 6
354 SELECT
355 ST_ASTEXT(
356 ST_TRANSFORM(
357 ST_GEOMFROMTEXT('POINT(63.42724046084803 10.398501870897267)', 4230),
358 4326
359 )
360 ) AS WGS84;
361
362 --echo # Telegrafenberg, Potsdam (origin of ED50).
363 --replace_numeric_round 6
364 SELECT
365 ST_ASTEXT(
366 ST_TRANSFORM(
367 ST_GEOMFROMTEXT('POINT(52.381389 13.064444)', 4326),
368 4230
369 )
370 ) AS ED50;
371 --replace_numeric_round 6
372 SELECT
373 ST_ASTEXT(
374 ST_TRANSFORM(
375 ST_GEOMFROMTEXT('POINT(52.38208611407426 13.065520672345304)', 4230),
376 4326
377 )
378 ) AS WGS84;
379
380 --echo #
381 --echo # Transformation to/from projected SRSs.
382 --echo #
383 # Examples taken from IOGP Publication 373-7-2 – Geomatics Guidance Note number 7, part 2 – September 2019
384 # available at www.epsg.org
385 # If IOGP does not contain an example then one is produced and tested against proj4,6
386
387 # EPSG 1024 Popular Visualisation Pseudo Mercator
388 # EPSG 3857: the web mercator projection i.e. epsg 1024 with wgs84 as base ellipsoid
389 # example from "Coordinate Conversions and Transformations including Formulas,
390 # IOGP Publication 373-7-2 – Geomatics Guidance Note number 7, part 2 – September 2019", pg. 45
391 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(24.381786962 -100.33333332)', 4326), 3857));
392 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-11169055.574774178 2800000.005281789)', 3857), 4326));
393 # test user defined EPSG 1024 projection
394 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'webmodairy' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["Modified Airy / Pseudo-Mercator",GEOGCS["modairy",DATUM["modairy",SPHEROID["Bessel 1841", 6377340.189,299.324937365, AUTHORITY["EPSG","7004"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6120"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4120"]],PROJECTION["Popular Visualisation Pseudo Mercator",AUTHORITY["EPSG","1024"]],PARAMETER["Latitude of natural origin",0,AUTHORITY["EPSG","8801"]],PARAMETER["Longitude of natural origin",0.01,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",100,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",-10,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","3857"]]';
395 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0.0008983333 0.001796667)', 4326, 'axis-order=long-lat'), 33001));
396 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-913.0663257585971 189.97410223677596)', 33001, 'axis-order=long-lat'), 4326), 'axis-order=long-lat');
397 DROP SPATIAL REFERENCE SYSTEM 33001;
398
399 # EPSG 1027 Lambert Azimuthal Equal Area (Spherical)
400 # create user defined srs based on 2163 but with a towgs84 clause
401 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["US National Atlas Equal Area",GEOGCS["Unspecified datum based upon the Clarke 1866 Authalic Sphere",DATUM["Not specified (based on Clarke 1866 Authalic Sphere)",SPHEROID["Clarke 1866 Authalic Sphere",6370997,0,AUTHORITY["EPSG","7052"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6052"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4052"]],PROJECTION["Lambert Azimuthal Equal Area (Spherical)",AUTHORITY["EPSG","1027"]],PARAMETER["Latitude of natural origin",45,AUTHORITY["EPSG","8801"]],PARAMETER["Longitude of natural origin",-100,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","2163"]]';
402 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 33001));
403 DROP SPATIAL REFERENCE SYSTEM 33001;
404
405 # EPSG 1028 Equidistant Cylindrical
406 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 4087));
407
408 # EPSG 1029 Equidistant Cylindrical (Spherical)
409 # create user defined srs based on 4088 but with a towgs84 clause
410 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["World Equidistant Cylindrical (Sphere)",GEOGCS["Unspecified datum based upon the GRS 1980 Authalic Sphere",DATUM["Not specified (based on GRS 1980 Authalic Sphere)",SPHEROID["GRS 1980 Authalic Sphere",6371007,0,AUTHORITY["EPSG","7048"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6047"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4047"]],PROJECTION["Equidistant Cylindrical (Spherical)",AUTHORITY["EPSG","1029"]],PARAMETER["Latitude of 1st standard parallel",0,AUTHORITY["EPSG","8823"]],PARAMETER["Longitude of natural origin",0,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","4088"]]';
411 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 33001));
412 DROP SPATIAL REFERENCE SYSTEM 33001;
413
414 # EPSG 1041 Krovak (North Orientated)
415 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50.20901 16.84977)', 4326), 5514));
416
417 # EPSG 1051 Lambert Conic Conformal (2SP Michigan)
418 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(43.750000014 -83.166666653)', 4326), 6201));
419
420 # EPSG 1052 Colombia Urban
421 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(4.7999999945 -74.250000023)', 4326), 6247));
422
423 # EPSG 9801 Lambert Conic Conformal (1SP)
424 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(17.932166647 -76.943683174)', 4326), 24200));
425
426 # EPSG 9802 Lambert Conic Conformal (2SP)
427 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(28.500000182 -95.99999989)', 4326), 32040));
428
429 # EPSG 9803 Lambert Conic Conformal (2SP Belgium)
430 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50.679572292 5.80737015)', 4326), 31300));
431
432 # EPSG 9804 Mercator (variant A)
433 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-3.0000001398 119.99999986)', 4326), 3002));
434
435 # EPSG 9805 Mercator (variant B)
436 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52.999999796 52.999999796)', 4326), 3388));
437
438 # EPSG 9806 Cassini-Soldner
439 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(10.000000275 -62.000000216)', 4326), 30200));
440
441 # EPSG 9807 Transverse Mercator
442 # BG and proj4 compute POINT(577393.3402239741 69673.56274845602)
443 # while IOGP note and proj6 compute POINT(577274.99 69740.50)
444 # proj4 computes POINT(577274.99 69740.50) if we avoid the +wgs84 string of source
445 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50.499999871 0.50000021429)', 4326), 27700));
446
447 # EPSG 9808 Transverse Mercator (South Orientated)
448 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(-25.732028354 28.282632944)', 4326), 2053));
449
450 # EPSG 9809 Oblique Stereographic
451 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(53.000000025 5.9999999931)', 4326), 28992));
452
453 # EPSG 9810 Polar Stereographic (variant A)
454 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(73.000000003 44.000000007)', 4326), 5041));
455 #TODO check SRS with lat_0=-90 e.g. epsg 5482
456
457 # EPSG 9811 New Zealand Map Grid
458 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(-36.848461 174.763336)', 4326), 27200));
459
460 # EPSG 9812 Hotine Oblique Mercator (variant A)
461 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(12 117)', 4326), 3079));
462
463 # EPSG 9813 Laborde Oblique Mercator
464 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(-16.189799986 44.45757)', 4326), 8441));
465
466 #TODO: Add a usert defined Laborde Oblique Mercator projection for 29701 (Paris)
467 #to test non-Greenwitch pms and non degree inputs (e.g. grad)
468
469 # EPSG 9815 Hotine Oblique Mercator (variant B)
470 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(5.3872536023 115.80550545)', 4326), 29873));
471
472 # EPSG 9817 Lambert Conic Near-Conformal
473 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(37.521562493 34.136469742)', 4326), 22700));
474
475 # data source GIGS-5107-04
476 # EPSG 9818 American Polyconic
477 DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(-6 -45)', 4674), 5880));
478
479 # EPSG 9819 Krovak
480 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50.20901 16.84977)', 4326), 5513));
481
482 # EPSG 9820 Lambert Azimuthal Equal Area
483 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50 5)', 4326), 3035));
484
485 # EPSG 9822 Albers Equal Area
486 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(42.749999987 -78.75)', 4326), 3174));
487
488 # EPSG 9824 Transverse Mercator Zoned Grid System
489 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(56 12)', 4326), 32600));
490 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-44 174)', 4326), 32700));
491
492 # EPSG 9824 9828 Bonne (South Orientated)
493 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(38.736946 -9.142685)', 4326), 5017));
494
495 # EPSG 9829 Polar Stereographic (variant B)
496 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-75 120)', 4326), 3032));
497
498 # EPSG 9830 Polar Stereographic (variant C)
499 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-66.605227791 140.07140001)', 4326), 2985));
500
501 # EPSG 9831 Guam Projection
502 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(13.33903845 144.63533131)', 4326), 3993));
503
504 # EPSG 9832 Modified Azimuthal Equidistant
505 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(9.5965258594 138.19303001)', 4326), 3295));
506 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'geocs3295' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'GEOGCS["Guam 1963",DATUM["Guam 1963",SPHEROID["Clarke 1866",6378206.4,294.9786982138982,AUTHORITY["EPSG","7008"]],TOWGS84[-100,-248,259,0,0,0,0],AUTHORITY["EPSG","6675"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4675"]]';
507 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(9.5965258594 138.19303)', 33001), 3295));
508
509 # EPSG 9833 Hyperbolic Cassini-Soldner
510 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-16.841456514 179.99433651)', 4326), 3139));
511
512 # EPSG 9834 Lambert Cylindrical Equal Area (Spherical)
513 # create user defined srs based on 3410 but with a towgs84 clause
514 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["NSIDC EASE-Grid Global",GEOGCS["Unspecified datum based upon the International 1924 Authalic Sphere",DATUM["Not specified (based on International 1924 Authalic Sphere)",SPHEROID["International 1924 Authalic Sphere",6371228,0,AUTHORITY["EPSG","7057"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6053"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4053"]],PROJECTION["Lambert Cylindrical Equal Area (Spherical)",AUTHORITY["EPSG","9834"]],PARAMETER["Latitude of 1st standard parallel",30,AUTHORITY["EPSG","8823"]],PARAMETER["Longitude of natural origin",0,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","3410"]]';
515 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 33001));
516
517 # EPSG 9835 Lambert Cylindrical Equal Area
518 # create user defined srs based on 6933 but with a towgs84 clause
519 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["WGS 84 / NSIDC EASE-Grid 2.0 Global",GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4326"]],PROJECTION["Lambert Cylindrical Equal Area",AUTHORITY["EPSG","9835"]],PARAMETER["Latitude of 1st standard parallel",30,AUTHORITY["EPSG","8823"]],PARAMETER["Longitude of natural origin",0,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","6933"]]';
520 DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 33001));
521 DROP SPATIAL REFERENCE SYSTEM 33001;
522
523 --echo # Verify that it isn't possible to transform to/from the four not implemented projections: 1042, 1043, 9816, 9826
524 --error ER_TRANSFORM_TARGET_SRS_NOT_SUPPORTED
525 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 5515);
526 --error ER_TRANSFORM_TARGET_SRS_NOT_SUPPORTED
527 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 5516);
528 --error ER_TRANSFORM_TARGET_SRS_MISSING_TOWGS84
529 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 22300);
530 CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["Carthage (Paris) / Tunisia Mining Grid",GEOGCS["Carthage (Paris)",DATUM["Carthage (Paris)",SPHEROID["Clarke 1880 (IGN)",6378249.2,293.4660212936269,AUTHORITY["EPSG","7011"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6816"]],PRIMEM["Paris",2.5969213,AUTHORITY["EPSG","8903"]],UNIT["grad",0.01570796326794895,AUTHORITY["EPSG","9105"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4816"]],PROJECTION["Tunisia Mining Grid",AUTHORITY["EPSG","9816"]],PARAMETER["Latitude of false origin",36.5964,AUTHORITY["EPSG","8821"]],PARAMETER["Longitude of false origin",7.83445,AUTHORITY["EPSG","8822"]],PARAMETER["Easting at false origin",270,AUTHORITY["EPSG","8826"]],PARAMETER["Northing at false origin",360,AUTHORITY["EPSG","8827"]],UNIT["kilometre",1000,AUTHORITY["EPSG","9036"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","22300"]]';
531 --error ER_TRANSFORM_TARGET_SRS_NOT_SUPPORTED
532 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 33001);
533 --error ER_TRANSFORM_TARGET_SRS_NOT_SUPPORTED
534 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 2218);
535 --error ER_TRANSFORM_SOURCE_SRS_NOT_SUPPORTED
536 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 5515), 4326);
537 --error ER_TRANSFORM_SOURCE_SRS_NOT_SUPPORTED
538 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 5516), 4326);
539 --error ER_TRANSFORM_SOURCE_SRS_MISSING_TOWGS84
540 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 22300), 4326);
541 --error ER_TRANSFORM_SOURCE_SRS_NOT_SUPPORTED
542 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 33001), 4326);
543 DROP SPATIAL REFERENCE SYSTEM 33001;
544 --error ER_TRANSFORM_SOURCE_SRS_NOT_SUPPORTED
545 DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 2218), 4326);