Debian Codegraph @

mysql-test/suite/gis/r/spatial_testing_functions_covers.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 # MBRCOVERS(g1,g2)
161 #####################################################################################
162 #====================================================================================
163 # point,point
164 #====================================================================================
165 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
166 MBRCOVERS(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center))
167 1
168 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
169 MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center))
170 0
171 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=105;
172 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_center))
173 1
174 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
175 MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'))
176 1
177 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
178 MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'))
179 0
180 #====================================================================================
181 # point,multipoint
182 #====================================================================================
183 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
184 MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points))
185 0
186 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=106;
187 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points))
188 0
189 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
190 MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'))
191 1
192 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
193 MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'))
194 0
195 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
196 MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'))
197 0
198 #====================================================================================
199 # point,linestring
200 #====================================================================================
201 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
202 MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center))
203 0
204 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
205 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center))
206 0
207 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0)'));
208 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
209 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
210 MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'))
211 0
212 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
213 MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'))
214 0
215 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
216 MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'))
217 0
218 #====================================================================================
219 # point,multilinestring
220 #====================================================================================
221 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
222 MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical))
223 0
224 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
225 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
226 0
227 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0))'));
228 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
229 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
230 MBRCOVERS(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'))
231 0
232 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
233 MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'))
234 0
235 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
236 MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'))
237 0
238 #====================================================================================
239 # point,polygon
240 #====================================================================================
241 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
242 MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star))
243 0
244 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=104;
245 MBRCOVERS(g,ST_GEOMFROMTEXT(@star))
246 0
247 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
248 MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'))
249 0
250 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
251 MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'))
252 0
253 SELECT MBRCOVERS(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))'));
254 MBRCOVERS(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))'))
255 0
256 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
257 MBRCOVERS(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'))
258 0
259 #====================================================================================
260 # point,multipolygon
261 #====================================================================================
262 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
263 MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems))
264 0
265 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
266 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems))
267 0
268 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
269 MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'))
270 0
271 SELECT MBRCOVERS(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)))'));
272 MBRCOVERS(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)))'))
273 0
274 SELECT MBRCOVERS(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)))'));
275 MBRCOVERS(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)))'))
276 0
277 #====================================================================================
278 # point,geometrycollection
279 #====================================================================================
280 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
281 MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems))
282 0
283 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
284 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems))
285 0
286 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
287 MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr))
288 0
289 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
290 MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
291 NULL
292 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
293 MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
294 NULL
295 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
296 MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'))
297 1
298 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
299 MBRCOVERS(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'))
300 0
301 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
302 MBRCOVERS(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'))
303 0
304 #====================================================================================
305 # multipoint,point
306 #====================================================================================
307 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
308 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top))
309 1
310 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
311 MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center))
312 0
313 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
314 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_left))
315 1
316 #====================================================================================
317 # multipoint,multipoint
318 #====================================================================================
319 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points));
320 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_bottom_points))
321 1
322 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
323 MBRCOVERS(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points))
324 0
325 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=108;
326 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_all_points))
327 0
328 #====================================================================================
329 # multipoint,linestring
330 #====================================================================================
331 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
332 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center))
333 1
334 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=109;
335 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center))
336 1
337 #====================================================================================
338 # multipoint,multilinestring
339 #====================================================================================
340 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
341 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_vertical))
342 0
343 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
344 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
345 0
346 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=109;
347 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal))
348 0
349 #====================================================================================
350 # multipoint,polygon
351 #====================================================================================
352 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical));
353 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_vertical))
354 1
355 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
356 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal))
357 0
358 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=109;
359 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_horizontal))
360 0
361 #====================================================================================
362 # multipoint,multipolygon
363 #====================================================================================
364 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems));
365 MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_of_elems))
366 1
367 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
368 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems))
369 0
370 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=109;
371 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems))
372 0
373 #====================================================================================
374 # multipoint,geometrycollection
375 #====================================================================================
376 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems));
377 MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 30,30 25)'),ST_GEOMFROMTEXT(@star_collection_elems))
378 1
379 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
380 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems))
381 0
382 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=109;
383 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems))
384 0
385 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr));
386 MBRCOVERS(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_multilinestr))
387 0
388 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(5 5,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
389 MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOINT(5 5,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
390 NULL
391 #====================================================================================
392 # linestring,point
393 #====================================================================================
394 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
395 MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center))
396 1
397 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
398 MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left))
399 0
400 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
401 MBRCOVERS(g,g2)
402 0
403 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
404 MBRCOVERS(g,g2)
405 0
406 #====================================================================================
407 # linestring,multipoint
408 #====================================================================================
409 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
410 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
411 1
412 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
413 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points))
414 0
415 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)')) FROM gis_geometrycollection WHERE fid=111;
416 MBRCOVERS(g,ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
417 1
418 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'));
419 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT('MULTIPOINT(15 10,15 25)'))
420 1
421 #====================================================================================
422 # linestring,linestring
423 #====================================================================================
424 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
425 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center))
426 1
427 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
428 MBRCOVERS(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical))
429 0
430 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=111;
431 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center))
432 1
433 #====================================================================================
434 # linestring,multilinestring
435 #====================================================================================
436 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
437 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
438 0
439 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical));
440 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_vertical))
441 0
442 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=110;
443 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal))
444 0
445 #====================================================================================
446 # linestring,polygon
447 #====================================================================================
448 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
449 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'))
450 0
451 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
452 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal))
453 0
454 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT('POLYGON((11 15,19 15,11 15))')) FROM gis_geometrycollection WHERE fid=110;
455 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
456 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'));
457 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('POLYGON((11 15,19 15,19 10,11 15))'))
458 0
459 #====================================================================================
460 # linestring,multipolygon
461 #====================================================================================
462 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))'));
463 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
464 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
465 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems))
466 0
467 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT('MULTIPOLYGON(((11 15,19 15,11 15)),((25 0,0 15,25 0)))')) FROM gis_geometrycollection WHERE fid=110;
468 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
469 #====================================================================================
470 # linestring,geometrycollection
471 #====================================================================================
472 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
473 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3))
474 0
475 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
476 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems))
477 0
478 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems_3)) FROM gis_geometrycollection WHERE fid=110;
479 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems_3))
480 0
481 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
482 MBRCOVERS(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr))
483 0
484 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
485 MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
486 NULL
487 #====================================================================================
488 # multilinestring,point
489 #====================================================================================
490 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
491 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top))
492 1
493 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
494 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center))
495 1
496 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
497 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top))
498 1
499 #====================================================================================
500 # multilinestring,multipoint
501 #====================================================================================
502 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points));
503 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points))
504 0
505 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
506 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points))
507 0
508 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=114;
509 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points))
510 0
511 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
512 MBRCOVERS(g,g2)
513 0
514 #====================================================================================
515 # multilinestring,linestring
516 #====================================================================================
517 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
518 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical))
519 1
520 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
521 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal))
522 0
523 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
524 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical))
525 1
526 #====================================================================================
527 # multilinestring,multilinestring
528 #====================================================================================
529 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'));
530 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'))
531 1
532 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
533 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
534 0
535 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))')) FROM gis_geometrycollection WHERE fid=114;
536 MBRCOVERS(g,ST_GEOMFROMTEXT('MULTILINESTRING((0 5,15 25,0 15))'))
537 1
538 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
539 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical))
540 1
541 #====================================================================================
542 # multilinestring,polygon
543 #====================================================================================
544 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical));
545 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_vertical))
546 0
547 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
548 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal))
549 0
550 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
551 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
552 0
553 #====================================================================================
554 # multilinestring,multipolygon
555 #====================================================================================
556 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical));
557 MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_elem_vertical))
558 1
559 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
560 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems))
561 0
562 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=114;
563 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems))
564 0
565 #====================================================================================
566 # multilinestring,geometrycollection
567 #====================================================================================
568 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems));
569 MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 25,25 0,25 30))'),ST_GEOMFROMTEXT(@star_collection_elems))
570 0
571 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
572 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems))
573 0
574 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=114;
575 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems))
576 0
577 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr));
578 MBRCOVERS(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr))
579 0
580 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
581 MBRCOVERS(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
582 NULL
583 #====================================================================================
584 # polygon,point
585 #====================================================================================
586 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
587 MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center))
588 1
589 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
590 MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'))
591 0
592 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
593 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_center))
594 1
595 #====================================================================================
596 # polygon,multipoint
597 #====================================================================================
598 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points));
599 MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points))
600 1
601 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
602 MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'))
603 0
604 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
605 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_all_points))
606 1
607 #====================================================================================
608 # polygon,linestring
609 #====================================================================================
610 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical));
611 MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical))
612 1
613 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
614 MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal))
615 1
616 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=100;
617 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_line_vertical))
618 1
619 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
620 MBRCOVERS(g,g2)
621 1
622 #====================================================================================
623 # polygon,multilinestring
624 #====================================================================================
625 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical));
626 MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_lines_near_vertical))
627 1
628 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
629 MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal))
630 0
631 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=100;
632 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
633 1
634 #====================================================================================
635 # polygon,polygon
636 #====================================================================================
637 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical));
638 MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical))
639 1
640 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
641 MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star))
642 0
643 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=100;
644 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
645 1
646 #====================================================================================
647 # polygon,multipolygon
648 #====================================================================================
649 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems));
650 MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems))
651 1
652 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
653 MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems))
654 0
655 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
656 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems))
657 1
658 #====================================================================================
659 # polygon,geometrycollection
660 #====================================================================================
661 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems));
662 MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems))
663 1
664 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
665 MBRCOVERS(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems))
666 0
667 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
668 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems))
669 1
670 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
671 MBRCOVERS(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr))
672 0
673 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
674 MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,0 0))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
675 NULL
676 #====================================================================================
677 # multipolygon,point
678 #====================================================================================
679 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
680 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top))
681 1
682 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
683 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POINT(30 30)'))
684 0
685 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=103;
686 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top))
687 1
688 #====================================================================================
689 # multipolygon,multipoint
690 #====================================================================================
691 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
692 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points))
693 1
694 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
695 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'))
696 0
697 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
698 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points))
699 1
700 #====================================================================================
701 # multipolygon,linestring
702 #====================================================================================
703 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
704 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center))
705 1
706 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
707 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'))
708 0
709 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
710 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center))
711 1
712 #====================================================================================
713 # multipolygon,multilinestring
714 #====================================================================================
715 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
716 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical))
717 1
718 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
719 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'))
720 0
721 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
722 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
723 1
724 #====================================================================================
725 # multipolygon,polygon
726 #====================================================================================
727 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
728 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical))
729 1
730 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star));
731 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star))
732 1
733 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
734 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'))
735 0
736 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=103;
737 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
738 1
739 #====================================================================================
740 # multipolygon,multipolygon
741 #====================================================================================
742 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
743 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems))
744 1
745 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
746 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'))
747 0
748 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=103;
749 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_of_elems))
750 1
751 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
752 MBRCOVERS(g,g2)
753 1
754 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
755 MBRCOVERS(g,g2)
756 1
757 #====================================================================================
758 # multipolygon,geometrycollection
759 #====================================================================================
760 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
761 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems))
762 1
763 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
764 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems_3))
765 0
766 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=103;
767 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems))
768 1
769 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=215;
770 MBRCOVERS(g,g2)
771 1
772 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
773 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr))
774 0
775 SELECT MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
776 MBRCOVERS(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 4,4 4,0 0)),((0 5,0 10,10 5,0 5)))'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'))
777 NULL
778 #====================================================================================
779 # geometrycollection,point
780 #====================================================================================
781 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
782 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top))
783 1
784 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'));
785 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POINT(30 30)'))
786 0
787 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=115;
788 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top))
789 1
790 Select MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)))'),ST_GEOMFROMTEXT('POINT(100 100)'));
791 MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(),POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)))'),ST_GEOMFROMTEXT('POINT(100 100)'))
792 0
793 Select MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('POINT(100 100)'));
794 MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0,0 0)),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('POINT(100 100)'))
795 0
796 #====================================================================================
797 # geometrycollection,multipoint
798 #====================================================================================
799 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
800 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points))
801 1
802 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'));
803 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOINT(30 30,0 35)'))
804 0
805 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
806 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_bottom_points))
807 1
808 SELECT MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('MULTIPOINT(5 0,10 0)'));
809 MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('MULTIPOINT(5 0,10 0)'))
810 1
811 #====================================================================================
812 # geometrycollection,linestring
813 #====================================================================================
814 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
815 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center))
816 1
817 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'));
818 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('LINESTRING(30 30,0 35)'))
819 0
820 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
821 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_top_to_center))
822 1
823 SELECT MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('LINESTRING(5 0,10 0)'));
824 MBRCOVERS(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,10 10,20 20),GEOMETRYCOLLECTION())'),ST_GEOMFROMTEXT('LINESTRING(5 0,10 0)'))
825 1
826 #====================================================================================
827 # geometrycollection,multilinestring
828 #====================================================================================
829 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical));
830 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical))
831 1
832 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
833 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'))
834 0
835 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
836 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_lines_near_vertical))
837 1
838 #====================================================================================
839 # geometrycollection,polygon
840 #====================================================================================
841 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
842 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical))
843 1
844 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star));
845 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star))
846 1
847 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
848 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'))
849 0
850 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=115;
851 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_elem_vertical))
852 1
853 #====================================================================================
854 # geometrycollection,multipolygon
855 #====================================================================================
856 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
857 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems))
858 1
859 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'));
860 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,15 25,35 0,0 0),(5 0,15 25,25 0,15 5,5 0)))'))
861 0
862 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
863 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems))
864 1
865 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=103;
866 MBRCOVERS(g,g2)
867 1
868 #====================================================================================
869 # geometrycollection,geometrycollection
870 #====================================================================================
871 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
872 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems))
873 1
874 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
875 MBRCOVERS(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3))
876 0
877 SELECT MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=115;
878 MBRCOVERS(g,ST_GEOMFROMTEXT(@star_collection_elems))
879 1
880 SELECT MBRCOVERS(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=115 and fid2=215;
881 MBRCOVERS(g,g2)
882 1
883 #####################################################################################
884 # Testing MBRCOVERS() with 2 geometries of same SRID
885 #####################################################################################
886 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
887 MBRCOVERS(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0))
888 0
889 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
890 MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145))
891 0
892 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
893 MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326))
894 0
895 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
896 MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135))
897 0
898 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
899 MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145))
900 0
901 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
902 MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326))
903 0
904 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
905 MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135))
906 0
907 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
908 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
909 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
910 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
911 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
912 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
913 #####################################################################################
914 # Invalid function calls
915 #####################################################################################
916 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
917 ERROR HY000: Binary geometry function mbrcovers given two geometries of different srids: 0 and 4326, which should have been identical.
918 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
919 ERROR HY000: Binary geometry function mbrcovers given two geometries of different srids: 4145 and 4326, which should have been identical.
920 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
921 ERROR HY000: Binary geometry function mbrcovers given two geometries of different srids: 4145 and 4326, which should have been identical.
922 SELECT MBRCOVERS(NULL,ST_GEOMFROMTEXT(@star_top));
923 MBRCOVERS(NULL,ST_GEOMFROMTEXT(@star_top))
924 NULL
925 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),NULL);
926 MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),NULL)
927 NULL
928 SELECT MBRCOVERS(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
929 MBRCOVERS(g,NULL)
930 NULL
931 SELECT MBRCOVERS(NULL,NULL);
932 MBRCOVERS(NULL,NULL)
933 NULL
934 SELECT MBRCOVERS(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
935 MBRCOVERS(fid,NULL)
936 NULL
937 SELECT MBRCOVERS(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
938 ERROR 22023: Invalid GIS data provided to function mbrcovers.
939 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
940 ERROR 22023: Invalid GIS data provided to function mbrcovers.
941 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
942 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
943 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
944 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
945 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
946 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
947 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
948 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
949 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
950 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
951 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
952 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
953 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
954 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
955 SELECT MBRCOVERS(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
956 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
957 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
958 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
959 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
960 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
961 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
962 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
963 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
964 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
965 SELECT MBRCOVERS(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
966 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
967 SELECT MBRCOVERS(,);
968 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
969 SELECT MBRCOVERS(ST_GEOMFROMTEXT(@star_of_elems),);
970 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
971 SELECT MBRCOVERS(,ST_GEOMFROMTEXT(@star_top));
972 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
973 CREATE TABLE t1 (g GEOMETRY NOT NULL);
974 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POINT(1 1)'));
975 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'));
976 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
977 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
978 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4))'));
979 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTIPOINT(1 1, 2 2)'));
980 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2),'
981 '(3 3, 4 4))'));
982 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
983 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)),((5 5, 10 5, 10 10, 5 10, 5 5)))'));
984 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
985 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
986 '(6 6, 7 6, 7 7, 6 7, 6 6)))'));
987 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
988 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((1 1, 10 1, 10 10, 1 10, 1 1), '
989 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
990 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'));
991 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
992 'GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'));
993 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0, 1 0, 1'
994 ' 1, 0 1, 0 0)))'));
995 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
996 'GEOMETRYCOLLECTION(POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), '
997 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
998 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
999 'GEOMETRYCOLLECTION(MULTIPOINT(1 1, 2 2))'));
1000 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1001 'GEOMETRYCOLLECTION(MULTILINESTRING((1 1, 2 2), (3 3, 4 4)))'));
1002 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1003 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1004 '((5 5, 10 5, 10 10, 5 10, 5 5))))'));
1005 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1006 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1007 '((5 5, 10 5, 10 10, 5 10, 5 5), (6 6, 7 6, 7 7, 6 7, 6 6))))'));
1008 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1009 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1010 '((1 1, 10 1, 10 10, 1 10, 1 1), (4 4, 6 4, 6 6, 4 6, 4 4))))'));
1011 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1012 'GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(1 1, 2 2),'
1013 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)),'
1014 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4)),'
1015 'MULTIPOINT(1 1, 2 2),MULTILINESTRING((1 1, 2 2), (3 3, 4 4)),'
1016 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))),'
1017 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
1018 '(6 6, 7 6, 7 7, 6 7, 6 6))))'));
1019 INSERT INTO t1 VALUES(
1020 GEOMETRYCOLLECTION(POINT(1,1),LINESTRING(POINT(1,1),POINT(2,2)),
1021 POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0))),
1022 POLYGON(LINESTRING(POINT(0,0),POINT(10,0),POINT(10,10),POINT(0,10),
1023 POINT(0,0)),LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),POINT(4,6),
1024 POINT(4,4))),MULTIPOINT(POINT(1,1),POINT(2,2)),
1025 MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),LINESTRING(POINT(3,3),
1026 POINT(4,4))),MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
1027 POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1028 POINT(10,10),POINT(5,10),POINT(5,5)))),
1029 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),
1030 POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),POINT(10,10),
1031 POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),POINT(7,7),
1032 POINT(6,7),POINT(6,6)))),GEOMETRYCOLLECTION(POINT(1,1)),
1033 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
1034 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
1035 POINT(0,1),POINT(0,0)))),GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),
1036 POINT(10,0),POINT(10,10),POINT(0,10),POINT(0,0)),LINESTRING(POINT(4,4),
1037 POINT(6,4),POINT(6,6),POINT(4,6),POINT(4,4)))),
1038 GEOMETRYCOLLECTION(MULTIPOINT(POINT(1,1),POINT(2,2))),
1039 GEOMETRYCOLLECTION(MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),
1040 LINESTRING(POINT(3,3),POINT(4,4)))),
1041 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
1042 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1043 POINT(10,10),POINT(5,10),POINT(5,5))))),
1044 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
1045 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1046 POINT(10,10),POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),
1047 POINT(7,7),POINT(6,7),POINT(6,6)))))));
1048 INSERT INTO t1 VALUES (
1049 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1,1)),
1050 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
1051 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(1,1), POINT(10,1), POINT(10,10),
1052 POINT(1,10), POINT(1,1)), LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),
1053 POINT(4,6),POINT(4,4))))));
1054 SELECT MBRCOVERS(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
1055 SELECT MBRCOVERS(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
1056 FROM t1 AS a JOIN t1 AS b;
1057 # clean up
1058 DROP TABLE t1;
1059 DROP TABLE gis_geometrycollection;
1060 DROP TABLE gis_geometrycollection_2;
1061 #
1062 # WL#8579 Spatial Reference Systems
1063 #
1064 # SRID 0 (should pass)
1065 SELECT MBRCOVERS(
1066 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1067 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1068 );
1069 MBRCOVERS(
1070 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1071 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1072 )
1073 1
1074 # Projected SRS (should pass)
1075 SELECT MBRCOVERS(
1076 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1077 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1078 );
1079 MBRCOVERS(
1080 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1081 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1082 )
1083 1
1084 # Geographic SRS (should pass)
1085 SELECT MBRCOVERS(
1086 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1087 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1088 );
1089 MBRCOVERS(
1090 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1091 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1092 )
1093 1
1094 #
1095 # WL#10827 Ellipsoidal R-tree support functions
1096 #
1097 SET @pt = ST_GeomFromText('POINT(0 0)', 4326);
1098 SET @pt_lat_minus_91 = x'E6100000010100000000000000000000000000000000C056C0';
1099 SET @pt_lat_plus_91 = x'E6100000010100000000000000000000000000000000C05640';
1100 SET @pt_long_minus_181 = x'E610000001010000000000000000A066C00000000000000000';
1101 SET @pt_long_plus_181 = x'E610000001010000000000000000A066400000000000000000';
1102 SELECT MBRCovers(@pt_lat_minus_91, @pt);
1103 ERROR 22S03: A parameter of function mbrcovers contains a geometry with latitude -91.000000, which is out of range. It must be within [-90.000000, 90.000000].
1104 SELECT MBRCovers(@pt_lat_plus_91, @pt);
1105 ERROR 22S03: A parameter of function mbrcovers contains a geometry with latitude 91.000000, which is out of range. It must be within [-90.000000, 90.000000].
1106 SELECT MBRCovers(@pt_long_minus_181, @pt);
1107 ERROR 22S02: A parameter of function mbrcovers contains a geometry with longitude -181.000000, which is out of range. It must be within (-180.000000, 180.000000].
1108 SELECT MBRCovers(@pt_long_plus_181, @pt);
1109 ERROR 22S02: A parameter of function mbrcovers contains a geometry with longitude 181.000000, which is out of range. It must be within (-180.000000, 180.000000].
1110 CREATE TABLE t1 (
1111 id INT,
1112 c GEOMETRY NOT NULL SRID 0,
1113 g GEOMETRY AS (ST_SRID(c, 4326)) STORED NOT NULL SRID 4326,
1114 SPATIAL INDEX c_idx (c),
1115 SPATIAL INDEX g_idx (g)
1116 );
1117 INSERT INTO t1 (id, c) VALUES
1118 (0, ST_GeomFromText('POINT(0 0)')),
1119 (1, ST_GeomFromText('POINT(1 1)')),
1120 (2, ST_GeomFromText('POINT(2 2)')),
1121 (3, ST_GeomFromText('POINT(3 3)')),
1122 (4, ST_GeomFromText('POINT(4 4)')),
1123 (5, ST_GeomFromText('POINT(5 5.00001)')),
1124 (6, ST_GeomFromText('POINT(6 6)')),
1125 (7, ST_GeomFromText('POINT(7 7)'));
1126 SET @py = 'POLYGON((0 0, 10 0, 10 5, 0 5, 0 0))';
1127 SET @cart_py = ST_GeomFromText(@py);
1128 SET @geo_py = ST_GeomFromText(@py, 4326, 'axis-order=long-lat');
1129 SET @mpt = 'MULTIPOINT((0 0), (10 5))';
1130 SET @cart_mpt = ST_GeomFromText(@mpt);
1131 SET @geo_mpt = ST_GeomFromText(@mpt, 4326, 'axis-order=long-lat');
1132 # Cartesian MBRCovers
1133 SELECT id, ST_AsText(c)
1134 FROM t1 IGNORE INDEX(c_idx)
1135 WHERE MBRCovers(@cart_py, c)
1136 ORDER BY id;
1137 id ST_AsText(c)
1138 0 POINT(0 0)
1139 1 POINT(1 1)
1140 2 POINT(2 2)
1141 3 POINT(3 3)
1142 4 POINT(4 4)
1143 SELECT id, ST_AsText(c)
1144 FROM t1 FORCE INDEX(c_idx)
1145 WHERE MBRCovers(@cart_py, c)
1146 ORDER BY id;
1147 id ST_AsText(c)
1148 0 POINT(0 0)
1149 1 POINT(1 1)
1150 2 POINT(2 2)
1151 3 POINT(3 3)
1152 4 POINT(4 4)
1153 SELECT id, ST_AsText(c)
1154 FROM t1 IGNORE INDEX(c_idx)
1155 WHERE MBRCovers(@cart_mpt, c)
1156 ORDER BY id;
1157 id ST_AsText(c)
1158 0 POINT(0 0)
1159 1 POINT(1 1)
1160 2 POINT(2 2)
1161 3 POINT(3 3)
1162 4 POINT(4 4)
1163 SELECT id, ST_AsText(c)
1164 FROM t1 FORCE INDEX(c_idx)
1165 WHERE MBRCovers(@cart_mpt, c)
1166 ORDER BY id;
1167 id ST_AsText(c)
1168 0 POINT(0 0)
1169 1 POINT(1 1)
1170 2 POINT(2 2)
1171 3 POINT(3 3)
1172 4 POINT(4 4)
1173 # Geographic MBRCovers
1174 SELECT id, ST_AsText(g)
1175 FROM t1 IGNORE INDEX(g_idx)
1176 WHERE MBRCovers(@geo_py, g)
1177 ORDER BY id;
1178 id ST_AsText(g)
1179 0 POINT(0 0)
1180 1 POINT(1 1)
1181 2 POINT(2 2)
1182 3 POINT(3 3)
1183 4 POINT(4 4)
1184 5 POINT(5.00001 5)
1185 SELECT id, ST_AsText(g)
1186 FROM t1 FORCE INDEX(g_idx)
1187 WHERE MBRCovers(@geo_py, g)
1188 ORDER BY id;
1189 id ST_AsText(g)
1190 0 POINT(0 0)
1191 1 POINT(1 1)
1192 2 POINT(2 2)
1193 3 POINT(3 3)
1194 4 POINT(4 4)
1195 5 POINT(5.00001 5)
1196 SELECT id, ST_AsText(g)
1197 FROM t1 IGNORE INDEX(g_idx)
1198 WHERE MBRCovers(@geo_mpt, g)
1199 ORDER BY id;
1200 id ST_AsText(g)
1201 0 POINT(0 0)
1202 1 POINT(1 1)
1203 2 POINT(2 2)
1204 3 POINT(3 3)
1205 4 POINT(4 4)
1206 SELECT id, ST_AsText(g)
1207 FROM t1 FORCE INDEX(g_idx)
1208 WHERE MBRCovers(@geo_mpt, g)
1209 ORDER BY id;
1210 id ST_AsText(g)
1211 0 POINT(0 0)
1212 1 POINT(1 1)
1213 2 POINT(2 2)
1214 3 POINT(3 3)
1215 4 POINT(4 4)
1216 DROP TABLE t1;
1217 #
1218 # WL#11096 Don't do Cartesian computations on geographic geometries
1219 #
1220 # Assume SRID 10 is not defined.
1221 DO MBRCOVERS(
1222 x'0A000000010100000000000000000000000000000000000000',
1223 x'0A000000010100000000000000000000000000000000000000'
1224 );
1225 ERROR SR001: There's no spatial reference system with SRID 10.