Debian Codegraph @

mysql-test/suite/gis/t/spatial_testing_functions_covers.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 # MBRCOVERS(g1,g2)
208 --echo #####################################################################################
209
210 --echo #====================================================================================
211 --echo # point,point
212 --echo #====================================================================================
213 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
214
215 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
216
217 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=105;
218
219 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
220
221 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
222
223 --echo #====================================================================================
224 --echo # point,multipoint
225 --echo #====================================================================================
226 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
227
228 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=106;
229
230 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
231
232 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
233
234 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
235
236 --echo #====================================================================================
237 --echo # point,linestring
238 --echo #====================================================================================
239 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
240
241 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
242
243 --error ER_GIS_INVALID_DATA
244 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0)'));
245
246 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
247
248 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
249
250 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
251
252 --echo #====================================================================================
253 --echo # point,multilinestring
254 --echo #====================================================================================
255 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
256
257 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
258
259 --error ER_GIS_INVALID_DATA
260 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0))'));
261
262 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
263
264 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
265
266 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
267
268 --echo #====================================================================================
269 --echo # point,polygon
270 --echo #====================================================================================
271 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
272
273 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=104;
274
275 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
276
277 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
278
279 SELECT MBRCOVERS(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))'));
280
281 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
282
283 --echo #====================================================================================
284 --echo # point,multipolygon
285 --echo #====================================================================================
286 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
287
288 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
289
290 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
291
292 SELECT MBRCOVERS(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)))'));
293
294 SELECT MBRCOVERS(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)))'));
295
296 --echo #====================================================================================
297 --echo # point,geometrycollection
298 --echo #====================================================================================
299 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
300
301 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
302
303 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
304
305 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
306
307 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
308
309 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
310
311 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
312
313 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
314
315 --echo #====================================================================================
316 --echo # multipoint,point
317 --echo #====================================================================================
318 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
319
320 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
321
322 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
323
324 --echo #====================================================================================
325 --echo # multipoint,multipoint
326 --echo #====================================================================================
327 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points));
328
329 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
330
331 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=108;
332
333 --echo #====================================================================================
334 --echo # multipoint,linestring
335 --echo #====================================================================================
336 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
337
338 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=109;
339
340 --echo #====================================================================================
341 --echo # multipoint,multilinestring
342 --echo #====================================================================================
343 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
344
345 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
346
347 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=109;
348
349 --echo #====================================================================================
350 --echo # multipoint,polygon
351 --echo #====================================================================================
352 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical));
353
354 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
355
356 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=109;
357
358 --echo #====================================================================================
359 --echo # multipoint,multipolygon
360 --echo #====================================================================================
361 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems));
362
363 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
364
365 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=109;
366
367 --echo #====================================================================================
368 --echo # multipoint,geometrycollection
369 --echo #====================================================================================
370 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems));
371
372 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
373
374 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=109;
375
376 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr));
377
378 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(5 5,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
379
380 --echo #====================================================================================
381 --echo # linestring,point
382 --echo #====================================================================================
383 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
384
385 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
386
387 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
388
389 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
390
391 --echo #====================================================================================
392 --echo # linestring,multipoint
393 --echo #====================================================================================
394 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
395
396 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
397
398 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=111;
399
400 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
401
402 --echo #====================================================================================
403 --echo # linestring,linestring
404 --echo #====================================================================================
405 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
406
407 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
408
409 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=111;
410
411 --echo #====================================================================================
412 --echo # linestring,multilinestring
413 --echo #====================================================================================
414 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
415
416 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical));
417
418 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=110;
419
420 --echo #====================================================================================
421 --echo # linestring,polygon
422 --echo #====================================================================================
423 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
424
425 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
426
427 --error ER_GIS_INVALID_DATA
428 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,11 15))')) FROM gis_geometrycollection WHERE fid=110;
429
430 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
431
432 --echo #====================================================================================
433 --echo # linestring,multipolygon
434 --echo #====================================================================================
435 --error ER_GIS_INVALID_DATA
436 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))'));
437
438 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
439
440 --error ER_GIS_INVALID_DATA
441 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))')) FROM gis_geometrycollection WHERE fid=110;
442
443 --echo #====================================================================================
444 --echo # linestring,geometrycollection
445 --echo #====================================================================================
446 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
447
448 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
449
450 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems_3)) FROM gis_geometrycollection WHERE fid=110;
451
452 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
453
454 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
455
456 --echo #====================================================================================
457 --echo # multilinestring,point
458 --echo #====================================================================================
459 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
460
461 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
462
463 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
464
465 --echo #====================================================================================
466 --echo # multilinestring,multipoint
467 --echo #====================================================================================
468 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points));
469
470 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
471
472 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=114;
473
474 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
475
476 --echo #====================================================================================
477 --echo # multilinestring,linestring
478 --echo #====================================================================================
479 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
480
481 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
482
483 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
484
485 --echo #====================================================================================
486 --echo # multilinestring,multilinestring
487 --echo #====================================================================================
488 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'));
489
490 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
491
492 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
493
494 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
495
496 --echo #====================================================================================
497 --echo # multilinestring,polygon
498 --echo #====================================================================================
499 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical));
500
501 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
502
503 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
504
505 --echo #====================================================================================
506 --echo # multilinestring,multipolygon
507 --echo #====================================================================================
508 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical));
509
510 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
511
512 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=114;
513
514 --echo #====================================================================================
515 --echo # multilinestring,geometrycollection
516 --echo #====================================================================================
517 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems));
518
519 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
520
521 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=114;
522
523 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr));
524
525 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
526
527 --echo #====================================================================================
528 --echo # polygon,point
529 --echo #====================================================================================
530 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
531
532 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
533
534 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
535
536 --echo #====================================================================================
537 --echo # polygon,multipoint
538 --echo #====================================================================================
539 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points));
540
541 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
542
543 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
544
545 --echo #====================================================================================
546 --echo # polygon,linestring
547 --echo #====================================================================================
548 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical));
549
550 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
551
552 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=100;
553
554 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
555
556 --echo #====================================================================================
557 --echo # polygon,multilinestring
558 --echo #====================================================================================
559 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical));
560
561 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
562
563 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=100;
564
565 --echo #====================================================================================
566 --echo # polygon,polygon
567 --echo #====================================================================================
568 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical));
569
570 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
571
572 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=100;
573
574 --echo #====================================================================================
575 --echo # polygon,multipolygon
576 --echo #====================================================================================
577 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems));
578
579 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
580
581 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
582
583 --echo #====================================================================================
584 --echo # polygon,geometrycollection
585 --echo #====================================================================================
586 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems));
587
588 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
589
590 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
591
592 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
593
594 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
595
596 --echo #====================================================================================
597 --echo # multipolygon,point
598 --echo #====================================================================================
599 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
600
601 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
602
603 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=103;
604
605 --echo #====================================================================================
606 --echo # multipolygon,multipoint
607 --echo #====================================================================================
608 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
609
610 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
611
612 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
613
614 --echo #====================================================================================
615 --echo # multipolygon,linestring
616 --echo #====================================================================================
617 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
618
619 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
620
621 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
622
623 --echo #====================================================================================
624 --echo # multipolygon,multilinestring
625 --echo #====================================================================================
626 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
627
628 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
629
630 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
631
632 --echo #====================================================================================
633 --echo # multipolygon,polygon
634 --echo #====================================================================================
635 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
636
637 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star));
638
639 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
640
641 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=103;
642
643 --echo #====================================================================================
644 --echo # multipolygon,multipolygon
645 --echo #====================================================================================
646 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
647
648 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
649
650 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=103;
651
652 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
653
654 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
655
656 --echo #====================================================================================
657 --echo # multipolygon,geometrycollection
658 --echo #====================================================================================
659 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
660
661 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
662
663 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=103;
664
665 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=215;
666
667 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
668
669 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
670
671 --echo #====================================================================================
672 --echo # geometrycollection,point
673 --echo #====================================================================================
674 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
675
676 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
677
678 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=115;
679
680 Select MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)))'),ST_GEOMFROMTEXT('POINT(100 100)'));
681
682 Select MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('POINT(100 100)'));
683
684 --echo #====================================================================================
685 --echo # geometrycollection,multipoint
686 --echo #====================================================================================
687 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
688
689 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
690
691 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
692
693 SELECT MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('MULTIPOINT(5 0,10 0)'));
694
695 --echo #====================================================================================
696 --echo # geometrycollection,linestring
697 --echo #====================================================================================
698 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
699
700 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
701
702 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
703
704 SELECT MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('LINESTRING(5 0,10 0)'));
705
706 --echo #====================================================================================
707 --echo # geometrycollection,multilinestring
708 --echo #====================================================================================
709 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
710
711 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
712
713 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
714
715 --echo #====================================================================================
716 --echo # geometrycollection,polygon
717 --echo #====================================================================================
718 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
719
720 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star));
721
722 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
723
724 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=115;
725
726 --echo #====================================================================================
727 --echo # geometrycollection,multipolygon
728 --echo #====================================================================================
729 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
730
731 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
732
733 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
734
735 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=103;
736
737 --echo #====================================================================================
738 --echo # geometrycollection,geometrycollection
739 --echo #====================================================================================
740 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
741
742 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
743
744 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
745
746 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=215;
747
748 --echo #####################################################################################
749 --echo # Testing MBRCOVERS() with 2 geometries of same SRID
750 --echo #####################################################################################
751
752 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
753
754 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
755
756 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
757
758 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
759
760 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
761
762 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
763
764 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
765
766 --error ER_DATA_OUT_OF_RANGE
767 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
768
769 --error ER_DATA_OUT_OF_RANGE
770 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
771
772 --error ER_DATA_OUT_OF_RANGE
773 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
774
775 --echo #####################################################################################
776 --echo # Invalid function calls
777 --echo #####################################################################################
778 --error ER_GIS_DIFFERENT_SRIDS
779 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
780
781 --error ER_GIS_DIFFERENT_SRIDS
782 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
783
784 --error ER_GIS_DIFFERENT_SRIDS
785 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
786
787 SELECT MBRCOVERS(NULL,ST_GEOMFROMTEXT(@star_top));
788
789 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),NULL);
790
791 SELECT MBRCOVERS(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
792
793 SELECT MBRCOVERS(NULL,NULL);
794
795 SELECT MBRCOVERS(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
796
797 --error ER_GIS_INVALID_DATA
798 SELECT MBRCOVERS(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
799
800 --error ER_GIS_INVALID_DATA
801 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
802
803 --error ER_GIS_INVALID_DATA
804 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
805
806 --error ER_GIS_INVALID_DATA
807 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
808
809 --error ER_PARSE_ERROR
810 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
811
812 --error ER_GIS_INVALID_DATA
813 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
814
815 --error ER_GIS_INVALID_DATA
816 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
817
818 --error ER_GIS_INVALID_DATA
819 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
820
821 --error ER_PARSE_ERROR
822 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
823
824 --error ER_GIS_INVALID_DATA
825 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
826
827 --error ER_GIS_INVALID_DATA
828 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
829
830 --error ER_GIS_INVALID_DATA
831 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
832
833 --error ER_PARSE_ERROR
834 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
835
836 --error ER_GIS_INVALID_DATA
837 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
838
839 --error ER_GIS_INVALID_DATA
840 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
841
842 --error ER_PARSE_ERROR
843 SELECT MBRCOVERS(,);
844
845 --error ER_PARSE_ERROR
846 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),);
847
848 --error ER_PARSE_ERROR
849 SELECT MBRCOVERS(,ST_GEOMFROMTEXT(@star_top));
850
851 # Test with all combinations of geometry types, including types inside geometry collections
852
853 CREATE TABLE t1 (g GEOMETRY NOT NULL);
854
855 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POINT(1 1)'));
856 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'));
857 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
858 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
859 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4))'));
860 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTIPOINT(1 1, 2 2)'));
861 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2),'
862 '(3 3, 4 4))'));
863 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
864 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)),((5 5, 10 5, 10 10, 5 10, 5 5)))'));
865 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
866 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
867 '(6 6, 7 6, 7 7, 6 7, 6 6)))'));
868 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
869 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((1 1, 10 1, 10 10, 1 10, 1 1), '
870 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
871 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'));
872 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
873 'GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'));
874 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0, 1 0, 1'
875 ' 1, 0 1, 0 0)))'));
876 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
877 'GEOMETRYCOLLECTION(POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), '
878 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
879 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
880 'GEOMETRYCOLLECTION(MULTIPOINT(1 1, 2 2))'));
881 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
882 'GEOMETRYCOLLECTION(MULTILINESTRING((1 1, 2 2), (3 3, 4 4)))'));
883 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
884 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
885 '((5 5, 10 5, 10 10, 5 10, 5 5))))'));
886 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
887 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
888 '((5 5, 10 5, 10 10, 5 10, 5 5), (6 6, 7 6, 7 7, 6 7, 6 6))))'));
889 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
890 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
891 '((1 1, 10 1, 10 10, 1 10, 1 1), (4 4, 6 4, 6 6, 4 6, 4 4))))'));
892 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
893 'GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(1 1, 2 2),'
894 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)),'
895 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4)),'
896 'MULTIPOINT(1 1, 2 2),MULTILINESTRING((1 1, 2 2), (3 3, 4 4)),'
897 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))),'
898 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
899 '(6 6, 7 6, 7 7, 6 7, 6 6))))'));
900
901 INSERT INTO t1 VALUES(
902 GEOMETRYCOLLECTION(POINT(1,1),LINESTRING(POINT(1,1),POINT(2,2)),
903 POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0))),
904 POLYGON(LINESTRING(POINT(0,0),POINT(10,0),POINT(10,10),POINT(0,10),
905 POINT(0,0)),LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),POINT(4,6),
906 POINT(4,4))),MULTIPOINT(POINT(1,1),POINT(2,2)),
907 MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),LINESTRING(POINT(3,3),
908 POINT(4,4))),MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
909 POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
910 POINT(10,10),POINT(5,10),POINT(5,5)))),
911 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),
912 POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),POINT(10,10),
913 POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),POINT(7,7),
914 POINT(6,7),POINT(6,6)))),GEOMETRYCOLLECTION(POINT(1,1)),
915 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
916 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
917 POINT(0,1),POINT(0,0)))),GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),
918 POINT(10,0),POINT(10,10),POINT(0,10),POINT(0,0)),LINESTRING(POINT(4,4),
919 POINT(6,4),POINT(6,6),POINT(4,6),POINT(4,4)))),
920 GEOMETRYCOLLECTION(MULTIPOINT(POINT(1,1),POINT(2,2))),
921 GEOMETRYCOLLECTION(MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),
922 LINESTRING(POINT(3,3),POINT(4,4)))),
923 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
924 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
925 POINT(10,10),POINT(5,10),POINT(5,5))))),
926 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
927 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
928 POINT(10,10),POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),
929 POINT(7,7),POINT(6,7),POINT(6,6)))))));
930 INSERT INTO t1 VALUES (
931 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1,1)),
932 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
933 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(1,1), POINT(10,1), POINT(10,10),
934 POINT(1,10), POINT(1,1)), LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),
935 POINT(4,6),POINT(4,4))))));
936
937 # We don't care about the result. We just want to put all parameter type
938 # combinations through the function.
939 --disable_result_log
940 SELECT MBRCOVERS(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
941
942 SELECT MBRCOVERS(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
943 FROM t1 AS a JOIN t1 AS b;
944 --enable_result_log
945
946 --echo # clean up
947 DROP TABLE t1;
948 DROP TABLE gis_geometrycollection;
949 DROP TABLE gis_geometrycollection_2;
950
951 --echo #
952 --echo # WL#8579 Spatial Reference Systems
953 --echo #
954
955 --echo # SRID 0 (should pass)
956 SELECT MBRCOVERS(
957 ST_GEOMFROMTEXT('POINT(0 0)', 0),
958 ST_GEOMFROMTEXT('POINT(0 0)', 0)
959 );
960
961 --echo # Projected SRS (should pass)
962 SELECT MBRCOVERS(
963 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
964 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
965 );
966
967 --echo # Geographic SRS (should pass)
968 SELECT MBRCOVERS(
969 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
970 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
971 );
972
973 --echo #
974 --echo # WL#10827 Ellipsoidal R-tree support functions
975 --echo #
976
977 SET @pt = ST_GeomFromText('POINT(0 0)', 4326);
978
979 # SRID=4326, long=0, lat=-91.
980 SET @pt_lat_minus_91 = x'E6100000010100000000000000000000000000000000C056C0';
981
982 # SRID=4326, long=0, lat=91.
983 SET @pt_lat_plus_91 = x'E6100000010100000000000000000000000000000000C05640';
984
985 # SRID=4326, long=-181, lat=0.
986 SET @pt_long_minus_181 = x'E610000001010000000000000000A066C00000000000000000';
987
988 # SRID=4326, long=181, lat=0.
989 SET @pt_long_plus_181 = x'E610000001010000000000000000A066400000000000000000';
990
991 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
992 SELECT MBRCovers(@pt_lat_minus_91, @pt);
993 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
994 SELECT MBRCovers(@pt_lat_plus_91, @pt);
995 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
996 SELECT MBRCovers(@pt_long_minus_181, @pt);
997 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
998 SELECT MBRCovers(@pt_long_plus_181, @pt);
999
1000 CREATE TABLE t1 (
1001 id INT,
1002 c GEOMETRY NOT NULL SRID 0,
1003 g GEOMETRY AS (ST_SRID(c, 4326)) STORED NOT NULL SRID 4326,
1004 SPATIAL INDEX c_idx (c),
1005 SPATIAL INDEX g_idx (g)
1006 );
1007
1008 INSERT INTO t1 (id, c) VALUES
1009 (0, ST_GeomFromText('POINT(0 0)')),
1010 (1, ST_GeomFromText('POINT(1 1)')),
1011 (2, ST_GeomFromText('POINT(2 2)')),
1012 (3, ST_GeomFromText('POINT(3 3)')),
1013 (4, ST_GeomFromText('POINT(4 4)')),
1014 (5, ST_GeomFromText('POINT(5 5.00001)')),
1015 (6, ST_GeomFromText('POINT(6 6)')),
1016 (7, ST_GeomFromText('POINT(7 7)'));
1017
1018 SET @py = 'POLYGON((0 0, 10 0, 10 5, 0 5, 0 0))';
1019 SET @cart_py = ST_GeomFromText(@py);
1020 SET @geo_py = ST_GeomFromText(@py, 4326, 'axis-order=long-lat');
1021
1022 SET @mpt = 'MULTIPOINT((0 0), (10 5))';
1023 SET @cart_mpt = ST_GeomFromText(@mpt);
1024 SET @geo_mpt = ST_GeomFromText(@mpt, 4326, 'axis-order=long-lat');
1025
1026 --echo # Cartesian MBRCovers
1027 SELECT id, ST_AsText(c)
1028 FROM t1 IGNORE INDEX(c_idx)
1029 WHERE MBRCovers(@cart_py, c)
1030 ORDER BY id;
1031 SELECT id, ST_AsText(c)
1032 FROM t1 FORCE INDEX(c_idx)
1033 WHERE MBRCovers(@cart_py, c)
1034 ORDER BY id;
1035 SELECT id, ST_AsText(c)
1036 FROM t1 IGNORE INDEX(c_idx)
1037 WHERE MBRCovers(@cart_mpt, c)
1038 ORDER BY id;
1039 SELECT id, ST_AsText(c)
1040 FROM t1 FORCE INDEX(c_idx)
1041 WHERE MBRCovers(@cart_mpt, c)
1042 ORDER BY id;
1043
1044 --echo # Geographic MBRCovers
1045 SELECT id, ST_AsText(g)
1046 FROM t1 IGNORE INDEX(g_idx)
1047 WHERE MBRCovers(@geo_py, g)
1048 ORDER BY id;
1049 SELECT id, ST_AsText(g)
1050 FROM t1 FORCE INDEX(g_idx)
1051 WHERE MBRCovers(@geo_py, g)
1052 ORDER BY id;
1053 SELECT id, ST_AsText(g)
1054 FROM t1 IGNORE INDEX(g_idx)
1055 WHERE MBRCovers(@geo_mpt, g)
1056 ORDER BY id;
1057 SELECT id, ST_AsText(g)
1058 FROM t1 FORCE INDEX(g_idx)
1059 WHERE MBRCovers(@geo_mpt, g)
1060 ORDER BY id;
1061
1062 DROP TABLE t1;
1063
1064 --echo #
1065 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
1066 --echo #
1067
1068 --echo # Assume SRID 10 is not defined.
1069 --error ER_SRS_NOT_FOUND
1070 DO MBRCOVERS(
1071 x'0A000000010100000000000000000000000000000000000000',
1072 x'0A000000010100000000000000000000000000000000000000'
1073 );