Debian Codegraph @

mysql-test/suite/gis/r/spatial_testing_functions_crosses.result

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