Debian Codegraph @

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