Debian Codegraph @

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

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