Debian Codegraph @

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

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