Debian Codegraph @

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