Debian Codegraph @

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

raw
1 # Disabled on Windows ASAN due to https://bugs.llvm.org/show_bug.cgi?id=35365
2 --source include/not_asan_windows.inc
3
4 ###############################################################################
5 # #
6 # This test is aimed to focus on Functions for testing Relations between #
7 # Geometry Objects. #
8 # #
9 # These functions take 2 geometries as inpout parameters and return #
10 # a qualitative or quantitavive realtion between themrealtion between them. #
11 # #
12 # Creation Date: 2013-12-16 #
13 # Author : Horst Hunger #
14 # #
15 ###############################################################################
16
17
18 ############################################################################################
19 # Creating the spatial objects #
20 ############################################################################################
21
22 --echo #Creating the spatial Geometry object
23 USE test;
24
25 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
26
27 ############################################################################################
28 # Inserting the values specific to the spatial objects #
29 ############################################################################################
30
31 # Geometric elements constructing a star and some of its elememts as base
32 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
33 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
34 SET @star_center= 'POINT(15 10)';
35 SET @star_top= 'POINT(15 25)';
36 SET @star_bottom_left= 'POINT(5 0)';
37 SET @star_bottom_right= 'POINT(25 0)';
38 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
39 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
40 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
41 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
42 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
43 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
44 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
45 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))';
46 SET @star_elem_vertical_val= '((5 0,15 25,25 0,15 5,5 0))';
47 SET @star_elem_horizontal_val= '((25 0,0 15,30 15,22 10,25 0))';
48 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)))';
49 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))';
50 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))';
51
52 # Star identical to the base star
53 SET @star_elem_vertical_1= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
54 SET @star_elem_horizontal_1= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
55 SET @star_center_1= 'POINT(15 10)';
56 SET @star_top_1= 'POINT(15 25)';
57 SET @star_bottom_left_1= 'POINT(5 0)';
58 SET @star_bottom_right_1= 'POINT(25 0)';
59 SET @star_bottom_points_1= 'MULTIPOINT(5 0,25 0)';
60 SET @star_all_points_1= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
61 SET @star_line_horizontal_1= 'LINESTRING(10 15,20 15)';
62 SET @star_line_vertical_1= 'LINESTRING(15 5,15 25)';
63 SET @star_top_to_center_1= 'LINESTRING(15 25,15 10)';
64 SET @star_lines_near_horizontal_1= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
65 SET @star_lines_near_vertical_1= 'MULTILINESTRING((0 5,15 25,0 25))';
66 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))';
67 SET @star_elem_vertical_val_1= '((5 0,15 25,25 0,15 5,5 0))';
68 SET @star_elem_horizontal_val_1= '((25 0,0 15,30 15,22 10,25 0))';
69 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)))';
70 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))';
71
72 # Star like the base star, but shifted to right by 10 on X to overlap base star
73 SET @star_elem_vertical_2= 'POLYGON((15 0,25 25,35 0,25 5,15 0))';
74 SET @star_elem_horizontal_2= 'POLYGON((35 0,10 15,40 15,32 10,35 0))';
75 SET @star_center_2= 'POINT(25 10)';
76 SET @star_top_2= 'POINT(25 25)';
77 SET @star_bottom_left_2= 'POINT(15 0)';
78 SET @star_bottom_right_2= 'POINT(35 0)';
79 SET @star_bottom_points_2= 'MULTIPOINT(15 0,35 0)';
80 SET @star_all_points_2= 'MULTIPOINT(15 0,35 0,35 10,25 25)';
81 SET @star_line_horizontal_2= 'LINESTRING(20 15,30 15)';
82 SET @star_line_vertical_2= 'LINESTRING(25 5,25 25)';
83 SET @star_top_to_center_2= 'LINESTRING(25 25,25 10)';
84 SET @star_lines_near_horizontal_2= 'MULTILINESTRING((35 0,10 15,25 30,10 5))';
85 SET @star_lines_near_vertical_2= 'MULTILINESTRING((10 5,25 25,10 25))';
86 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))';
87 SET @star_elem_vertical_val_2= '((15 0,25 25,35 0,25 5,15 0))';
88 SET @star_elem_horizontal_val_2= '((35 0,10 15,40 15,32 10,35 0))';
89 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)))';
90 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))';
91
92 # Star like the base star, but shifted to right by 60 on X to be completly separate
93 SET @star_elem_vertical_3= 'POLYGON((65 0,75 25,85 0,75 5,65 0))';
94 SET @star_elem_horizontal_3= 'POLYGON((85 0,60 15,90 15,82 10,85 0))';
95 SET @star_center_3= 'POINT(75 10)';
96 SET @star_top_3= 'POINT(75 25)';
97 SET @star_bottom_left_3= 'POINT(65 0)';
98 SET @star_bottom_right_3= 'POINT(85 0)';
99 SET @star_bottom_points_3= 'MULTIPOINT(65 0,85 0)';
100 SET @star_all_points_3= 'MULTIPOINT(65 0,85 0,75 10,75 25)';
101 SET @star_line_horizontal_3= 'LINESTRING(70 15,80 15)';
102 SET @star_line_vertical_3= 'LINESTRING(75 5,75 25)';
103 SET @star_top_to_center_3= 'LINESTRING(75 25,75 10)';
104 SET @star_lines_near_horizontal_3= 'MULTILINESTRING((85 0,60 15,85 30,60 5))';
105 SET @star_lines_near_vertical_3= 'MULTILINESTRING((60 5,75 25,60 25))';
106 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))';
107 SET @star_elem_vertical_val_3= '((65 0,75 25,85 0,75 5,65 0))';
108 SET @star_elem_horizontal_val_3= '((85 0,60 15,90 15,82 10,85 0))';
109 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)))';
110 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))';
111
112 --echo #INSERT base star
113 --disable_warnings
114 INSERT INTO gis_geometrycollection VALUES
115 (100,ST_GEOMFROMTEXT(@star)),
116 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
117 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
118 (103,ST_GEOMFROMTEXT(@star_of_elems)),
119 (104,ST_GEOMFROMTEXT(@star_top)),
120 (105,ST_GEOMFROMTEXT(@star_center)),
121 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
122 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
123 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
124 (109,ST_GEOMFROMTEXT(@star_all_points)),
125 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
126 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
127 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
128 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
129 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
130 (115,ST_GEOMFROMTEXT(@star_collection_elems));
131 --enable_warnings
132
133 --echo #INSERT identical (to base) star
134 --disable_warnings
135 INSERT INTO gis_geometrycollection VALUES
136 (200,ST_GEOMFROMTEXT(@star_1)),
137 (201,ST_GEOMFROMTEXT(@star_elem_vertical_1)),
138 (202,ST_GEOMFROMTEXT(@star_elem_horizontal_1)),
139 (203,ST_GEOMFROMTEXT(@star_of_elems_1)),
140 (204,ST_GEOMFROMTEXT(@star_top_1)),
141 (205,ST_GEOMFROMTEXT(@star_center_1)),
142 (206,ST_GEOMFROMTEXT(@star_bottom_left_1)),
143 (207,ST_GEOMFROMTEXT(@star_bottom_right_1)),
144 (208,ST_GEOMFROMTEXT(@star_bottom_points_1)),
145 (209,ST_GEOMFROMTEXT(@star_all_points_1)),
146 (210,ST_GEOMFROMTEXT(@star_line_horizontal_1)),
147 (211,ST_GEOMFROMTEXT(@star_line_vertical_1)),
148 (212,ST_GEOMFROMTEXT(@star_top_to_center_1)),
149 (213,ST_GEOMFROMTEXT(@star_lines_near_horizontal_1)),
150 (214,ST_GEOMFROMTEXT(@star_lines_near_vertical_1)),
151 (215,ST_GEOMFROMTEXT(@star_collection_elems_1));
152 --enable_warnings
153
154 --echo #INSERT overlapping star
155 --disable_warnings
156 INSERT INTO gis_geometrycollection VALUES
157 (300,ST_GEOMFROMTEXT(@star_2)),
158 (301,ST_GEOMFROMTEXT(@star_elem_vertical_2)),
159 (302,ST_GEOMFROMTEXT(@star_elem_horizontal_2)),
160 (303,ST_GEOMFROMTEXT(@star_of_elems_2)),
161 (304,ST_GEOMFROMTEXT(@star_top_2)),
162 (305,ST_GEOMFROMTEXT(@star_center_2)),
163 (306,ST_GEOMFROMTEXT(@star_bottom_left_2)),
164 (307,ST_GEOMFROMTEXT(@star_bottom_right_2)),
165 (308,ST_GEOMFROMTEXT(@star_bottom_points_2)),
166 (309,ST_GEOMFROMTEXT(@star_all_points_2)),
167 (310,ST_GEOMFROMTEXT(@star_line_horizontal_2)),
168 (311,ST_GEOMFROMTEXT(@star_line_vertical_2)),
169 (312,ST_GEOMFROMTEXT(@star_top_to_center_2)),
170 (313,ST_GEOMFROMTEXT(@star_lines_near_horizontal_2)),
171 (314,ST_GEOMFROMTEXT(@star_lines_near_vertical_2)),
172 (315,ST_GEOMFROMTEXT(@star_collection_elems_2));
173 --enable_warnings
174
175 --echo #INSERT separate star
176 --disable_warnings
177 INSERT INTO gis_geometrycollection VALUES
178 (400,ST_GEOMFROMTEXT(@star_3)),
179 (401,ST_GEOMFROMTEXT(@star_elem_vertical_3)),
180 (402,ST_GEOMFROMTEXT(@star_elem_horizontal_3)),
181 (403,ST_GEOMFROMTEXT(@star_of_elems_3)),
182 (404,ST_GEOMFROMTEXT(@star_top_3)),
183 (405,ST_GEOMFROMTEXT(@star_center_3)),
184 (406,ST_GEOMFROMTEXT(@star_bottom_left_3)),
185 (407,ST_GEOMFROMTEXT(@star_bottom_right_3)),
186 (408,ST_GEOMFROMTEXT(@star_bottom_points_3)),
187 (409,ST_GEOMFROMTEXT(@star_all_points_3)),
188 (410,ST_GEOMFROMTEXT(@star_line_horizontal_3)),
189 (411,ST_GEOMFROMTEXT(@star_line_vertical_3)),
190 (412,ST_GEOMFROMTEXT(@star_top_to_center_3)),
191 (413,ST_GEOMFROMTEXT(@star_lines_near_horizontal_3)),
192 (414,ST_GEOMFROMTEXT(@star_lines_near_vertical_3)),
193 (415,ST_GEOMFROMTEXT(@star_collection_elems_3));
194 --enable_warnings
195
196 CREATE TABLE gis_geometrycollection_2 SELECT fid as fid2,g as g2 FROM gis_geometrycollection;
197
198 --echo #Checking the integrity of the above create/insert statements
199
200 --echo #64 rows.
201 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
202 --echo #64 rows.
203 SELECT count(ST_ASTEXT(g2) != 'NULL') FROM gis_geometrycollection_2;
204
205 ############################################################################################
206 # Checking the spatial testing functions #
207 ############################################################################################
208
209 --echo #####################################################################################
210 --echo # ST_CROSSES(g1,g2)
211 --echo #####################################################################################
212
213 --echo #====================================================================================
214 --echo # point,point
215 --echo #====================================================================================
216 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
217
218 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
219
220 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=105;
221
222 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
223
224 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
225
226 --echo #====================================================================================
227 --echo # point,multipoint
228 --echo #====================================================================================
229 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
230
231 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_bottom_points));
232
233 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=106;
234
235 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
236
237 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
238
239 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
240
241 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
242
243 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
244
245 --echo #====================================================================================
246 --echo # point,linestring
247 --echo #====================================================================================
248 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
249
250 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_line_horizontal));
251
252 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
253
254 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
255
256 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
257
258 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
259
260 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
261
262 --echo #====================================================================================
263 --echo # point,multilinestring
264 --echo #====================================================================================
265 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
266
267 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
268
269 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
270
271 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'));
272
273 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
274
275 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
276
277 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
278
279 --echo #====================================================================================
280 --echo # point,polygon
281 --echo #====================================================================================
282 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
283
284 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_horizontal));
285
286 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_vertical));
287
288 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=104;
289
290 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
291
292 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
293
294 SELECT ST_CROSSES(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))'));
295
296 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
297
298 --echo #====================================================================================
299 --echo # point,multipolygon
300 --echo #====================================================================================
301 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
302
303 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_of_elems));
304
305 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
306
307 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
308
309 SELECT ST_CROSSES(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)))'));
310
311 SELECT ST_CROSSES(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)))'));
312
313 SELECT ST_CROSSES(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)))'));
314
315 --echo #====================================================================================
316 --echo # point,geometrycollection
317 --echo #====================================================================================
318 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
319
320 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_collection_elems));
321
322 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
323
324 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
325
326 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
327
328 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
329
330 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
331
332 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
333
334 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
335
336 --echo #====================================================================================
337 --echo # multipoint,point
338 --echo #====================================================================================
339 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
340
341 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
342
343 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
344
345 --echo #====================================================================================
346 --echo # multipoint,multipoint
347 --echo #====================================================================================
348 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points));
349
350 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
351
352 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=208;
353
354 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=308;
355
356 --echo #====================================================================================
357 --echo # multipoint,linestring
358 --echo #====================================================================================
359 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
360
361 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=109;
362
363 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=209;
364
365 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=309;
366
367 --echo #====================================================================================
368 --echo # multipoint,multilinestring
369 --echo #====================================================================================
370 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
371
372 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
373
374 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=109;
375
376 --echo #====================================================================================
377 --echo # multipoint,polygon
378 --echo #====================================================================================
379 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical));
380
381 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
382
383 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=109;
384
385 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=209;
386
387 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=309;
388
389 --echo #====================================================================================
390 --echo # multipoint,multipolygon
391 --echo #====================================================================================
392 SELECT ST_CROSSES(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems));
393
394 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
395
396 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=109;
397
398 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=209;
399
400 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=309;
401
402 --echo #====================================================================================
403 --echo # multipoint,geomertycollection
404 --echo #====================================================================================
405 SELECT ST_CROSSES(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems));
406
407 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
408
409 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=109;
410
411 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=209;
412
413 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=309;
414
415 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr));
416
417 --echo #====================================================================================
418 --echo # linestring,point
419 --echo #====================================================================================
420 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
421
422 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
423
424 SELECT ST_CROSSES(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
425
426 --echo #====================================================================================
427 --echo # linestring,multipoint
428 --echo #====================================================================================
429 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
430
431 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
432
433 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=111;
434
435 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=311;
436
437 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=411;
438
439 --echo #====================================================================================
440 --echo # linestring,linestring
441 --echo #====================================================================================
442 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
443
444 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
445
446 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=111;
447
448 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=311;
449
450 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=411;
451
452 --echo #====================================================================================
453 --echo # linestring,multilinestring
454 --echo #====================================================================================
455 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
456
457 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical));
458
459 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=110;
460
461 --echo #====================================================================================
462 --echo # linestring,polygon
463 --echo #====================================================================================
464 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
465
466 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
467
468 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
469
470 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
471
472 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 25,11 15,11 15))')) FROM gis_geometrycollection WHERE fid=110;
473
474 --echo #====================================================================================
475 --echo # linestring,multipolygon
476 --echo #====================================================================================
477 SELECT ST_CROSSES(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)))'));
478
479 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
480
481 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_2));
482
483 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3));
484
485 SELECT ST_CROSSES(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;
486
487 --echo #====================================================================================
488 --echo # linestring,geometrycollection
489 --echo #====================================================================================
490 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
491
492 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
493
494 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_2));
495
496 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
497
498 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=110;
499
500 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
501
502 --echo #====================================================================================
503 --echo # multilinestring,point
504 --echo #====================================================================================
505 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
506
507 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
508
509 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_2));
510
511 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_3));
512
513 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
514
515 --echo #====================================================================================
516 --echo # multilinestring,multipoint
517 --echo #====================================================================================
518 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points));
519
520 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
521
522 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=114;
523
524 SELECT ST_CROSSES(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 ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
530
531 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
532
533 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_2));
534
535 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_3));
536
537 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
538
539 --echo #====================================================================================
540 --echo # multilinestring,multilinestring
541 --echo #====================================================================================
542 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'));
543
544 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
545
546 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal_3));
547
548 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
549
550 SELECT ST_CROSSES(ST_GEOMFROMTEXT('LINESTRING(3 10, 1 5, 1 10, 3 4, 7 8, 6 10, 10 2)'), ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0))'));
551
552 --echo #====================================================================================
553 --echo # multilinestring,polygon
554 --echo #====================================================================================
555 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical));
556
557 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
558
559 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
560
561 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
562
563 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
564
565 SELECT ST_CROSSES(ST_GEOMFROMTEXT('MULTILINESTRING((6 6,15 15),(0 0,7 7))'), ST_GEOMFROMTEXT('POLYGON((5 5,5 15,15 15,15 5,5 5))'));
566
567 SELECT ST_CROSSES(ST_GEOMFROMTEXT('MULTILINESTRING((15 15,6 6),(0 0,7 7))'), ST_GEOMFROMTEXT('POLYGON((5 5,5 15,15 15,15 5,5 5))'));
568
569 --echo #====================================================================================
570 --echo # multilinestring,multipolygon
571 --echo #====================================================================================
572 SELECT ST_CROSSES(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical));
573
574 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
575
576 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=114;
577
578 --echo #====================================================================================
579 --echo # multilinestring,geometrycollection
580 --echo #====================================================================================
581 SELECT ST_CROSSES(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems));
582
583 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
584
585 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=114;
586
587 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr));
588
589 --echo #====================================================================================
590 --echo # polygon,point
591 --echo #====================================================================================
592 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
593
594 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
595
596 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
597
598 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=200;
599
600 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=300;
601
602 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=400;
603
604 --echo #====================================================================================
605 --echo # polygon,multipoint
606 --echo #====================================================================================
607 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points));
608
609 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
610
611 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
612
613 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=300;
614
615 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=400;
616
617 --echo #====================================================================================
618 --echo # polygon,linestring
619 --echo #====================================================================================
620 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical));
621
622 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
623
624 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=100;
625
626 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=300;
627
628 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=400;
629
630 SELECT ST_CROSSES(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
631
632 --echo #====================================================================================
633 --echo # polygon,multilinestring
634 --echo #====================================================================================
635 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical));
636
637 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
638
639 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=100;
640
641 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=300;
642
643 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=400;
644
645 --echo #====================================================================================
646 --echo # polygon,polygon
647 --echo #====================================================================================
648 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical));
649
650 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
651
652 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=100;
653
654 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=300;
655
656 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=400;
657
658 --echo #====================================================================================
659 --echo # polygon,multipolygon
660 --echo #====================================================================================
661 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems));
662
663 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
664
665 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
666
667 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=300;
668
669 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=400;
670
671 --echo #====================================================================================
672 --echo # polygon,geometrycollection
673 --echo #====================================================================================
674 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems));
675
676 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
677
678 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
679
680 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=300;
681
682 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=400;
683
684 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
685
686 --echo #====================================================================================
687 --echo # multipolygon,point
688 --echo #====================================================================================
689 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
690
691 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
692
693 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=103;
694
695 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=403;
696
697 --echo #====================================================================================
698 --echo # multipolygon,multipoint
699 --echo #====================================================================================
700 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
701
702 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
703
704 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
705
706 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=403;
707
708 --echo #====================================================================================
709 --echo # multipolygon,linestring
710 --echo #====================================================================================
711 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
712
713 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
714
715 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
716
717 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=403;
718
719 --echo #====================================================================================
720 --echo # multipolygon,multilinestring
721 --echo #====================================================================================
722 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
723
724 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
725
726 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
727
728 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=403;
729
730 --echo #====================================================================================
731 --echo # multipolygon,polygon
732 --echo #====================================================================================
733 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
734
735 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star));
736
737 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
738
739 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=103;
740
741 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=303;
742
743 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=403;
744
745 --echo #====================================================================================
746 --echo # multipolygon,multipolygon
747 --echo #====================================================================================
748 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
749
750 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
751
752 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=103;
753
754 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=303;
755
756 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
757
758 SELECT ST_CROSSES(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
759
760 --echo #====================================================================================
761 --echo # multipolygon,geometrycollection
762 --echo #====================================================================================
763 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
764
765 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
766
767 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=103;
768
769 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=303;
770
771 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
772
773 SELECT ST_CROSSES(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=103;
774
775 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
776
777 --echo #====================================================================================
778 --echo # geometrycollection,point
779 --echo #====================================================================================
780 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
781
782 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
783
784 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=115;
785
786 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=415;
787
788 --echo #====================================================================================
789 --echo # geometrycollection,multipoint
790 --echo #====================================================================================
791 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
792
793 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
794
795 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
796
797 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=415;
798
799 --echo #====================================================================================
800 --echo # geometrycollection,linestring
801 --echo #====================================================================================
802 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
803
804 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
805
806 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
807
808 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=415;
809
810 --echo #====================================================================================
811 --echo # geometrycollection,multilinestring
812 --echo #====================================================================================
813 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
814
815 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
816
817 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
818
819 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=415;
820
821 --echo #====================================================================================
822 --echo # geometrycollection,polygon
823 --echo #====================================================================================
824 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
825
826 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star));
827
828 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
829
830 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=115;
831
832 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=315;
833
834 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=415;
835
836 --echo #====================================================================================
837 --echo # geometrycollection,multipolygon
838 --echo #====================================================================================
839 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
840
841 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
842
843 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=115;
844
845 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=315;
846
847 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=415;
848
849 SELECT ST_CROSSES(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
850
851 --echo #====================================================================================
852 --echo # geometrycollection,geometrycollection
853 --echo #====================================================================================
854 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
855
856 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
857
858 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
859
860 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
861
862 SELECT ST_CROSSES(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
863
864 SELECT ST_CROSSES(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=215;
865
866 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
867
868 --echo #####################################################################################
869 --echo # Testing ST_CROSSES() with 2 geometries of same SRID
870 --echo #####################################################################################
871
872 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
873
874 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
875
876 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000));
877
878 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
879
880 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
881
882 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000));
883
884 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
885
886 --error ER_DATA_OUT_OF_RANGE
887 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
888
889 --error ER_DATA_OUT_OF_RANGE
890 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
891
892 --error ER_DATA_OUT_OF_RANGE
893 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
894
895 --echo #####################################################################################
896 --echo # Invalid function calls
897 --echo #####################################################################################
898 --error ER_GIS_DIFFERENT_SRIDS
899 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
900
901 --error ER_GIS_DIFFERENT_SRIDS
902 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
903
904 --error ER_GIS_DIFFERENT_SRIDS
905 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
906
907 SELECT ST_CROSSES(NULL,ST_GEOMFROMTEXT(@star_top));
908
909 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),NULL);
910
911 SELECT ST_CROSSES(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
912
913 SELECT ST_CROSSES(NULL,NULL);
914
915 SELECT ST_CROSSES(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
916
917 --error ER_GIS_INVALID_DATA
918 SELECT ST_CROSSES(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
919
920 --error ER_GIS_INVALID_DATA
921 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
922
923 --error ER_GIS_INVALID_DATA
924 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
925
926 --error ER_GIS_INVALID_DATA
927 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
928
929 --error ER_PARSE_ERROR
930 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
931
932 --error ER_GIS_INVALID_DATA
933 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
934
935 --error ER_GIS_INVALID_DATA
936 SELECT ST_CROSSES(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
937
938 --error ER_GIS_INVALID_DATA
939 SELECT ST_CROSSES(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
940
941 --error ER_PARSE_ERROR
942 SELECT ST_CROSSES(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
943
944 --error ER_GIS_INVALID_DATA
945 SELECT ST_CROSSES(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
946
947 --error ER_GIS_INVALID_DATA
948 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
949
950 --error ER_GIS_INVALID_DATA
951 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
952
953 --error ER_PARSE_ERROR
954 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
955
956 --error ER_GIS_INVALID_DATA
957 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
958
959 --error ER_GIS_INVALID_DATA
960 SELECT ST_CROSSES(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
961
962 --error ER_PARSE_ERROR
963 SELECT ST_CROSSES(,);
964
965 --error ER_PARSE_ERROR
966 SELECT ST_CROSSES(ST_GEOMFROMTEXT(@star_of_elems),);
967
968 --error ER_PARSE_ERROR
969 SELECT ST_CROSSES(,ST_GEOMFROMTEXT(@star_top));
970
971 # Test with all combinations of geometry types, including types inside geometry collections
972
973 CREATE TABLE t1 (g GEOMETRY NOT NULL);
974
975 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POINT(1 1)'));
976 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'));
977 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
978 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
979 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4))'));
980 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTIPOINT(1 1, 2 2)'));
981 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2),'
982 '(3 3, 4 4))'));
983 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
984 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)),((5 5, 10 5, 10 10, 5 10, 5 5)))'));
985 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
986 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
987 '(6 6, 7 6, 7 7, 6 7, 6 6)))'));
988 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
989 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((1 1, 10 1, 10 10, 1 10, 1 1), '
990 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
991 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'));
992 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
993 'GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'));
994 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0, 1 0, 1'
995 ' 1, 0 1, 0 0)))'));
996 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
997 'GEOMETRYCOLLECTION(POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), '
998 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
999 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1000 'GEOMETRYCOLLECTION(MULTIPOINT(1 1, 2 2))'));
1001 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1002 'GEOMETRYCOLLECTION(MULTILINESTRING((1 1, 2 2), (3 3, 4 4)))'));
1003 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1004 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1005 '((5 5, 10 5, 10 10, 5 10, 5 5))))'));
1006 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1007 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1008 '((5 5, 10 5, 10 10, 5 10, 5 5), (6 6, 7 6, 7 7, 6 7, 6 6))))'));
1009 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1010 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1011 '((1 1, 10 1, 10 10, 1 10, 1 1), (4 4, 6 4, 6 6, 4 6, 4 4))))'));
1012 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1013 'GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(1 1, 2 2),'
1014 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)),'
1015 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4)),'
1016 'MULTIPOINT(1 1, 2 2),MULTILINESTRING((1 1, 2 2), (3 3, 4 4)),'
1017 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))),'
1018 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
1019 '(6 6, 7 6, 7 7, 6 7, 6 6))))'));
1020
1021 INSERT INTO t1 VALUES(
1022 GEOMETRYCOLLECTION(POINT(1,1),LINESTRING(POINT(1,1),POINT(2,2)),
1023 POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0))),
1024 POLYGON(LINESTRING(POINT(0,0),POINT(10,0),POINT(10,10),POINT(0,10),
1025 POINT(0,0)),LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),POINT(4,6),
1026 POINT(4,4))),MULTIPOINT(POINT(1,1),POINT(2,2)),
1027 MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),LINESTRING(POINT(3,3),
1028 POINT(4,4))),MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
1029 POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1030 POINT(10,10),POINT(5,10),POINT(5,5)))),
1031 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),
1032 POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),POINT(10,10),
1033 POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),POINT(7,7),
1034 POINT(6,7),POINT(6,6)))),GEOMETRYCOLLECTION(POINT(1,1)),
1035 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
1036 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
1037 POINT(0,1),POINT(0,0)))),GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),
1038 POINT(10,0),POINT(10,10),POINT(0,10),POINT(0,0)),LINESTRING(POINT(4,4),
1039 POINT(6,4),POINT(6,6),POINT(4,6),POINT(4,4)))),
1040 GEOMETRYCOLLECTION(MULTIPOINT(POINT(1,1),POINT(2,2))),
1041 GEOMETRYCOLLECTION(MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),
1042 LINESTRING(POINT(3,3),POINT(4,4)))),
1043 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
1044 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1045 POINT(10,10),POINT(5,10),POINT(5,5))))),
1046 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
1047 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1048 POINT(10,10),POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),
1049 POINT(7,7),POINT(6,7),POINT(6,6)))))));
1050 INSERT INTO t1 VALUES (
1051 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1,1)),
1052 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
1053 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(1,1), POINT(10,1), POINT(10,10),
1054 POINT(1,10), POINT(1,1)), LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),
1055 POINT(4,6),POINT(4,4))))));
1056
1057 # We don't care about the result. We just want to put all parameter type
1058 # combinations through the function.
1059 --disable_result_log
1060 SELECT ST_CROSSES(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
1061
1062 SELECT ST_CROSSES(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
1063 FROM t1 AS a JOIN t1 AS b;
1064 --enable_result_log
1065
1066 --echo # clean up
1067 DROP TABLE t1;
1068 DROP TABLE gis_geometrycollection;
1069 DROP TABLE gis_geometrycollection_2;
1070
1071 --echo #
1072 --echo # WL#8579 Spatial Reference Systems
1073 --echo #
1074
1075 --echo # SRID 0 (should pass)
1076 SELECT ST_CROSSES(
1077 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1078 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1079 );
1080
1081 --echo # Projected SRS (should pass)
1082 SELECT ST_CROSSES(
1083 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1084 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1085 );
1086
1087 --echo # Geographic SRS (should pass)
1088 SELECT ST_CROSSES(
1089 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1090 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1091 );
1092
1093 --echo #
1094 --echo # WL#10827 Ellipsoidal R-tree support functions
1095 --echo #
1096
1097 SET @pt = ST_GeomFromText('POINT(0 0)', 4326);
1098
1099 # SRID=4326, long=0, lat=-91.
1100 SET @pt_lat_minus_91 = x'E6100000010100000000000000000000000000000000C056C0';
1101
1102 # SRID=4326, long=0, lat=91.
1103 SET @pt_lat_plus_91 = x'E6100000010100000000000000000000000000000000C05640';
1104
1105 # SRID=4326, long=-181, lat=0.
1106 SET @pt_long_minus_181 = x'E610000001010000000000000000A066C00000000000000000';
1107
1108 # SRID=4326, long=181, lat=0.
1109 SET @pt_long_plus_181 = x'E610000001010000000000000000A066400000000000000000';
1110
1111 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1112 SELECT ST_Crosses(@pt_lat_minus_91, @pt);
1113 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1114 SELECT ST_Crosses(@pt_lat_plus_91, @pt);
1115 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1116 SELECT ST_Crosses(@pt_long_minus_181, @pt);
1117 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1118 SELECT ST_Crosses(@pt_long_plus_181, @pt);
1119
1120 CREATE TABLE t1 (
1121 id INT,
1122 c GEOMETRY NOT NULL SRID 0,
1123 g GEOMETRY AS (ST_SRID(c, 4326)) STORED NOT NULL SRID 4326,
1124 SPATIAL INDEX c_idx (c),
1125 SPATIAL INDEX g_idx (g)
1126 );
1127
1128 INSERT INTO t1 (id, c) VALUES
1129 (0, ST_GeomFromText('LINESTRING(0 10, 10 10)')),
1130 (1, ST_GeomFromText('LINESTRING(0 10, 5 10)')),
1131 (2, ST_GeomFromText('LINESTRING(-10 10, 5 10)')),
1132 (3, ST_GeomFromText('LINESTRING(0 10.00001, 10 10.00001)')),
1133 (4, ST_GeomFromText('LINESTRING(0 9.99999, 10 9.99999)')),
1134 (5, ST_GeomFromText('LINESTRING(1 10, 2 10)')),
1135 (6, ST_GeomFromText('LINESTRING(2 0, 2 20)')),
1136 (7, ST_GeomFromText('LINESTRING(2 10, 8 10)'));
1137
1138 SET @ls = 'LINESTRING(-5 10, 5 10)';
1139 SET @cart_ls = ST_GeomFromText(@ls);
1140 SET @geo_ls = ST_GeomFromText(@ls, 4326, 'axis-order=long-lat');
1141
1142 --echo # Cartesian ST_Crosses
1143 SELECT id, ST_AsText(c)
1144 FROM t1 IGNORE INDEX(c_idx)
1145 WHERE ST_Crosses(c, @cart_ls)
1146 ORDER BY id;
1147 SELECT id, ST_AsText(c)
1148 FROM t1 FORCE INDEX(c_idx)
1149 WHERE ST_Crosses(c, @cart_ls)
1150 ORDER BY id;
1151
1152 --echo # Geographic ST_Crosses
1153 SELECT id, ST_AsText(g)
1154 FROM t1 IGNORE INDEX(g_idx)
1155 WHERE ST_Crosses(g, @geo_ls)
1156 ORDER BY id;
1157 SELECT id, ST_AsText(g)
1158 FROM t1 FORCE INDEX(g_idx)
1159 WHERE ST_Crosses(g, @geo_ls)
1160 ORDER BY id;
1161
1162 DROP TABLE t1;
1163
1164 --echo #
1165 --echo # Bug #26188208 ST_CROSSES(GC, GC) RETURNS INCORRECT RESULT FOR CORNER
1166 --echo # CASE
1167 --echo #
1168
1169 --echo # Should not cross since there's no interior point in the first argument
1170 --echo # that's in the second arguemnt's exterior.
1171 SELECT ST_Crosses(
1172 ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 1),POINT(0 10))'),
1173 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 2),POINT(0 10))')
1174 ) AS res;
1175 SELECT ST_Crosses(
1176 ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 1),POINT(0 10))', 4326),
1177 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 2),POINT(0 10))', 4326)
1178 ) AS res;
1179
1180 --echo # Should not cross since the shared interior is not of dimension 0.
1181 SELECT ST_Crosses(
1182 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1), POINT(0 11))'),
1183 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 2))')
1184 ) AS res;
1185 SELECT ST_Crosses(
1186 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 1), POINT(0 11))',
1187 4326),
1188 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 0, 0 2))', 4326)
1189 ) AS res;
1190
1191 --echo # Should not cross since the shared interior is not of dimension 0.
1192 SELECT ST_Crosses(
1193 ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 11),LINESTRING(0 1, 0 3))'),
1194 ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 11),LINESTRING(0 0, 0 2))')
1195 ) AS res;
1196 SELECT ST_Crosses(
1197 ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 11),LINESTRING(0 1, 0 3))', 4326),
1198 ST_GeomFromText('GEOMETRYCOLLECTION(POINT(0 11),LINESTRING(0 0, 0 2))', 4326)
1199 ) AS res;
1200
1201 --echo # Should cross since the point is inside the polygon while the linestring
1202 --echo # is not.
1203 SELECT ST_Crosses(
1204 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(5 0, 5 5, 10 5), POINT(7 3))'),
1205 ST_GeomFromText('POLYGON((6 0, 6 4, 9 4, 6 0))')
1206 ) AS res;
1207 SELECT ST_Crosses(
1208 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(5 0, 5 5, 10 5), POINT(7 3))',
1209 4326),
1210 ST_GeomFromText('POLYGON((6 0, 6 4, 9 4, 6 0))', 4326)
1211 ) AS res;
1212
1213 --echo # Should not cross since (1 1) is in a boundary point of the
1214 --echo # multilinestring.
1215 SELECT ST_Crosses(
1216 ST_GeomFromText('MULTIPOINT((1 1),(3 3))'),
1217 ST_GeomFromText('GEOMETRYCOLLECTION(MULTILINESTRING((0 0, 2 2),(1 1, 2 2)))')
1218 ) AS res;
1219 SELECT ST_Crosses(
1220 ST_GeomFromText('MULTIPOINT((1 1),(3 3))', 4326),
1221 ST_GeomFromText('GEOMETRYCOLLECTION(MULTILINESTRING((0 0, 2 2),(1 1, 2 2)))',
1222 4326)
1223 ) AS res;
1224
1225 --echo # Should not cross since (1 1) is in a boundary point of the
1226 --echo # multilinestring.
1227 SELECT ST_Crosses(
1228 ST_GeomFromText('MULTIPOINT((1 1),(3 3))'),
1229 ST_GeomFromText('MULTILINESTRING((0 0, 2 2),(1 1, 2 2))')
1230 ) AS res;
1231 SELECT ST_Crosses(
1232 ST_GeomFromText('MULTIPOINT((1 1),(3 3))', 4326),
1233 ST_GeomFromText('MULTILINESTRING((0 0, 2 2),(1 1, 2 2))', 4326)
1234 ) AS res;
1235
1236 --echo # Should not cross since (1 1) is in a boundary point of one of the
1237 --echo # linestrings.
1238 SELECT ST_Crosses(
1239 ST_GeomFromText('MULTIPOINT((1 1),(3 3))'),
1240 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 0, 2 2), '
1241 'LINESTRING(1 1, 2 2))')
1242 ) AS res;
1243 SELECT ST_Crosses(
1244 ST_GeomFromText('MULTIPOINT((1 1),(3 3))', 4326),
1245 ST_GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 0, 2 2), '
1246 'LINESTRING(1 1, 2 2))', 4326)
1247 ) AS res;
1248
1249 --echo #
1250 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
1251 --echo #
1252
1253 --echo # Assume SRID 10 is not defined.
1254 --error ER_SRS_NOT_FOUND
1255 DO ST_CROSSES(
1256 x'0A000000010100000000000000000000000000000000000000',
1257 x'0A000000010100000000000000000000000000000000000000'
1258 );
1259
1260 --echo #
1261 --echo # Bug #27576700 GIS: MYSQLD GOT SIGNAL 11 AT ../SQL/GIS/GEOMETRIES.CC:37
1262 --echo #
1263
1264 DO ST_CROSSES(ST_GeomFromText('MULTILINESTRING((-58.88597
1265 157.94019,-17.85522 -5.31935,-17.80859 66.34707,-8.4484 -20.57939,-16.15053
1266 -24.75792,32.71796 -163.83575))', 4326),
1267 ST_GeomFromText('GEOMETRYCOLLECTION(POLYGON((13.443455046240892
1268 -26.153114098537444,62.05128 -72.33176,-8.59805 -130.37858,-31.81082259135185
1269 -82.65801207243817,-70.42619 -130.86883,-56.09334404701969
1270 -6.644295318933246,-61.6458 34.12106,-55.53375 39.37693,-51.252745479240595
1271 35.30986970416038,-43.38976 103.45927,-28.50529 157.25408,79.09999
1272 56.11646,13.443455046240892 -26.153114098537444)),POLYGON((63.110017291878336
1273 11.399678592060411,80.3392 -167.15302,55.375240472210756
1274 -162.85403689121705,55.08425 -169.40944,13.66333
1275 -159.95389,10.013286038933956 -151.33914592929725,-56.78912
1276 -102.14145,-62.62410567680437 20.097654365570406,-63.28217
1277 21.6508,-62.73883333175459 22.501133221270692,-68.12018 135.23754,31.42659
1278 168.39603,53.0133 116.03589,53.696900549622086 108.95148967623732,62.36624
1279 103.97485,63.59381 22.29884,63.110017291878336
1280 11.399678592060411)),MULTIPOINT((-10.24117 -64.16013),(-38.99204
1281 -117.71918),(-28.10106 17.94683),(-73.52889 -137.44223),(62.91798
1282 63.52398),(-16.96991 -147.03994)),MULTILINESTRING((83.9657 -101.5132,48.81774
1283 14.53876,-71.20097 21.78803,-31.20884 -62.40592,-32.79402 146.98985,44.27884
1284 -176.86693),(-10.11554 170.23719,46.14032 -65.71065,58.53335
1285 81.35396,-28.31051 170.86429,-89.95184 -85.79089,-9.75639 138.94996)))',
1286 4326));