Debian Codegraph @

mysql-test/suite/gis/r/cast_as_multilinestring.result

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