Debian Codegraph @

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

raw
1 # This test tests the ST_LATITUDE function.
2
3 --echo # NULL as one of the parameters must result in NULL return value.
4 SELECT ST_LATITUDE(NULL);
5 SELECT ST_LATITUDE(NULL, NULL);
6 SELECT ST_LATITUDE(NULL, 1);
7 SELECT ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), NULL);
8
9 --echo # Invalid data is not allowed.
10 --error ER_GIS_INVALID_DATA
11 DO ST_LATITUDE(x'000000000123456789abcdef');
12 --error ER_GIS_INVALID_DATA
13 DO ST_LATITUDE(x'000000000123456789abcdef', 1);
14
15 --echo # New value must be within the allowed range.
16 --error ER_LATITUDE_OUT_OF_RANGE
17 DO ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), -90.000000001);
18 --error ER_LATITUDE_OUT_OF_RANGE
19 DO ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 90.000000001);
20
21 --echo # First parameter must be a point.
22 --echo # Cartesian SRID 0
23 --error ER_UNEXPECTED_GEOMETRY_TYPE
24 DO ST_LATITUDE(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)', 0));
25 --error ER_UNEXPECTED_GEOMETRY_TYPE
26 DO ST_LATITUDE(ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 0 0))', 0));
27 --error ER_UNEXPECTED_GEOMETRY_TYPE
28 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 0));
29 --error ER_UNEXPECTED_GEOMETRY_TYPE
30 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOINT((0 0), (1 1))', 0));
31 --error ER_UNEXPECTED_GEOMETRY_TYPE
32 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1))', 0));
33 --error ER_UNEXPECTED_GEOMETRY_TYPE
34 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))', 0));
35 --error ER_UNEXPECTED_GEOMETRY_TYPE
36 DO ST_LATITUDE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))', 0));
37 --echo # Projected
38 --error ER_UNEXPECTED_GEOMETRY_TYPE
39 DO ST_LATITUDE(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)', 3857));
40 --error ER_UNEXPECTED_GEOMETRY_TYPE
41 DO ST_LATITUDE(ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 0 0))', 3857));
42 --error ER_UNEXPECTED_GEOMETRY_TYPE
43 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 3857));
44 --error ER_UNEXPECTED_GEOMETRY_TYPE
45 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOINT((0 0), (1 1))', 3857));
46 --error ER_UNEXPECTED_GEOMETRY_TYPE
47 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1))', 3857));
48 --error ER_UNEXPECTED_GEOMETRY_TYPE
49 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))', 3857));
50 --error ER_UNEXPECTED_GEOMETRY_TYPE
51 DO ST_LATITUDE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))', 3857));
52 --echo # Geographic
53 --error ER_UNEXPECTED_GEOMETRY_TYPE
54 DO ST_LATITUDE(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)', 4326));
55 --error ER_UNEXPECTED_GEOMETRY_TYPE
56 DO ST_LATITUDE(ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 0 0))', 4326));
57 --error ER_UNEXPECTED_GEOMETRY_TYPE
58 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326));
59 --error ER_UNEXPECTED_GEOMETRY_TYPE
60 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOINT((0 0), (1 1))', 4326));
61 --error ER_UNEXPECTED_GEOMETRY_TYPE
62 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1))', 4326));
63 --error ER_UNEXPECTED_GEOMETRY_TYPE
64 DO ST_LATITUDE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))', 4326));
65 --error ER_UNEXPECTED_GEOMETRY_TYPE
66 DO ST_LATITUDE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))', 4326));
67
68 --echo # Point must be geographic.
69 --error ER_SRS_NOT_GEOGRAPHIC
70 DO ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 0));
71 --error ER_SRS_NOT_GEOGRAPHIC
72 DO ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 3857));
73 DO ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
74 --error ER_SRS_NOT_GEOGRAPHIC
75 DO ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 0), 1);
76 --error ER_SRS_NOT_GEOGRAPHIC
77 DO ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 3857), 1);
78 DO ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1);
79
80 --echo # Get or set the latitude of a point in a lat-long SRS.
81 SELECT ST_LATITUDE(ST_GEOMFROMTEXT('POINT(1 0)', 4326));
82 SELECT HEX(ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1));
83
84 --echo # Get or set the latitude of a point in a long-lat SRS.
85 SELECT ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 1)', 7035));
86 SELECT HEX(ST_LATITUDE(ST_GEOMFROMTEXT('POINT(0 0)', 7035), 1));
87
88 --echo # Get or set the latitude of a point in a lat-long SRS with a meridian
89 --echo # that doesn't go through Greenwich.
90 SELECT ST_LATITUDE(ST_GEOMFROMTEXT('POINT(1 0)', 4801));
91 SELECT HEX(ST_LATITUDE(ST_GEOMFROMTEXT('POINT(1 0)', 4801), 1));