Debian Codegraph @

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