Debian Codegraph @

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

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