Debian Codegraph @

mysql-test/suite/gis/r/spatial_testing_functions_intersects.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 # MBRINTERSECTS(g1,g2)
161 #####################################################################################
162 #====================================================================================
163 # point,point
164 #====================================================================================
165 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
166 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center))
167 1
168 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
169 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center))
170 0
171 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=105;
172 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
173 1
174 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
175 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'))
176 1
177 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
178 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'))
179 0
180 #====================================================================================
181 # point,multipoint
182 #====================================================================================
183 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
184 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points))
185 1
186 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_bottom_points));
187 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_bottom_points))
188 0
189 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=106;
190 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
191 1
192 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
193 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'))
194 1
195 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
196 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'))
197 1
198 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
199 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'))
200 1
201 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
202 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'))
203 1
204 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
205 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'))
206 0
207 #====================================================================================
208 # point,linestring
209 #====================================================================================
210 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
211 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center))
212 1
213 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_line_horizontal));
214 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_line_horizontal))
215 0
216 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
217 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
218 1
219 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
220 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'))
221 1
222 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
223 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'))
224 1
225 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
226 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'))
227 1
228 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
229 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'))
230 0
231 #====================================================================================
232 # point,multilinestring
233 #====================================================================================
234 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
235 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical))
236 1
237 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
238 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
239 1
240 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
241 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
242 1
243 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'));
244 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'))
245 1
246 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
247 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'))
248 1
249 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
250 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'))
251 1
252 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
253 MBRINTERSECTS(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 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
259 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star))
260 1
261 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_horizontal));
262 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_horizontal))
263 0
264 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_vertical));
265 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_vertical))
266 1
267 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=104;
268 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star))
269 1
270 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
271 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'))
272 1
273 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
274 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'))
275 1
276 SELECT MBRINTERSECTS(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 MBRINTERSECTS(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 1
279 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
280 MBRINTERSECTS(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 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
286 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems))
287 1
288 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_of_elems));
289 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_of_elems))
290 0
291 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
292 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
293 1
294 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
295 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'))
296 1
297 SELECT MBRINTERSECTS(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 MBRINTERSECTS(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 1
300 SELECT MBRINTERSECTS(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 MBRINTERSECTS(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 1
303 SELECT MBRINTERSECTS(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 MBRINTERSECTS(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 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
310 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems))
311 1
312 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_collection_elems));
313 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_collection_elems))
314 0
315 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
316 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
317 1
318 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
319 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr))
320 1
321 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
322 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
323 NULL
324 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
325 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'))
326 1
327 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
328 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'))
329 1
330 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
331 MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'))
332 1
333 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
334 MBRINTERSECTS(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 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
340 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top))
341 1
342 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
343 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center))
344 0
345 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
346 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_left))
347 1
348 #====================================================================================
349 # multipoint,multipoint
350 #====================================================================================
351 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points));
352 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points))
353 1
354 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
355 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points))
356 1
357 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=208;
358 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
359 1
360 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=308;
361 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
362 1
363 #====================================================================================
364 # multipoint,linestring
365 #====================================================================================
366 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
367 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center))
368 1
369 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=109;
370 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
371 1
372 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=209;
373 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
374 1
375 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=309;
376 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
377 1
378 #====================================================================================
379 # multipoint,multilinestring
380 #====================================================================================
381 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
382 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical))
383 1
384 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
385 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
386 1
387 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=109;
388 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal))
389 1
390 #====================================================================================
391 # multipoint,polygon
392 #====================================================================================
393 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical));
394 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical))
395 1
396 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
397 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal))
398 1
399 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=109;
400 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal))
401 1
402 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=209;
403 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal))
404 1
405 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=309;
406 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal))
407 1
408 #====================================================================================
409 # multipoint,multipolygon
410 #====================================================================================
411 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems));
412 MBRINTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems))
413 1
414 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
415 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems))
416 1
417 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=109;
418 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
419 1
420 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=209;
421 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
422 1
423 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=309;
424 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
425 1
426 #====================================================================================
427 # multipoint,geometrycollection
428 #====================================================================================
429 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems));
430 MBRINTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems))
431 1
432 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
433 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems))
434 1
435 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=109;
436 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
437 1
438 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=209;
439 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
440 1
441 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=309;
442 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
443 1
444 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr));
445 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr))
446 1
447 #====================================================================================
448 # linestring,point
449 #====================================================================================
450 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
451 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center))
452 1
453 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
454 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left))
455 0
456 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
457 MBRINTERSECTS(g,g2)
458 0
459 #====================================================================================
460 # linestring,multipoint
461 #====================================================================================
462 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
463 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
464 1
465 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
466 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points))
467 1
468 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=111;
469 MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
470 1
471 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=311;
472 MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
473 0
474 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=411;
475 MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
476 0
477 #====================================================================================
478 # linestring,linestring
479 #====================================================================================
480 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
481 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center))
482 1
483 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
484 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical))
485 1
486 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=111;
487 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
488 1
489 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=311;
490 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
491 0
492 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=411;
493 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
494 0
495 #====================================================================================
496 # linestring,multilinestring
497 #====================================================================================
498 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
499 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
500 1
501 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical));
502 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical))
503 1
504 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=110;
505 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal))
506 1
507 #====================================================================================
508 # linestring,polygon
509 #====================================================================================
510 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
511 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'))
512 1
513 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
514 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal))
515 1
516 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
517 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_2))
518 1
519 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
520 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_3))
521 0
522 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,11 15))')) FROM gis_geometrycollection WHERE fid=110;
523 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
524 #====================================================================================
525 # linestring,multipolygon
526 #====================================================================================
527 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))'));
528 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
529 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
530 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems))
531 1
532 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_2));
533 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_2))
534 1
535 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3));
536 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3))
537 0
538 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))')) FROM gis_geometrycollection WHERE fid=110;
539 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
540 #====================================================================================
541 # linestring,geometrycollection
542 #====================================================================================
543 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
544 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems))
545 1
546 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_2));
547 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_2))
548 1
549 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
550 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3))
551 0
552 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=110;
553 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
554 1
555 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
556 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr))
557 1
558 #====================================================================================
559 # multilinestring,point
560 #====================================================================================
561 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
562 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top))
563 1
564 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
565 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center))
566 1
567 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_2));
568 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_2))
569 0
570 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_3));
571 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_3))
572 0
573 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
574 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
575 1
576 #====================================================================================
577 # multilinestring,multipoint
578 #====================================================================================
579 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points));
580 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points))
581 0
582 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
583 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points))
584 1
585 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=114;
586 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
587 0
588 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
589 MBRINTERSECTS(g,g2)
590 0
591 #====================================================================================
592 # multilinestring,linestring
593 #====================================================================================
594 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
595 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical))
596 1
597 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
598 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal))
599 1
600 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_2));
601 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_2))
602 0
603 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_3));
604 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_3))
605 0
606 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
607 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical))
608 1
609 #====================================================================================
610 # multilinestring,multilinestring
611 #====================================================================================
612 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'));
613 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'))
614 1
615 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
616 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
617 1
618 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal_3));
619 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal_3))
620 0
621 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
622 MBRINTERSECTS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'))
623 1
624 #====================================================================================
625 # multilinestring,polygon
626 #====================================================================================
627 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical));
628 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical))
629 1
630 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
631 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal))
632 1
633 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
634 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_2))
635 1
636 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
637 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_3))
638 0
639 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
640 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
641 1
642 #====================================================================================
643 # multilinestring,multipolygon
644 #====================================================================================
645 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical));
646 MBRINTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical))
647 1
648 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
649 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems))
650 1
651 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=114;
652 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
653 1
654 #====================================================================================
655 # multilinestring,geometrycollection
656 #====================================================================================
657 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems));
658 MBRINTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems))
659 1
660 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
661 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems))
662 1
663 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=114;
664 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
665 1
666 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr));
667 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr))
668 1
669 #====================================================================================
670 # polygon,point
671 #====================================================================================
672 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
673 MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center))
674 1
675 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
676 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'))
677 0
678 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
679 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
680 1
681 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=200;
682 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
683 1
684 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=300;
685 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
686 1
687 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=400;
688 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
689 0
690 #====================================================================================
691 # polygon,multipoint
692 #====================================================================================
693 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points));
694 MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points))
695 1
696 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
697 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'))
698 1
699 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
700 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
701 1
702 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=300;
703 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
704 1
705 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=400;
706 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
707 0
708 #====================================================================================
709 # polygon,linestring
710 #====================================================================================
711 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical));
712 MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical))
713 1
714 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
715 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal))
716 1
717 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=100;
718 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical))
719 1
720 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=300;
721 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical))
722 1
723 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=400;
724 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical))
725 0
726 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
727 MBRINTERSECTS(g,g2)
728 1
729 #====================================================================================
730 # polygon,multilinestring
731 #====================================================================================
732 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical));
733 MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical))
734 1
735 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
736 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
737 1
738 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=100;
739 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
740 1
741 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=300;
742 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
743 1
744 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=400;
745 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
746 0
747 #====================================================================================
748 # polygon,polygon
749 #====================================================================================
750 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical));
751 MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical))
752 1
753 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
754 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star))
755 1
756 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=100;
757 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
758 1
759 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=300;
760 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
761 1
762 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=400;
763 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
764 0
765 #====================================================================================
766 # polygon,multipolygon
767 #====================================================================================
768 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems));
769 MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems))
770 1
771 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
772 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems))
773 1
774 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
775 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
776 1
777 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=300;
778 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
779 1
780 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=400;
781 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
782 0
783 #====================================================================================
784 # polygon,geometrycollection
785 #====================================================================================
786 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems));
787 MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems))
788 1
789 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
790 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems))
791 1
792 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
793 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
794 1
795 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=300;
796 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
797 1
798 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=400;
799 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
800 0
801 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
802 MBRINTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr))
803 1
804 #====================================================================================
805 # multipolygon,point
806 #====================================================================================
807 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
808 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top))
809 1
810 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
811 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'))
812 0
813 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=103;
814 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
815 1
816 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=403;
817 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
818 0
819 #====================================================================================
820 # multipolygon,multipoint
821 #====================================================================================
822 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
823 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points))
824 1
825 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
826 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'))
827 0
828 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
829 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
830 1
831 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=403;
832 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
833 0
834 #====================================================================================
835 # multipolygon,linestring
836 #====================================================================================
837 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
838 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center))
839 1
840 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
841 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'))
842 0
843 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
844 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
845 1
846 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=403;
847 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
848 0
849 #====================================================================================
850 # multipolygon,multilinestring
851 #====================================================================================
852 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
853 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical))
854 1
855 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
856 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'))
857 0
858 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
859 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
860 1
861 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=403;
862 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
863 0
864 #====================================================================================
865 # multipolygon,polygon
866 #====================================================================================
867 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
868 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical))
869 1
870 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star));
871 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star))
872 1
873 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
874 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'))
875 1
876 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=103;
877 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
878 1
879 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=303;
880 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
881 1
882 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=403;
883 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
884 0
885 #====================================================================================
886 # multipolygon,multipolygon
887 #====================================================================================
888 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
889 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems))
890 1
891 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
892 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'))
893 1
894 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=103;
895 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
896 1
897 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=303;
898 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
899 1
900 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
901 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
902 0
903 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
904 MBRINTERSECTS(g,g2)
905 1
906 #====================================================================================
907 # multipolygon,geometrycollection
908 #====================================================================================
909 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
910 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems))
911 1
912 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=103;
913 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
914 1
915 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=303;
916 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
917 1
918 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
919 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
920 0
921 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
922 MBRINTERSECTS(g,g2)
923 1
924 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
925 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr))
926 1
927 #====================================================================================
928 # geometrycollection,point
929 #====================================================================================
930 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
931 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top))
932 1
933 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
934 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'))
935 0
936 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=115;
937 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
938 1
939 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=415;
940 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
941 0
942 #====================================================================================
943 # geometrycollection,multipoint
944 #====================================================================================
945 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
946 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points))
947 1
948 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
949 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'))
950 0
951 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
952 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
953 1
954 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=415;
955 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
956 0
957 #====================================================================================
958 # geometrycollection,linestring
959 #====================================================================================
960 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
961 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center))
962 1
963 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
964 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'))
965 0
966 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
967 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
968 1
969 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=415;
970 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
971 0
972 #====================================================================================
973 # geometrycollection,multilinestring
974 #====================================================================================
975 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
976 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical))
977 1
978 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
979 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'))
980 0
981 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
982 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
983 1
984 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=415;
985 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
986 0
987 #====================================================================================
988 # geometrycollection,polygon
989 #====================================================================================
990 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
991 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical))
992 1
993 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star));
994 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star))
995 1
996 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
997 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'))
998 1
999 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=115;
1000 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1001 1
1002 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=315;
1003 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1004 1
1005 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=415;
1006 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1007 0
1008 #====================================================================================
1009 # geometrycollection,multipolygon
1010 #====================================================================================
1011 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
1012 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems))
1013 1
1014 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
1015 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'))
1016 1
1017 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
1018 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1019 1
1020 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
1021 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1022 1
1023 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
1024 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1025 0
1026 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
1027 MBRINTERSECTS(g,g2)
1028 1
1029 #====================================================================================
1030 # geometrycollection,geometrycollection
1031 #====================================================================================
1032 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
1033 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems))
1034 1
1035 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
1036 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1037 1
1038 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
1039 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1040 1
1041 SELECT MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
1042 MBRINTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1043 0
1044 SELECT MBRINTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=115;
1045 MBRINTERSECTS(g,g2)
1046 1
1047 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1048 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr))
1049 1
1050 #####################################################################################
1051 # ST_INTERSECTS(g1,g2)
1052 #####################################################################################
1053 #====================================================================================
1054 # point,point
1055 #====================================================================================
1056 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
1057 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center))
1058 1
1059 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
1060 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center))
1061 0
1062 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=105;
1063 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
1064 1
1065 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
1066 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'))
1067 1
1068 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
1069 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'))
1070 0
1071 #====================================================================================
1072 # point,multipoint
1073 #====================================================================================
1074 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
1075 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points))
1076 1
1077 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_bottom_points));
1078 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_bottom_points))
1079 0
1080 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=106;
1081 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
1082 1
1083 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
1084 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'))
1085 1
1086 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
1087 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'))
1088 1
1089 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
1090 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'))
1091 1
1092 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
1093 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'))
1094 1
1095 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
1096 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'))
1097 0
1098 #====================================================================================
1099 # point,linestring
1100 #====================================================================================
1101 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
1102 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center))
1103 1
1104 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_line_horizontal));
1105 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_line_horizontal))
1106 0
1107 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
1108 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1109 1
1110 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
1111 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'))
1112 1
1113 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
1114 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'))
1115 1
1116 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
1117 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'))
1118 1
1119 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
1120 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'))
1121 0
1122 #====================================================================================
1123 # point,multilinestring
1124 #====================================================================================
1125 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1126 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical))
1127 1
1128 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1129 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
1130 0
1131 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
1132 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
1133 1
1134 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'));
1135 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'))
1136 1
1137 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
1138 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'))
1139 1
1140 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
1141 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'))
1142 1
1143 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
1144 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'))
1145 0
1146 #====================================================================================
1147 # point,polygon
1148 #====================================================================================
1149 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
1150 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star))
1151 1
1152 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_horizontal));
1153 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_horizontal))
1154 0
1155 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_vertical));
1156 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_elem_vertical))
1157 1
1158 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=104;
1159 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star))
1160 1
1161 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
1162 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'))
1163 1
1164 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
1165 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'))
1166 1
1167 SELECT ST_INTERSECTS(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))'));
1168 ST_INTERSECTS(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))'))
1169 0
1170 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
1171 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'))
1172 0
1173 #====================================================================================
1174 # point,multipolygon
1175 #====================================================================================
1176 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
1177 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems))
1178 1
1179 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_of_elems));
1180 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_of_elems))
1181 0
1182 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
1183 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1184 1
1185 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
1186 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'))
1187 1
1188 SELECT ST_INTERSECTS(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)))'));
1189 ST_INTERSECTS(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)))'))
1190 1
1191 SELECT ST_INTERSECTS(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)))'));
1192 ST_INTERSECTS(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)))'))
1193 0
1194 SELECT ST_INTERSECTS(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)))'));
1195 ST_INTERSECTS(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)))'))
1196 0
1197 #====================================================================================
1198 # point,geometrycollection
1199 #====================================================================================
1200 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
1201 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems))
1202 1
1203 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_collection_elems));
1204 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(-0.01 0)'),ST_GEOMFROMTEXT(@star_collection_elems))
1205 0
1206 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
1207 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1208 1
1209 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1210 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr))
1211 1
1212 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
1213 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
1214 NULL
1215 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
1216 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'))
1217 1
1218 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
1219 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'))
1220 1
1221 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
1222 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'))
1223 1
1224 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
1225 ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'))
1226 0
1227 #====================================================================================
1228 # multipoint,point
1229 #====================================================================================
1230 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
1231 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top))
1232 1
1233 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
1234 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center))
1235 0
1236 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
1237 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_left))
1238 1
1239 #====================================================================================
1240 # multipoint,multipoint
1241 #====================================================================================
1242 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points));
1243 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points))
1244 1
1245 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
1246 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points))
1247 1
1248 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=208;
1249 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
1250 1
1251 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=308;
1252 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
1253 0
1254 #====================================================================================
1255 # multipoint,linestring
1256 #====================================================================================
1257 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
1258 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center))
1259 1
1260 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=109;
1261 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1262 1
1263 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=209;
1264 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1265 1
1266 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=309;
1267 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1268 0
1269 #====================================================================================
1270 # multipoint,multilinestring
1271 #====================================================================================
1272 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1273 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical))
1274 1
1275 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1276 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
1277 1
1278 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=109;
1279 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal))
1280 1
1281 #====================================================================================
1282 # multipoint,polygon
1283 #====================================================================================
1284 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical));
1285 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical))
1286 1
1287 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
1288 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal))
1289 1
1290 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=109;
1291 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal))
1292 1
1293 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=209;
1294 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal))
1295 1
1296 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=309;
1297 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_horizontal))
1298 0
1299 #====================================================================================
1300 # multipoint,multipolygon
1301 #====================================================================================
1302 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems));
1303 ST_INTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems))
1304 0
1305 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
1306 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems))
1307 1
1308 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=109;
1309 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1310 1
1311 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=209;
1312 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1313 1
1314 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=309;
1315 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1316 0
1317 #====================================================================================
1318 # multipoint,geometrycollection
1319 #====================================================================================
1320 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems));
1321 ST_INTERSECTS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems))
1322 0
1323 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
1324 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems))
1325 1
1326 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=109;
1327 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1328 1
1329 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=209;
1330 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1331 1
1332 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=309;
1333 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1334 0
1335 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1336 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr))
1337 1
1338 #====================================================================================
1339 # linestring,point
1340 #====================================================================================
1341 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
1342 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center))
1343 1
1344 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
1345 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left))
1346 0
1347 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
1348 ST_INTERSECTS(g,g2)
1349 0
1350 #====================================================================================
1351 # linestring,multipoint
1352 #====================================================================================
1353 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
1354 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
1355 1
1356 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
1357 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points))
1358 1
1359 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=111;
1360 ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
1361 1
1362 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=311;
1363 ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
1364 0
1365 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=411;
1366 ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
1367 0
1368 #====================================================================================
1369 # linestring,linestring
1370 #====================================================================================
1371 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
1372 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center))
1373 1
1374 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
1375 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical))
1376 1
1377 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=111;
1378 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1379 1
1380 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=311;
1381 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1382 0
1383 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=411;
1384 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1385 0
1386 #====================================================================================
1387 # linestring,multilinestring
1388 #====================================================================================
1389 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1390 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
1391 0
1392 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1393 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical))
1394 0
1395 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=110;
1396 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal))
1397 0
1398 #====================================================================================
1399 # linestring,polygon
1400 #====================================================================================
1401 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
1402 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'))
1403 1
1404 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
1405 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal))
1406 1
1407 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
1408 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_2))
1409 1
1410 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
1411 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal_3))
1412 0
1413 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 25,11 15,11 15))')) FROM gis_geometrycollection WHERE fid=110;
1414 ST_INTERSECTS(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 25,11 15,11 15))'))
1415 1
1416 #====================================================================================
1417 # linestring,multipolygon
1418 #====================================================================================
1419 SELECT ST_INTERSECTS(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)))'));
1420 ST_INTERSECTS(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)))'))
1421 1
1422 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
1423 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems))
1424 1
1425 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_2));
1426 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_2))
1427 1
1428 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3));
1429 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3))
1430 0
1431 SELECT ST_INTERSECTS(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;
1432 ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,19 25,11 15,11 15)),((25 0,0 15,25 10,25 0)))'))
1433 1
1434 #====================================================================================
1435 # linestring,geometrycollection
1436 #====================================================================================
1437 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
1438 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems))
1439 1
1440 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_2));
1441 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_2))
1442 1
1443 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
1444 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3))
1445 0
1446 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=110;
1447 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1448 1
1449 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1450 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr))
1451 1
1452 #====================================================================================
1453 # multilinestring,point
1454 #====================================================================================
1455 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
1456 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top))
1457 1
1458 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
1459 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center))
1460 0
1461 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_2));
1462 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_2))
1463 0
1464 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_3));
1465 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center_3))
1466 0
1467 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
1468 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
1469 1
1470 #====================================================================================
1471 # multilinestring,multipoint
1472 #====================================================================================
1473 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points));
1474 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points))
1475 0
1476 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
1477 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points))
1478 1
1479 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=114;
1480 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
1481 0
1482 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
1483 ST_INTERSECTS(g,g2)
1484 0
1485 #====================================================================================
1486 # multilinestring,linestring
1487 #====================================================================================
1488 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
1489 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical))
1490 1
1491 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
1492 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal))
1493 0
1494 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_2));
1495 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_2))
1496 0
1497 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_3));
1498 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal_3))
1499 0
1500 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
1501 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical))
1502 1
1503 #====================================================================================
1504 # multilinestring,multilinestring
1505 #====================================================================================
1506 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'));
1507 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'))
1508 1
1509 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1510 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
1511 1
1512 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal_3));
1513 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal_3))
1514 0
1515 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
1516 ST_INTERSECTS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'))
1517 1
1518 #====================================================================================
1519 # multilinestring,polygon
1520 #====================================================================================
1521 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical));
1522 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical))
1523 1
1524 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
1525 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal))
1526 1
1527 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_2));
1528 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_2))
1529 0
1530 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_3));
1531 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal_3))
1532 0
1533 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
1534 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1535 1
1536 #====================================================================================
1537 # multilinestring,multipolygon
1538 #====================================================================================
1539 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical));
1540 ST_INTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical))
1541 1
1542 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
1543 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems))
1544 1
1545 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=114;
1546 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1547 1
1548 #====================================================================================
1549 # multilinestring,geometrycollection
1550 #====================================================================================
1551 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems));
1552 ST_INTERSECTS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems))
1553 1
1554 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
1555 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems))
1556 1
1557 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=114;
1558 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1559 1
1560 #====================================================================================
1561 # polygon,point
1562 #====================================================================================
1563 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
1564 ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center))
1565 1
1566 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
1567 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'))
1568 0
1569 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
1570 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
1571 1
1572 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=200;
1573 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
1574 1
1575 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=300;
1576 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
1577 0
1578 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=400;
1579 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_center))
1580 0
1581 #====================================================================================
1582 # polygon,multipoint
1583 #====================================================================================
1584 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points));
1585 ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points))
1586 1
1587 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
1588 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'))
1589 0
1590 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
1591 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
1592 1
1593 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=300;
1594 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
1595 0
1596 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=400;
1597 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_all_points))
1598 0
1599 #====================================================================================
1600 # polygon,linestring
1601 #====================================================================================
1602 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical));
1603 ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical))
1604 1
1605 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
1606 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal))
1607 1
1608 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=100;
1609 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical))
1610 1
1611 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=300;
1612 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical))
1613 1
1614 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=400;
1615 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_line_vertical))
1616 0
1617 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
1618 ST_INTERSECTS(g,g2)
1619 1
1620 #====================================================================================
1621 # polygon,multilinestring
1622 #====================================================================================
1623 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1624 ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical))
1625 1
1626 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1627 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
1628 1
1629 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=100;
1630 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
1631 1
1632 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=300;
1633 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
1634 0
1635 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=400;
1636 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
1637 0
1638 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(2 2,2 4,4 4,4 2,2 2))'),
1639 ST_GEOMFROMTEXT('MULTILINESTRING((11 11,20 20),(5 7, 4 1))'));
1640 ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0),(2 2,2 4,4 4,4 2,2 2))'),
1641 ST_GEOMFROMTEXT('MULTILINESTRING((11 11,20 20),(5 7, 4 1))'))
1642 1
1643 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((5 0,0 5,-5 0,0 -5,5 0))'),
1644 ST_GEOMFROMTEXT('MULTILINESTRING((10 0, 18 12),(2 2, 2 1))'));
1645 ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((5 0,0 5,-5 0,0 -5,5 0))'),
1646 ST_GEOMFROMTEXT('MULTILINESTRING((10 0, 18 12),(2 2, 2 1))'))
1647 1
1648 #====================================================================================
1649 # polygon,polygon
1650 #====================================================================================
1651 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical));
1652 ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical))
1653 1
1654 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
1655 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star))
1656 1
1657 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=100;
1658 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1659 1
1660 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=300;
1661 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1662 1
1663 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=400;
1664 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1665 0
1666 #====================================================================================
1667 # polygon,multipolygon
1668 #====================================================================================
1669 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems));
1670 ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems))
1671 1
1672 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
1673 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems))
1674 1
1675 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
1676 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1677 1
1678 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=300;
1679 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1680 1
1681 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=400;
1682 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1683 0
1684 #====================================================================================
1685 # polygon,goemetrycollection
1686 #====================================================================================
1687 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems));
1688 ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems))
1689 1
1690 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
1691 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems))
1692 1
1693 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
1694 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1695 1
1696 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=300;
1697 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1698 1
1699 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=400;
1700 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1701 0
1702 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1703 ST_INTERSECTS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr))
1704 1
1705 #====================================================================================
1706 # multipolygon,point
1707 #====================================================================================
1708 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
1709 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top))
1710 1
1711 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
1712 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'))
1713 0
1714 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=103;
1715 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
1716 1
1717 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=403;
1718 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
1719 0
1720 #====================================================================================
1721 # multipolygon,multipoint
1722 #====================================================================================
1723 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
1724 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points))
1725 1
1726 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
1727 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'))
1728 0
1729 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
1730 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
1731 1
1732 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=403;
1733 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
1734 0
1735 #====================================================================================
1736 # multipolygon,linestring
1737 #====================================================================================
1738 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
1739 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center))
1740 1
1741 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
1742 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'))
1743 0
1744 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
1745 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1746 1
1747 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=403;
1748 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1749 0
1750 #====================================================================================
1751 # multipolygon,multilinestring
1752 #====================================================================================
1753 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1754 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical))
1755 1
1756 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
1757 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'))
1758 0
1759 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
1760 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
1761 1
1762 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=403;
1763 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
1764 0
1765 #====================================================================================
1766 # multipolygon,polygon
1767 #====================================================================================
1768 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
1769 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical))
1770 1
1771 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star));
1772 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star))
1773 1
1774 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
1775 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'))
1776 1
1777 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=103;
1778 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1779 1
1780 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=303;
1781 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1782 1
1783 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=403;
1784 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1785 0
1786 #====================================================================================
1787 # multipolygon,multipolygon
1788 #====================================================================================
1789 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
1790 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems))
1791 1
1792 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
1793 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'))
1794 1
1795 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=103;
1796 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1797 1
1798 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=303;
1799 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1800 1
1801 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
1802 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_of_elems))
1803 0
1804 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1805 ST_INTERSECTS(g,g2)
1806 1
1807 #====================================================================================
1808 # multipolygon,geometrycollection
1809 #====================================================================================
1810 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
1811 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems))
1812 1
1813 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=103;
1814 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1815 1
1816 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=303;
1817 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1818 1
1819 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
1820 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1821 0
1822 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
1823 ST_INTERSECTS(g,g2)
1824 1
1825 #====================================================================================
1826 # geometrycollection,point
1827 #====================================================================================
1828 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
1829 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top))
1830 1
1831 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
1832 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'))
1833 0
1834 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=115;
1835 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
1836 1
1837 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=415;
1838 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top))
1839 0
1840 #====================================================================================
1841 # geometrycollection,multipoint
1842 #====================================================================================
1843 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
1844 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points))
1845 1
1846 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
1847 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'))
1848 0
1849 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
1850 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
1851 1
1852 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=415;
1853 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_bottom_points))
1854 0
1855 #====================================================================================
1856 # geometrycollection,linestring
1857 #====================================================================================
1858 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
1859 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center))
1860 1
1861 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
1862 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'))
1863 0
1864 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
1865 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1866 1
1867 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=415;
1868 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_top_to_center))
1869 0
1870 #====================================================================================
1871 # geometrycollection,multilinestring
1872 #====================================================================================
1873 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1874 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical))
1875 1
1876 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
1877 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'))
1878 0
1879 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
1880 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
1881 1
1882 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=415;
1883 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
1884 0
1885 #====================================================================================
1886 # geometrycollection,polygon
1887 #====================================================================================
1888 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
1889 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical))
1890 1
1891 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star));
1892 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star))
1893 1
1894 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
1895 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'))
1896 1
1897 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=115;
1898 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1899 1
1900 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=315;
1901 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1902 1
1903 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=415;
1904 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
1905 0
1906 #====================================================================================
1907 # geometrycollection,multipolygon
1908 #====================================================================================
1909 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
1910 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems))
1911 1
1912 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
1913 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'))
1914 1
1915 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
1916 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1917 1
1918 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
1919 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1920 1
1921 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
1922 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1923 0
1924 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
1925 ST_INTERSECTS(g,g2)
1926 1
1927 #====================================================================================
1928 # geometrycollection,geometrycollection
1929 #====================================================================================
1930 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
1931 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems))
1932 1
1933 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
1934 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1935 1
1936 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=315;
1937 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1938 1
1939 SELECT ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
1940 ST_INTERSECTS(g,ST_GEOMFROMTEXT(@star_collection_elems))
1941 0
1942 SELECT ST_INTERSECTS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=115;
1943 ST_INTERSECTS(g,g2)
1944 1
1945 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1946 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr))
1947 1
1948 #####################################################################################
1949 # Testing with 2 geometries of same SRID
1950 #####################################################################################
1951 #====================================================================================
1952 # MBRINTERSECTS(g1,g2)
1953 #====================================================================================
1954 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
1955 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0))
1956 0
1957 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1958 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145))
1959 0
1960 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000));
1961 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000))
1962 0
1963 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1964 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145))
1965 0
1966 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000));
1967 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,2000),ST_GEOMFROMTEXT(@star_center,2000))
1968 0
1969 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
1970 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
1971 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
1972 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
1973 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
1974 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
1975 #====================================================================================
1976 # ST_INTERSECTS(g1,g2)
1977 #====================================================================================
1978 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
1979 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0))
1980 0
1981 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1982 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145))
1983 0
1984 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
1985 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326))
1986 0
1987 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
1988 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135))
1989 0
1990 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1991 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145))
1992 0
1993 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
1994 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326))
1995 0
1996 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
1997 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135))
1998 0
1999 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
2000 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
2001 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
2002 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
2003 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
2004 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
2005 #####################################################################################
2006 # Invalid function calls
2007 #####################################################################################
2008 #====================================================================================
2009 # ST_INTERSECTS(g1,g2)
2010 #====================================================================================
2011 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
2012 ERROR HY000: Binary geometry function st_intersects given two geometries of different srids: 0 and 4326, which should have been identical.
2013 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
2014 ERROR HY000: Binary geometry function st_intersects given two geometries of different srids: 4145 and 4326, which should have been identical.
2015 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
2016 ERROR HY000: Binary geometry function st_intersects given two geometries of different srids: 4145 and 4326, which should have been identical.
2017 SELECT ST_INTERSECTS(NULL,ST_GEOMFROMTEXT(@star_top));
2018 ST_INTERSECTS(NULL,ST_GEOMFROMTEXT(@star_top))
2019 NULL
2020 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),NULL);
2021 ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),NULL)
2022 NULL
2023 SELECT ST_INTERSECTS(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
2024 ST_INTERSECTS(g,NULL)
2025 NULL
2026 SELECT ST_INTERSECTS(NULL,NULL);
2027 ST_INTERSECTS(NULL,NULL)
2028 NULL
2029 SELECT ST_INTERSECTS(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
2030 ST_INTERSECTS(fid,NULL)
2031 NULL
2032 SELECT ST_INTERSECTS(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
2033 ERROR 22023: Invalid GIS data provided to function st_intersects.
2034 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
2035 ERROR 22023: Invalid GIS data provided to function st_intersects.
2036 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2037 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2038 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2039 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2040 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2041 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
2042 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2043 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2044 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2045 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2046 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2047 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2048 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2049 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
2050 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2051 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2052 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2053 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2054 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2055 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2056 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2057 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
2058 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2059 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2060 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2061 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2062 SELECT ST_INTERSECTS(,);
2063 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
2064 SELECT ST_INTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),);
2065 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
2066 SELECT ST_INTERSECTS(,ST_GEOMFROMTEXT(@star_top));
2067 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
2068 #====================================================================================
2069 # MBRINTERSECTS(g1,g2)
2070 #====================================================================================
2071 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
2072 ERROR HY000: Binary geometry function mbrintersects given two geometries of different srids: 0 and 4326, which should have been identical.
2073 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
2074 ERROR HY000: Binary geometry function mbrintersects given two geometries of different srids: 4145 and 4326, which should have been identical.
2075 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
2076 ERROR HY000: Binary geometry function mbrintersects given two geometries of different srids: 4145 and 4326, which should have been identical.
2077 SELECT MBRINTERSECTS(NULL,ST_GEOMFROMTEXT(@star_top));
2078 MBRINTERSECTS(NULL,ST_GEOMFROMTEXT(@star_top))
2079 NULL
2080 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),NULL);
2081 MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),NULL)
2082 NULL
2083 SELECT MBRINTERSECTS(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
2084 MBRINTERSECTS(g,NULL)
2085 NULL
2086 SELECT MBRINTERSECTS(NULL,NULL);
2087 MBRINTERSECTS(NULL,NULL)
2088 NULL
2089 SELECT MBRINTERSECTS(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
2090 MBRINTERSECTS(fid,NULL)
2091 NULL
2092 SELECT MBRINTERSECTS(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
2093 ERROR 22023: Invalid GIS data provided to function mbrintersects.
2094 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
2095 ERROR 22023: Invalid GIS data provided to function mbrintersects.
2096 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2097 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2098 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2099 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2100 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2101 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
2102 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2103 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2104 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2105 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2106 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2107 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2108 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2109 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
2110 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2111 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2112 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2113 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2114 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2115 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2116 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2117 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
2118 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2119 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2120 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
2121 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
2122 SELECT MBRINTERSECTS(,);
2123 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
2124 SELECT MBRINTERSECTS(ST_GEOMFROMTEXT(@star_of_elems),);
2125 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
2126 SELECT MBRINTERSECTS(,ST_GEOMFROMTEXT(@star_top));
2127 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
2128 CREATE TABLE t1 (g GEOMETRY NOT NULL);
2129 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POINT(1 1)'));
2130 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'));
2131 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
2132 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2133 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4))'));
2134 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTIPOINT(1 1, 2 2)'));
2135 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2),'
2136 '(3 3, 4 4))'));
2137 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2138 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)),((5 5, 10 5, 10 10, 5 10, 5 5)))'));
2139 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2140 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
2141 '(6 6, 7 6, 7 7, 6 7, 6 6)))'));
2142 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2143 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((1 1, 10 1, 10 10, 1 10, 1 1), '
2144 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
2145 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'));
2146 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2147 'GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'));
2148 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0, 1 0, 1'
2149 ' 1, 0 1, 0 0)))'));
2150 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2151 'GEOMETRYCOLLECTION(POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), '
2152 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
2153 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2154 'GEOMETRYCOLLECTION(MULTIPOINT(1 1, 2 2))'));
2155 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2156 'GEOMETRYCOLLECTION(MULTILINESTRING((1 1, 2 2), (3 3, 4 4)))'));
2157 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2158 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
2159 '((5 5, 10 5, 10 10, 5 10, 5 5))))'));
2160 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2161 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
2162 '((5 5, 10 5, 10 10, 5 10, 5 5), (6 6, 7 6, 7 7, 6 7, 6 6))))'));
2163 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2164 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
2165 '((1 1, 10 1, 10 10, 1 10, 1 1), (4 4, 6 4, 6 6, 4 6, 4 4))))'));
2166 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
2167 'GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(1 1, 2 2),'
2168 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)),'
2169 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4)),'
2170 'MULTIPOINT(1 1, 2 2),MULTILINESTRING((1 1, 2 2), (3 3, 4 4)),'
2171 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))),'
2172 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
2173 '(6 6, 7 6, 7 7, 6 7, 6 6))))'));
2174 INSERT INTO t1 VALUES(
2175 GEOMETRYCOLLECTION(POINT(1,1),LINESTRING(POINT(1,1),POINT(2,2)),
2176 POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0))),
2177 POLYGON(LINESTRING(POINT(0,0),POINT(10,0),POINT(10,10),POINT(0,10),
2178 POINT(0,0)),LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),POINT(4,6),
2179 POINT(4,4))),MULTIPOINT(POINT(1,1),POINT(2,2)),
2180 MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),LINESTRING(POINT(3,3),
2181 POINT(4,4))),MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
2182 POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
2183 POINT(10,10),POINT(5,10),POINT(5,5)))),
2184 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),
2185 POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),POINT(10,10),
2186 POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),POINT(7,7),
2187 POINT(6,7),POINT(6,6)))),GEOMETRYCOLLECTION(POINT(1,1)),
2188 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
2189 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
2190 POINT(0,1),POINT(0,0)))),GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),
2191 POINT(10,0),POINT(10,10),POINT(0,10),POINT(0,0)),LINESTRING(POINT(4,4),
2192 POINT(6,4),POINT(6,6),POINT(4,6),POINT(4,4)))),
2193 GEOMETRYCOLLECTION(MULTIPOINT(POINT(1,1),POINT(2,2))),
2194 GEOMETRYCOLLECTION(MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),
2195 LINESTRING(POINT(3,3),POINT(4,4)))),
2196 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
2197 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
2198 POINT(10,10),POINT(5,10),POINT(5,5))))),
2199 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
2200 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
2201 POINT(10,10),POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),
2202 POINT(7,7),POINT(6,7),POINT(6,6)))))));
2203 INSERT INTO t1 VALUES (
2204 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1,1)),
2205 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
2206 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(1,1), POINT(10,1), POINT(10,10),
2207 POINT(1,10), POINT(1,1)), LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),
2208 POINT(4,6),POINT(4,4))))));
2209 SELECT ST_INTERSECTS(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
2210 SELECT MBRINTERSECTS(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
2211 SELECT ST_INTERSECTS(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
2212 FROM t1 AS a JOIN t1 AS b;
2213 SELECT MBRINTERSECTS(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
2214 FROM t1 AS a JOIN t1 AS b;
2215 # clean up
2216 DROP TABLE t1;
2217 DROP TABLE gis_geometrycollection;
2218 DROP TABLE gis_geometrycollection_2;
2219 #
2220 # WL#8579 Spatial Reference Systems
2221 #
2222 # SRID 0 (should pass)
2223 SELECT ST_INTERSECTS(
2224 ST_GEOMFROMTEXT('POINT(0 0)', 0),
2225 ST_GEOMFROMTEXT('POINT(0 0)', 0)
2226 );
2227 ST_INTERSECTS(
2228 ST_GEOMFROMTEXT('POINT(0 0)', 0),
2229 ST_GEOMFROMTEXT('POINT(0 0)', 0)
2230 )
2231 1
2232 SELECT MBRINTERSECTS(
2233 ST_GEOMFROMTEXT('POINT(0 0)', 0),
2234 ST_GEOMFROMTEXT('POINT(0 0)', 0)
2235 );
2236 MBRINTERSECTS(
2237 ST_GEOMFROMTEXT('POINT(0 0)', 0),
2238 ST_GEOMFROMTEXT('POINT(0 0)', 0)
2239 )
2240 1
2241 # Projected SRS (should pass)
2242 SELECT ST_INTERSECTS(
2243 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
2244 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
2245 );
2246 ST_INTERSECTS(
2247 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
2248 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
2249 )
2250 1
2251 SELECT MBRINTERSECTS(
2252 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
2253 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
2254 );
2255 MBRINTERSECTS(
2256 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
2257 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
2258 )
2259 1
2260 # Geographic SRS (should pass)
2261 SELECT ST_INTERSECTS(
2262 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
2263 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
2264 );
2265 ST_INTERSECTS(
2266 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
2267 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
2268 )
2269 1
2270 SELECT MBRINTERSECTS(
2271 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
2272 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
2273 );
2274 MBRINTERSECTS(
2275 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
2276 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
2277 )
2278 1
2279 #
2280 # WL#10827 Ellipsoidal R-tree support functions
2281 #
2282 SET @pt = ST_GeomFromText('POINT(0 0)', 4326);
2283 SET @pt_lat_minus_91 = x'E6100000010100000000000000000000000000000000C056C0';
2284 SET @pt_lat_plus_91 = x'E6100000010100000000000000000000000000000000C05640';
2285 SET @pt_long_minus_181 = x'E610000001010000000000000000A066C00000000000000000';
2286 SET @pt_long_plus_181 = x'E610000001010000000000000000A066400000000000000000';
2287 SELECT ST_Intersects(@pt_lat_minus_91, @pt);
2288 ERROR 22S03: A parameter of function st_intersects contains a geometry with latitude -91.000000, which is out of range. It must be within [-90.000000, 90.000000].
2289 SELECT ST_Intersects(@pt_lat_plus_91, @pt);
2290 ERROR 22S03: A parameter of function st_intersects contains a geometry with latitude 91.000000, which is out of range. It must be within [-90.000000, 90.000000].
2291 SELECT ST_Intersects(@pt_long_minus_181, @pt);
2292 ERROR 22S02: A parameter of function st_intersects contains a geometry with longitude -181.000000, which is out of range. It must be within (-180.000000, 180.000000].
2293 SELECT ST_Intersects(@pt_long_plus_181, @pt);
2294 ERROR 22S02: A parameter of function st_intersects contains a geometry with longitude 181.000000, which is out of range. It must be within (-180.000000, 180.000000].
2295 SELECT MBRIntersects(@pt_lat_minus_91, @pt);
2296 ERROR 22S03: A parameter of function mbrintersects contains a geometry with latitude -91.000000, which is out of range. It must be within [-90.000000, 90.000000].
2297 SELECT MBRIntersects(@pt_lat_plus_91, @pt);
2298 ERROR 22S03: A parameter of function mbrintersects contains a geometry with latitude 91.000000, which is out of range. It must be within [-90.000000, 90.000000].
2299 SELECT MBRIntersects(@pt_long_minus_181, @pt);
2300 ERROR 22S02: A parameter of function mbrintersects contains a geometry with longitude -181.000000, which is out of range. It must be within (-180.000000, 180.000000].
2301 SELECT MBRIntersects(@pt_long_plus_181, @pt);
2302 ERROR 22S02: A parameter of function mbrintersects contains a geometry with longitude 181.000000, which is out of range. It must be within (-180.000000, 180.000000].
2303 CREATE TABLE t1 (
2304 id INT,
2305 c GEOMETRY NOT NULL SRID 0,
2306 g GEOMETRY AS (ST_SRID(c, 4326)) STORED NOT NULL SRID 4326,
2307 SPATIAL INDEX c_idx (c),
2308 SPATIAL INDEX g_idx (g)
2309 );
2310 INSERT INTO t1 (id, c) VALUES
2311 (0, ST_GeomFromText('POINT(0 0)')),
2312 (1, ST_GeomFromText('POINT(1 1)')),
2313 (2, ST_GeomFromText('POINT(2 2)')),
2314 (3, ST_GeomFromText('POINT(3 3)')),
2315 (4, ST_GeomFromText('POINT(4 4)')),
2316 (5, ST_GeomFromText('POINT(5 5.00001)')),
2317 (6, ST_GeomFromText('POINT(6 6)')),
2318 (7, ST_GeomFromText('POINT(7 7)'));
2319 SET @py = 'POLYGON((0 0, 10 0, 10 5, 0 5, 0 0))';
2320 SET @cart_py = ST_GeomFromText(@py);
2321 SET @geo_py = ST_GeomFromText(@py, 4326, 'axis-order=long-lat');
2322 SET @mpt = 'MULTIPOINT((0 0), (10 5))';
2323 SET @cart_mpt = ST_GeomFromText(@mpt);
2324 SET @geo_mpt = ST_GeomFromText(@mpt, 4326, 'axis-order=long-lat');
2325 # Cartesian ST_Intersects
2326 SELECT id, ST_AsText(c)
2327 FROM t1 IGNORE INDEX(c_idx)
2328 WHERE ST_Intersects(c, @cart_py)
2329 ORDER BY id;
2330 id ST_AsText(c)
2331 0 POINT(0 0)
2332 1 POINT(1 1)
2333 2 POINT(2 2)
2334 3 POINT(3 3)
2335 4 POINT(4 4)
2336 SELECT id, ST_AsText(c)
2337 FROM t1 FORCE INDEX(c_idx)
2338 WHERE ST_Intersects(c, @cart_py)
2339 ORDER BY id;
2340 id ST_AsText(c)
2341 0 POINT(0 0)
2342 1 POINT(1 1)
2343 2 POINT(2 2)
2344 3 POINT(3 3)
2345 4 POINT(4 4)
2346 # Geographic ST_Intersects
2347 SELECT id, ST_AsText(g)
2348 FROM t1 IGNORE INDEX(g_idx)
2349 WHERE ST_Intersects(g, @geo_py)
2350 ORDER BY id;
2351 id ST_AsText(g)
2352 0 POINT(0 0)
2353 1 POINT(1 1)
2354 2 POINT(2 2)
2355 3 POINT(3 3)
2356 4 POINT(4 4)
2357 5 POINT(5.00001 5)
2358 SELECT id, ST_AsText(g)
2359 FROM t1 FORCE INDEX(g_idx)
2360 WHERE ST_Intersects(g, @geo_py)
2361 ORDER BY id;
2362 id ST_AsText(g)
2363 0 POINT(0 0)
2364 1 POINT(1 1)
2365 2 POINT(2 2)
2366 3 POINT(3 3)
2367 4 POINT(4 4)
2368 5 POINT(5.00001 5)
2369 # Cartesian MBRIntersects
2370 SELECT id, ST_AsText(c)
2371 FROM t1 IGNORE INDEX(c_idx)
2372 WHERE MBRIntersects(c, @cart_py)
2373 ORDER BY id;
2374 id ST_AsText(c)
2375 0 POINT(0 0)
2376 1 POINT(1 1)
2377 2 POINT(2 2)
2378 3 POINT(3 3)
2379 4 POINT(4 4)
2380 SELECT id, ST_AsText(c)
2381 FROM t1 FORCE INDEX(c_idx)
2382 WHERE MBRIntersects(c, @cart_py)
2383 ORDER BY id;
2384 id ST_AsText(c)
2385 0 POINT(0 0)
2386 1 POINT(1 1)
2387 2 POINT(2 2)
2388 3 POINT(3 3)
2389 4 POINT(4 4)
2390 SELECT id, ST_AsText(c)
2391 FROM t1 IGNORE INDEX(c_idx)
2392 WHERE MBRIntersects(c, @cart_mpt)
2393 ORDER BY id;
2394 id ST_AsText(c)
2395 0 POINT(0 0)
2396 1 POINT(1 1)
2397 2 POINT(2 2)
2398 3 POINT(3 3)
2399 4 POINT(4 4)
2400 SELECT id, ST_AsText(c)
2401 FROM t1 FORCE INDEX(c_idx)
2402 WHERE MBRIntersects(c, @cart_mpt)
2403 ORDER BY id;
2404 id ST_AsText(c)
2405 0 POINT(0 0)
2406 1 POINT(1 1)
2407 2 POINT(2 2)
2408 3 POINT(3 3)
2409 4 POINT(4 4)
2410 # Geographic MBRIntersects
2411 SELECT id, ST_AsText(g)
2412 FROM t1 IGNORE INDEX(g_idx)
2413 WHERE MBRIntersects(g, @geo_py)
2414 ORDER BY id;
2415 id ST_AsText(g)
2416 0 POINT(0 0)
2417 1 POINT(1 1)
2418 2 POINT(2 2)
2419 3 POINT(3 3)
2420 4 POINT(4 4)
2421 5 POINT(5.00001 5)
2422 SELECT id, ST_AsText(g)
2423 FROM t1 FORCE INDEX(g_idx)
2424 WHERE MBRIntersects(g, @geo_py)
2425 ORDER BY id;
2426 id ST_AsText(g)
2427 0 POINT(0 0)
2428 1 POINT(1 1)
2429 2 POINT(2 2)
2430 3 POINT(3 3)
2431 4 POINT(4 4)
2432 5 POINT(5.00001 5)
2433 SELECT id, ST_AsText(g)
2434 FROM t1 IGNORE INDEX(g_idx)
2435 WHERE MBRIntersects(g, @geo_mpt)
2436 ORDER BY id;
2437 id ST_AsText(g)
2438 0 POINT(0 0)
2439 1 POINT(1 1)
2440 2 POINT(2 2)
2441 3 POINT(3 3)
2442 4 POINT(4 4)
2443 SELECT id, ST_AsText(g)
2444 FROM t1 FORCE INDEX(g_idx)
2445 WHERE MBRIntersects(g, @geo_mpt)
2446 ORDER BY id;
2447 id ST_AsText(g)
2448 0 POINT(0 0)
2449 1 POINT(1 1)
2450 2 POINT(2 2)
2451 3 POINT(3 3)
2452 4 POINT(4 4)
2453 DROP TABLE t1;
2454 #
2455 # WL#11096 Don't do Cartesian computations on geographic geometries
2456 #
2457 # Assume SRID 10 is not defined.
2458 DO MBRINTERSECTS(
2459 x'0A000000010100000000000000000000000000000000000000',
2460 x'0A000000010100000000000000000000000000000000000000'
2461 );
2462 ERROR SR001: There's no spatial reference system with SRID 10.
2463 DO ST_INTERSECTS(
2464 x'0A000000010100000000000000000000000000000000000000',
2465 x'0A000000010100000000000000000000000000000000000000'
2466 );
2467 ERROR SR001: There's no spatial reference system with SRID 10.