Debian Codegraph @

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

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