Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # This test is aimed to focus on Operators creating Geometry objects. #
4 # #
5 # These operators take 2 geometries as input parameters and return #
6 # a new geometry object. #
7 # #
8 # Creation Date: 2014-02-20 #
9 # Author : Horst Hunger #
10 # #
11 ###############################################################################
12
13
14 ############################################################################################
15 # Creating the spatial objects #
16 ############################################################################################
17
18 --echo #Creating the spatial Geometry object
19 USE test;
20
21 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
22
23 ############################################################################################
24 # Inserting the values specific to the spatial objects #
25 ############################################################################################
26
27 # Geometric elements constructing a star and some of its elememts as base
28 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
29 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
30 SET @star_center= 'POINT(15 10)';
31 SET @star_top= 'POINT(15 25)';
32 SET @star_bottom_left= 'POINT(5 0)';
33 SET @star_bottom_right= 'POINT(25 0)';
34 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
35 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
36 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
37 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
38 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
39 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
40 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
41 SET @star= 'POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))';
42 SET @star_elem_vertical_val= '((5 0,15 25,25 0,15 5,5 0))';
43 SET @star_elem_horizontal_val= '((25 0,0 15,30 15,22 10,25 0))';
44 SET @star_of_elems='MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))';
45 # star_collection_elems contains at least one invalid geometry.
46 SET @star_collection_elems='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
47 SET @star_collection_multilinestr='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),MULTILINESTRING((25 0,0 15,15 30,0 5)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
48
49 # Star identical to the base star
50 SET @star_elem_vertical_1= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
51 SET @star_elem_horizontal_1= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
52 SET @star_center_1= 'POINT(15 10)';
53 SET @star_top_1= 'POINT(15 25)';
54 SET @star_bottom_left_1= 'POINT(5 0)';
55 SET @star_bottom_right_1= 'POINT(25 0)';
56 SET @star_bottom_points_1= 'MULTIPOINT(5 0,25 0)';
57 SET @star_all_points_1= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
58 SET @star_line_horizontal_1= 'LINESTRING(10 15,20 15)';
59 SET @star_line_vertical_1= 'LINESTRING(15 5,15 25)';
60 SET @star_top_to_center_1= 'LINESTRING(15 25,15 10)';
61 SET @star_lines_near_horizontal_1= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
62 SET @star_lines_near_vertical_1= 'MULTILINESTRING((0 5,15 25,0 25))';
63 SET @star_1= 'POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))';
64 SET @star_elem_vertical_val_1= '((5 0,15 25,25 0,15 5,5 0))';
65 SET @star_elem_horizontal_val_1= '((25 0,0 15,30 15,22 10,25 0))';
66 SET @star_of_elems_1='MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))';
67 SET @star_collection_elems_1='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
68
69 # Star like the base star, but shifted to right by 10 on X to overlap base star
70 SET @star_elem_vertical_2= 'POLYGON((15 0,25 25,35 0,25 5,15 0))';
71 SET @star_elem_horizontal_2= 'POLYGON((35 0,10 15,40 15,32 10,35 0))';
72 SET @star_center_2= 'POINT(25 10)';
73 SET @star_top_2= 'POINT(25 25)';
74 SET @star_bottom_left_2= 'POINT(15 0)';
75 SET @star_bottom_right_2= 'POINT(35 0)';
76 SET @star_bottom_points_2= 'MULTIPOINT(15 0,35 0)';
77 SET @star_all_points_2= 'MULTIPOINT(15 0,35 0,35 10,25 25)';
78 SET @star_line_horizontal_2= 'LINESTRING(20 15,30 15)';
79 SET @star_line_vertical_2= 'LINESTRING(25 5,25 25)';
80 SET @star_top_to_center_2= 'LINESTRING(25 25,25 10)';
81 SET @star_lines_near_horizontal_2= 'MULTILINESTRING((35 0,10 15,25 30,10 5))';
82 SET @star_lines_near_vertical_2= 'MULTILINESTRING((10 5,25 25,10 25))';
83 SET @star_2= 'POLYGON((15 0,17 10,10 15,20 15,25 25,30 15,40 15,32 10,35 0,25 5,15 0))';
84 SET @star_elem_vertical_val_2= '((15 0,25 25,35 0,25 5,15 0))';
85 SET @star_elem_horizontal_val_2= '((35 0,10 15,40 15,32 10,35 0))';
86 SET @star_of_elems_2='MULTIPOLYGON(((15 0,25 25,35 0,25 5,15 0)),((35 0,10 15,40 15,32 10,35 0)))';
87 SET @star_collection_elems_2='GEOMETRYCOLLECTION(MULTIPOLYGON(((15 0,25 25,35 0,25 5,15 0)),((35 0,10 15,40 15,32 10,35 0))),POLYGON((15 0,17 10,10 15,20 15,25 25,30 15,40 15,32 10,35 0,25 5,15 0)),LINESTRING(25 25,25 10),MULTIPOINT(15 0,35 0),POINT(25 25))';
88
89 # Star like the base star, but shifted to right by 60 on X to be completly separate
90 SET @star_elem_vertical_3= 'POLYGON((65 0,75 25,85 0,75 5,65 0))';
91 SET @star_elem_horizontal_3= 'POLYGON((85 0,60 15,90 15,82 10,85 0))';
92 SET @star_center_3= 'POINT(75 10)';
93 SET @star_top_3= 'POINT(75 25)';
94 SET @star_bottom_left_3= 'POINT(65 0)';
95 SET @star_bottom_right_3= 'POINT(85 0)';
96 SET @star_bottom_points_3= 'MULTIPOINT(65 0,85 0)';
97 SET @star_all_points_3= 'MULTIPOINT(65 0,85 0,75 10,75 25)';
98 SET @star_line_horizontal_3= 'LINESTRING(70 15,80 15)';
99 SET @star_line_vertical_3= 'LINESTRING(75 5,75 25)';
100 SET @star_top_to_center_3= 'LINESTRING(75 25,75 10)';
101 SET @star_lines_near_horizontal_3= 'MULTILINESTRING((85 0,60 15,85 30,60 5))';
102 SET @star_lines_near_vertical_3= 'MULTILINESTRING((60 5,75 25,60 25))';
103 SET @star_3= 'POLYGON((65 0,67 10,60 15,70 15,75 25,80 15,90 15,82 10,85 0,75 5,65 0))';
104 SET @star_elem_vertical_val_3= '((65 0,75 25,85 0,75 5,65 0))';
105 SET @star_elem_horizontal_val_3= '((85 0,60 15,90 15,82 10,85 0))';
106 SET @star_of_elems_3='MULTIPOLYGON(((65 0,75 25,85 0,75 5,65 0)),((85 0,60 15,90 15,82 10,85 0)))';
107 SET @star_collection_elems_3='GEOMETRYCOLLECTION(MULTIPOLYGON(((65 0,75 25,85 0,75 5,65 0)),((85 0,60 15,90 15,82 10,85 0))),POLYGON((65 0,67 10,60 15,70 15,75 25,80 15,90 15,82 10,85 0,75 5,65 0)),LINESTRING(75 25,75 10),MULTIPOINT(65 0,85 0),POINT(75 25))';
108
109 SET @gc_result='GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),MULTILINESTRING((0 15,15 30,6 15),(4.2 12,0 5)))';
110 SET @gc_result2='GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),MULTILINESTRING((0 5,4.883720930232558 11.511627906976745),(7.5 15,15 25,0 25)))';
111 SET @gc_result3='GEOMETRYCOLLECTION(POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),POLYGON((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)))';
112 SET @poly_result='POLYGON((3 5,0 5,0 0,5 0,5 3,7 3,7 5,10 5,10 9,15 9,15 15,9 15,9 10,5 10,5 7,3 7,3 5))';
113
114 --echo #INSERT base star
115 --disable_warnings
116 INSERT INTO gis_geometrycollection VALUES
117 (100,ST_GEOMFROMTEXT(@star)),
118 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
119 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
120 (103,ST_GEOMFROMTEXT(@star_of_elems)),
121 (104,ST_GEOMFROMTEXT(@star_top)),
122 (105,ST_GEOMFROMTEXT(@star_center)),
123 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
124 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
125 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
126 (109,ST_GEOMFROMTEXT(@star_all_points)),
127 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
128 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
129 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
130 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
131 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
132 (115,ST_GEOMFROMTEXT(@star_collection_elems));
133 --enable_warnings
134
135 --echo #INSERT identical (to base) star
136 --disable_warnings
137 INSERT INTO gis_geometrycollection VALUES
138 (200,ST_GEOMFROMTEXT(@star_1)),
139 (201,ST_GEOMFROMTEXT(@star_elem_vertical_1)),
140 (202,ST_GEOMFROMTEXT(@star_elem_horizontal_1)),
141 (203,ST_GEOMFROMTEXT(@star_of_elems_1)),
142 (204,ST_GEOMFROMTEXT(@star_top_1)),
143 (205,ST_GEOMFROMTEXT(@star_center_1)),
144 (206,ST_GEOMFROMTEXT(@star_bottom_left_1)),
145 (207,ST_GEOMFROMTEXT(@star_bottom_right_1)),
146 (208,ST_GEOMFROMTEXT(@star_bottom_points_1)),
147 (209,ST_GEOMFROMTEXT(@star_all_points_1)),
148 (210,ST_GEOMFROMTEXT(@star_line_horizontal_1)),
149 (211,ST_GEOMFROMTEXT(@star_line_vertical_1)),
150 (212,ST_GEOMFROMTEXT(@star_top_to_center_1)),
151 (213,ST_GEOMFROMTEXT(@star_lines_near_horizontal_1)),
152 (214,ST_GEOMFROMTEXT(@star_lines_near_vertical_1)),
153 (215,ST_GEOMFROMTEXT(@star_collection_elems_1));
154 --enable_warnings
155
156 --echo #INSERT overlapping star
157 --disable_warnings
158 INSERT INTO gis_geometrycollection VALUES
159 (300,ST_GEOMFROMTEXT(@star_2)),
160 (301,ST_GEOMFROMTEXT(@star_elem_vertical_2)),
161 (302,ST_GEOMFROMTEXT(@star_elem_horizontal_2)),
162 (303,ST_GEOMFROMTEXT(@star_of_elems_2)),
163 (304,ST_GEOMFROMTEXT(@star_top_2)),
164 (305,ST_GEOMFROMTEXT(@star_center_2)),
165 (306,ST_GEOMFROMTEXT(@star_bottom_left_2)),
166 (307,ST_GEOMFROMTEXT(@star_bottom_right_2)),
167 (308,ST_GEOMFROMTEXT(@star_bottom_points_2)),
168 (309,ST_GEOMFROMTEXT(@star_all_points_2)),
169 (310,ST_GEOMFROMTEXT(@star_line_horizontal_2)),
170 (311,ST_GEOMFROMTEXT(@star_line_vertical_2)),
171 (312,ST_GEOMFROMTEXT(@star_top_to_center_2)),
172 (313,ST_GEOMFROMTEXT(@star_lines_near_horizontal_2)),
173 (314,ST_GEOMFROMTEXT(@star_lines_near_vertical_2)),
174 (315,ST_GEOMFROMTEXT(@star_collection_elems_2));
175 --enable_warnings
176
177 --echo #INSERT separate star
178 --disable_warnings
179 INSERT INTO gis_geometrycollection VALUES
180 (400,ST_GEOMFROMTEXT(@star_3)),
181 (401,ST_GEOMFROMTEXT(@star_elem_vertical_3)),
182 (402,ST_GEOMFROMTEXT(@star_elem_horizontal_3)),
183 (403,ST_GEOMFROMTEXT(@star_of_elems_3)),
184 (404,ST_GEOMFROMTEXT(@star_top_3)),
185 (405,ST_GEOMFROMTEXT(@star_center_3)),
186 (406,ST_GEOMFROMTEXT(@star_bottom_left_3)),
187 (407,ST_GEOMFROMTEXT(@star_bottom_right_3)),
188 (408,ST_GEOMFROMTEXT(@star_bottom_points_3)),
189 (409,ST_GEOMFROMTEXT(@star_all_points_3)),
190 (410,ST_GEOMFROMTEXT(@star_line_horizontal_3)),
191 (411,ST_GEOMFROMTEXT(@star_line_vertical_3)),
192 (412,ST_GEOMFROMTEXT(@star_top_to_center_3)),
193 (413,ST_GEOMFROMTEXT(@star_lines_near_horizontal_3)),
194 (414,ST_GEOMFROMTEXT(@star_lines_near_vertical_3)),
195 (415,ST_GEOMFROMTEXT(@star_collection_elems_3));
196 --enable_warnings
197
198 CREATE TABLE gis_geometrycollection_2 SELECT fid as fid2,g as g2 FROM gis_geometrycollection;
199
200 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
201 SELECT count(ST_ASTEXT(g2) != 'NULL') FROM gis_geometrycollection_2;
202
203 ############################################################################################
204 # Checking the spatial operator functions #
205 ############################################################################################
206
207 --echo #####################################################################################
208 --echo # ST_UNION(g1,g2)
209 --echo #####################################################################################
210
211 --echo #====================================================================================
212 --echo # point,point
213 --echo #====================================================================================
214 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('POINT(15 10)'));
215
216 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))'));
217
218 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('POINT(15 10)')) FROM gis_geometrycollection WHERE fid=105;
219
220 --echo #====================================================================================
221 --echo # point,multipoint
222 --echo #====================================================================================
223 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(25 0))'));
224
225 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(25 0))'));
226
227 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(25 0))')) FROM gis_geometrycollection WHERE fid=106;
228
229 --echo #====================================================================================
230 --echo # point,linestring
231 --echo #====================================================================================
232 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'));
233
234 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0))'));
235
236 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)')) FROM gis_geometrycollection WHERE fid=104;
237
238 --echo #====================================================================================
239 --echo # point,multilinestring
240 --echo #====================================================================================
241 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)'));
242
243 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(15 10))'));
244
245 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)')) FROM gis_geometrycollection WHERE fid=104;
246
247 --echo #====================================================================================
248 --echo # point,polygon
249 --echo #====================================================================================
250 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))'));
251
252 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top_3),ST_GEOMFROMTEXT(@star)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),POINT(75 25))'));
253
254 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection WHERE fid=104;
255
256 --echo #====================================================================================
257 --echo # point,multipolygon
258 --echo #====================================================================================
259
260 --echo #====================================================================================
261 --echo # point,geometrycollection
262 --echo #====================================================================================
263 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POINT(0 0)'));
264
265 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('POINT(0 0)'));
266
267 --echo #====================================================================================
268 --echo # multipoint,point
269 --echo #====================================================================================
270 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(15 25),(25 0))'));
271
272 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(25 0))'));
273
274 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_bottom_left)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(25 0))')) FROM gis_geometrycollection WHERE fid=108;
275
276 --echo #====================================================================================
277 --echo # multipoint,multipoint
278 --echo #====================================================================================
279 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(15 25),(25 0))'));
280
281 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(15 25),(25 0))'));
282
283 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_all_points_1)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(15 25),(25 0))'));
284
285 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(15 25),(25 0))')) FROM gis_geometrycollection WHERE fid=108;
286
287 --echo #====================================================================================
288 --echo # multipoint,linestring
289 --echo #====================================================================================
290 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0),POINT(25 0))'));
291
292 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0),POINT(25 0))'));
293
294 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0),POINT(25 0))')) FROM gis_geometrycollection WHERE fid=109;
295
296 --echo #====================================================================================
297 --echo # multipoint,multilinestring
298 --echo #====================================================================================
299 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(5 0),POINT(15 10),POINT(25 0))'));
300
301 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((25 0,0 15,15 30,0 5)),POINT(5 0),POINT(15 10),POINT(15 25))'));
302
303 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((25 0,0 15,15 30,0 5)),POINT(5 0),POINT(15 10),POINT(15 25))')) FROM gis_geometrycollection WHERE fid=109;
304
305 --echo #====================================================================================
306 --echo # multipoint,polygon
307 --echo #====================================================================================
308 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,15 25,5 0))'));
309
310 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((25 0,0 15,30 15,22 10,25 0)),POINT(5 0),POINT(15 25))'));
311
312 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((25 0,0 15,30 15,22 10,25 0)),POINT(5 0),POINT(15 25))')) FROM gis_geometrycollection WHERE fid=109;
313
314 --echo #====================================================================================
315 --echo # multipoint,multipolygon
316 --echo #====================================================================================
317
318 --echo #====================================================================================
319 --echo # multipoint,geometrycollection
320 --echo #====================================================================================
321 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POINT(0 0)'));
322
323 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('MULTIPOINT((0 0),(10 10))'));
324
325 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('MULTIPOINT((0 0),(10 10))'));
326
327 --echo #====================================================================================
328 --echo # linestring,point
329 --echo #====================================================================================
330 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'));
331
332 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'),ST_GEOMFROMTEXT('POINT(15 10)')),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'));
333
334 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0))'));
335
336 SELECT ST_EQUALS(ST_UNION(g,g2),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(10 15,20 15),POINT(15 10))')) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
337
338 --echo #====================================================================================
339 --echo # linestring,multipoint
340 --echo #====================================================================================
341 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')),ST_GEOMFROMTEXT('LINESTRING(15 5,15 25)'));
342
343 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 5,15 25),POINT(5 0),POINT(25 0))'));
344
345 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')),ST_GEOMFROMTEXT('LINESTRING(15 5,15 25)')) FROM gis_geometrycollection WHERE fid=111;
346
347 --echo #====================================================================================
348 --echo # linestring,linestring
349 --echo #====================================================================================
350 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 5,15 25)'));
351
352 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((15 25,15 10),(15 5,15 10))'));
353
354 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_top_to_center_1)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'));
355
356 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 5,15 25)')) FROM gis_geometrycollection WHERE fid=111;
357
358 --echo #====================================================================================
359 --echo # linestring,multilinestring
360 --echo #====================================================================================
361 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(25 0,0 15,15 30,0 5))'));
362
363 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(0 5,15 25,0 25))'));
364
365 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(25 0,0 15,15 30,0 5))')) FROM gis_geometrycollection WHERE fid=110;
366
367 --echo #====================================================================================
368 --echo # linestring,polygon
369 --echo #====================================================================================
370 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((11 15,19 10,19 15,11 15)),MULTILINESTRING((10 15,11 15),(19 15,20 15)))'));
371
372 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('POLYGON((25 0,22 10,30 15,0 15,25 0))'));
373
374 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,11 25,11 15))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((11 15,19 15,11 25,11 15)),MULTILINESTRING((10 15,11 15),(19 15,20 15)))')) FROM gis_geometrycollection WHERE fid=110;
375
376 --echo #====================================================================================
377 --echo # linestring,multipolygon
378 --echo #====================================================================================
379 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 25,11 15)))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((11 15,19 15,11 25,11 15)),MULTILINESTRING((10 15,11 15),(19 15,20 15)))'));
380
381 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 25,11 15)),((25 0,0 15,25 10,25 0)))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((11 15,19 15,11 25,11 15)),((25 0,25 10,0 15,25 0))),MULTILINESTRING((10 15,11 15),(19 15,20 15)))')) FROM gis_geometrycollection WHERE fid=110;
382
383 --echo #====================================================================================
384 --echo # linestring,geometrycollection
385 --echo #====================================================================================
386 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(10 15,20 15),POLYGON((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)))'));
387
388 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(10 15,20 15),POLYGON((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)))')) FROM gis_geometrycollection WHERE fid=110;
389
390 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
391
392 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
393
394 --echo #====================================================================================
395 --echo # multilinestring,point
396 --echo #====================================================================================
397 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)'));
398
399 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(15 10))'));
400
401 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)')) FROM gis_geometrycollection WHERE fid=114;
402
403 --echo #====================================================================================
404 --echo # multilinestring,multipoint
405 --echo #====================================================================================
406 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(5 0),POINT(25 0))'));
407
408 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(5 0),POINT(15 10),POINT(25 0))'));
409
410 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(5 0),POINT(25 0))')) FROM gis_geometrycollection WHERE fid=114;
411
412 SELECT ST_EQUALS(ST_UNION(g,g2),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(5 0),POINT(25 0))')) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
413
414 --echo #====================================================================================
415 --echo # multilinestring,linestring
416 --echo #====================================================================================
417 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((15 5,15 25),(0 5,15 25,0 25))'));
418
419 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(0 5,15 25,0 25))'));
420
421 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((15 5,15 25),(0 5,15 25,0 25))')) FROM gis_geometrycollection WHERE fid=114;
422
423 --echo #====================================================================================
424 --echo # multilinestring,multilinestring
425 --echo #====================================================================================
426 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 25),(15 25,0 15))'));
427
428 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal)),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 25),(25 0,0 15,15 30,0 5))'));
429
430 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 25),(15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
431
432 --echo #====================================================================================
433 --echo # multilinestring,multilinestring
434 --echo #====================================================================================
435 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((15 5,15 25),(0 5,15 25,0 25))')) FROM gis_geometrycollection WHERE fid=114;
436
437 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,15 25,5 0)),LINESTRING(0 5,15 25,0 25))'));
438
439 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((25 0,22 10,30 15,0 15,25 0)),MULTILINESTRING((0 5,5.172413793103448 11.89655172413793),(7.5 15,15 25,0 25)))'));
440
441 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,15 25,5 0)),LINESTRING(0 5,15 25,0 25))')) FROM gis_geometrycollection WHERE fid=114;
442
443 --echo #====================================================================================
444 --echo # multilinestring,multipolygon
445 --echo #====================================================================================
446 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,15 25,5 0)),MULTILINESTRING((0 25,10.714285714285715 14.285714285714286),(25 0,25 30)))'));
447
448 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTILINESTRING((100 100, 200 200))'),
449 ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 10 0, 10 10, 0 10, 0 0)))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0)),LINESTRING(100 100,200 200))'));
450
451 --echo #====================================================================================
452 --echo # multilinestring,geometrycollection
453 --echo #====================================================================================
454 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
455
456 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10),(5 5,15 15))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
457 'GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10),(5 5,15 15))'));
458
459 --echo #====================================================================================
460 --echo # polygon,point
461 --echo #====================================================================================
462 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))'));
463
464 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,15 25,5 0)),POINT(0 0))'));
465
466 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection WHERE fid=100;
467
468 --echo #====================================================================================
469 --echo # polygon,multipoint
470 --echo #====================================================================================
471 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))'));
472
473 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((5 0,15 25,25 0,15 5,5 0)),POINT(0 0),POINT(30 25))'));
474
475 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection WHERE fid=100;
476
477 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))'));
478
479 --echo #====================================================================================
480 --echo # polygon,linestring
481 --echo #====================================================================================
482 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))'));
483
484 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,15 25,5 0)),MULTILINESTRING((10 15,11 15),(19 15,20 15)))'));
485
486 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection WHERE fid=100;
487
488 SELECT ST_EQUALS(ST_UNION(g,g2),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
489
490 --echo #====================================================================================
491 --echo # polygon,multilinestring
492 --echo #====================================================================================
493 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT(@gc_result2));
494
495 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((5 0,15 5,25 0,15 25,5 0)),LINESTRING(8.870967741935484 9.67741935483871,0 15,15 30,0 5))'));
496
497 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT(@gc_result2)) FROM gis_geometrycollection WHERE fid=100;
498
499 --echo #====================================================================================
500 --echo # polygon,polygon
501 --echo #====================================================================================
502 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('POLYGON((15 25,10 15,0 15,7 10,5 0,15 5,25 0,22 10,30 15,20 15,15 25))'));
503
504 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star)),ST_GEOMFROMTEXT('POLYGON((15 25,10 15,0 15,7 10,5 0,15 5,25 0,22 10,30 15,20 15,15 25))'));
505
506 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('POLYGON((15 25,10 15,0 15,7 10,5 0,15 5,25 0,22 10,30 15,20 15,15 25))')) FROM gis_geometrycollection WHERE fid=100;
507
508 --echo #====================================================================================
509 --echo # polygon,multipolygon
510 --echo #====================================================================================
511
512 --echo #====================================================================================
513 --echo # polygon,geometrycollection
514 --echo #====================================================================================
515 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT(@gc_result3));
516
517 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 0))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 0))'));
518
519 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10, 0 0),(4 4,4 6,6 6,4 4))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 0),(4 4,4 6,6 6,4 4))'));
520
521 --echo #====================================================================================
522 --echo # multipolygon,point
523 --echo #====================================================================================
524
525 --echo #====================================================================================
526 --echo # multipolygon,multipoint
527 --echo #====================================================================================
528
529 --echo #====================================================================================
530 --echo # multipolygon,linestring
531 --echo #====================================================================================
532
533 --echo #====================================================================================
534 --echo # multipolygon,multilinestring
535 --echo #====================================================================================
536
537 --echo #====================================================================================
538 --echo # multipolygon,polygon
539 --echo #====================================================================================
540
541 --echo #====================================================================================
542 --echo # multipolygon,multipolygon
543 --echo #====================================================================================
544
545 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))'),
546 ST_GEOMFROMTEXT('MULTIPOLYGON(((3 3,3 7,7 7,7 3,3 3)),((9 9,9 15,15 15,15 9,9 9)))')),ST_GEOMFROMTEXT(@poly_result));
547
548 --echo #====================================================================================
549 --echo # multipolygon,geometrycollectionn
550 --echo #====================================================================================
551
552 SELECT ST_EQUALS(ST_UNION(g,g2),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=115;
553
554 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10, 0 0)))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 0))'));
555
556 --echo #====================================================================================
557 --echo # geometrycollection,point
558 --echo #====================================================================================
559 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection WHERE fid=115;
560
561 --echo #====================================================================================
562 --echo # geometrycollection,multipoint
563 --echo #====================================================================================
564 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection WHERE fid=115;
565
566 --echo #====================================================================================
567 --echo # geometrycollection,linestring
568 --echo #====================================================================================
569 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection WHERE fid=115;
570
571 --echo #====================================================================================
572 --echo # geometrycollection,multilinestring
573 --echo #====================================================================================
574
575 --echo #====================================================================================
576 --echo # geometrycollection,polygon
577 --echo #====================================================================================
578 SELECT ST_EQUALS(ST_UNION(g,ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection WHERE fid=115;
579
580 --echo #====================================================================================
581 --echo # geometrycollection,multipolygon
582 --echo #====================================================================================
583
584 SELECT ST_EQUALS(ST_UNION(g,g2),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=215;
585
586 --echo #====================================================================================
587 --echo # geometrycollection,geometrycollectionn
588 --echo #====================================================================================
589 SELECT ST_EQUALS(ST_UNION(g,g2),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0))')) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=215;
590
591 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'),
592 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')));
593
594 SELECT ST_EQUALS(ST_UNION(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'),
595 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1), GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('POINT(1 1)'));
596
597 --echo #####################################################################################
598 --echo # Testing ST_UNION() with 2 geometries of same SRID
599 --echo #####################################################################################
600 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0)));
601
602 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326)));
603
604 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145)));
605
606 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135)));
607
608 --error ER_DATA_OUT_OF_RANGE
609 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1)));
610
611 --error ER_DATA_OUT_OF_RANGE
612 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024)));
613
614 --error ER_DATA_OUT_OF_RANGE
615 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000)));
616
617 --echo #####################################################################################
618 --echo # Invalid function calls
619 --echo #####################################################################################
620 --error ER_GIS_DIFFERENT_SRIDS
621 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326)));
622
623 --error ER_GIS_DIFFERENT_SRIDS
624 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326)));
625
626 --error ER_DATA_OUT_OF_RANGE
627 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1)));
628
629 SELECT ST_ASTEXT(ST_UNION(NULL,ST_GEOMFROMTEXT(@star_top)));
630
631 --echo # Invalid geometry in input
632 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_of_elems),NULL));
633
634 --echo # Invalid geometry in input
635 SELECT ST_ASTEXT(ST_UNION(g,NULL)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
636
637 SELECT ST_ASTEXT(ST_UNION(NULL,NULL));
638
639 --echo # Invalid geometry in input
640 SELECT ST_ASTEXT(ST_UNION(fid,NULL)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
641
642 --echo # Invalid geometry in input
643 --error ER_GIS_INVALID_DATA
644 SELECT ST_ASTEXT(ST_UNION(fid,ST_GEOMFROMTEXT(@star_top))) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
645
646 --echo # Invalid geometry in input
647 --error ER_GIS_INVALID_DATA
648 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_of_elems),fid)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
649
650 --error ER_GIS_INVALID_DATA
651 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
652
653 --error ER_GIS_INVALID_DATA
654 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
655
656 --error ER_PARSE_ERROR
657 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
658
659 --error ER_GIS_INVALID_DATA
660 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
661
662 --error ER_GIS_INVALID_DATA
663 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
664
665 --error ER_GIS_INVALID_DATA
666 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
667
668 --error ER_PARSE_ERROR
669 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
670
671 --error ER_GIS_INVALID_DATA
672 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
673
674 --error ER_GIS_INVALID_DATA
675 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
676
677 --error ER_GIS_INVALID_DATA
678 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
679
680 --error ER_PARSE_ERROR
681 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
682
683 --error ER_GIS_INVALID_DATA
684 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
685
686 --error ER_GIS_INVALID_DATA
687 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
688
689 --error ER_GIS_INVALID_DATA
690 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON((0 0,10 10,0 0))'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10))')));
691
692 --error ER_GIS_INVALID_DATA
693 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10,0 0))'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 10,0 0)))')));
694
695 --error ER_GIS_INVALID_DATA
696 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON((0 0,10 10,0 0))'),ST_GEOMFROMTEXT('POLYGON((0 0,10 10,0 0))')));
697
698 --error ER_PARSE_ERROR
699 SELECT ST_ASTEXT(ST_UNION(,));
700
701 --echo # Invalid geometry in input
702 --error ER_PARSE_ERROR
703 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_of_elems),));
704
705 --error ER_PARSE_ERROR
706 SELECT ST_ASTEXT(ST_UNION(,ST_GEOMFROMTEXT(@star_top)));
707
708 --echo # Invalid geometry in input
709 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems)));
710
711 --echo # Invalid geometry in input
712 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0)),((5 0,15 25,25 0,15 5,5 0)))')));
713
714 --echo # Invalid geometry in input
715 SELECT ST_ASTEXT(ST_UNION(g,ST_GEOMFROMTEXT(@star_of_elems))) FROM gis_geometrycollection WHERE fid=103;
716
717 --echo # Invalid geometry in input
718 SELECT ST_ASTEXT(ST_UNION(g,g2)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
719
720
721 --echo #clean up
722 DROP TABLE gis_geometrycollection;
723 DROP TABLE gis_geometrycollection_2;
724
725 --echo #
726 --echo # Bug#21927733 ST_UNION() PRODUCES AN INVALID POLYGON GEOMETRY
727 --echo #
728 SELECT ST_ASTEXT(ST_UNION(ST_GEOMFROMTEXT('POLYGON((4 5,12 11,-12
729 -3,4 5))'), ST_GEOMFROMTEXT('MULTIPOLYGON(((5 4,-14 0,1 0,5 4)),((1 6,13 0,10
730 12,1 6)))')));
731
732 --echo #
733 --echo # WL#8579 Spatial Reference Systems
734 --echo #
735
736 --echo # SRID 0 (should pass)
737 SELECT ST_ASTEXT(ST_UNION(
738 ST_GEOMFROMTEXT('POINT(0 0)', 0),
739 ST_GEOMFROMTEXT('POINT(0 0)', 0)
740 ));
741
742 --echo # Projected SRS (should pass)
743 SELECT ST_ASTEXT(ST_UNION(
744 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
745 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
746 ));
747
748 --echo # Geographic SRS (should pass)
749 SELECT ST_ASTEXT(ST_UNION(
750 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
751 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
752 ));
753
754 --echo #
755 --echo # Bug #25510403 SRID OF RESULT OF SET OPERATION IS DIFFERENT FROM INPUT
756 --echo # GEOMETRIES
757 --echo #
758
759 SELECT ST_SRID(ST_Union(
760 ST_GeomFromText("MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))", 2000),
761 ST_GeomFromText("MULTILINESTRING((1 1, 2 2))", 2000)
762 )) AS result;
763
764 SELECT ST_SRID(ST_Union(
765 ST_GeomFromText("LINESTRING(1 1, 2 2)", 2000),
766 ST_GeomFromText("MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))", 2000)
767 )) AS result;
768
769 SELECT ST_SRID(ST_Union(
770 ST_GeomFromText("MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))", 2000),
771 ST_GeomFromText("LINESTRING(1 1, 2 2)", 2000)
772 )) AS result;
773
774 SELECT ST_SRID(ST_Union(
775 ST_GeomFromText("MULTILINESTRING((1 1, 2 2))", 2000),
776 ST_GeomFromText("MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))", 2000)
777 )) AS result;
778
779 --echo #
780 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
781 --echo #
782
783 --echo # Assume SRID 10 is not defined.
784 --error ER_SRS_NOT_FOUND
785 DO ST_UNION(
786 x'0A000000010100000000000000000000000000000000000000',
787 x'0A000000010100000000000000000000000000000000000000'
788 );