Debian Codegraph @

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

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