Debian Codegraph @

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

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