Debian Codegraph @

mysql-test/suite/gis/r/spatial_operators_symdifference.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 #INSERT base star
78 INSERT INTO gis_geometrycollection VALUES
79 (100,ST_GEOMFROMTEXT(@star)),
80 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
81 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
82 (103,ST_GEOMFROMTEXT(@star_of_elems)),
83 (104,ST_GEOMFROMTEXT(@star_top)),
84 (105,ST_GEOMFROMTEXT(@star_center)),
85 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
86 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
87 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
88 (109,ST_GEOMFROMTEXT(@star_all_points)),
89 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
90 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
91 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
92 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
93 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
94 (115,ST_GEOMFROMTEXT(@star_collection_elems));
95 #INSERT identical (to base) star
96 INSERT INTO gis_geometrycollection VALUES
97 (200,ST_GEOMFROMTEXT(@star_1)),
98 (201,ST_GEOMFROMTEXT(@star_elem_vertical_1)),
99 (202,ST_GEOMFROMTEXT(@star_elem_horizontal_1)),
100 (203,ST_GEOMFROMTEXT(@star_of_elems_1)),
101 (204,ST_GEOMFROMTEXT(@star_top_1)),
102 (205,ST_GEOMFROMTEXT(@star_center_1)),
103 (206,ST_GEOMFROMTEXT(@star_bottom_left_1)),
104 (207,ST_GEOMFROMTEXT(@star_bottom_right_1)),
105 (208,ST_GEOMFROMTEXT(@star_bottom_points_1)),
106 (209,ST_GEOMFROMTEXT(@star_all_points_1)),
107 (210,ST_GEOMFROMTEXT(@star_line_horizontal_1)),
108 (211,ST_GEOMFROMTEXT(@star_line_vertical_1)),
109 (212,ST_GEOMFROMTEXT(@star_top_to_center_1)),
110 (213,ST_GEOMFROMTEXT(@star_lines_near_horizontal_1)),
111 (214,ST_GEOMFROMTEXT(@star_lines_near_vertical_1)),
112 (215,ST_GEOMFROMTEXT(@star_collection_elems_1));
113 #INSERT overlapping star
114 INSERT INTO gis_geometrycollection VALUES
115 (300,ST_GEOMFROMTEXT(@star_2)),
116 (301,ST_GEOMFROMTEXT(@star_elem_vertical_2)),
117 (302,ST_GEOMFROMTEXT(@star_elem_horizontal_2)),
118 (303,ST_GEOMFROMTEXT(@star_of_elems_2)),
119 (304,ST_GEOMFROMTEXT(@star_top_2)),
120 (305,ST_GEOMFROMTEXT(@star_center_2)),
121 (306,ST_GEOMFROMTEXT(@star_bottom_left_2)),
122 (307,ST_GEOMFROMTEXT(@star_bottom_right_2)),
123 (308,ST_GEOMFROMTEXT(@star_bottom_points_2)),
124 (309,ST_GEOMFROMTEXT(@star_all_points_2)),
125 (310,ST_GEOMFROMTEXT(@star_line_horizontal_2)),
126 (311,ST_GEOMFROMTEXT(@star_line_vertical_2)),
127 (312,ST_GEOMFROMTEXT(@star_top_to_center_2)),
128 (313,ST_GEOMFROMTEXT(@star_lines_near_horizontal_2)),
129 (314,ST_GEOMFROMTEXT(@star_lines_near_vertical_2)),
130 (315,ST_GEOMFROMTEXT(@star_collection_elems_2));
131 #INSERT separate star
132 INSERT INTO gis_geometrycollection VALUES
133 (400,ST_GEOMFROMTEXT(@star_3)),
134 (401,ST_GEOMFROMTEXT(@star_elem_vertical_3)),
135 (402,ST_GEOMFROMTEXT(@star_elem_horizontal_3)),
136 (403,ST_GEOMFROMTEXT(@star_of_elems_3)),
137 (404,ST_GEOMFROMTEXT(@star_top_3)),
138 (405,ST_GEOMFROMTEXT(@star_center_3)),
139 (406,ST_GEOMFROMTEXT(@star_bottom_left_3)),
140 (407,ST_GEOMFROMTEXT(@star_bottom_right_3)),
141 (408,ST_GEOMFROMTEXT(@star_bottom_points_3)),
142 (409,ST_GEOMFROMTEXT(@star_all_points_3)),
143 (410,ST_GEOMFROMTEXT(@star_line_horizontal_3)),
144 (411,ST_GEOMFROMTEXT(@star_line_vertical_3)),
145 (412,ST_GEOMFROMTEXT(@star_top_to_center_3)),
146 (413,ST_GEOMFROMTEXT(@star_lines_near_horizontal_3)),
147 (414,ST_GEOMFROMTEXT(@star_lines_near_vertical_3)),
148 (415,ST_GEOMFROMTEXT(@star_collection_elems_3));
149 CREATE TABLE gis_geometrycollection_2 SELECT fid as fid2,g as g2 FROM gis_geometrycollection;
150 #Checking the integrity of the above create/insert statements
151 #64 rows.
152 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
153 count(ST_ASTEXT(g) != 'NULL')
154 64
155 #64 rows.
156 SELECT count(ST_ASTEXT(g2) != 'NULL') FROM gis_geometrycollection_2;
157 count(ST_ASTEXT(g2) != 'NULL')
158 64
159 #####################################################################################
160 # ST_SYMDIFFERENCE(g1,g2)
161 #####################################################################################
162 #====================================================================================
163 # point,point
164 #====================================================================================
165 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
166 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
167 1
168 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))'));
169 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))'))
170 1
171 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')) FROM gis_geometrycollection WHERE fid=105;
172 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
173 1
174 #====================================================================================
175 # point,multipoint
176 #====================================================================================
177 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('POINT(25 0)'));
178 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('POINT(25 0)'))
179 1
180 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(25 0))'));
181 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(25 0))'))
182 1
183 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('POINT(25 0)')) FROM gis_geometrycollection WHERE fid=106;
184 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('POINT(25 0)'))
185 1
186 #====================================================================================
187 # point,linestring
188 #====================================================================================
189 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'));
190 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'))
191 1
192 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0))'));
193 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0))'))
194 1
195 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)')) FROM gis_geometrycollection WHERE fid=104;
196 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'))
197 1
198 #====================================================================================
199 # point,multilinestring
200 #====================================================================================
201 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)'));
202 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)'))
203 1
204 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(15 10))'));
205 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(15 10))'))
206 1
207 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)')) FROM gis_geometrycollection WHERE fid=104;
208 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)'))
209 1
210 #====================================================================================
211 # point,polygon
212 #====================================================================================
213 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
214 ST_EQUALS(ST_SYMDIFFERENCE(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 1
216 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
217 ST_EQUALS(ST_SYMDIFFERENCE(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 1
219 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
220 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
221 1
222 #====================================================================================
223 # point,multipolygon
224 #====================================================================================
225 #====================================================================================
226 # point,geometrycollection
227 #====================================================================================
228 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems)),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))'));
229 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems)),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))'))
230 1
231 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_3),ST_GEOMFROMTEXT(@star_collection_elems)),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))'));
232 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_3),ST_GEOMFROMTEXT(@star_collection_elems)),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))'))
233 1
234 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)),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;
235 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)),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))'))
236 1
237 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr)),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)),MULTILINESTRING((0 15,15 30,6 15),(4.2 12,0 5)))'));
238 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr)),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)),MULTILINESTRING((0 15,15 30,6 15),(4.2 12,0 5)))
239 1
240 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POINT(0 0)'));
241 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POINT(0 0)'))
242 1
243 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('POINT(0 0)'));
244 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('POINT(0 0)'))
245 1
246 #====================================================================================
247 # multipoint,point
248 #====================================================================================
249 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(25 0))'));
250 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(25 0))'))
251 1
252 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(25 0))'));
253 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('MULTIPOINT((5 0),(15 10),(25 0))'))
254 1
255 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_bottom_left)),ST_GEOMFROMTEXT('POINT(25 0)')) FROM gis_geometrycollection WHERE fid=108;
256 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_bottom_left)),ST_GEOMFROMTEXT('POINT(25 0)'))
257 1
258 #====================================================================================
259 # multipoint,multipoint
260 #====================================================================================
261 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))'));
262 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))'))
263 1
264 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))'));
265 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))'))
266 1
267 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_all_points_1)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
268 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_all_points_1)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
269 1
270 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))')) FROM gis_geometrycollection WHERE fid=108;
271 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('MULTIPOINT((15 10),(15 25))'))
272 1
273 #====================================================================================
274 # multipoint,linestring
275 #====================================================================================
276 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
277 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
278 1
279 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
280 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
281 1
282 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
283 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0),POINT(25 0))'))
284 1
285 #====================================================================================
286 # multipoint,multilinestring
287 #====================================================================================
288 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
289 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
290 1
291 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
292 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
293 1
294 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
295 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
296 1
297 #====================================================================================
298 # multipoint,polygon
299 #====================================================================================
300 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,15 25,5 0))'));
301 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('POLYGON((5 0,15 5,25 0,15 25,5 0))'))
302 1
303 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((25 0,22 10,30 15,0 15,25 0)),POINT(5 0),POINT(15 25))'));
304 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((25 0,22 10,30 15,0 15,25 0)),POINT(5 0),POINT(15 25))'))
305 1
306 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((25 0,22 10,30 15,0 15,25 0)),POINT(5 0),POINT(15 25))')) FROM gis_geometrycollection WHERE fid=109;
307 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((25 0,22 10,30 15,0 15,25 0)),POINT(5 0),POINT(15 25))'))
308 1
309 #====================================================================================
310 # multipoint,multipolygon
311 #====================================================================================
312 #====================================================================================
313 # multipoint,geometrycollection
314 #====================================================================================
315 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems)),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(0 0),POINT(0 30),POINT(30 25))'));
316 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems)),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(0 0),POINT(0 30),POINT(30 25))
317 1
318 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems)),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))'));
319 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems)),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))'))
320 1
321 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)),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=109;
322 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)),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))'))
323 1
324 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr)),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)),MULTILINESTRING((0 15,15 30,6 15),(4.2 12,0 5)))'));
325 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr)),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)),MULTILINESTRING((0 15,15 30,6 15),(4.2 12
326 1
327 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POINT(0 0)'));
328 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POINT(0 0)'))
329 1
330 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,1 1)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('MULTIPOINT((0 0),(1 1))'));
331 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,1 1)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('MULTIPOINT((0 0),(1 1))'))
332 1
333 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,1 1)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('MULTIPOINT((0 0),(1 1))'));
334 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,1 1)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('MULTIPOINT((0 0),(1 1))'))
335 1
336 #====================================================================================
337 # linestring,point
338 #====================================================================================
339 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'));
340 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'))
341 1
342 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'),ST_GEOMFROMTEXT('POINT(15 10)')),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'));
343 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'),ST_GEOMFROMTEXT('POINT(15 10)')),ST_GEOMFROMTEXT('LINESTRING(15 25,15 10)'))
344 1
345 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0))'));
346 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 25,15 10),POINT(5 0))'))
347 1
348 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
349 ST_EQUALS(ST_SYMDIFFERENCE(g,g2),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(10 15,20 15),POINT(15 10))'))
350 1
351 #====================================================================================
352 # linestring,multipoint
353 #====================================================================================
354 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')),ST_GEOMFROMTEXT('LINESTRING(15 5,15 25)'));
355 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')),ST_GEOMFROMTEXT('LINESTRING(15 5,15 25)'))
356 1
357 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 5,15 25),POINT(5 0),POINT(25 0))'));
358 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(15 5,15 25),POINT(5 0),POINT(25 0))'))
359 1
360 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')),ST_GEOMFROMTEXT('LINESTRING(15 5,15 25)')) FROM gis_geometrycollection WHERE fid=111;
361 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')),ST_GEOMFROMTEXT('LINESTRING(15 5,15 25)'))
362 1
363 #====================================================================================
364 # linestring,linestring
365 #====================================================================================
366 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 5,15 10)'));
367 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 5,15 10)'))
368 1
369 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('LINESTRING(15 5,15 10)'));
370 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('LINESTRING(15 5,15 10)'))
371 1
372 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_top_to_center_1)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
373 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_top_to_center_1)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
374 1
375 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 5,15 10)')) FROM gis_geometrycollection WHERE fid=111;
376 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_top_to_center)),ST_GEOMFROMTEXT('LINESTRING(15 5,15 10)'))
377 1
378 #====================================================================================
379 # linestring,multilinestring
380 #====================================================================================
381 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
382 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
383 1
384 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(0 5,15 25,0 25))'));
385 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(0 5,15 25,0 25))'))
386 1
387 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
388 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(25 0,0 15,15 30,0 5))'))
389 1
390 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
391 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
392 1
393 #====================================================================================
394 # linestring,polygon
395 #====================================================================================
396 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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)))'));
397 ST_EQUALS(ST_SYMDIFFERENCE(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)))'))
398 1
399 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('POLYGON((25 0,22 10,30 15,0 15,25 0))'));
400 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal)),ST_GEOMFROMTEXT('POLYGON((25 0,22 10,30 15,0 15,25 0))'))
401 1
402 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 25,11 15))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((11 15,19 15,19 25,11 15)),MULTILINESTRING((10 15,11 15),(19 15,20 15)))')) FROM gis_geometrycollection WHERE fid=110;
403 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 25,11 15))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((11 15,19 15,19 25,11 15)),MULTILINESTRING((10 15,11 15),(19 15,20 15)))'))
404 1
405 #====================================================================================
406 # linestring,multipolygon
407 #====================================================================================
408 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,19 25,11 15)))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((11 15,19 15,19 25,11 15)),MULTILINESTRING((10 15,11 15),(19 15,20 15)))'));
409 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,19 25,11 15)))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((11 15,19 15,19 25,11 15)),MULTILINESTRING((10 15,11 15),(19 15,20 15)))'))
410 1
411 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,19 25,11 15)),((25 0,0 15,25 10,25 0)))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((11 15,19 15,19 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;
412 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,19 25,11 15)),((25 0,0 15,25 10,25 0)))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((11 15,19 15,19 25,11 15)),((25 0,25 10,0 15,25 0))),MULTILINESTRING((10 15,11 15),(19 15
413 1
414 #====================================================================================
415 # linestring,geometrycollection
416 #====================================================================================
417 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems)),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))'));
418 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems)),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))'))
419 1
420 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)),LINESTRING(10 15,20 15))'));
421 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)),LINESTRING(10 15,20 15))'))
422 1
423 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)),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=110;
424 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)),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))'))
425 1
426 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr)),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)),MULTILINESTRING((0 15,15 30,6 15),(4.2 12,0 5)))'));
427 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr)),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)),MULTILINESTRING((0 15,15 30,6 15),(4
428 1
429 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'));
430 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'))
431 1
432 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'));
433 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('LINESTRING(0 0,1 1)'))
434 1
435 #====================================================================================
436 # multilinestring,point
437 #====================================================================================
438 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)'));
439 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)'))
440 1
441 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(15 10))'));
442 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(15 10))'))
443 1
444 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)')) FROM gis_geometrycollection WHERE fid=114;
445 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_top)),ST_GEOMFROMTEXT('LINESTRING(0 5,15 25,0 25)'))
446 1
447 #====================================================================================
448 # multilinestring,multipoint
449 #====================================================================================
450 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
451 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
452 1
453 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
454 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
455 1
456 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
457 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_bottom_points)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(5 0),POINT(25 0))'))
458 1
459 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
460 ST_EQUALS(ST_SYMDIFFERENCE(g,g2),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 5,15 25,0 25)),POINT(5 0),POINT(25 0))'))
461 1
462 #====================================================================================
463 # multilinestring,linestring
464 #====================================================================================
465 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((15 5,15 25),(0 5,15 25,0 25))'));
466 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((15 5,15 25),(0 5,15 25,0 25))'))
467 1
468 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(0 5,15 25,0 25))'));
469 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal)),ST_GEOMFROMTEXT('MULTILINESTRING((10 15,20 15),(0 5,15 25,0 25))'))
470 1
471 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
472 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((15 5,15 25),(0 5,15 25,0 25))'))
473 1
474 #====================================================================================
475 # multilinestring,multilinestring
476 #====================================================================================
477 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')),ST_GEOMFROMTEXT('MULTILINESTRING((15 25,0 25),(15 25,0 15))'));
478 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')),ST_GEOMFROMTEXT('MULTILINESTRING((15 25,0 25),(15 25,0 15))'))
479 1
480 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
481 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
482 1
483 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')),ST_GEOMFROMTEXT('MULTILINESTRING((15 25,0 25),(15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
484 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')),ST_GEOMFROMTEXT('MULTILINESTRING((15 25,0 25),(15 25,0 15))'))
485 1
486 #====================================================================================
487 # multilinestring,multilinestring
488 #====================================================================================
489 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
490 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_line_vertical)),ST_GEOMFROMTEXT('MULTILINESTRING((15 5,15 25),(0 5,15 25,0 25))'))
491 1
492 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
493 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
494 1
495 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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)))'));
496 ST_EQUALS(ST_SYMDIFFERENCE(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
497 1
498 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
499 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
500 1
501 #====================================================================================
502 # multilinestring,multipolygon
503 #====================================================================================
504 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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)))'));
505 ST_EQUALS(ST_SYMDIFFERENCE(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
506 1
507 #====================================================================================
508 # multilinestring,geometrycollection
509 #====================================================================================
510 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr)),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))'));
511 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_lines_near_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr)),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))'))
512 1
513 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1),(2 2,3 3))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1),(2 2,3 3))'));
514 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1),(2 2,3 3))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1),(2 2,3 3))'))
515 1
516 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,2 2))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
517 'GEOMETRYCOLLECTION(),GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('LINESTRING(0 0,1 1,2 2)'));
518 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1,2 2))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
519 'GEOMETRYCOLLECTION(),GEOMETRYCOLLEC
520 1
521 #====================================================================================
522 # polygon,point
523 #====================================================================================
524 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'));
525 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'))
526 1
527 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
528 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
529 1
530 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))')) FROM gis_geometrycollection WHERE fid=100;
531 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_center)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'))
532 1
533 #====================================================================================
534 # polygon,multipoint
535 #====================================================================================
536 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'));
537 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'))
538 1
539 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
540 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
541 1
542 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))')) FROM gis_geometrycollection WHERE fid=100;
543 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'))
544 1
545 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'));
546 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points)),ST_GEOMFROMTEXT('POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))'))
547 1
548 #====================================================================================
549 # polygon,linestring
550 #====================================================================================
551 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
552 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
553 1
554 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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)))'));
555 ST_EQUALS(ST_SYMDIFFERENCE(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)))'))
556 1
557 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
558 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
559 1
560 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
561 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
562 1
563 #====================================================================================
564 # polygon,multilinestring
565 #====================================================================================
566 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical)),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)),MULTILINESTRING((0 5,4.883720930232558 11.511627906976745),(7.5 15,15 25,0 25)))'));
567 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical)),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)),MULTILINESTRING((0 5,4.883720930232558 11.51162790697674
568 1
569 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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))'));
570 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
571 1
572 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)),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)),MULTILINESTRING((0 5,4.883720930232558 11.511627906976745),(7.5 15,15 25,0 25)))')) FROM gis_geometrycollection WHERE fid=100;
573 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)),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)),MULTILINESTRING((0 5,4.883720930232558 11.511627906976745),(7.5 15,15 25,0 25
574 1
575 #====================================================================================
576 # polygon,polygon
577 #====================================================================================
578 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))'));
579 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))'))
580 1
581 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_3),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)),((5 0,15 5,25 0,15 25,5 0)))'));
582 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_3),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)),((5 0,15 5,25 0,15 25,5 0)))'))
583 1
584 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))'));
585 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))'))
586 1
587 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))')) FROM gis_geometrycollection WHERE fid=100;
588 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))'))
589 1
590 #====================================================================================
591 # polygon,multipolygon
592 #====================================================================================
593 #====================================================================================
594 # polygon,geometrycollection
595 #====================================================================================
596 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)))'));
597 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)))'))
598 1
599 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((0 0,2 2,3 0,0 0))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POLYGON((0 0,2 2,3 0,0 0))'));
600 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((0 0,2 2,3 0,0 0))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POLYGON((0 0,2 2,3 0,0 0))'))
601 1
602 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0),(2 2,2 3,3 3,3 2,2 2))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
603 'GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0),(2 2,2 3,3 3,3 2,2 2))'));
604 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0),(2 2,2 3,3 3,3 2,2 2))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION('
605
606 1
607 #====================================================================================
608 # multipolygon,point
609 #====================================================================================
610 #====================================================================================
611 # multipolygon,multipoint
612 #====================================================================================
613 #====================================================================================
614 # multipolygon,linestring
615 #====================================================================================
616 #====================================================================================
617 # multipolygon,multilinestring
618 #====================================================================================
619 #====================================================================================
620 # multipolygon,polygon
621 #====================================================================================
622 #====================================================================================
623 # multipolygon,multipolygon
624 #====================================================================================
625 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 0,5 5)))'),
626 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('MULTIPOLYGON(((5 3,3 3,3 5,0 5,0 0,5 0,5 3)),((5 3,7 3,5 5,5 3)),((3 5,5 5,5 7,3 7,3 5)),((9 10,5 10,5 7,7 7,7 3,10 0,10 9,9 9,9 10)),((9 10,10 10,10 9,15 9,15 15,9 15,9 10)))
627 '));
628 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 0,5 5)))'),
629 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('MULTIPOLYGON(((5 3,3 3,3 5,0 5,0 0,5 0,
630 1
631 #====================================================================================
632 # multipolygon,geometrycollectionn
633 #====================================================================================
634 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,2 2,3 0,0 0)))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POLYGON((0 0,2 2,3 0,0 0))'));
635 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,2 2,3 0,0 0)))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')),ST_GEOMFROMTEXT('POLYGON((0 0,2 2,3 0,0 0))'))
636 1
637 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0),(2 2,2 3,3 3,3 2,2 2)),((5 5,5 7,7 7,7 5,5 5)))'),
638 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0),(2 2,2 3,3 3,3 2,2 2)),((5 5,5 7,7 7,7 5,5 5)))'));
639 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0),(2 2,2 3,3 3,3 2,2 2)),((5 5,5 7,7 7,7 5,5 5)))'),
640 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())')),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0),(2 2,2 3,3
641 1
642 #====================================================================================
643 # geometrycollection,point
644 #====================================================================================
645 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),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))'));
646 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),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))'))
647 1
648 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)')),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(30 30))'));
649 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)')),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(30 30))'))
650 1
651 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
652 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
653 1
654 #====================================================================================
655 # geometrycollection,multipoint
656 #====================================================================================
657 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),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))'));
658 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),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))'))
659 1
660 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)')),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(0 35),POINT(30 30))'));
661 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)')),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(0 35),POINT(30 30))'))
662 1
663 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
664 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
665 1
666 #====================================================================================
667 # geometrycollection,linestring
668 #====================================================================================
669 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),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))'));
670 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),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))'))
671 1
672 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)')),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)),LINESTRING(30 30,0 35))'));
673 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)')),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)),LINESTRING(30 30,0 35))'))
674 1
675 SELECT ST_EQUALS(ST_SYMDIFFERENCE(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;
676 ST_EQUALS(ST_SYMDIFFERENCE(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))'))
677 1
678 #====================================================================================
679 # geometrycollection,multilinestring
680 #====================================================================================
681 #====================================================================================
682 # geometrycollection,polygon
683 #====================================================================================
684 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),((5 0,5 5,0 5,0 0,5 0)))'));
685 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5,5 0,0 0))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),((5 0,5 5,0 5,0 0,5 0)))'))
686 1
687 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))'));
688 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))'))
689 1
690 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
691 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
692 1
693 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((9 15,0 15,6.3 10.5,9 15)),((9 15,10 15,15 25,9 15)),((6.299999999999999 10.5,0 0,5 0,7 10,6.299999999999999 10.5)),((25.333333333333332 12.083333333333334,30 15,23 15,25.333333333333332 12.083333333333334)),((25.333333333333332 12.083333333333334,22 10,25 0,35 0,25.333333333333332 12.083333333333334)),((23 15,15 25,20 15,23 15)),((5 0,25 0,15 5,5 0)))'));
694 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((9 15,0 15,6.3 10.5,9 15)),((9 15,10 15,15 25,9 15)),((6.299999999999999 10.5,0 0,5 0,7 10,6.29999999999999
695 1
696 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))')) FROM gis_geometrycollection WHERE fid=115;
697 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_elem_vertical)),ST_GEOMFROMTEXT('MULTIPOLYGON(((15 25,25 0,22 10,30 15,20 15,15 25)),((15 25,10 15,0 15,7 10,5 0,15 25)))'))
698 1
699 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(2 2,5 5))'),
700 ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),LINESTRING(4 4,5 5))'));
701 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(2 2,5 5))'),
702 ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6
703 1
704 #====================================================================================
705 # geometrycollection,multipolygon
706 #====================================================================================
707 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),((5 0,5 5,0 5,0 0,5 0)))'));
708 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),((5 0,5 5,0 5,0 0,5 0)))'))
709 1
710 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(2 2,4 4))'),
711 ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((5 5,10 5,10 10,5 10,5 5)))'));
712 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(2 2,4 4))'),
713 ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((5 5,10 5,10 10,
714 1
715 #====================================================================================
716 # geometrycollection,geometrycollectionn
717 #====================================================================================
718 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,67 10,65 0)))'));
719 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3)),ST_GEOMFROMTEXT('MULTIPOLYGON(((5 0,15 5,25 0,22 10,30 15,20 15,15 25,10 15,0 15,7 10,5 0)),((65 0,75 5,85 0,82 10,90 15,80 15,75 25,70 15,60 15,
720 1
721 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
722 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
723 1
724 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')) FROM gis_geometrycollection WHERE fid=115;
725 ST_EQUALS(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
726 1
727 SELECT ST_EQUALS(ST_SYMDIFFERENCE(g,g2),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=215;
728 ST_EQUALS(ST_SYMDIFFERENCE(g,g2),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
729 1
730 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT(@star_collection_elems)),ST_GEOMFROMTEXT('MULTILINESTRING((0 15,15 30,6 15),(4.2 12,0 5))'));
731 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_collection_multilinestr),ST_GEOMFROMTEXT(@star_collection_elems)),ST_GEOMFROMTEXT('MULTILINESTRING((0 15,15 30,6 15),(4.2 12,0 5))'))
732 1
733 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,2 2),POINT(4 4),POINT(6 6))'),
734 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(4 4),POINT(6 6))')),ST_GEOMFROMTEXT('LINESTRING(0 0,2 2)'));
735 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,2 2),POINT(4 4),POINT(6 6))'),
736 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(4 4),POINT(6 6))')),ST_GEOMFROMTEXT('LINESTRING(0 0,2 2)'))
737 1
738 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,2 2),POINT(4 4),POINT(6 6))'),
739 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(4 4),POINT(6 6))')),ST_GEOMFROMTEXT('MULTIPOINT((0 0),(2 2))'));
740 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,2 2),POINT(4 4),POINT(6 6))'),
741 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(4 4),POINT(6 6))')),ST_GEOMFROMTEXT('MULTIPOINT((0 0),(2 2))'))
742 1
743 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,1 1),(2 2,3 3)),POINT(4 4),POINT(6 6))'),
744 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(4 4),POINT(6 6))')),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1),(2 2,3 3))'));
745 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTILINESTRING((0 0,1 1),(2 2,3 3)),POINT(4 4),POINT(6 6))'),
746 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(4 4),POINT(6 6))')),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,1 1),(2 2,3 3))'))
747 1
748 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((6 6,6 10,10 10,10 6,6 6))),'
749 'POINT(14 14),POINT(16 16))'),
750 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(14 14),POINT(16 16))')),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((6 6,6 10,10 10,10 6,6 6)))'));
751 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((6 6,6 10,10 10,10 6,6 6))),'
752 'POINT(14 14),POINT(16 16))'),
753 ST_GEOMFROMTEXT('GEOMETR
754 1
755 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'),
756 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
757 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'),
758 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
759 1
760 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'),
761 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1), GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('POINT(1 1)'));
762 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'),
763 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1), GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('POINT(1 1)'))
764 1
765 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1)))'),
766 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('POINT(1 1)'));
767 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1)))'),
768 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('POINT(1 1)'))
769 1
770 SELECT ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1)))'),
771 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1), GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
772 ST_EQUALS(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1)))'),
773 ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1 1), GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())))')),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'))
774 1
775 #####################################################################################
776 # Testing ST_SYMDIFFERENCE() with 2 geometries of same SRID
777 #####################################################################################
778 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0)));
779 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0)))
780 MULTIPOINT((15 25),(15 10))
781 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145)));
782 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145)))
783 MULTIPOINT((15 25),(15 10))
784 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000)));
785 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000)))
786 MULTIPOINT((15 25),(15 10))
787 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326)));
788 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326)))
789 MULTIPOINT((15 25),(15 10))
790 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135)));
791 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135)))
792 MULTIPOINT((15 25),(15 10))
793 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1)));
794 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
795 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024)));
796 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
797 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000)));
798 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
799 #####################################################################################
800 # Invalid function calls
801 #####################################################################################
802 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326)));
803 ERROR HY000: Binary geometry function st_symdifference given two geometries of different srids: 0 and 4326, which should have been identical.
804 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326)));
805 ERROR HY000: Binary geometry function st_symdifference given two geometries of different srids: 4145 and 4326, which should have been identical.
806 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0)));
807 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0)))
808 MULTIPOINT((15 25),(15 10))
809 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1)));
810 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
811 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(NULL,ST_GEOMFROMTEXT(@star_top)));
812 ST_ASTEXT(ST_SYMDIFFERENCE(NULL,ST_GEOMFROMTEXT(@star_top)))
813 NULL
814 # Invalid geometry in input
815 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_of_elems),NULL));
816 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_of_elems),NULL))
817 NULL
818 # Invalid geometry in input
819 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(g,NULL)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
820 ST_ASTEXT(ST_SYMDIFFERENCE(g,NULL))
821 NULL
822 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(NULL,NULL));
823 ST_ASTEXT(ST_SYMDIFFERENCE(NULL,NULL))
824 NULL
825 # Invalid geometry in input
826 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(fid,NULL)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
827 ST_ASTEXT(ST_SYMDIFFERENCE(fid,NULL))
828 NULL
829 # Invalid geometry in input
830 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(fid,ST_GEOMFROMTEXT(@star_top))) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
831 ERROR 22023: Invalid GIS data provided to function st_symdifference.
832 # Invalid geometry in input
833 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_of_elems),fid)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
834 ERROR 22023: Invalid GIS data provided to function st_symdifference.
835 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
836 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
837 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
838 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
839 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
840 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
841 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
842 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
843 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
844 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
845 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
846 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
847 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
848 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
849 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
850 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
851 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
852 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
853 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
854 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
855 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
856 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
857 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
858 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
859 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)')));
860 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
861 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(,));
862 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
863 # Invalid geometry in input
864 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_of_elems),));
865 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
866 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(,ST_GEOMFROMTEXT(@star_top)));
867 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
868 # Invalid geometry in input
869 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems)));
870 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems)))
871 GEOMETRYCOLLECTION EMPTY
872 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems)));
873 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems)))
874 MULTIPOLYGON(((25 0,22 10,30 15,20 15,15 25,25 0)),((15 25,10 15,0 15,7 10,5 0,15 25)))
875 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems))) FROM gis_geometrycollection WHERE fid=100;
876 ST_ASTEXT(ST_SYMDIFFERENCE(g,ST_GEOMFROMTEXT(@star_collection_elems)))
877 GEOMETRYCOLLECTION EMPTY
878 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr)));
879 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr)))
880 MULTILINESTRING((0 15,15 30,6 15),(4.2 12,0 5))
881 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems)));
882 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems)))
883 GEOMETRYCOLLECTION EMPTY
884 CREATE TABLE t1 (pk INT PRIMARY KEY, g GEOMETRY NOT NULL);
885 INSERT INTO t1 VALUES (1, ST_GEOMFROMTEXT('POINT(1 1)'));
886 INSERT INTO t1 VALUES (2, ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'));
887 INSERT INTO t1 VALUES (3, ST_GEOMFROMTEXT(
888 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
889 INSERT INTO t1 VALUES (4, ST_GEOMFROMTEXT(
890 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 4 6, 6 6, 6 4, 4 4))'));
891 INSERT INTO t1 VALUES (5, ST_GEOMFROMTEXT('MULTIPOINT(1 1, 2 2)'));
892 INSERT INTO t1 VALUES (6, ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2),'
893 '(3 3, 4 4))'));
894 INSERT INTO t1 VALUES (7, ST_GEOMFROMTEXT(
895 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)),((5 5, 10 5, 10 10, 5 10, 5 5)))'));
896 INSERT INTO t1 VALUES (8, ST_GEOMFROMTEXT(
897 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
898 '(6 6, 6 7, 7 7, 7 6, 6 6)))'));
899 INSERT INTO t1 VALUES (9, ST_GEOMFROMTEXT(
900 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((1 1, 10 1, 10 10, 1 10, 1 1), '
901 '(4 4, 4 6, 6 6, 6 4, 4 4)))'));
902 INSERT INTO t1 VALUES (10, ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'));
903 INSERT INTO t1 VALUES (11, ST_GEOMFROMTEXT(
904 'GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'));
905 INSERT INTO t1 VALUES (12, ST_GEOMFROMTEXT(
906 'GEOMETRYCOLLECTION(POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)))'));
907 INSERT INTO t1 VALUES (13, ST_GEOMFROMTEXT(
908 'GEOMETRYCOLLECTION(POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), '
909 '(4 4, 4 6, 6 6, 6 4, 4 4)))'));
910 INSERT INTO t1 VALUES (14, ST_GEOMFROMTEXT(
911 'GEOMETRYCOLLECTION(MULTIPOINT(1 1, 2 2))'));
912 INSERT INTO t1 VALUES (15, ST_GEOMFROMTEXT(
913 'GEOMETRYCOLLECTION(MULTILINESTRING((1 1, 2 2), (3 3, 4 4)))'));
914 INSERT INTO t1 VALUES (16, ST_GEOMFROMTEXT(
915 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
916 '((5 5, 10 5, 10 10, 5 10, 5 5))))'));
917 INSERT INTO t1 VALUES (17, ST_GEOMFROMTEXT(
918 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
919 '((5 5, 10 5, 10 10, 5 10, 5 5), (6 6, 6 7, 7 7, 7 6, 6 6))))'));
920 INSERT INTO t1 VALUES (18, ST_GEOMFROMTEXT(
921 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
922 '((1 1, 10 1, 10 10, 1 10, 1 1), (4 4, 4 6, 6 6, 6 4, 4 4))))'));
923 INSERT INTO t1 VALUES (19, ST_GEOMFROMTEXT(
924 'GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(1 1, 2 2),'
925 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)),'
926 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 4 6, 6 6, 6 4, 4 4)),'
927 'MULTIPOINT(1 1, 2 2),MULTILINESTRING((1 1, 2 2), (3 3, 4 4)),'
928 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))),'
929 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
930 '(6 6, 7 6, 7 7, 6 7, 6 6))))'));
931 INSERT INTO t1 VALUES(20,
932 GEOMETRYCOLLECTION(POINT(1,1),LINESTRING(POINT(1,1),POINT(2,2)),
933 POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0))),
934 POLYGON(LINESTRING(POINT(0,0),POINT(10,0),POINT(10,10),POINT(0,10),
935 POINT(0,0)),LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),POINT(4,6),
936 POINT(4,4))),MULTIPOINT(POINT(1,1),POINT(2,2)),
937 MULTILINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),LINESTRING(POINT(3,3),
938 POINT(4,4))),MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
939 POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
940 POINT(10,10),POINT(5,10),POINT(5,5)))),
941 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),
942 POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),POINT(10,10),
943 POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(6,7),POINT(7,7),
944 POINT(7,6),POINT(6,6)))),GEOMETRYCOLLECTION(POINT(1,1)),
945 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
946 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
947 POINT(0,1),POINT(0,0)))),GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),
948 POINT(10,0),POINT(10,10),POINT(0,10),POINT(0,0)),LINESTRING(POINT(4,4),
949 POINT(4,6),POINT(6,6),POINT(6,6),POINT(4,4)))),
950 GEOMETRYCOLLECTION(MULTIPOINT(POINT(1,1),POINT(2,2))),
951 GEOMETRYCOLLECTION(MULTILINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),
952 LINESTRING(POINT(3,3),POINT(4,4)))),
953 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
954 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
955 POINT(10,10),POINT(5,10),POINT(5,5))))),
956 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
957 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
958 POINT(10,10),POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(6,7),
959 POINT(7,7),POINT(7,6),POINT(6,6)))))));
960 INSERT INTO t1 VALUES (21,
961 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1,1)),
962 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
963 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(1,1), POINT(10,1), POINT(10,10),
964 POINT(1,10), POINT(1,1)), LINESTRING(POINT(4,4),POINT(4,6),POINT(6,6),
965 POINT(6,4),POINT(4,4))))));
966 CREATE TABLE symdifference_results (pk INT PRIMARY KEY AUTO_INCREMENT, g GEOMETRY NOT NULL);
967 INSERT INTO symdifference_results(g)
968 VALUES
969 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
970 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
971 (ST_GEOMFROMTEXT('POLYGON((0 0,1 0,1 1,0 1,0 0))')),
972 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
973 (ST_GEOMFROMTEXT('POINT(2 2)')),
974 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
975 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5)))')),
976 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6)))')),
977 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
978 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
979 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
980 (ST_GEOMFROMTEXT('POLYGON((0 0,1 0,1 1,0 1,0 0))')),
981 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
982 (ST_GEOMFROMTEXT('POINT(2 2)')),
983 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
984 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5)))')),
985 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6)))')),
986 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
987 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
988 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
989 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
990 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
991 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
992 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),LINESTRING(1 1,2 2))')),
993 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
994 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
995 (ST_GEOMFROMTEXT('LINESTRING(3 3,4 4)')),
996 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),LINESTRING(1 1,2 2))')),
997 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),LINESTRING(1 1,2 2))')),
998 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
999 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1000 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1001 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),LINESTRING(1 1,2 2))')),
1002 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1003 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1004 (ST_GEOMFROMTEXT('LINESTRING(3 3,4 4)')),
1005 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),LINESTRING(1 1,2 2))')),
1006 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),LINESTRING(1 1,2 2))')),
1007 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1008 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1009 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1010 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1011 (ST_GEOMFROMTEXT('POLYGON((0 0,1 0,1 1,0 1,0 0))')),
1012 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),LINESTRING(1 1,2 2))')),
1013 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1014 (ST_GEOMFROMTEXT('POLYGON((0 1,1 1,1 0,10 0,10 10,0 10,0 1),(4 4,4 6,6 6,6 4,4 4))')),
1015 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),POINT(2 2))')),
1016 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1017 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5))')),
1018 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))')),
1019 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1020 (ST_GEOMFROMTEXT('POLYGON((0 0,1 0,1 1,0 1,0 0))')),
1021 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),LINESTRING(1 1,2 2))')),
1022 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1023 (ST_GEOMFROMTEXT('POLYGON((0 1,1 1,1 0,10 0,10 10,0 10,0 1),(4 4,4 6,6 6,6 4,4 4))')),
1024 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),POINT(2 2))')),
1025 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1026 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5))')),
1027 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))')),
1028 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1029 (ST_GEOMFROMTEXT('POLYGON((1 0,10 0,10 5,10 10,0 10,0 1,1 1,1 0),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1030 (ST_GEOMFROMTEXT('POLYGON((1 0,10 0,10 5,10 10,0 10,0 1,1 1,1 0),(5 5,4 4,4 6,5 6,5 5))')),
1031 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1,0 1,0 0,1 0,1 1)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1032 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1033 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1034 (ST_GEOMFROMTEXT('POLYGON((0 1,1 1,1 0,10 0,10 10,0 10,0 1),(4 4,4 6,6 6,6 4,4 4))')),
1035 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1036 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1037 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1038 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)))')),
1039 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1040 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 1,1 1,1 10,0 10,0 1)),((10 1,1 1,1 0,10 0,10 1)))')),
1041 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1042 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1043 (ST_GEOMFROMTEXT('POLYGON((0 1,1 1,1 0,10 0,10 10,0 10,0 1),(4 4,4 6,6 6,6 4,4 4))')),
1044 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1045 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1046 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1047 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)))')),
1048 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1049 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 1,1 1,1 10,0 10,0 1)),((10 1,1 1,1 0,10 0,10 1)))')),
1050 (ST_GEOMFROMTEXT('POLYGON((5 6,5 5,6 5,6 6,5 6))')),
1051 (ST_GEOMFROMTEXT('POLYGON((5 6,5 5,4 4,6 4,6 6,5 6))')),
1052 (ST_GEOMFROMTEXT('POLYGON((1 10,0 10,0 0,10 0,10 1,1 1,1 10))')),
1053 (ST_GEOMFROMTEXT('POINT(2 2)')),
1054 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1055 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),POINT(2 2))')),
1056 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1057 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1058 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1059 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),POINT(2 2))')),
1060 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),POINT(2 2))')),
1061 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1062 (ST_GEOMFROMTEXT('POINT(2 2)')),
1063 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1064 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),POINT(2 2))')),
1065 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1066 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1067 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1068 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),POINT(2 2))')),
1069 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),POINT(2 2))')),
1070 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1071 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1072 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1073 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1074 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1075 (ST_GEOMFROMTEXT('LINESTRING(3 3,4 4)')),
1076 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1077 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1078 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1079 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1080 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1081 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1082 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1083 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1084 (ST_GEOMFROMTEXT('LINESTRING(3 3,4 4)')),
1085 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1086 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1087 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1088 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1089 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1090 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1091 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1092 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1093 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1094 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1095 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5)))')),
1096 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),LINESTRING(1 1,2 2))')),
1097 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5))')),
1098 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 5,6 6,5 6,5 5,6 5)),((6 5,6 4,4 4,4 6,5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5)))')),
1099 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),POINT(2 2))')),
1100 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1101 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1102 (ST_GEOMFROMTEXT('POLYGON((6 6,7 6,7 7,6 7,6 6))')),
1103 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 5,6 6,5 6,5 5,6 5)),((6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1,10 1,10 5,6 5)))')),
1104 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5)))')),
1105 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),LINESTRING(1 1,2 2))')),
1106 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5))')),
1107 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 5,6 6,5 6,5 5,6 5)),((6 5,6 4,4 4,4 6,5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5)))')),
1108 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),POINT(2 2))')),
1109 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1110 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1111 (ST_GEOMFROMTEXT('POLYGON((6 6,7 6,7 7,6 7,6 6))')),
1112 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 5,6 6,5 6,5 5,6 5)),((6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1,10 1,10 5,6 5)))')),
1113 (ST_GEOMFROMTEXT('POLYGON((5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6,5 10))')),
1114 (ST_GEOMFROMTEXT('POLYGON((5 10,0 10,0 1,1 1,1 0,10 0,10 5,5 5,4 4,4 6,5 6,5 10))')),
1115 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1,0 1,0 0,1 0,1 1)),((1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1)),((6 5,6 6,5 6,5 5,6 5)))')),
1116 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6)))')),
1117 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),LINESTRING(1 1,2 2))')),
1118 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))')),
1119 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)),((6 5,6 4,4 4,4 6,5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5)))')),
1120 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),POINT(2 2))')),
1121 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1122 (ST_GEOMFROMTEXT('POLYGON((6 6,7 6,7 7,6 7,6 6))')),
1123 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1124 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)),((6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1,10 1,10 5,6 5)))')),
1125 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6)))')),
1126 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),LINESTRING(1 1,2 2))')),
1127 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))')),
1128 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)),((6 5,6 4,4 4,4 6,5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5)))')),
1129 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),POINT(2 2))')),
1130 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1131 (ST_GEOMFROMTEXT('POLYGON((6 6,7 6,7 7,6 7,6 6))')),
1132 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1133 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)),((6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1,10 1,10 5,6 5)))')),
1134 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,7 6,7 7,6 7,6 6)),((5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6,5 10)))')),
1135 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,7 6,7 7,6 7,6 6)),((5 10,0 10,0 1,1 1,1 0,10 0,10 5,5 5,4 4,4 6,5 6,5 10)))')),
1136 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1,0 1,0 0,1 0,1 1)),((1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1)),((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1137 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1138 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1139 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1140 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 1,1 1,1 10,0 10,0 1)),((10 1,1 1,1 0,10 0,10 1)))')),
1141 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1142 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1143 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)))')),
1144 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1145 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1146 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1147 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1148 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1149 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 1,1 1,1 10,0 10,0 1)),((10 1,1 1,1 0,10 0,10 1)))')),
1150 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1151 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1152 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)))')),
1153 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1154 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1155 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 10,0 10,0 1,1 1,1 10)),((10 1,1 1,1 0,10 0,10 1)),((5 6,5 5,6 5,6 6,5 6)))')),
1156 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 10,0 10,0 1,1 1,1 10)),((10 1,1 1,1 0,10 0,10 1)),((5 6,5 5,4 4,6 4,6 6,5 6)))')),
1157 (ST_GEOMFROMTEXT('POLYGON((1 1,0 1,0 0,1 0,1 1))')),
1158 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1159 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1160 (ST_GEOMFROMTEXT('POLYGON((0 0,1 0,1 1,0 1,0 0))')),
1161 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1162 (ST_GEOMFROMTEXT('POINT(2 2)')),
1163 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1164 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5)))')),
1165 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6)))')),
1166 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1167 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1168 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1169 (ST_GEOMFROMTEXT('POLYGON((0 0,1 0,1 1,0 1,0 0))')),
1170 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1171 (ST_GEOMFROMTEXT('POINT(2 2)')),
1172 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1173 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5)))')),
1174 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6)))')),
1175 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1176 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1177 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1178 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1179 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1180 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1181 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),LINESTRING(1 1,2 2))')),
1182 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1183 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1184 (ST_GEOMFROMTEXT('LINESTRING(3 3,4 4)')),
1185 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),LINESTRING(1 1,2 2))')),
1186 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),LINESTRING(1 1,2 2))')),
1187 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1188 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1189 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1190 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),LINESTRING(1 1,2 2))')),
1191 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1192 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1193 (ST_GEOMFROMTEXT('LINESTRING(3 3,4 4)')),
1194 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),LINESTRING(1 1,2 2))')),
1195 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),LINESTRING(1 1,2 2))')),
1196 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1197 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1198 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1199 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1200 (ST_GEOMFROMTEXT('POLYGON((0 0,1 0,1 1,0 1,0 0))')),
1201 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),LINESTRING(1 1,2 2))')),
1202 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1203 (ST_GEOMFROMTEXT('POLYGON((0 1,1 1,1 0,10 0,10 10,0 10,0 1),(4 4,4 6,6 6,6 4,4 4))')),
1204 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),POINT(2 2))')),
1205 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1206 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5))')),
1207 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))')),
1208 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1209 (ST_GEOMFROMTEXT('POLYGON((0 0,1 0,1 1,0 1,0 0))')),
1210 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),LINESTRING(1 1,2 2))')),
1211 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1212 (ST_GEOMFROMTEXT('POLYGON((0 1,1 1,1 0,10 0,10 10,0 10,0 1),(4 4,4 6,6 6,6 4,4 4))')),
1213 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),POINT(2 2))')),
1214 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1215 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5))')),
1216 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))')),
1217 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1218 (ST_GEOMFROMTEXT('POLYGON((1 0,10 0,10 5,10 10,0 10,0 1,1 1,1 0),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1219 (ST_GEOMFROMTEXT('POLYGON((1 0,10 0,10 5,10 10,0 10,0 1,1 1,1 0),(5 5,4 4,4 6,5 6,5 5))')),
1220 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1,0 1,0 0,1 0,1 1)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1221 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1222 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1223 (ST_GEOMFROMTEXT('POLYGON((0 1,1 1,1 0,10 0,10 10,0 10,0 1),(4 4,4 6,6 6,6 4,4 4))')),
1224 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1225 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1226 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1227 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)))')),
1228 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1229 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 1,1 1,1 10,0 10,0 1)),((10 1,1 1,1 0,10 0,10 1)))')),
1230 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1231 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1232 (ST_GEOMFROMTEXT('POLYGON((0 1,1 1,1 0,10 0,10 10,0 10,0 1),(4 4,4 6,6 6,6 4,4 4))')),
1233 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1234 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1235 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1236 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)))')),
1237 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1238 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 1,1 1,1 10,0 10,0 1)),((10 1,1 1,1 0,10 0,10 1)))')),
1239 (ST_GEOMFROMTEXT('POLYGON((5 6,5 5,6 5,6 6,5 6))')),
1240 (ST_GEOMFROMTEXT('POLYGON((5 6,5 5,4 4,6 4,6 6,5 6))')),
1241 (ST_GEOMFROMTEXT('POLYGON((1 10,0 10,0 0,10 0,10 1,1 1,1 10))')),
1242 (ST_GEOMFROMTEXT('POINT(2 2)')),
1243 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1244 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),POINT(2 2))')),
1245 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1246 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1247 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1248 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),POINT(2 2))')),
1249 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),POINT(2 2))')),
1250 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1251 (ST_GEOMFROMTEXT('POINT(2 2)')),
1252 (ST_GEOMFROMTEXT('LINESTRING(1 1,2 2)')),
1253 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),POINT(2 2))')),
1254 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1255 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1256 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1257 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),POINT(2 2))')),
1258 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),POINT(2 2))')),
1259 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1260 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1261 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1262 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1263 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1264 (ST_GEOMFROMTEXT('LINESTRING(3 3,4 4)')),
1265 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1266 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1267 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1268 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1269 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1270 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1271 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1272 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1273 (ST_GEOMFROMTEXT('LINESTRING(3 3,4 4)')),
1274 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,1 0,1 1,0 1,0 0)),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1275 (ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
1276 (ST_GEOMFROMTEXT('MULTILINESTRING((1 1,2 2),(3 3,4 4))')),
1277 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1278 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1279 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1280 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1281 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1282 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1283 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1284 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5)))')),
1285 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),LINESTRING(1 1,2 2))')),
1286 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5))')),
1287 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 5,6 6,5 6,5 5,6 5)),((6 5,6 4,4 4,4 6,5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5)))')),
1288 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),POINT(2 2))')),
1289 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1290 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1291 (ST_GEOMFROMTEXT('POLYGON((6 6,7 6,7 7,6 7,6 6))')),
1292 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 5,6 6,5 6,5 5,6 5)),((6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1,10 1,10 5,6 5)))')),
1293 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5)))')),
1294 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),LINESTRING(1 1,2 2))')),
1295 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5))')),
1296 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 5,6 6,5 6,5 5,6 5)),((6 5,6 4,4 4,4 6,5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5)))')),
1297 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),POINT(2 2))')),
1298 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1299 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1300 (ST_GEOMFROMTEXT('POLYGON((6 6,7 6,7 7,6 7,6 6))')),
1301 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 5,6 6,5 6,5 5,6 5)),((6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1,10 1,10 5,6 5)))')),
1302 (ST_GEOMFROMTEXT('POLYGON((5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6,5 10))')),
1303 (ST_GEOMFROMTEXT('POLYGON((5 10,0 10,0 1,1 1,1 0,10 0,10 5,5 5,4 4,4 6,5 6,5 10))')),
1304 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1,0 1,0 0,1 0,1 1)),((1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1)),((6 5,6 6,5 6,5 5,6 5)))')),
1305 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6)))')),
1306 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),LINESTRING(1 1,2 2))')),
1307 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))')),
1308 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)),((6 5,6 4,4 4,4 6,5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5)))')),
1309 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),POINT(2 2))')),
1310 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1311 (ST_GEOMFROMTEXT('POLYGON((6 6,7 6,7 7,6 7,6 6))')),
1312 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1313 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)),((6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1,10 1,10 5,6 5)))')),
1314 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6)))')),
1315 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),LINESTRING(1 1,2 2))')),
1316 (ST_GEOMFROMTEXT('POLYGON((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))')),
1317 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)),((6 5,6 4,4 4,4 6,5 6,5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5)))')),
1318 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),POINT(2 2))')),
1319 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((5 5,10 5,10 10,5 10,5 5),(6 6,6 7,7 7,7 6,6 6))),MULTILINESTRING((1 1,2 2),(3 3,4 4)))')),
1320 (ST_GEOMFROMTEXT('POLYGON((6 6,7 6,7 7,6 7,6 6))')),
1321 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1322 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)),((6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1,10 1,10 5,6 5)))')),
1323 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,7 6,7 7,6 7,6 6)),((5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6,5 10)))')),
1324 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,7 6,7 7,6 7,6 6)),((5 10,0 10,0 1,1 1,1 0,10 0,10 5,5 5,4 4,4 6,5 6,5 10)))')),
1325 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1,0 1,0 0,1 0,1 1)),((1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6,5 10,1 10,1 1)),((6 6,5 6,5 5,6 5,6 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1326 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1327 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1328 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1329 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 1,1 1,1 10,0 10,0 1)),((10 1,1 1,1 0,10 0,10 1)))')),
1330 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1331 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1332 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)))')),
1333 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1334 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1335 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1336 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1337 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1338 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 1,1 1,1 10,0 10,0 1)),((10 1,1 1,1 0,10 0,10 1)))')),
1339 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1340 (ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,1 0,1 1,0 1,0 0)),((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)))')),
1341 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)))')),
1342 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((6 6,7 6,7 7,6 7,6 6)))')),
1343 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1344 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 10,0 10,0 1,1 1,1 10)),((10 1,1 1,1 0,10 0,10 1)),((5 6,5 5,6 5,6 6,5 6)))')),
1345 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 10,0 10,0 1,1 1,1 10)),((10 1,1 1,1 0,10 0,10 1)),((5 6,5 5,4 4,6 4,6 6,5 6)))')),
1346 (ST_GEOMFROMTEXT('POLYGON((1 1,0 1,0 0,1 0,1 1))')),
1347 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1348 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1349 (ST_GEOMFROMTEXT('POLYGON((1 0,10 0,10 5,10 10,0 10,0 1,1 1,1 0),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1350 (ST_GEOMFROMTEXT('POLYGON((5 6,5 5,6 5,6 6,5 6))')),
1351 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1352 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1353 (ST_GEOMFROMTEXT('POLYGON((5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6,5 10))')),
1354 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,7 6,7 7,6 7,6 6)),((5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6,5 10)))')),
1355 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 10,0 10,0 1,1 1,1 10)),((10 1,1 1,1 0,10 0,10 1)),((5 6,5 5,6 5,6 6,5 6)))')),
1356 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1357 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1358 (ST_GEOMFROMTEXT('POLYGON((1 0,10 0,10 5,10 10,0 10,0 1,1 1,1 0),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1359 (ST_GEOMFROMTEXT('POLYGON((5 6,5 5,6 5,6 6,5 6))')),
1360 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1361 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(6 5,6 4,4 4,4 6,5 6,5 5,6 5))')),
1362 (ST_GEOMFROMTEXT('POLYGON((5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6,5 10))')),
1363 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,7 6,7 7,6 7,6 6)),((5 10,0 10,0 1,1 1,1 0,10 0,10 5,6 5,6 4,4 4,4 6,5 6,5 10)))')),
1364 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 10,0 10,0 1,1 1,1 10)),((10 1,1 1,1 0,10 0,10 1)),((5 6,5 5,6 5,6 6,5 6)))')),
1365 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1366 (ST_GEOMFROMTEXT('POLYGON((4 4,6 4,6 5,5 5,4 4))')),
1367 (ST_GEOMFROMTEXT('MULTIPOLYGON(((10 1,1 1,1 10,0 10,0 0,10 0,10 1)),((5 6,5 5,6 5,6 6,5 6)))')),
1368 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1369 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1370 (ST_GEOMFROMTEXT('POLYGON((1 0,10 0,10 5,10 10,0 10,0 1,1 1,1 0),(5 5,4 4,4 6,5 6,5 5))')),
1371 (ST_GEOMFROMTEXT('POLYGON((5 6,5 5,4 4,6 4,6 6,5 6))')),
1372 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1373 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1374 (ST_GEOMFROMTEXT('POLYGON((5 10,0 10,0 1,1 1,1 0,10 0,10 5,5 5,4 4,4 6,5 6,5 10))')),
1375 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,7 6,7 7,6 7,6 6)),((5 10,0 10,0 1,1 1,1 0,10 0,10 5,5 5,4 4,4 6,5 6,5 10)))')),
1376 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 10,0 10,0 1,1 1,1 10)),((10 1,1 1,1 0,10 0,10 1)),((5 6,5 5,4 4,6 4,6 6,5 6)))')),
1377 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1378 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1379 (ST_GEOMFROMTEXT('POLYGON((1 0,10 0,10 5,10 10,0 10,0 1,1 1,1 0),(5 5,4 4,4 6,5 6,5 5))')),
1380 (ST_GEOMFROMTEXT('POLYGON((5 6,5 5,4 4,6 4,6 6,5 6))')),
1381 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1382 (ST_GEOMFROMTEXT('POLYGON((0 10,0 0,10 0,10 5,10 10,0 10),(5 5,4 4,4 6,5 6,5 5))')),
1383 (ST_GEOMFROMTEXT('POLYGON((5 10,0 10,0 1,1 1,1 0,10 0,10 5,5 5,4 4,4 6,5 6,5 10))')),
1384 (ST_GEOMFROMTEXT('MULTIPOLYGON(((6 6,7 6,7 7,6 7,6 6)),((5 10,0 10,0 1,1 1,1 0,10 0,10 5,5 5,4 4,4 6,5 6,5 10)))')),
1385 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 10,0 10,0 1,1 1,1 10)),((10 1,1 1,1 0,10 0,10 1)),((5 6,5 5,4 4,6 4,6 6,5 6)))')),
1386 (ST_GEOMFROMTEXT('POLYGON((4 4,6 4,6 5,5 5,4 4))')),
1387 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY')),
1388 (ST_GEOMFROMTEXT('MULTIPOLYGON(((10 1,1 1,1 10,0 10,0 0,10 0,10 1)),((5 6,5 5,4 4,6 4,6 6,5 6)))')),
1389 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1390 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1391 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)),((1 1,0 1,0 0,1 0,1 1)))')),
1392 (ST_GEOMFROMTEXT('POLYGON((1 10,0 10,0 0,10 0,10 1,1 1,1 10))')),
1393 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1394 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1395 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((1 1,0 1,0 0,1 0,1 1)))')),
1396 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((1 1,0 1,0 0,1 0,1 1)),((6 6,7 6,7 7,6 7,6 6)))')),
1397 (ST_GEOMFROMTEXT('POLYGON((1 1,0 1,0 0,1 0,1 1))')),
1398 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1399 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1400 (ST_GEOMFROMTEXT('MULTIPOLYGON(((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4)),((1 1,0 1,0 0,1 0,1 1)))')),
1401 (ST_GEOMFROMTEXT('POLYGON((1 10,0 10,0 0,10 0,10 1,1 1,1 10))')),
1402 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1403 (ST_GEOMFROMTEXT('POLYGON((1 1,10 1,10 10,1 10,1 1),(4 4,4 6,6 6,6 4,4 4))')),
1404 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((1 1,0 1,0 0,1 0,1 1)))')),
1405 (ST_GEOMFROMTEXT('MULTIPOLYGON(((5 6,5 10,1 10,1 1,10 1,10 5,6 5,6 4,4 4,4 6,5 6)),((5 6,5 5,6 5,6 6,5 6)),((1 1,0 1,0 0,1 0,1 1)),((6 6,7 6,7 7,6 7,6 6)))')),
1406 (ST_GEOMFROMTEXT('POLYGON((1 1,0 1,0 0,1 0,1 1))')),
1407 (ST_GEOMFROMTEXT('MULTIPOLYGON(((10 1,1 1,1 10,0 10,0 0,10 0,10 1)),((5 6,5 5,6 5,6 6,5 6)))')),
1408 (ST_GEOMFROMTEXT('MULTIPOLYGON(((10 1,1 1,1 10,0 10,0 0,10 0,10 1)),((5 6,5 5,4 4,6 4,6 6,5 6)))')),
1409 (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION EMPTY'));
1410 CREATE TABLE symdifference (pk INT PRIMARY KEY AUTO_INCREMENT, g GEOMETRY NOT NULL);
1411 INSERT INTO symdifference SELECT 0, ST_SYMDIFFERENCE(a.g, b.g) FROM t1 AS a JOIN t1 AS b ORDER BY a.pk, b.pk;
1412 SELECT SUM(ST_EQUALS(a.g, b.g)) FROM symdifference AS a, symdifference_results AS b WHERE a.pk = b.pk;
1413 SUM(ST_EQUALS(a.g, b.g))
1414 441
1415 #clean up
1416 DROP TABLE gis_geometrycollection;
1417 DROP TABLE gis_geometrycollection_2;
1418 DROP TABLE t1;
1419 DROP TABLE symdifference;
1420 DROP TABLE symdifference_results;
1421 #
1422 # Bug #21263152 ST_SYMDIFFERENCE(POLYGON, POLYGON) MAY RETURN AN INVALID
1423 # MULTIPOLYGON
1424 #
1425 SELECT ST_ISVALID(
1426 ST_SYMDIFFERENCE(
1427 ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'),
1428 ST_GEOMFROMTEXT('POLYGON((1 0, 1 1, 2 1, 2 0, 1 0))')
1429 )
1430 ) AS valid;
1431 valid
1432 1
1433 SELECT ST_ISVALID(
1434 ST_SYMDIFFERENCE(
1435 ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'),
1436 ST_GeomFromText('POLYGON((1 0, 1 1, 0 1, 0 2, 2 2, 2 0, 1 0))')
1437 )
1438 ) AS valid;
1439 valid
1440 1
1441 SELECT ST_ASTEXT(
1442 ST_SYMDIFFERENCE(
1443 ST_GEOMFROMTEXT('POLYGON((52 18, 66 23, 73 9, 48 6, 52 18),
1444 (59 18, 67 18, 67 13, 59 13, 59 18))'),
1445 ST_GEOMFROMTEXT('POLYGON((62 48, 84 48, 84 30, 56 30, 56 34, 62 48))')
1446 )
1447 ) AS r;
1448 r
1449 MULTIPOLYGON(((52 18,48 6,73 9,66 23,52 18),(59 18,67 18,67 13,59 13,59 18)),((62 48,56 34,56 30,84 30,84 48,62 48)))
1450 #
1451 # Bug#21927639 ST_SYMDIFFERENCE(POLYGON, POLYGON) RETURNS INVALID
1452 # MULTIPOLYGOM GEOMETRY
1453 #
1454 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((6 7,18
1455 14,-8 1,0 0,18 -8,6 7),(6 0,-4 3,5 3,6 0))'), ST_GEOMFROMTEXT('POLYGON((0
1456 7,-5 6,11 -13,0 7))')));
1457 ST_ASTEXT(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POLYGON((6 7,18
1458 14,-8 1,0 0,18 -8,6 7),(6 0,-4 3,5 3,6 0))'), ST_GEOMFROMTEXT('POLYGON((0
1459 7,-5 6,11 -13,0 7))')))
1460 MULTIPOLYGON(((0.08411214953271084 -0.03738317757009302,-1.9577464788732395 2.387323943661972,-4 3,-8 1,0 0,0.08411214953271084 -0.03738317757009302)),((0.08411214953271084 -0.03738317757009302,11 -13,5.095588235294118 -2.264705882352941,0.08411214953271084 -0.03738317757009302)),((-1.9577464788732395 2.387323943661972,3.4251497005988023 0.7724550898203593,2.2 3,-2.473684210526316 3,-1.9577464788732395 2.387323943661972)),((3.4251497005988023 0.772455089820359,5.095588235294118 -2.264705882352941,18 -8,6 7,18 14,0.8627450980392162 5.431372549019606,2.2 3,5 3,6 0,3.4251497005988023 0.772455089820359)),((0.8627450980392157 5.431372549019608,0 7,-5 6,-2.9259259259259256 3.537037037037038,0.8627450980392157 5.431372549019608)),((-2.473684210526316 3,-2.925925925925926 3.537037037037037,-4 3,-2.473684210526316 3)))
1461 #
1462 # WL#8579 Spatial Reference Systems
1463 #
1464 # SRID 0 (should pass)
1465 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(
1466 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1467 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1468 ));
1469 ST_ASTEXT(ST_SYMDIFFERENCE(
1470 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1471 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1472 ))
1473 GEOMETRYCOLLECTION EMPTY
1474 # Projected SRS (should pass)
1475 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(
1476 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1477 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1478 ));
1479 ST_ASTEXT(ST_SYMDIFFERENCE(
1480 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1481 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1482 ))
1483 GEOMETRYCOLLECTION EMPTY
1484 # Geographic SRS (should pass)
1485 SELECT ST_ASTEXT(ST_SYMDIFFERENCE(
1486 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1487 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1488 ));
1489 ST_ASTEXT(ST_SYMDIFFERENCE(
1490 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1491 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1492 ))
1493 GEOMETRYCOLLECTION EMPTY
1494 #
1495 # Bug #25510403 SRID OF RESULT OF SET OPERATION IS DIFFERENT FROM INPUT
1496 # GEOMETRIES
1497 #
1498 SELECT ST_SRID(ST_SymDifference(
1499 ST_GeomFromText("LINESTRING(1 1, 2 2)", 2000),
1500 ST_GeomFromText("MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))", 2000)
1501 )) AS result;
1502 result
1503 2000
1504 SELECT ST_SRID(ST_SymDifference(
1505 ST_GeomFromText("MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))", 2000),
1506 ST_GeomFromText("MULTILINESTRING((1 1, 2 2))", 2000)
1507 )) AS result;
1508 result
1509 2000
1510 SELECT ST_SRID(ST_SymDifference(
1511 ST_GeomFromText("MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))", 2000),
1512 ST_GeomFromText("LINESTRING(1 1, 2 2)", 2000)
1513 )) AS result;
1514 result
1515 2000
1516 SELECT ST_SRID(ST_SymDifference(
1517 ST_GeomFromText("MULTILINESTRING((1 1, 2 2))", 2000),
1518 ST_GeomFromText("MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))", 2000)
1519 )) AS result;
1520 result
1521 2000
1522 #
1523 # WL#11096 Don't do Cartesian computations on geographic geometries
1524 #
1525 # Assume SRID 10 is not defined.
1526 DO ST_SYMDIFFERENCE(
1527 x'0A000000010100000000000000000000000000000000000000',
1528 x'0A000000010100000000000000000000000000000000000000'
1529 );
1530 ERROR SR001: There's no spatial reference system with SRID 10.