Debian Codegraph @

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