Debian Codegraph @

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