Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # CAST(... AS LINESTRING) allows casting geometries of type #
4 # LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING and GEOMETRYCOLLECTION #
5 # to type LINESTRING. #
6 # #
7 # Creation Date: 2020-08-02 #
8 # Author: Magnus Rushfeldt #
9 # #
10 ###############################################################################
11
12 --echo ############################################
13 --echo # Requirement F-8a: #
14 --echo # CAST(linestring AS LINESTRING) #
15 --echo ############################################
16 --echo #
17
18 --echo # Casting from LINESTRING to LINESTRING is always allowed.
19 --echo # Must return Linestring.
20 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS LINESTRING));
21 --echo # Must return 1.
22 SELECT ST_EQUALS(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'), CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS LINESTRING));
23 --echo #
24
25 --echo #
26 --echo ############################################
27 --echo # Requirement F-8b: #
28 --echo # CAST(polygon AS LINESTRING) #
29 --echo ############################################
30 --echo #
31
32 --echo # Casting from POLYGON with only exterior ring to LINESTRING is allowed.
33 --echo # Must return Linestring.
34 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 2 2, 3 3, 1 1))') AS LINESTRING));
35 --echo # Must return 1.
36 SELECT ST_EQUALS(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2, 3 3, 1 1)'), CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 2 2, 3 3, 1 1))') AS LINESTRING));
37 --echo #
38
39 --echo # Casting from POLYGON with multiple rings to LINESTRING is not allowed.
40 --echo # Must raise error.
41 --error ER_INVALID_CAST_TO_GEOMETRY
42 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POLYGON((1 1, 2 2, 3 3, 1 1), (4 4, 5 5, 6 6, 4 4))') AS LINESTRING));
43
44 --echo #
45 --echo ############################################
46 --echo # Requirement F-8c: #
47 --echo # CAST(multipoint AS LINESTRING) #
48 --echo ############################################
49 --echo #
50
51 --echo # Casting from MULTIPOINT with two or more points to LINESTRING is allowed.
52 --echo # Must return Linestring.
53 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS LINESTRING));
54 --echo # Must return 1.
55 SELECT ST_EQUALS(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'), CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1), (2 2))') AS LINESTRING));
56 --echo #
57
58 --echo # Casting from MULTIPOINT with only one point to LINESTRING is not allowed.
59 --echo # Must raise error.
60 --error ER_INVALID_CAST_TO_GEOMETRY
61 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((1 1))') AS LINESTRING));
62
63 --echo #
64 --echo ############################################
65 --echo # Requirement F-8d: #
66 --echo # CAST(multilinestring AS LINESTRING) #
67 --echo ############################################
68 --echo #
69
70 --echo # Casting from MULTILINESTRING with only one Linestring to LINESTRING is allowed.
71 --echo # Must return Linestring.
72 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2))') AS LINESTRING));
73 --echo # Must return 1.
74 SELECT ST_EQUALS(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'), CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2))') AS LINESTRING));
75 --echo #
76
77 --echo # Casting from MULTILINESTRING with multiple Linestrings to LINESTRING is not allowed.
78 --echo # Must raise error.
79 --error ER_INVALID_CAST_TO_GEOMETRY
80 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2), (3 3, 4 4))') AS LINESTRING));
81
82 --echo #
83 --echo ############################################
84 --echo # Requirement F-8e: #
85 --echo # CAST(geometrycollection AS LINESTRING) #
86 --echo ############################################
87 --echo #
88
89 --echo # Casting from GEOMETRYCOLLECTION with only one Linestring to LINESTRING is allowed.
90 --echo # Must return Linestring.
91 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))') AS LINESTRING));
92 --echo # Must return 1.
93 SELECT ST_EQUALS(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'), CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))') AS LINESTRING));
94 --echo #
95
96 --echo # Casting from empty GEOMETRYCOLLECTION to LINESTRING is not allowed.
97 --echo # Must raise error.
98 --error ER_INVALID_CAST_TO_GEOMETRY
99 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()') AS LINESTRING));
100 --echo #
101
102 --echo # Casting from GEOMETRYCOLLECTION with multiple Linestrings to LINESTRING is not allowed.
103 --echo # Must raise error.
104 --error ER_INVALID_CAST_TO_GEOMETRY
105 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2), LINESTRING(3 3, 4 4))') AS LINESTRING));
106 --echo #
107
108 --echo # Casting from GEOMETRYCOLLECTION with other geometries than Linestrings to LINESTRING is not allowed.
109 --echo # Must raise error.
110 --error ER_INVALID_CAST_TO_GEOMETRY
111 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2), GEOMETRYCOLLECTION())') AS LINESTRING));
112
113 --echo #
114 --echo ############################################
115 --echo # Requirement F-8d: #
116 --echo # Disallowed casts to LINESTRING #
117 --echo ############################################
118 --echo #
119
120 --echo # Casting from POINT to LINESTRING is not allowed.
121 --echo # Must raise error.
122 --error ER_INVALID_CAST_TO_GEOMETRY
123 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POINT(1 1)') AS LINESTRING));
124 --echo #
125
126 --echo # Casting from MULTIPOLYGON to LINESTRING is not allowed.
127 --echo # Must raise error.
128 --error ER_INVALID_CAST_TO_GEOMETRY
129 DO ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1, 2 2, 3 3, 1 1)))') AS LINESTRING));
130 --echo #
131
132 --echo #############################################
133 --echo # Testing result of WKT input #
134 --echo #############################################
135 --echo #
136
137 --echo # Casting from ST_GEOMFROMTEXT(<wkt>) to LINESTRING must return expected linestring.
138 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)') AS LINESTRING));
139 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('POLYGON((3 3, 4 3, 4 4, 3 4, 3 3))') AS LINESTRING));
140 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTIPOINT((5 5), (6 6))') AS LINESTRING));
141 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('MULTILINESTRING((7 7, 8 8))') AS LINESTRING));
142 SELECT ST_ASTEXT(CAST(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(9 9, 10 10))') AS LINESTRING));
143 --echo #
144
145 --echo #############################################
146 --echo # Testing result of user variable input #
147 --echo #############################################
148 --echo #
149
150 SET @linestring = ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)');
151 SET @polygon = ST_GEOMFROMTEXT('POLYGON((3 3, 4 3, 4 4, 3 4, 3 3))');
152 SET @multipoint = ST_GEOMFROMTEXT('MULTIPOINT((5 5), (6 6))');
153 SET @multilinestring = ST_GEOMFROMTEXT('MULTILINESTRING((7 7, 8 8))');
154 SET @geomcollection = ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(9 9, 10 10))');
155 --echo #
156
157 --echo # Casting from geometry in user variable to LINESTRING must return expected linestring.
158 SELECT ST_ASTEXT(CAST(@linestring AS LINESTRING));
159 SELECT ST_ASTEXT(CAST(@multipoint AS LINESTRING));
160 SELECT ST_ASTEXT(CAST(@multilinestring AS LINESTRING));
161 SELECT ST_ASTEXT(CAST(@geomcollection AS LINESTRING));
162 --echo #
163
164 --echo #############################################
165 --echo # Testing result of table column input #
166 --echo #############################################
167 --echo #
168
169 CREATE TABLE gis_linestring_castable (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
170 INSERT INTO gis_linestring_castable VALUES
171 (101, ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)')),
172 (102, ST_GEOMFROMTEXT('POLYGON((3 3, 4 3, 4 4, 3 4, 3 3))')),
173 (103, ST_GEOMFROMTEXT('MULTIPOINT((5 5), (6 6))')),
174 (104, ST_GEOMFROMTEXT('MULTILINESTRING((7 7, 8 8))')),
175 (105, ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(9 9, 10 10))'));
176 --echo #
177
178 --echo # Casting from geometry column to LINESTRING must return expected linestring.
179 SELECT ST_ASTEXT(CAST(g AS LINESTRING)) FROM gis_linestring_castable;
180 --echo #
181
182 --echo # Cleanup.
183 DROP TABLE gis_linestring_castable;