Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # This test is aimed to focus on Functions for testing Relations between #
4 # Geometry Objects. #
5 # #
6 # These functions take 2 geometries as inpout parameters and return #
7 # a qualitative or quantitavive realtion between themrealtion between them. #
8 # #
9 # Creation Date: 2013-12-16 #
10 # Author : Horst Hunger #
11 # #
12 ###############################################################################
13
14
15 ############################################################################################
16 # Creating the spatial objects #
17 ############################################################################################
18
19 --echo #Creating the spatial Geometry object
20 USE test;
21
22 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
23
24 ############################################################################################
25 # Inserting the values specific to the spatial objects #
26 ############################################################################################
27
28 # Geometric elements constructing a star and some of its elememts as base
29 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
30 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
31 SET @star_center= 'POINT(15 10)';
32 SET @star_top= 'POINT(15 25)';
33 SET @star_bottom_left= 'POINT(5 0)';
34 SET @star_bottom_right= 'POINT(25 0)';
35 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
36 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
37 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
38 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
39 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
40 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
41 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
42 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))';
43 SET @star_elem_vertical_val= '((5 0,15 25,25 0,15 5,5 0))';
44 SET @star_elem_horizontal_val= '((25 0,0 15,30 15,22 10,25 0))';
45 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)))';
46 SET @star_collection_elems='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
47 SET @star_collection_multilinestr='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),MULTILINESTRING((25 0,0 15,15 30,0 5)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
48
49 # Star identical to the base star
50 SET @star_elem_vertical_1= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
51 SET @star_elem_horizontal_1= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
52 SET @star_center_1= 'POINT(15 10)';
53 SET @star_top_1= 'POINT(15 25)';
54 SET @star_bottom_left_1= 'POINT(5 0)';
55 SET @star_bottom_right_1= 'POINT(25 0)';
56 SET @star_bottom_points_1= 'MULTIPOINT(5 0,25 0)';
57 SET @star_all_points_1= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
58 SET @star_line_horizontal_1= 'LINESTRING(10 15,20 15)';
59 SET @star_line_vertical_1= 'LINESTRING(15 5,15 25)';
60 SET @star_top_to_center_1= 'LINESTRING(15 25,15 10)';
61 SET @star_lines_near_horizontal_1= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
62 SET @star_lines_near_vertical_1= 'MULTILINESTRING((0 5,15 25,0 25))';
63 SET @star_1= 'POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0))';
64 SET @star_elem_vertical_val_1= '((5 0,15 25,25 0,15 5,5 0))';
65 SET @star_elem_horizontal_val_1= '((25 0,0 15,30 15,22 10,25 0))';
66 SET @star_of_elems_1='MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0)))';
67 SET @star_collection_elems_1='GEOMETRYCOLLECTION(MULTIPOLYGON(((5 0,15 25,25 0,15 5,5 0)),((25 0,0 15,30 15,22 10,25 0))),POLYGON((5 0,7 10,0 15,10 15,15 25,20 15,30 15,22 10,25 0,15 5,5 0)),LINESTRING(15 25,15 10),MULTIPOINT(5 0,25 0),POINT(15 25))';
68
69 # Star like the base star, but shifted to right by 10 on X to overlap base star
70 SET @star_elem_vertical_2= 'POLYGON((15 0,25 25,35 0,25 5,15 0))';
71 SET @star_elem_horizontal_2= 'POLYGON((35 0,10 15,40 15,32 10,35 0))';
72 SET @star_center_2= 'POINT(25 10)';
73 SET @star_top_2= 'POINT(25 25)';
74 SET @star_bottom_left_2= 'POINT(15 0)';
75 SET @star_bottom_right_2= 'POINT(35 0)';
76 SET @star_bottom_points_2= 'MULTIPOINT(15 0,35 0)';
77 SET @star_all_points_2= 'MULTIPOINT(15 0,35 0,35 10,25 25)';
78 SET @star_line_horizontal_2= 'LINESTRING(20 15,30 15)';
79 SET @star_line_vertical_2= 'LINESTRING(25 5,25 25)';
80 SET @star_top_to_center_2= 'LINESTRING(25 25,25 10)';
81 SET @star_lines_near_horizontal_2= 'MULTILINESTRING((35 0,10 15,25 30,10 5))';
82 SET @star_lines_near_vertical_2= 'MULTILINESTRING((10 5,25 25,10 25))';
83 SET @star_2= 'POLYGON((15 0,17 10,10 15,20 15,25 25,30 15,40 15,32 10,35 0,25 5,15 0))';
84 SET @star_elem_vertical_val_2= '((15 0,25 25,35 0,25 5,15 0))';
85 SET @star_elem_horizontal_val_2= '((35 0,10 15,40 15,32 10,35 0))';
86 SET @star_of_elems_2='MULTIPOLYGON(((15 0,25 25,35 0,25 5,15 0)),((35 0,10 15,40 15,32 10,35 0)))';
87 SET @star_collection_elems_2='GEOMETRYCOLLECTION(MULTIPOLYGON(((15 0,25 25,35 0,25 5,15 0)),((35 0,10 15,40 15,32 10,35 0))),POLYGON((15 0,17 10,10 15,20 15,25 25,30 15,40 15,32 10,35 0,25 5,15 0)),LINESTRING(25 25,25 10),MULTIPOINT(15 0,35 0),POINT(25 25))';
88
89 # Star like the base star, but shifted to right by 60 on X to be completly separate
90 SET @star_elem_vertical_3= 'POLYGON((65 0,75 25,85 0,75 5,65 0))';
91 SET @star_elem_horizontal_3= 'POLYGON((85 0,60 15,90 15,82 10,85 0))';
92 SET @star_center_3= 'POINT(75 10)';
93 SET @star_top_3= 'POINT(75 25)';
94 SET @star_bottom_left_3= 'POINT(65 0)';
95 SET @star_bottom_right_3= 'POINT(85 0)';
96 SET @star_bottom_points_3= 'MULTIPOINT(65 0,85 0)';
97 SET @star_all_points_3= 'MULTIPOINT(65 0,85 0,75 10,75 25)';
98 SET @star_line_horizontal_3= 'LINESTRING(70 15,80 15)';
99 SET @star_line_vertical_3= 'LINESTRING(75 5,75 25)';
100 SET @star_top_to_center_3= 'LINESTRING(75 25,75 10)';
101 SET @star_lines_near_horizontal_3= 'MULTILINESTRING((85 0,60 15,85 30,60 5))';
102 SET @star_lines_near_vertical_3= 'MULTILINESTRING((60 5,75 25,60 25))';
103 SET @star_3= 'POLYGON((65 0,67 10,60 15,70 15,75 25,80 15,90 15,82 10,85 0,75 5,65 0))';
104 SET @star_elem_vertical_val_3= '((65 0,75 25,85 0,75 5,65 0))';
105 SET @star_elem_horizontal_val_3= '((85 0,60 15,90 15,82 10,85 0))';
106 SET @star_of_elems_3='MULTIPOLYGON(((65 0,75 25,85 0,75 5,65 0)),((85 0,60 15,90 15,82 10,85 0)))';
107 SET @star_collection_elems_3='GEOMETRYCOLLECTION(MULTIPOLYGON(((65 0,75 25,85 0,75 5,65 0)),((85 0,60 15,90 15,82 10,85 0))),POLYGON((65 0,67 10,60 15,70 15,75 25,80 15,90 15,82 10,85 0,75 5,65 0)),LINESTRING(75 25,75 10),MULTIPOINT(65 0,85 0),POINT(75 25))';
108
109 --echo #INSERT base star
110 --disable_warnings
111 INSERT INTO gis_geometrycollection VALUES
112 (100,ST_GEOMFROMTEXT(@star)),
113 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
114 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
115 (103,ST_GEOMFROMTEXT(@star_of_elems)),
116 (104,ST_GEOMFROMTEXT(@star_top)),
117 (105,ST_GEOMFROMTEXT(@star_center)),
118 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
119 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
120 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
121 (109,ST_GEOMFROMTEXT(@star_all_points)),
122 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
123 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
124 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
125 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
126 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
127 (115,ST_GEOMFROMTEXT(@star_collection_elems));
128 --enable_warnings
129
130 --echo #INSERT identical (to base) star
131 --disable_warnings
132 INSERT INTO gis_geometrycollection VALUES
133 (200,ST_GEOMFROMTEXT(@star_1)),
134 (201,ST_GEOMFROMTEXT(@star_elem_vertical_1)),
135 (202,ST_GEOMFROMTEXT(@star_elem_horizontal_1)),
136 (203,ST_GEOMFROMTEXT(@star_of_elems_1)),
137 (204,ST_GEOMFROMTEXT(@star_top_1)),
138 (205,ST_GEOMFROMTEXT(@star_center_1)),
139 (206,ST_GEOMFROMTEXT(@star_bottom_left_1)),
140 (207,ST_GEOMFROMTEXT(@star_bottom_right_1)),
141 (208,ST_GEOMFROMTEXT(@star_bottom_points_1)),
142 (209,ST_GEOMFROMTEXT(@star_all_points_1)),
143 (210,ST_GEOMFROMTEXT(@star_line_horizontal_1)),
144 (211,ST_GEOMFROMTEXT(@star_line_vertical_1)),
145 (212,ST_GEOMFROMTEXT(@star_top_to_center_1)),
146 (213,ST_GEOMFROMTEXT(@star_lines_near_horizontal_1)),
147 (214,ST_GEOMFROMTEXT(@star_lines_near_vertical_1)),
148 (215,ST_GEOMFROMTEXT(@star_collection_elems_1));
149 --enable_warnings
150
151 --echo #INSERT overlapping star
152 --disable_warnings
153 INSERT INTO gis_geometrycollection VALUES
154 (300,ST_GEOMFROMTEXT(@star_2)),
155 (301,ST_GEOMFROMTEXT(@star_elem_vertical_2)),
156 (302,ST_GEOMFROMTEXT(@star_elem_horizontal_2)),
157 (303,ST_GEOMFROMTEXT(@star_of_elems_2)),
158 (304,ST_GEOMFROMTEXT(@star_top_2)),
159 (305,ST_GEOMFROMTEXT(@star_center_2)),
160 (306,ST_GEOMFROMTEXT(@star_bottom_left_2)),
161 (307,ST_GEOMFROMTEXT(@star_bottom_right_2)),
162 (308,ST_GEOMFROMTEXT(@star_bottom_points_2)),
163 (309,ST_GEOMFROMTEXT(@star_all_points_2)),
164 (310,ST_GEOMFROMTEXT(@star_line_horizontal_2)),
165 (311,ST_GEOMFROMTEXT(@star_line_vertical_2)),
166 (312,ST_GEOMFROMTEXT(@star_top_to_center_2)),
167 (313,ST_GEOMFROMTEXT(@star_lines_near_horizontal_2)),
168 (314,ST_GEOMFROMTEXT(@star_lines_near_vertical_2)),
169 (315,ST_GEOMFROMTEXT(@star_collection_elems_2));
170 --enable_warnings
171
172 --echo #INSERT separate star
173 --disable_warnings
174 INSERT INTO gis_geometrycollection VALUES
175 (400,ST_GEOMFROMTEXT(@star_3)),
176 (401,ST_GEOMFROMTEXT(@star_elem_vertical_3)),
177 (402,ST_GEOMFROMTEXT(@star_elem_horizontal_3)),
178 (403,ST_GEOMFROMTEXT(@star_of_elems_3)),
179 (404,ST_GEOMFROMTEXT(@star_top_3)),
180 (405,ST_GEOMFROMTEXT(@star_center_3)),
181 (406,ST_GEOMFROMTEXT(@star_bottom_left_3)),
182 (407,ST_GEOMFROMTEXT(@star_bottom_right_3)),
183 (408,ST_GEOMFROMTEXT(@star_bottom_points_3)),
184 (409,ST_GEOMFROMTEXT(@star_all_points_3)),
185 (410,ST_GEOMFROMTEXT(@star_line_horizontal_3)),
186 (411,ST_GEOMFROMTEXT(@star_line_vertical_3)),
187 (412,ST_GEOMFROMTEXT(@star_top_to_center_3)),
188 (413,ST_GEOMFROMTEXT(@star_lines_near_horizontal_3)),
189 (414,ST_GEOMFROMTEXT(@star_lines_near_vertical_3)),
190 (415,ST_GEOMFROMTEXT(@star_collection_elems_3));
191 --enable_warnings
192
193 CREATE TABLE gis_geometrycollection_2 SELECT fid as fid2,g as g2 FROM gis_geometrycollection;
194
195 --echo #Checking the integrity of the above create/insert statements
196
197 --echo #64 rows.
198 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
199 --echo #64 rows.
200 SELECT count(ST_ASTEXT(g2) != 'NULL') FROM gis_geometrycollection_2;
201
202 ############################################################################################
203 # Checking the spatial testing functions #
204 ############################################################################################
205
206 --echo #####################################################################################
207 --echo # MBRINTERSECTS(g1,g2)
208 --echo #####################################################################################
209
210 --echo #====================================================================================
211 --echo # point,point
212 --echo #====================================================================================
213 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
214
215 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
216
217 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=105;
218
219 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
220
221 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
222
223 --echo #====================================================================================
224 --echo # point,multipoint
225 --echo #====================================================================================
226 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
227
228 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_bottom_points));
229
230 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=106;
231
232 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
233
234 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
235
236 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
237
238 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
239
240 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
241
242 --echo #====================================================================================
243 --echo # point,linestring
244 --echo #====================================================================================
245 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
246
247 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_line_horizontal));
248
249 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
250
251 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
252
253 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
254
255 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
256
257 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
258
259 --echo #====================================================================================
260 --echo # point,multilinestring
261 --echo #====================================================================================
262 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
263
264 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
265
266 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
267
268 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'));
269
270 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
271
272 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
273
274 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
275
276 --echo #====================================================================================
277 --echo # point,polygon
278 --echo #====================================================================================
279 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
280
281 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_horizontal));
282
283 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_vertical));
284
285 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=104;
286
287 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
288
289 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
290
291 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))'));
292
293 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
294
295 --echo #====================================================================================
296 --echo # point,multipolygon
297 --echo #====================================================================================
298 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
299
300 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_of_elems));
301
302 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
303
304 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
305
306 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)),((10 10,10 20,20 20,20 10,10 10)))'));
307
308 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
309
310 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
311
312 --echo #====================================================================================
313 --echo # point,geometrycollection
314 --echo #====================================================================================
315 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
316
317 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_collection_elems));
318
319 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
320
321 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
322
323 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
324
325 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
326
327 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
328
329 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
330
331 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
332
333 --echo #====================================================================================
334 --echo # multipoint,point
335 --echo #====================================================================================
336 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
337
338 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
339
340 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
341
342 --echo #====================================================================================
343 --echo # multipoint,multipoint
344 --echo #====================================================================================
345 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points));
346
347 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
348
349 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=208;
350
351 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=308;
352
353 --echo #====================================================================================
354 --echo # multipoint,linestring
355 --echo #====================================================================================
356 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
357
358 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=109;
359
360 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=209;
361
362 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=309;
363
364 --echo #====================================================================================
365 --echo # multipoint,multilinestring
366 --echo #====================================================================================
367 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
368
369 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
370
371 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=109;
372
373 --echo #====================================================================================
374 --echo # multipoint,polygon
375 --echo #====================================================================================
376 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical));
377
378 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
379
380 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=109;
381
382 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=209;
383
384 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=309;
385
386 --echo #====================================================================================
387 --echo # multipoint,multipolygon
388 --echo #====================================================================================
389 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems));
390
391 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
392
393 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=109;
394
395 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=209;
396
397 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=309;
398
399 --echo #====================================================================================
400 --echo # multipoint,geometrycollection
401 --echo #====================================================================================
402 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems));
403
404 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
405
406 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=109;
407
408 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=209;
409
410 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=309;
411
412 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr));
413
414 --echo #====================================================================================
415 --echo # linestring,point
416 --echo #====================================================================================
417 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
418
419 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
420
421 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
422
423 --echo #====================================================================================
424 --echo # linestring,multipoint
425 --echo #====================================================================================
426 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
427
428 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
429
430 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=111;
431
432 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=311;
433
434 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=411;
435
436 --echo #====================================================================================
437 --echo # linestring,linestring
438 --echo #====================================================================================
439 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
440
441 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
442
443 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=111;
444
445 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=311;
446
447 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=411;
448
449 --echo #====================================================================================
450 --echo # linestring,multilinestring
451 --echo #====================================================================================
452 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
453
454 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical));
455
456 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=110;
457
458 --echo #====================================================================================
459 --echo # linestring,polygon
460 --echo #====================================================================================
461 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
462
463 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
464
465 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
466
467 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
468
469 --error ER_GIS_INVALID_DATA
470 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,11 15))')) FROM gis_geometrycollection WHERE fid=110;
471
472 --echo #====================================================================================
473 --echo # linestring,multipolygon
474 --echo #====================================================================================
475 --error ER_GIS_INVALID_DATA
476 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))'));
477
478 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
479
480 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_2));
481
482 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3));
483
484 --error ER_GIS_INVALID_DATA
485 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))')) FROM gis_geometrycollection WHERE fid=110;
486
487 --echo #====================================================================================
488 --echo # linestring,geometrycollection
489 --echo #====================================================================================
490 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
491
492 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_2));
493
494 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
495
496 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=110;
497
498 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
499
500 --echo #====================================================================================
501 --echo # multilinestring,point
502 --echo #====================================================================================
503 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
504
505 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
506
507 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_2));
508
509 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_3));
510
511 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
512
513 --echo #====================================================================================
514 --echo # multilinestring,multipoint
515 --echo #====================================================================================
516 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points));
517
518 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
519
520 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=114;
521
522 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
523
524 --echo #====================================================================================
525 --echo # multilinestring,linestring
526 --echo #====================================================================================
527 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
528
529 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
530
531 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_2));
532
533 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_3));
534
535 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
536
537 --echo #====================================================================================
538 --echo # multilinestring,multilinestring
539 --echo #====================================================================================
540 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'));
541
542 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
543
544 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal_3));
545
546 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
547
548 --echo #====================================================================================
549 --echo # multilinestring,polygon
550 --echo #====================================================================================
551 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical));
552
553 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
554
555 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
556
557 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
558
559 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
560
561 --echo #====================================================================================
562 --echo # multilinestring,multipolygon
563 --echo #====================================================================================
564 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical));
565
566 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
567
568 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=114;
569
570 --echo #====================================================================================
571 --echo # multilinestring,geometrycollection
572 --echo #====================================================================================
573 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems));
574
575 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
576
577 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=114;
578
579 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr));
580
581 --echo #====================================================================================
582 --echo # polygon,point
583 --echo #====================================================================================
584 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
585
586 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
587
588 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
589
590 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=200;
591
592 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=300;
593
594 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=400;
595
596 --echo #====================================================================================
597 --echo # polygon,multipoint
598 --echo #====================================================================================
599 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points));
600
601 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
602
603 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
604
605 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=300;
606
607 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=400;
608
609 --echo #====================================================================================
610 --echo # polygon,linestring
611 --echo #====================================================================================
612 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical));
613
614 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
615
616 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=100;
617
618 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=300;
619
620 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=400;
621
622 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
623
624 --echo #====================================================================================
625 --echo # polygon,multilinestring
626 --echo #====================================================================================
627 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical));
628
629 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
630
631 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=100;
632
633 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=300;
634
635 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=400;
636
637 --echo #====================================================================================
638 --echo # polygon,polygon
639 --echo #====================================================================================
640 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical));
641
642 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
643
644 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=100;
645
646 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=300;
647
648 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=400;
649
650 --echo #====================================================================================
651 --echo # polygon,multipolygon
652 --echo #====================================================================================
653 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems));
654
655 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
656
657 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
658
659 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=300;
660
661 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=400;
662
663 --echo #====================================================================================
664 --echo # polygon,geometrycollection
665 --echo #====================================================================================
666 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems));
667
668 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
669
670 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
671
672 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=300;
673
674 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=400;
675
676 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
677
678 --echo #====================================================================================
679 --echo # multipolygon,point
680 --echo #====================================================================================
681 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
682
683 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
684
685 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=103;
686
687 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=403;
688
689 --echo #====================================================================================
690 --echo # multipolygon,multipoint
691 --echo #====================================================================================
692 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
693
694 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
695
696 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
697
698 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=403;
699
700 --echo #====================================================================================
701 --echo # multipolygon,linestring
702 --echo #====================================================================================
703 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
704
705 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
706
707 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
708
709 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=403;
710
711 --echo #====================================================================================
712 --echo # multipolygon,multilinestring
713 --echo #====================================================================================
714 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
715
716 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
717
718 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
719
720 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=403;
721
722 --echo #====================================================================================
723 --echo # multipolygon,polygon
724 --echo #====================================================================================
725 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
726
727 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star));
728
729 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
730
731 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=103;
732
733 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=303;
734
735 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=403;
736
737 --echo #====================================================================================
738 --echo # multipolygon,multipolygon
739 --echo #====================================================================================
740 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
741
742 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
743
744 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=103;
745
746 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=303;
747
748 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
749
750 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
751
752 --echo #====================================================================================
753 --echo # multipolygon,geometrycollection
754 --echo #====================================================================================
755 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
756
757 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=103;
758
759 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=303;
760
761 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
762
763 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
764
765 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
766
767 --echo #====================================================================================
768 --echo # geometrycollection,point
769 --echo #====================================================================================
770 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
771
772 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
773
774 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=115;
775
776 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=415;
777
778 --echo #====================================================================================
779 --echo # geometrycollection,multipoint
780 --echo #====================================================================================
781 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
782
783 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
784
785 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
786
787 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=415;
788
789 --echo #====================================================================================
790 --echo # geometrycollection,linestring
791 --echo #====================================================================================
792 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
793
794 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
795
796 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
797
798 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=415;
799
800 --echo #====================================================================================
801 --echo # geometrycollection,multilinestring
802 --echo #====================================================================================
803 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
804
805 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
806
807 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
808
809 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=415;
810
811 --echo #====================================================================================
812 --echo # geometrycollection,polygon
813 --echo #====================================================================================
814 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
815
816 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star));
817
818 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
819
820 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=115;
821
822 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=315;
823
824 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=415;
825
826 --echo #====================================================================================
827 --echo # geometrycollection,multipolygon
828 --echo #====================================================================================
829 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
830
831 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
832
833 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
834
835 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
836
837 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
838
839 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
840
841 --echo #====================================================================================
842 --echo # geometrycollection,geometrycollection
843 --echo #====================================================================================
844 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
845
846 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
847
848 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
849
850 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
851
852 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=115;
853
854 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
855
856 --echo #####################################################################################
857 --echo # ST_INTERSECTS(g1,g2)
858 --echo #####################################################################################
859
860 --echo #====================================================================================
861 --echo # point,point
862 --echo #====================================================================================
863 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
864
865 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
866
867 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=105;
868
869 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
870
871 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
872
873 --echo #====================================================================================
874 --echo # point,multipoint
875 --echo #====================================================================================
876 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
877
878 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_bottom_points));
879
880 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=106;
881
882 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
883
884 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
885
886 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
887
888 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
889
890 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
891
892 --echo #====================================================================================
893 --echo # point,linestring
894 --echo #====================================================================================
895 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
896
897 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_line_horizontal));
898
899 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
900
901 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
902
903 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
904
905 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
906
907 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
908
909 --echo #====================================================================================
910 --echo # point,multilinestring
911 --echo #====================================================================================
912 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
913
914 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
915
916 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
917
918 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'));
919
920 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
921
922 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
923
924 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
925
926 --echo #====================================================================================
927 --echo # point,polygon
928 --echo #====================================================================================
929 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
930
931 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_horizontal));
932
933 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_vertical));
934
935 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=104;
936
937 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
938
939 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
940
941 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))'));
942
943 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
944
945 --echo #====================================================================================
946 --echo # point,multipolygon
947 --echo #====================================================================================
948 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
949
950 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_of_elems));
951
952 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
953
954 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
955
956 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)),((10 10,10 20,20 20,20 10,10 10)))'));
957
958 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
959
960 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)))'));
961
962 --echo #====================================================================================
963 --echo # point,geometrycollection
964 --echo #====================================================================================
965 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
966
967 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_collection_elems));
968
969 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
970
971 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
972
973 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
974
975 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
976
977 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
978
979 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
980
981 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
982
983 --echo #====================================================================================
984 --echo # multipoint,point
985 --echo #====================================================================================
986 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
987
988 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
989
990 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
991
992 --echo #====================================================================================
993 --echo # multipoint,multipoint
994 --echo #====================================================================================
995 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points));
996
997 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
998
999 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=208;
1000
1001 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=308;
1002
1003 --echo #====================================================================================
1004 --echo # multipoint,linestring
1005 --echo #====================================================================================
1006 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
1007
1008 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=109;
1009
1010 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=209;
1011
1012 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=309;
1013
1014 --echo #====================================================================================
1015 --echo # multipoint,multilinestring
1016 --echo #====================================================================================
1017 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1018
1019 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1020
1021 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=109;
1022
1023 --echo #====================================================================================
1024 --echo # multipoint,polygon
1025 --echo #====================================================================================
1026 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical));
1027
1028 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
1029
1030 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=109;
1031
1032 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=209;
1033
1034 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=309;
1035
1036 --echo #====================================================================================
1037 --echo # multipoint,multipolygon
1038 --echo #====================================================================================
1039 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems));
1040
1041 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
1042
1043 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=109;
1044
1045 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=209;
1046
1047 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=309;
1048
1049 --echo #====================================================================================
1050 --echo # multipoint,geometrycollection
1051 --echo #====================================================================================
1052 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems));
1053
1054 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
1055
1056 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=109;
1057
1058 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=209;
1059
1060 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=309;
1061
1062 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1063
1064 --echo #====================================================================================
1065 --echo # linestring,point
1066 --echo #====================================================================================
1067 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
1068
1069 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
1070
1071 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
1072
1073 --echo #====================================================================================
1074 --echo # linestring,multipoint
1075 --echo #====================================================================================
1076 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
1077
1078 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
1079
1080 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=111;
1081
1082 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=311;
1083
1084 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=411;
1085
1086 --echo #====================================================================================
1087 --echo # linestring,linestring
1088 --echo #====================================================================================
1089 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
1090
1091 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
1092
1093 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=111;
1094
1095 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=311;
1096
1097 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=411;
1098
1099 --echo #====================================================================================
1100 --echo # linestring,multilinestring
1101 --echo #====================================================================================
1102 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1103
1104 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1105
1106 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=110;
1107
1108 --echo #====================================================================================
1109 --echo # linestring,polygon
1110 --echo #====================================================================================
1111 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
1112
1113 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
1114
1115 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
1116
1117 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
1118
1119 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 25,11 15,11 15))')) FROM gis_geometrycollection WHERE fid=110;
1120
1121 --echo #====================================================================================
1122 --echo # linestring,multipolygon
1123 --echo #====================================================================================
1124 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,19 25,11 15,11 15)),((25 0,0 15,25 10,25 0)))'));
1125
1126 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
1127
1128 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_2));
1129
1130 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3));
1131
1132 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,19 25,11 15,11 15)),((25 0,0 15,25 10,25 0)))')) FROM gis_geometrycollection WHERE fid=110;
1133
1134 --echo #====================================================================================
1135 --echo # linestring,geometrycollection
1136 --echo #====================================================================================
1137 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
1138
1139 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_2));
1140
1141 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
1142
1143 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=110;
1144
1145 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1146
1147 --echo #====================================================================================
1148 --echo # multilinestring,point
1149 --echo #====================================================================================
1150 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
1151
1152 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
1153
1154 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_2));
1155
1156 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_3));
1157
1158 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
1159
1160 --echo #====================================================================================
1161 --echo # multilinestring,multipoint
1162 --echo #====================================================================================
1163 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points));
1164
1165 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
1166
1167 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=114;
1168
1169 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
1170
1171 --echo #====================================================================================
1172 --echo # multilinestring,linestring
1173 --echo #====================================================================================
1174 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
1175
1176 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
1177
1178 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_2));
1179
1180 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_3));
1181
1182 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
1183
1184 --echo #====================================================================================
1185 --echo # multilinestring,multilinestring
1186 --echo #====================================================================================
1187 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'));
1188
1189 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1190
1191 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal_3));
1192
1193 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
1194
1195 --echo #====================================================================================
1196 --echo # multilinestring,polygon
1197 --echo #====================================================================================
1198 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical));
1199
1200 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
1201
1202 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
1203
1204 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
1205
1206 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
1207
1208 --echo #====================================================================================
1209 --echo # multilinestring,multipolygon
1210 --echo #====================================================================================
1211 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical));
1212
1213 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
1214
1215 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=114;
1216
1217 --echo #====================================================================================
1218 --echo # multilinestring,geometrycollection
1219 --echo #====================================================================================
1220 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems));
1221
1222 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
1223
1224 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=114;
1225
1226 --echo #====================================================================================
1227 --echo # polygon,point
1228 --echo #====================================================================================
1229 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
1230
1231 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
1232
1233 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
1234
1235 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=200;
1236
1237 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=300;
1238
1239 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=400;
1240
1241 --echo #====================================================================================
1242 --echo # polygon,multipoint
1243 --echo #====================================================================================
1244 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points));
1245
1246 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
1247
1248 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
1249
1250 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=300;
1251
1252 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=400;
1253
1254 --echo #====================================================================================
1255 --echo # polygon,linestring
1256 --echo #====================================================================================
1257 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical));
1258
1259 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
1260
1261 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=100;
1262
1263 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=300;
1264
1265 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=400;
1266
1267 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
1268
1269 --echo #====================================================================================
1270 --echo # polygon,multilinestring
1271 --echo #====================================================================================
1272 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1273
1274 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1275
1276 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=100;
1277
1278 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=300;
1279
1280 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=400;
1281
1282 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(2 2,2 4,4 4,4 2,2 2))'),
1283 ST_GEOMFROMTEXT('MULTILINESTRING((11 11,20 20),(5 7, 4 1))'));
1284
1285 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((5 0,0 5,-5 0,0 -5,5 0))'),
1286 ST_GEOMFROMTEXT('MULTILINESTRING((10 0, 18 12),(2 2, 2 1))'));
1287
1288 --echo #====================================================================================
1289 --echo # polygon,polygon
1290 --echo #====================================================================================
1291 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical));
1292
1293 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
1294
1295 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=100;
1296
1297 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=300;
1298
1299 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=400;
1300
1301 --echo #====================================================================================
1302 --echo # polygon,multipolygon
1303 --echo #====================================================================================
1304 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems));
1305
1306 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
1307
1308 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
1309
1310 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=300;
1311
1312 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=400;
1313
1314 --echo #====================================================================================
1315 --echo # polygon,goemetrycollection
1316 --echo #====================================================================================
1317 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems));
1318
1319 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
1320
1321 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
1322
1323 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=300;
1324
1325 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=400;
1326
1327 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1328
1329 --echo #====================================================================================
1330 --echo # multipolygon,point
1331 --echo #====================================================================================
1332 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
1333
1334 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
1335
1336 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=103;
1337
1338 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=403;
1339
1340 --echo #====================================================================================
1341 --echo # multipolygon,multipoint
1342 --echo #====================================================================================
1343 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
1344
1345 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
1346
1347 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
1348
1349 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=403;
1350
1351 --echo #====================================================================================
1352 --echo # multipolygon,linestring
1353 --echo #====================================================================================
1354 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
1355
1356 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
1357
1358 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
1359
1360 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=403;
1361
1362 --echo #====================================================================================
1363 --echo # multipolygon,multilinestring
1364 --echo #====================================================================================
1365 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1366
1367 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
1368
1369 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
1370
1371 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=403;
1372
1373 --echo #====================================================================================
1374 --echo # multipolygon,polygon
1375 --echo #====================================================================================
1376 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
1377
1378 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star));
1379
1380 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
1381
1382 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=103;
1383
1384 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=303;
1385
1386 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=403;
1387
1388 --echo #====================================================================================
1389 --echo # multipolygon,multipolygon
1390 --echo #====================================================================================
1391 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
1392
1393 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
1394
1395 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=103;
1396
1397 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=303;
1398
1399 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
1400
1401 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1402
1403 --echo #====================================================================================
1404 --echo # multipolygon,geometrycollection
1405 --echo #====================================================================================
1406 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
1407
1408 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=103;
1409
1410 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=303;
1411
1412 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
1413
1414 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
1415
1416 --echo #====================================================================================
1417 --echo # geometrycollection,point
1418 --echo #====================================================================================
1419 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
1420
1421 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
1422
1423 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=115;
1424
1425 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=415;
1426
1427 --echo #====================================================================================
1428 --echo # geometrycollection,multipoint
1429 --echo #====================================================================================
1430 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
1431
1432 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
1433
1434 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
1435
1436 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=415;
1437
1438 --echo #====================================================================================
1439 --echo # geometrycollection,linestring
1440 --echo #====================================================================================
1441 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
1442
1443 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
1444
1445 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
1446
1447 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=415;
1448
1449 --echo #====================================================================================
1450 --echo # geometrycollection,multilinestring
1451 --echo #====================================================================================
1452 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1453
1454 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
1455
1456 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
1457
1458 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=415;
1459
1460 --echo #====================================================================================
1461 --echo # geometrycollection,polygon
1462 --echo #====================================================================================
1463 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
1464
1465 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star));
1466
1467 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
1468
1469 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=115;
1470
1471 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=315;
1472
1473 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=415;
1474
1475 --echo #====================================================================================
1476 --echo # geometrycollection,multipolygon
1477 --echo #====================================================================================
1478 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
1479
1480 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
1481
1482 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
1483
1484 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
1485
1486 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
1487
1488 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
1489
1490 --echo #====================================================================================
1491 --echo # geometrycollection,geometrycollection
1492 --echo #====================================================================================
1493 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
1494
1495 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
1496
1497 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
1498
1499 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
1500
1501 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=115;
1502
1503 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1504
1505 --echo #####################################################################################
1506 --echo # Testing with 2 geometries of same SRID
1507 --echo #####################################################################################
1508
1509 --echo #====================================================================================
1510 --echo # MBRINTERSECTS(g1,g2)
1511 --echo #====================================================================================
1512 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
1513
1514 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1515
1516 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000));
1517
1518 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1519
1520 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000));
1521
1522 --error ER_DATA_OUT_OF_RANGE
1523 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
1524
1525 --error ER_DATA_OUT_OF_RANGE
1526 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
1527
1528 --error ER_DATA_OUT_OF_RANGE
1529 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
1530
1531 --echo #====================================================================================
1532 --echo # ST_INTERSECTS(g1,g2)
1533 --echo #====================================================================================
1534 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
1535
1536 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1537
1538 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
1539
1540 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
1541
1542 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1543
1544 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
1545
1546 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
1547
1548 --error ER_DATA_OUT_OF_RANGE
1549 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
1550
1551 --error ER_DATA_OUT_OF_RANGE
1552 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
1553
1554 --error ER_DATA_OUT_OF_RANGE
1555 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
1556
1557 --echo #####################################################################################
1558 --echo # Invalid function calls
1559 --echo #####################################################################################
1560
1561 --echo #====================================================================================
1562 --echo # ST_INTERSECTS(g1,g2)
1563 --echo #====================================================================================
1564 --error ER_GIS_DIFFERENT_SRIDS
1565 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
1566
1567 --error ER_GIS_DIFFERENT_SRIDS
1568 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
1569
1570 --error ER_GIS_DIFFERENT_SRIDS
1571 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
1572
1573 SELECT ST_INTERSECTS(NULL,ST_GEOMFROMTEXT(@star_top));
1574
1575 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),NULL);
1576
1577 SELECT ST_INTERSECTS(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1578
1579 SELECT ST_INTERSECTS(NULL,NULL);
1580
1581 SELECT ST_INTERSECTS(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1582
1583 --error ER_GIS_INVALID_DATA
1584 SELECT ST_INTERSECTS(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1585
1586 --error ER_GIS_INVALID_DATA
1587 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1588
1589 --error ER_GIS_INVALID_DATA
1590 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1591
1592 --error ER_GIS_INVALID_DATA
1593 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1594
1595 --error ER_PARSE_ERROR
1596 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1597
1598 --error ER_GIS_INVALID_DATA
1599 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1600
1601 --error ER_GIS_INVALID_DATA
1602 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1603
1604 --error ER_GIS_INVALID_DATA
1605 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1606
1607 --error ER_PARSE_ERROR
1608 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1609
1610 --error ER_GIS_INVALID_DATA
1611 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1612
1613 --error ER_GIS_INVALID_DATA
1614 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1615
1616 --error ER_GIS_INVALID_DATA
1617 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1618
1619 --error ER_PARSE_ERROR
1620 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1621
1622 --error ER_GIS_INVALID_DATA
1623 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1624
1625 --error ER_GIS_INVALID_DATA
1626 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1627
1628 --error ER_PARSE_ERROR
1629 SELECT ST_INTERSECTS(,);
1630
1631 --error ER_PARSE_ERROR
1632 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),);
1633
1634 --error ER_PARSE_ERROR
1635 SELECT ST_INTERSECTS(,ST_GEOMFROMTEXT(@star_top));
1636
1637 --echo #====================================================================================
1638 --echo # MBRINTERSECTS(g1,g2)
1639 --echo #====================================================================================
1640 --error ER_GIS_DIFFERENT_SRIDS
1641 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
1642
1643 --error ER_GIS_DIFFERENT_SRIDS
1644 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
1645
1646 --error ER_GIS_DIFFERENT_SRIDS
1647 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
1648
1649 SELECT MBRINTERSECTS(NULL,ST_GEOMFROMTEXT(@star_top));
1650
1651 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),NULL);
1652
1653 SELECT MBRINTERSECTS(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1654
1655 SELECT MBRINTERSECTS(NULL,NULL);
1656
1657 SELECT MBRINTERSECTS(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1658
1659 --error ER_GIS_INVALID_DATA
1660 SELECT MBRINTERSECTS(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1661
1662 --error ER_GIS_INVALID_DATA
1663 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1664
1665 --error ER_GIS_INVALID_DATA
1666 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1667
1668 --error ER_GIS_INVALID_DATA
1669 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1670
1671 --error ER_PARSE_ERROR
1672 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1673
1674 --error ER_GIS_INVALID_DATA
1675 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1676
1677 --error ER_GIS_INVALID_DATA
1678 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1679
1680 --error ER_GIS_INVALID_DATA
1681 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1682
1683 --error ER_PARSE_ERROR
1684 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1685
1686 --error ER_GIS_INVALID_DATA
1687 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1688
1689 --error ER_GIS_INVALID_DATA
1690 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1691
1692 --error ER_GIS_INVALID_DATA
1693 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1694
1695 --error ER_PARSE_ERROR
1696 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1697
1698 --error ER_GIS_INVALID_DATA
1699 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1700
1701 --error ER_GIS_INVALID_DATA
1702 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1703
1704 --error ER_PARSE_ERROR
1705 SELECT MBRINTERSECTS(,);
1706
1707 --error ER_PARSE_ERROR
1708 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),);
1709
1710 --error ER_PARSE_ERROR
1711 SELECT MBRINTERSECTS(,ST_GEOMFROMTEXT(@star_top));
1712
1713 # Test with all combinations of geometry types, including types inside geometry collections
1714
1715 CREATE TABLE t1 (g GEOMETRY NOT NULL);
1716
1717 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POINT(1 1)'));
1718 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'));
1719 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
1720 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1721 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4))'));
1722 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTIPOINT(1 1, 2 2)'));
1723 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2),'
1724 '(3 3, 4 4))'));
1725 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1726 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)),((5 5, 10 5, 10 10, 5 10, 5 5)))'));
1727 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1728 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
1729 '(6 6, 7 6, 7 7, 6 7, 6 6)))'));
1730 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1731 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((1 1, 10 1, 10 10, 1 10, 1 1), '
1732 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
1733 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'));
1734 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1735 'GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'));
1736 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0, 1 0, 1'
1737 ' 1, 0 1, 0 0)))'));
1738 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1739 'GEOMETRYCOLLECTION(POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), '
1740 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
1741 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1742 'GEOMETRYCOLLECTION(MULTIPOINT(1 1, 2 2))'));
1743 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1744 'GEOMETRYCOLLECTION(MULTILINESTRING((1 1, 2 2), (3 3, 4 4)))'));
1745 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1746 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1747 '((5 5, 10 5, 10 10, 5 10, 5 5))))'));
1748 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1749 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1750 '((5 5, 10 5, 10 10, 5 10, 5 5), (6 6, 7 6, 7 7, 6 7, 6 6))))'));
1751 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1752 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1753 '((1 1, 10 1, 10 10, 1 10, 1 1), (4 4, 6 4, 6 6, 4 6, 4 4))))'));
1754 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1755 'GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(1 1, 2 2),'
1756 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)),'
1757 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4)),'
1758 'MULTIPOINT(1 1, 2 2),MULTILINESTRING((1 1, 2 2), (3 3, 4 4)),'
1759 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))),'
1760 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
1761 '(6 6, 7 6, 7 7, 6 7, 6 6))))'));
1762
1763 INSERT INTO t1 VALUES(
1764 GEOMETRYCOLLECTION(POINT(1,1),LINESTRING(POINT(1,1),POINT(2,2)),
1765 POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0))),
1766 POLYGON(LINESTRING(POINT(0,0),POINT(10,0),POINT(10,10),POINT(0,10),
1767 POINT(0,0)),LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),POINT(4,6),
1768 POINT(4,4))),MULTIPOINT(POINT(1,1),POINT(2,2)),
1769 MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),LINESTRING(POINT(3,3),
1770 POINT(4,4))),MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
1771 POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1772 POINT(10,10),POINT(5,10),POINT(5,5)))),
1773 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),
1774 POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),POINT(10,10),
1775 POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),POINT(7,7),
1776 POINT(6,7),POINT(6,6)))),GEOMETRYCOLLECTION(POINT(1,1)),
1777 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
1778 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
1779 POINT(0,1),POINT(0,0)))),GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),
1780 POINT(10,0),POINT(10,10),POINT(0,10),POINT(0,0)),LINESTRING(POINT(4,4),
1781 POINT(6,4),POINT(6,6),POINT(4,6),POINT(4,4)))),
1782 GEOMETRYCOLLECTION(MULTIPOINT(POINT(1,1),POINT(2,2))),
1783 GEOMETRYCOLLECTION(MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),
1784 LINESTRING(POINT(3,3),POINT(4,4)))),
1785 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
1786 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1787 POINT(10,10),POINT(5,10),POINT(5,5))))),
1788 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
1789 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1790 POINT(10,10),POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),
1791 POINT(7,7),POINT(6,7),POINT(6,6)))))));
1792 INSERT INTO t1 VALUES (
1793 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1,1)),
1794 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
1795 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(1,1), POINT(10,1), POINT(10,10),
1796 POINT(1,10), POINT(1,1)), LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),
1797 POINT(4,6),POINT(4,4))))));
1798
1799 # We don't care about the result. We just want to put all parameter type
1800 # combinations through the function.
1801 --disable_result_log
1802 SELECT ST_INTERSECTS(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
1803 SELECT MBRINTERSECTS(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
1804
1805 SELECT ST_INTERSECTS(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
1806 FROM t1 AS a JOIN t1 AS b;
1807 SELECT MBRINTERSECTS(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
1808 FROM t1 AS a JOIN t1 AS b;
1809 --enable_result_log
1810
1811 --echo # clean up
1812 DROP TABLE t1;
1813 DROP TABLE gis_geometrycollection;
1814 DROP TABLE gis_geometrycollection_2;
1815
1816 --echo #
1817 --echo # WL#8579 Spatial Reference Systems
1818 --echo #
1819
1820 --echo # SRID 0 (should pass)
1821 SELECT ST_INTERSECTS(
1822 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1823 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1824 );
1825 SELECT MBRINTERSECTS(
1826 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1827 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1828 );
1829
1830 --echo # Projected SRS (should pass)
1831 SELECT ST_INTERSECTS(
1832 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1833 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1834 );
1835 SELECT MBRINTERSECTS(
1836 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1837 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1838 );
1839
1840 --echo # Geographic SRS (should pass)
1841 SELECT ST_INTERSECTS(
1842 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1843 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1844 );
1845 SELECT MBRINTERSECTS(
1846 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1847 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1848 );
1849
1850 --echo #
1851 --echo # WL#10827 Ellipsoidal R-tree support functions
1852 --echo #
1853
1854 SET @pt = ST_GeomFromText('POINT(0 0)', 4326);
1855
1856 # SRID=4326, long=0, lat=-91.
1857 SET @pt_lat_minus_91 = x'E6100000010100000000000000000000000000000000C056C0';
1858
1859 # SRID=4326, long=0, lat=91.
1860 SET @pt_lat_plus_91 = x'E6100000010100000000000000000000000000000000C05640';
1861
1862 # SRID=4326, long=-181, lat=0.
1863 SET @pt_long_minus_181 = x'E610000001010000000000000000A066C00000000000000000';
1864
1865 # SRID=4326, long=181, lat=0.
1866 SET @pt_long_plus_181 = x'E610000001010000000000000000A066400000000000000000';
1867
1868 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1869 SELECT ST_Intersects(@pt_lat_minus_91, @pt);
1870 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1871 SELECT ST_Intersects(@pt_lat_plus_91, @pt);
1872 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1873 SELECT ST_Intersects(@pt_long_minus_181, @pt);
1874 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1875 SELECT ST_Intersects(@pt_long_plus_181, @pt);
1876 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1877 SELECT MBRIntersects(@pt_lat_minus_91, @pt);
1878 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1879 SELECT MBRIntersects(@pt_lat_plus_91, @pt);
1880 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1881 SELECT MBRIntersects(@pt_long_minus_181, @pt);
1882 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1883 SELECT MBRIntersects(@pt_long_plus_181, @pt);
1884
1885 CREATE TABLE t1 (
1886 id INT,
1887 c GEOMETRY NOT NULL SRID 0,
1888 g GEOMETRY AS (ST_SRID(c, 4326)) STORED NOT NULL SRID 4326,
1889 SPATIAL INDEX c_idx (c),
1890 SPATIAL INDEX g_idx (g)
1891 );
1892
1893 INSERT INTO t1 (id, c) VALUES
1894 (0, ST_GeomFromText('POINT(0 0)')),
1895 (1, ST_GeomFromText('POINT(1 1)')),
1896 (2, ST_GeomFromText('POINT(2 2)')),
1897 (3, ST_GeomFromText('POINT(3 3)')),
1898 (4, ST_GeomFromText('POINT(4 4)')),
1899 (5, ST_GeomFromText('POINT(5 5.00001)')),
1900 (6, ST_GeomFromText('POINT(6 6)')),
1901 (7, ST_GeomFromText('POINT(7 7)'));
1902
1903 SET @py = 'POLYGON((0 0, 10 0, 10 5, 0 5, 0 0))';
1904 SET @cart_py = ST_GeomFromText(@py);
1905 SET @geo_py = ST_GeomFromText(@py, 4326, 'axis-order=long-lat');
1906
1907 SET @mpt = 'MULTIPOINT((0 0), (10 5))';
1908 SET @cart_mpt = ST_GeomFromText(@mpt);
1909 SET @geo_mpt = ST_GeomFromText(@mpt, 4326, 'axis-order=long-lat');
1910
1911 --echo # Cartesian ST_Intersects
1912 SELECT id, ST_AsText(c)
1913 FROM t1 IGNORE INDEX(c_idx)
1914 WHERE ST_Intersects(c, @cart_py)
1915 ORDER BY id;
1916 SELECT id, ST_AsText(c)
1917 FROM t1 FORCE INDEX(c_idx)
1918 WHERE ST_Intersects(c, @cart_py)
1919 ORDER BY id;
1920
1921 --echo # Geographic ST_Intersects
1922 SELECT id, ST_AsText(g)
1923 FROM t1 IGNORE INDEX(g_idx)
1924 WHERE ST_Intersects(g, @geo_py)
1925 ORDER BY id;
1926 SELECT id, ST_AsText(g)
1927 FROM t1 FORCE INDEX(g_idx)
1928 WHERE ST_Intersects(g, @geo_py)
1929 ORDER BY id;
1930
1931 --echo # Cartesian MBRIntersects
1932 SELECT id, ST_AsText(c)
1933 FROM t1 IGNORE INDEX(c_idx)
1934 WHERE MBRIntersects(c, @cart_py)
1935 ORDER BY id;
1936 SELECT id, ST_AsText(c)
1937 FROM t1 FORCE INDEX(c_idx)
1938 WHERE MBRIntersects(c, @cart_py)
1939 ORDER BY id;
1940 SELECT id, ST_AsText(c)
1941 FROM t1 IGNORE INDEX(c_idx)
1942 WHERE MBRIntersects(c, @cart_mpt)
1943 ORDER BY id;
1944 SELECT id, ST_AsText(c)
1945 FROM t1 FORCE INDEX(c_idx)
1946 WHERE MBRIntersects(c, @cart_mpt)
1947 ORDER BY id;
1948
1949 --echo # Geographic MBRIntersects
1950 SELECT id, ST_AsText(g)
1951 FROM t1 IGNORE INDEX(g_idx)
1952 WHERE MBRIntersects(g, @geo_py)
1953 ORDER BY id;
1954 SELECT id, ST_AsText(g)
1955 FROM t1 FORCE INDEX(g_idx)
1956 WHERE MBRIntersects(g, @geo_py)
1957 ORDER BY id;
1958 SELECT id, ST_AsText(g)
1959 FROM t1 IGNORE INDEX(g_idx)
1960 WHERE MBRIntersects(g, @geo_mpt)
1961 ORDER BY id;
1962 SELECT id, ST_AsText(g)
1963 FROM t1 FORCE INDEX(g_idx)
1964 WHERE MBRIntersects(g, @geo_mpt)
1965 ORDER BY id;
1966
1967 DROP TABLE t1;
1968
1969 --echo #
1970 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
1971 --echo #
1972
1973 --echo # Assume SRID 10 is not defined.
1974 --error ER_SRS_NOT_FOUND
1975 DO MBRINTERSECTS(
1976 x'0A000000010100000000000000000000000000000000000000',
1977 x'0A000000010100000000000000000000000000000000000000'
1978 );
1979 --error ER_SRS_NOT_FOUND
1980 DO ST_INTERSECTS(
1981 x'0A000000010100000000000000000000000000000000000000',
1982 x'0A000000010100000000000000000000000000000000000000'
1983 );