Debian Codegraph @

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

raw
1 ###############################################################################
2 # #
3 # This test is aimed to focus on Functions for testing Relations between #
4 # Geometry Objects. #
5 # #
6 # These functions take 2 geometries as inpout parameters and return #
7 # a qualitative or quantitavive realtion between themrealtion between them. #
8 # #
9 # Creation Date: 2013-12-16 #
10 # Author : Horst Hunger #
11 # #
12 ###############################################################################
13
14
15 ############################################################################################
16 # Creating the spatial objects #
17 ############################################################################################
18
19 --echo #Creating the spatial Geometry object
20 USE test;
21
22 CREATE TABLE gis_geometrycollection (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
23
24 ############################################################################################
25 # Inserting the values specific to the spatial objects #
26 ############################################################################################
27
28 # Geometric elements constructing a star and some of its elememts as base
29 SET @star_elem_vertical= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
30 SET @star_elem_horizontal= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
31 SET @star_center= 'POINT(15 10)';
32 SET @star_top= 'POINT(15 25)';
33 SET @star_bottom_left= 'POINT(5 0)';
34 SET @star_bottom_right= 'POINT(25 0)';
35 SET @star_bottom_points= 'MULTIPOINT(5 0,25 0)';
36 SET @star_all_points= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
37 SET @star_line_horizontal= 'LINESTRING(10 15,20 15)';
38 SET @star_line_vertical= 'LINESTRING(15 5,15 25)';
39 SET @star_top_to_center= 'LINESTRING(15 25,15 10)';
40 SET @star_lines_near_horizontal= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
41 SET @star_lines_near_vertical= 'MULTILINESTRING((0 5,15 25,0 25))';
42 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))';
43 SET @star_elem_vertical_val= '((5 0,15 25,25 0,15 5,5 0))';
44 SET @star_elem_horizontal_val= '((25 0,0 15,30 15,22 10,25 0))';
45 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)))';
46 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))';
47 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))';
48
49 # Star identical to the base star
50 SET @star_elem_vertical_1= 'POLYGON((5 0,15 25,25 0,15 5,5 0))';
51 SET @star_elem_horizontal_1= 'POLYGON((25 0,0 15,30 15,22 10,25 0))';
52 SET @star_center_1= 'POINT(15 10)';
53 SET @star_top_1= 'POINT(15 25)';
54 SET @star_bottom_left_1= 'POINT(5 0)';
55 SET @star_bottom_right_1= 'POINT(25 0)';
56 SET @star_bottom_points_1= 'MULTIPOINT(5 0,25 0)';
57 SET @star_all_points_1= 'MULTIPOINT(5 0,25 0,15 10,15 25)';
58 SET @star_line_horizontal_1= 'LINESTRING(10 15,20 15)';
59 SET @star_line_vertical_1= 'LINESTRING(15 5,15 25)';
60 SET @star_top_to_center_1= 'LINESTRING(15 25,15 10)';
61 SET @star_lines_near_horizontal_1= 'MULTILINESTRING((25 0,0 15,15 30,0 5))';
62 SET @star_lines_near_vertical_1= 'MULTILINESTRING((0 5,15 25,0 25))';
63 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))';
64 SET @star_elem_vertical_val_1= '((5 0,15 25,25 0,15 5,5 0))';
65 SET @star_elem_horizontal_val_1= '((25 0,0 15,30 15,22 10,25 0))';
66 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)))';
67 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))';
68
69 # Star like the base star, but shifted to right by 10 on X to overlap base star
70 SET @star_elem_vertical_2= 'POLYGON((15 0,25 25,35 0,25 5,15 0))';
71 SET @star_elem_horizontal_2= 'POLYGON((35 0,10 15,40 15,32 10,35 0))';
72 SET @star_center_2= 'POINT(25 10)';
73 SET @star_top_2= 'POINT(25 25)';
74 SET @star_bottom_left_2= 'POINT(15 0)';
75 SET @star_bottom_right_2= 'POINT(35 0)';
76 SET @star_bottom_points_2= 'MULTIPOINT(15 0,35 0)';
77 SET @star_all_points_2= 'MULTIPOINT(15 0,35 0,35 10,25 25)';
78 SET @star_line_horizontal_2= 'LINESTRING(20 15,30 15)';
79 SET @star_line_vertical_2= 'LINESTRING(25 5,25 25)';
80 SET @star_top_to_center_2= 'LINESTRING(25 25,25 10)';
81 SET @star_lines_near_horizontal_2= 'MULTILINESTRING((35 0,10 15,25 30,10 5))';
82 SET @star_lines_near_vertical_2= 'MULTILINESTRING((10 5,25 25,10 25))';
83 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))';
84 SET @star_elem_vertical_val_2= '((15 0,25 25,35 0,25 5,15 0))';
85 SET @star_elem_horizontal_val_2= '((35 0,10 15,40 15,32 10,35 0))';
86 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)))';
87 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))';
88
89 # Star like the base star, but shifted to right by 60 on X to be completly separate
90 SET @star_elem_vertical_3= 'POLYGON((65 0,75 25,85 0,75 5,65 0))';
91 SET @star_elem_horizontal_3= 'POLYGON((85 0,60 15,90 15,82 10,85 0))';
92 SET @star_center_3= 'POINT(75 10)';
93 SET @star_top_3= 'POINT(75 25)';
94 SET @star_bottom_left_3= 'POINT(65 0)';
95 SET @star_bottom_right_3= 'POINT(85 0)';
96 SET @star_bottom_points_3= 'MULTIPOINT(65 0,85 0)';
97 SET @star_all_points_3= 'MULTIPOINT(65 0,85 0,75 10,75 25)';
98 SET @star_line_horizontal_3= 'LINESTRING(70 15,80 15)';
99 SET @star_line_vertical_3= 'LINESTRING(75 5,75 25)';
100 SET @star_top_to_center_3= 'LINESTRING(75 25,75 10)';
101 SET @star_lines_near_horizontal_3= 'MULTILINESTRING((85 0,60 15,85 30,60 5))';
102 SET @star_lines_near_vertical_3= 'MULTILINESTRING((60 5,75 25,60 25))';
103 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))';
104 SET @star_elem_vertical_val_3= '((65 0,75 25,85 0,75 5,65 0))';
105 SET @star_elem_horizontal_val_3= '((85 0,60 15,90 15,82 10,85 0))';
106 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)))';
107 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))';
108
109 --echo #INSERT base star
110 --disable_warnings
111 INSERT INTO gis_geometrycollection VALUES
112 (100,ST_GEOMFROMTEXT(@star)),
113 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
114 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
115 (103,ST_GEOMFROMTEXT(@star_of_elems)),
116 (104,ST_GEOMFROMTEXT(@star_top)),
117 (105,ST_GEOMFROMTEXT(@star_center)),
118 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
119 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
120 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
121 (109,ST_GEOMFROMTEXT(@star_all_points)),
122 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
123 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
124 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
125 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
126 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
127 (115,ST_GEOMFROMTEXT(@star_collection_elems));
128 --enable_warnings
129
130 --echo #INSERT identical (to base) star
131 --disable_warnings
132 INSERT INTO gis_geometrycollection VALUES
133 (200,ST_GEOMFROMTEXT(@star_1)),
134 (201,ST_GEOMFROMTEXT(@star_elem_vertical_1)),
135 (202,ST_GEOMFROMTEXT(@star_elem_horizontal_1)),
136 (203,ST_GEOMFROMTEXT(@star_of_elems_1)),
137 (204,ST_GEOMFROMTEXT(@star_top_1)),
138 (205,ST_GEOMFROMTEXT(@star_center_1)),
139 (206,ST_GEOMFROMTEXT(@star_bottom_left_1)),
140 (207,ST_GEOMFROMTEXT(@star_bottom_right_1)),
141 (208,ST_GEOMFROMTEXT(@star_bottom_points_1)),
142 (209,ST_GEOMFROMTEXT(@star_all_points_1)),
143 (210,ST_GEOMFROMTEXT(@star_line_horizontal_1)),
144 (211,ST_GEOMFROMTEXT(@star_line_vertical_1)),
145 (212,ST_GEOMFROMTEXT(@star_top_to_center_1)),
146 (213,ST_GEOMFROMTEXT(@star_lines_near_horizontal_1)),
147 (214,ST_GEOMFROMTEXT(@star_lines_near_vertical_1)),
148 (215,ST_GEOMFROMTEXT(@star_collection_elems_1));
149 --enable_warnings
150
151 --echo #INSERT overlapping star
152 --disable_warnings
153 INSERT INTO gis_geometrycollection VALUES
154 (300,ST_GEOMFROMTEXT(@star_2)),
155 (301,ST_GEOMFROMTEXT(@star_elem_vertical_2)),
156 (302,ST_GEOMFROMTEXT(@star_elem_horizontal_2)),
157 (303,ST_GEOMFROMTEXT(@star_of_elems_2)),
158 (304,ST_GEOMFROMTEXT(@star_top_2)),
159 (305,ST_GEOMFROMTEXT(@star_center_2)),
160 (306,ST_GEOMFROMTEXT(@star_bottom_left_2)),
161 (307,ST_GEOMFROMTEXT(@star_bottom_right_2)),
162 (308,ST_GEOMFROMTEXT(@star_bottom_points_2)),
163 (309,ST_GEOMFROMTEXT(@star_all_points_2)),
164 (310,ST_GEOMFROMTEXT(@star_line_horizontal_2)),
165 (311,ST_GEOMFROMTEXT(@star_line_vertical_2)),
166 (312,ST_GEOMFROMTEXT(@star_top_to_center_2)),
167 (313,ST_GEOMFROMTEXT(@star_lines_near_horizontal_2)),
168 (314,ST_GEOMFROMTEXT(@star_lines_near_vertical_2)),
169 (315,ST_GEOMFROMTEXT(@star_collection_elems_2));
170 --enable_warnings
171
172 --echo #INSERT separate star
173 --disable_warnings
174 INSERT INTO gis_geometrycollection VALUES
175 (400,ST_GEOMFROMTEXT(@star_3)),
176 (401,ST_GEOMFROMTEXT(@star_elem_vertical_3)),
177 (402,ST_GEOMFROMTEXT(@star_elem_horizontal_3)),
178 (403,ST_GEOMFROMTEXT(@star_of_elems_3)),
179 (404,ST_GEOMFROMTEXT(@star_top_3)),
180 (405,ST_GEOMFROMTEXT(@star_center_3)),
181 (406,ST_GEOMFROMTEXT(@star_bottom_left_3)),
182 (407,ST_GEOMFROMTEXT(@star_bottom_right_3)),
183 (408,ST_GEOMFROMTEXT(@star_bottom_points_3)),
184 (409,ST_GEOMFROMTEXT(@star_all_points_3)),
185 (410,ST_GEOMFROMTEXT(@star_line_horizontal_3)),
186 (411,ST_GEOMFROMTEXT(@star_line_vertical_3)),
187 (412,ST_GEOMFROMTEXT(@star_top_to_center_3)),
188 (413,ST_GEOMFROMTEXT(@star_lines_near_horizontal_3)),
189 (414,ST_GEOMFROMTEXT(@star_lines_near_vertical_3)),
190 (415,ST_GEOMFROMTEXT(@star_collection_elems_3));
191 --enable_warnings
192
193 CREATE TABLE gis_geometrycollection_2 SELECT fid as fid2,g as g2 FROM gis_geometrycollection;
194
195 --echo #Checking the integrity of the above create/insert statements
196
197 --echo #64 rows.
198 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
199 --echo #64 rows.
200 SELECT count(ST_ASTEXT(g2) != 'NULL') FROM gis_geometrycollection_2;
201
202 ############################################################################################
203 # Checking the spatial testing functions #
204 ############################################################################################
205
206 --echo #####################################################################################
207 --echo # MBRDISJOINT(g1,g2)
208 --echo #####################################################################################
209
210 --echo #====================================================================================
211 --echo # point,point
212 --echo #====================================================================================
213 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
214
215 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
216
217 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=104;
218
219 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
220
221 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
222
223 --echo #====================================================================================
224 --echo # point,multipoint
225 --echo #====================================================================================
226 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_bottom_points));
227
228 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
229
230 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=108;
231
232 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
233
234 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
235
236 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
237
238 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
239
240 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
241
242 --echo #====================================================================================
243 --echo # point,linestring
244 --echo #====================================================================================
245 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_line_vertical));
246
247 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
248
249 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
250
251 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
252
253 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
254
255 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
256
257 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
258
259 --echo #====================================================================================
260 --echo # point,multilinestring
261 --echo #====================================================================================
262 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_lines_near_vertical));
263
264 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
265
266 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
267
268 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'));
269
270 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
271
272 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
273
274 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
275
276 --echo #====================================================================================
277 --echo # point,polygon
278 --echo #====================================================================================
279 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top_3),ST_GEOMFROMTEXT(@star));
280
281 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
282
283 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=404;
284
285 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
286
287 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
288
289 SELECT MBRDISJOINT(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))'));
290
291 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
292
293 --echo #====================================================================================
294 --echo # point,multipolygon
295 --echo #====================================================================================
296 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
297
298 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
299
300 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
301
302 SELECT MBRDISJOINT(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)))'));
303
304 SELECT MBRDISJOINT(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)))'));
305
306 SELECT MBRDISJOINT(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)))'));
307
308 --echo #====================================================================================
309 --echo # point,geometrycollection
310 --echo #====================================================================================
311 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
312
313 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
314
315 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
316
317 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
318
319 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
320
321 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
322
323 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
324
325 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
326
327 --echo #====================================================================================
328 --echo # multipoint,point
329 --echo #====================================================================================
330 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
331
332 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
333
334 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
335
336 --echo #====================================================================================
337 --echo # multipoint,multipoint
338 --echo #====================================================================================
339 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_all_points_3),ST_GEOMFROMTEXT(@star_bottom_points));
340
341 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
342
343 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=408;
344
345 --echo #====================================================================================
346 --echo # multipoint,linestring
347 --echo #====================================================================================
348 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
349
350 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=409;
351
352 --echo #====================================================================================
353 --echo # multipoint,multilinestring
354 --echo #====================================================================================
355 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
356
357 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
358
359 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=409;
360
361 --echo #====================================================================================
362 --echo # multipoint,polygon
363 --echo #====================================================================================
364 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
365
366 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
367
368 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=401;
369
370 --echo #====================================================================================
371 --echo # multipoint,multipolygon
372 --echo #====================================================================================
373 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems_3),ST_GEOMFROMTEXT(@star_of_elems));
374
375 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
376
377 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
378
379 --echo #====================================================================================
380 --echo # multipoint,geometrycollection
381 --echo #====================================================================================
382 --echo # Invalid geometry in input
383 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems_3),ST_GEOMFROMTEXT(@star_collection_elems));
384
385 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
386
387 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
388
389 --echo # Invalid geometry in input
390 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems_3),ST_GEOMFROMTEXT(@star_collection_multilinestr));
391
392 --echo #====================================================================================
393 --echo # linestring,point
394 --echo #====================================================================================
395 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
396
397 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
398
399 SELECT MBRDISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
400
401 --echo #====================================================================================
402 --echo # linestring,multipoint
403 --echo #====================================================================================
404 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points_3));
405
406 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
407
408 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_all_points_3)) FROM gis_geometrycollection WHERE fid=111;
409
410 --echo #====================================================================================
411 --echo # linestring,linestring
412 --echo #====================================================================================
413 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
414
415 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
416
417 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center_3)) FROM gis_geometrycollection WHERE fid=111;
418
419 --echo #====================================================================================
420 --echo # linestring,multilinestring
421 --echo #====================================================================================
422 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
423
424 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal_3),ST_GEOMFROMTEXT(@star_lines_near_vertical));
425
426 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal_3)) FROM gis_geometrycollection WHERE fid=110;
427
428 --echo #====================================================================================
429 --echo # linestring,polygon
430 --echo #====================================================================================
431 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_vertical_3));
432
433 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
434
435 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical_3)) FROM gis_geometrycollection WHERE fid=110;
436
437 --echo #====================================================================================
438 --echo # linestring,multipolygon
439 --echo #====================================================================================
440 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3));
441
442 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
443
444 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems_3)) FROM gis_geometrycollection WHERE fid=110;
445
446 --echo #====================================================================================
447 --echo # linestring,geometrycollection
448 --echo #====================================================================================
449 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
450
451 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
452
453 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems_3)) FROM gis_geometrycollection WHERE fid=110;
454
455 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
456
457 --echo #====================================================================================
458 --echo # multilinestring,point
459 --echo #====================================================================================
460 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
461
462 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
463
464 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
465
466 --echo #====================================================================================
467 --echo # multilinestring,multipoint
468 --echo #====================================================================================
469 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points_3));
470
471 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
472
473 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_bottom_points_3)) FROM gis_geometrycollection WHERE fid=114;
474
475 SELECT MBRDISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
476
477 --echo #====================================================================================
478 --echo # multilinestring,linestring
479 --echo #====================================================================================
480 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
481
482 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
483
484 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
485
486 --echo #====================================================================================
487 --echo # multilinestring,multilinestring
488 --echo #====================================================================================
489 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_near_vertical_3));
490
491 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
492
493 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=114;
494
495 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_line_vertical_3)) FROM gis_geometrycollection WHERE fid=114;
496
497 --echo #====================================================================================
498 --echo # multilinestring,polygon
499 --echo #====================================================================================
500 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_verticali_3));
501
502 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
503
504 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
505
506 --echo #====================================================================================
507 --echo # multilinestring,multipolygon
508 --echo #====================================================================================
509 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elems_vertical_3),ST_GEOMFROMTEXT(@star_of_elems));
510
511 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
512
513 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems_3)) FROM gis_geometrycollection WHERE fid=114;
514
515 --echo #====================================================================================
516 --echo # multilinestring,geometrycollection
517 --echo #====================================================================================
518 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elems_vertical_3),ST_GEOMFROMTEXT(@star_collection_elems));
519
520 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
521
522 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems_3)) FROM gis_geometrycollection WHERE fid=114;
523
524 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_multilinestr));
525
526 --echo #====================================================================================
527 --echo # polygon,point
528 --echo #====================================================================================
529 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
530
531 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
532
533 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
534
535 --echo #====================================================================================
536 --echo # polygon,multipoint
537 --echo #====================================================================================
538 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points_3));
539
540 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
541
542 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
543
544 --echo #====================================================================================
545 --echo # polygon,linestring
546 --echo #====================================================================================
547 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical_3));
548
549 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
550
551 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=400;
552
553 SELECT MBRDISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
554
555 --echo #====================================================================================
556 --echo # polygon,multilinestring
557 --echo #====================================================================================
558 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_3),ST_GEOMFROMTEXT(@star_lines_near_vertical));
559
560 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
561
562 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=400;
563
564 --echo #====================================================================================
565 --echo # polygon,polygon
566 --echo #====================================================================================
567 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical_3));
568
569 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
570
571 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical_3)) FROM gis_geometrycollection WHERE fid=100;
572
573 --echo #====================================================================================
574 --echo # polygon,multipolygon
575 --echo #====================================================================================
576 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems_3));
577
578 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
579
580 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
581
582 --echo #====================================================================================
583 --echo # polygon,geometrycollection
584 --echo #====================================================================================
585 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems_3));
586
587 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
588
589 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
590
591 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
592
593 --echo #====================================================================================
594 --echo # multipolygon,point
595 --echo #====================================================================================
596 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
597
598 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_3));
599
600 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_top_3)) FROM gis_geometrycollection WHERE fid=103;
601
602 --echo #====================================================================================
603 --echo # multipolygon,multipoint
604 --echo #====================================================================================
605 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points_3));
606
607 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
608
609 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
610
611 --echo #====================================================================================
612 --echo # multipolygon,linestring
613 --echo #====================================================================================
614 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center_3));
615
616 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
617
618 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
619
620 --echo #====================================================================================
621 --echo # multipolygon,multilinestring
622 --echo #====================================================================================
623 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical_3));
624
625 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
626
627 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
628
629 --echo #====================================================================================
630 --echo # multipolygon,polygon
631 --echo #====================================================================================
632 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
633
634 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_3));
635
636 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
637
638 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=403;
639
640 --echo #====================================================================================
641 --echo # multipolygon,multipolygon
642 --echo #====================================================================================
643 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems_3));
644
645 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
646
647 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
648
649 SELECT MBRDISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
650
651 --echo #====================================================================================
652 --echo # multipolygon,geometrycollection
653 --echo #====================================================================================
654 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
655
656 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
657
658 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
659
660 SELECT MBRDISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
661
662 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
663
664 --echo #====================================================================================
665 --echo # geometrycollection,point
666 --echo #====================================================================================
667 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
668
669 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_3));
670
671 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_top_3)) FROM gis_geometrycollection WHERE fid=115;
672
673 --echo #====================================================================================
674 --echo # geometrycollection,multipoint
675 --echo #====================================================================================
676 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points_3));
677
678 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
679
680 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
681
682 --echo #====================================================================================
683 --echo # geometrycollection,linestring
684 --echo #====================================================================================
685 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center_3));
686
687 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
688
689 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
690
691 --echo #====================================================================================
692 --echo # geometrycollection,multilinestring
693 --echo #====================================================================================
694 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical_3));
695
696 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
697
698 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
699
700 --echo #====================================================================================
701 --echo # geometrycollection,polygon
702 --echo #====================================================================================
703 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
704
705 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_3));
706
707 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
708
709 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=415;
710
711 --echo #====================================================================================
712 --echo # geometrycollection,multipolygon
713 --echo #====================================================================================
714 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems_3));
715
716 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
717
718 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
719
720 SELECT MBRDISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
721
722 --echo #====================================================================================
723 --echo # geometrycollection,geometrycollection
724 --echo #====================================================================================
725 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
726
727 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
728
729 SELECT MBRDISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
730
731 SELECT MBRDISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
732
733 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
734
735 --echo #####################################################################################
736 --echo # ST_DISJOINT(g1,g2)
737 --echo #####################################################################################
738
739 --echo #====================================================================================
740 --echo # point,point
741 --echo #====================================================================================
742 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center));
743
744 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_center));
745
746 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=104;
747
748 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(0 0)'));
749
750 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POINT(10 0)'));
751
752 --echo #====================================================================================
753 --echo # point,multipoint
754 --echo #====================================================================================
755 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_bottom_points));
756
757 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_bottom_points));
758
759 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=108;
760
761 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0)'));
762
763 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 0)'));
764
765 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
766
767 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
768
769 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,5 0,10 0)'));
770
771 --echo #====================================================================================
772 --echo # point,linestring
773 --echo #====================================================================================
774 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_bottom_left),ST_GEOMFROMTEXT(@star_line_vertical));
775
776 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_top_to_center));
777
778 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=104;
779
780 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
781
782 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
783
784 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0,20 0)'));
785
786 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 0)'));
787
788 --echo #====================================================================================
789 --echo # point,multilinestring
790 --echo #====================================================================================
791 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_center),ST_GEOMFROMTEXT(@star_lines_near_vertical));
792
793 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_lines_near_vertical));
794
795 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=104;
796
797 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 0))'));
798
799 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(10 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
800
801 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0,10 0))'));
802
803 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(20 0)'),ST_GEOMFROMTEXT('MULTILINESTRING((0 0,5 0),(5 0,10 0))'));
804
805 --echo #====================================================================================
806 --echo # point,polygon
807 --echo #====================================================================================
808 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top_3),ST_GEOMFROMTEXT(@star));
809
810 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star));
811
812 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star)) FROM gis_geometrycollection WHERE fid=404;
813
814 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
815
816 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(5 0)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
817
818 SELECT ST_DISJOINT(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))'));
819
820 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
821
822 --echo #====================================================================================
823 --echo # point,multipolygon
824 --echo #====================================================================================
825 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_of_elems));
826
827 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=104;
828
829 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)))'));
830
831 SELECT ST_DISJOINT(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)))'));
832
833 SELECT ST_DISJOINT(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)))'));
834
835 SELECT ST_DISJOINT(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)))'));
836
837 --echo #====================================================================================
838 --echo # point,geometrycollection
839 --echo #====================================================================================
840 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_elems));
841
842 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=104;
843
844 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_collection_multilinestr));
845
846 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())'));
847
848 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5))'));
849
850 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(5 5)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT(0 0,5 5,10 10),GEOMETRYCOLLECTION())'));
851
852 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(0 0)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
853
854 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(20 20)'),ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))))'));
855
856 --echo #====================================================================================
857 --echo # multipoint,point
858 --echo #====================================================================================
859 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top));
860
861 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_center));
862
863 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_bottom_left)) FROM gis_geometrycollection WHERE fid=108;
864
865 --echo #====================================================================================
866 --echo # multipoint,multipoint
867 --echo #====================================================================================
868 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_all_points_3),ST_GEOMFROMTEXT(@star_bottom_points));
869
870 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_all_points));
871
872 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=408;
873
874 --echo #====================================================================================
875 --echo # multipoint,linestring
876 --echo #====================================================================================
877 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_top_to_center));
878
879 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=409;
880
881 --echo #====================================================================================
882 --echo # multipoint,multilinestring
883 --echo #====================================================================================
884 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_lines_near_vertical));
885
886 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
887
888 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal)) FROM gis_geometrycollection WHERE fid=409;
889
890 --echo #====================================================================================
891 --echo # multipoint,polygon
892 --echo #====================================================================================
893 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_bottom_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
894
895 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_elem_horizontal));
896
897 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_elem_horizontal)) FROM gis_geometrycollection WHERE fid=401;
898
899 --echo #====================================================================================
900 --echo # multipoint,multipolygon
901 --echo #====================================================================================
902 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems_3),ST_GEOMFROMTEXT(@star_of_elems));
903
904 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_of_elems));
905
906 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
907
908 --echo #====================================================================================
909 --echo # multipoint,geometrycollection
910 --echo #====================================================================================
911 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems_3),ST_GEOMFROMTEXT(@star_collection_elems));
912
913 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_all_points),ST_GEOMFROMTEXT(@star_collection_elems));
914
915 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
916
917 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems_3),ST_GEOMFROMTEXT(@star_collection_multilinestr));
918
919 --echo #====================================================================================
920 --echo # linestring,point
921 --echo #====================================================================================
922 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_bottom_left));
923
924 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_center));
925
926 SELECT ST_DISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=110 and fid2=105;
927
928 --echo #====================================================================================
929 --echo # linestring,multipoint
930 --echo #====================================================================================
931 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points_3));
932
933 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_all_points));
934
935 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_all_points_3)) FROM gis_geometrycollection WHERE fid=111;
936
937 --echo #====================================================================================
938 --echo # linestring,linestring
939 --echo #====================================================================================
940 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_vertical),ST_GEOMFROMTEXT(@star_top_to_center));
941
942 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top_to_center),ST_GEOMFROMTEXT(@star_line_vertical));
943
944 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center_3)) FROM gis_geometrycollection WHERE fid=111;
945
946 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('LINESTRING(5 5,10 10)'), ST_GEOMFROMTEXT('LINESTRING(6 6,3 3)'));
947
948 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('LINESTRING(5 5,2 8)'), ST_GEOMFROMTEXT('LINESTRING(4 6,7 3)'));
949
950 --echo #====================================================================================
951 --echo # linestring,multilinestring
952 --echo #====================================================================================
953 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
954
955 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal_3),ST_GEOMFROMTEXT(@star_lines_near_vertical));
956
957 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_horizontal_3)) FROM gis_geometrycollection WHERE fid=110;
958
959 --echo #====================================================================================
960 --echo # linestring,polygon
961 --echo #====================================================================================
962 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_vertical_3));
963
964 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_elem_horizontal));
965
966 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical_3)) FROM gis_geometrycollection WHERE fid=110;
967
968 --echo #====================================================================================
969 --echo # linestring,multipolygon
970 --echo #====================================================================================
971 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems_3));
972
973 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_of_elems));
974
975 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems_3)) FROM gis_geometrycollection WHERE fid=110;
976
977 --echo #====================================================================================
978 --echo # linestring,geometrycollection
979 --echo #====================================================================================
980 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems_3));
981
982 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_elems));
983
984 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems_3)) FROM gis_geometrycollection WHERE fid=110;
985
986 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_line_horizontal),ST_GEOMFROMTEXT(@star_collection_multilinestr));
987
988 --echo #====================================================================================
989 --echo # multilinestring,point
990 --echo #====================================================================================
991 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_top));
992
993 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_center));
994
995 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection WHERE fid=114;
996
997 --echo #====================================================================================
998 --echo # multilinestring,multipoint
999 --echo #====================================================================================
1000 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_bottom_points_3));
1001
1002 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_all_points));
1003
1004 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_bottom_points_3)) FROM gis_geometrycollection WHERE fid=114;
1005
1006 SELECT ST_DISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=114 and fid2=108;
1007
1008 --echo #====================================================================================
1009 --echo # multilinestring,linestring
1010 --echo #====================================================================================
1011 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_vertical));
1012
1013 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
1014
1015 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=114;
1016
1017 --echo #====================================================================================
1018 --echo # multilinestring,multilinestring
1019 --echo #====================================================================================
1020 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_near_vertical_3));
1021
1022 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1023
1024 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=114;
1025
1026 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_line_vertical_3)) FROM gis_geometrycollection WHERE fid=114;
1027
1028 --echo #====================================================================================
1029 --echo # multilinestring,polygon
1030 --echo #====================================================================================
1031 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_verticali_3));
1032
1033 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_elem_horizontal));
1034
1035 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=114;
1036
1037 --echo #====================================================================================
1038 --echo # multilinestring,multipolygon
1039 --echo #====================================================================================
1040 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elems_vertical_3),ST_GEOMFROMTEXT(@star_of_elems));
1041
1042 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_of_elems));
1043
1044 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems_3)) FROM gis_geometrycollection WHERE fid=114;
1045
1046 --echo #====================================================================================
1047 --echo # multilinestring,geometrycollection
1048 --echo #====================================================================================
1049 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elems_vertical_3),ST_GEOMFROMTEXT(@star_collection_elems));
1050
1051 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_lines_near_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
1052
1053 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems_3)) FROM gis_geometrycollection WHERE fid=114;
1054
1055 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elems_vertical_3),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1056
1057 --echo #====================================================================================
1058 --echo # polygon,point
1059 --echo #====================================================================================
1060 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_center));
1061
1062 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('POINT(0 0)'));
1063
1064 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_center)) FROM gis_geometrycollection WHERE fid=100;
1065
1066 --echo #====================================================================================
1067 --echo # polygon,multipoint
1068 --echo #====================================================================================
1069 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_all_points_3));
1070
1071 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT('MULTIPOINT(0 0,30 25)'));
1072
1073 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_all_points)) FROM gis_geometrycollection WHERE fid=100;
1074
1075 --echo #====================================================================================
1076 --echo # polygon,linestring
1077 --echo #====================================================================================
1078 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_line_vertical_3));
1079
1080 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_line_horizontal));
1081
1082 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_line_vertical)) FROM gis_geometrycollection WHERE fid=400;
1083
1084 SELECT ST_DISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=100 and fid2=111;
1085
1086 --echo #====================================================================================
1087 --echo # polygon,multilinestring
1088 --echo #====================================================================================
1089 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_3),ST_GEOMFROMTEXT(@star_lines_near_vertical));
1090
1091 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_lines_near_horizontal));
1092
1093 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=400;
1094
1095 --echo #====================================================================================
1096 --echo # polygon,polygon
1097 --echo #====================================================================================
1098 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_elem_vertical_3));
1099
1100 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star));
1101
1102 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical_3)) FROM gis_geometrycollection WHERE fid=100;
1103
1104 --echo #====================================================================================
1105 --echo # polygon,multipolygon
1106 --echo #====================================================================================
1107 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_of_elems_3));
1108
1109 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_of_elems));
1110
1111 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=100;
1112
1113 --echo #====================================================================================
1114 --echo # polygon,geometrycollection
1115 --echo #====================================================================================
1116 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_elems_3));
1117
1118 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_elem_vertical),ST_GEOMFROMTEXT(@star_collection_elems));
1119
1120 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=100;
1121
1122 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1123
1124 --echo #====================================================================================
1125 --echo # multipolygon,point
1126 --echo #====================================================================================
1127 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top));
1128
1129 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_3));
1130
1131 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_top_3)) FROM gis_geometrycollection WHERE fid=103;
1132
1133 --echo #====================================================================================
1134 --echo # multipolygon,multipoint
1135 --echo #====================================================================================
1136 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points_3));
1137
1138 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_bottom_points));
1139
1140 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=103;
1141
1142 --echo #====================================================================================
1143 --echo # multipolygon,linestring
1144 --echo #====================================================================================
1145 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center_3));
1146
1147 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_top_to_center));
1148
1149 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=103;
1150
1151 --echo #====================================================================================
1152 --echo # multipolygon,multilinestring
1153 --echo #====================================================================================
1154 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical_3));
1155
1156 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
1157
1158 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=103;
1159
1160 --echo #====================================================================================
1161 --echo # multipolygon,polygon
1162 --echo #====================================================================================
1163 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
1164
1165 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_3));
1166
1167 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0))'));
1168
1169 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=403;
1170
1171 --echo #====================================================================================
1172 --echo # multipolygon,multipolygon
1173 --echo #====================================================================================
1174 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems_3));
1175
1176 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_of_elems));
1177
1178 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_of_elems)) FROM gis_geometrycollection WHERE fid=403;
1179
1180 SELECT ST_DISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1181
1182 --echo #====================================================================================
1183 --echo # multipolygon,geometrycollection
1184 --echo #====================================================================================
1185 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
1186
1187 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),ST_GEOMFROMTEXT(@star_collection_elems));
1188
1189 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=403;
1190
1191 SELECT ST_DISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
1192
1193 --echo #====================================================================================
1194 --echo # geometrycollection,point
1195 --echo #====================================================================================
1196 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top));
1197
1198 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_3));
1199
1200 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_top_3)) FROM gis_geometrycollection WHERE fid=115;
1201
1202 --echo #====================================================================================
1203 --echo # geometrycollection,multipoint
1204 --echo #====================================================================================
1205 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points_3));
1206
1207 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_bottom_points));
1208
1209 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_bottom_points)) FROM gis_geometrycollection WHERE fid=115;
1210
1211 --echo #====================================================================================
1212 --echo # geometrycollection,linestring
1213 --echo #====================================================================================
1214 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center_3));
1215
1216 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_top_to_center));
1217
1218 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_top_to_center)) FROM gis_geometrycollection WHERE fid=115;
1219
1220 --echo #====================================================================================
1221 --echo # geometrycollection,multilinestring
1222 --echo #====================================================================================
1223 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_lines_near_vertical_3));
1224
1225 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('MULTILINESTRING((0 30,30 30,0 35))'));
1226
1227 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_lines_near_vertical)) FROM gis_geometrycollection WHERE fid=115;
1228
1229 --echo #====================================================================================
1230 --echo # geometrycollection,polygon
1231 --echo #====================================================================================
1232 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_elem_vertical));
1233
1234 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_3));
1235
1236 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT('POLYGON((0 0,15 25,35 0,0 0,0 0))'));
1237
1238 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_elem_vertical)) FROM gis_geometrycollection WHERE fid=415;
1239
1240 --echo #====================================================================================
1241 --echo # geometrycollection,multipolygon
1242 --echo #====================================================================================
1243 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems_3));
1244
1245 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_of_elems));
1246
1247 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
1248
1249 SELECT ST_DISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
1250
1251 --echo #====================================================================================
1252 --echo # geometrycollection,geometrycollection
1253 --echo #====================================================================================
1254 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems_3));
1255
1256 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_elems));
1257
1258 SELECT ST_DISJOINT(g,ST_GEOMFROMTEXT(@star_collection_elems)) FROM gis_geometrycollection WHERE fid=415;
1259
1260 SELECT ST_DISJOINT(g,g2) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=115;
1261
1262 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_collection_elems),ST_GEOMFROMTEXT(@star_collection_multilinestr));
1263
1264 --echo #####################################################################################
1265 --echo # Testing with 2 geometries of same SRID
1266 --echo #####################################################################################
1267
1268 --echo #====================================================================================
1269 --echo # MBRDISJOINT(g1,g2)
1270 --echo #====================================================================================
1271 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
1272
1273 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1274
1275 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
1276
1277 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
1278
1279 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1280
1281 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
1282
1283 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
1284
1285 --error ER_DATA_OUT_OF_RANGE
1286 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
1287
1288 --error ER_DATA_OUT_OF_RANGE
1289 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
1290
1291 --error ER_DATA_OUT_OF_RANGE
1292 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
1293
1294 --echo #====================================================================================
1295 --echo # ST_DISJOINT(g1,g2)
1296 --echo #====================================================================================
1297 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,0),ST_GEOMFROMTEXT(@star_center,0));
1298
1299 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1300
1301 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
1302
1303 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
1304
1305 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4145));
1306
1307 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4326),ST_GEOMFROMTEXT(@star_center,4326));
1308
1309 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4135),ST_GEOMFROMTEXT(@star_center,4135));
1310
1311 --error ER_DATA_OUT_OF_RANGE
1312 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,-1),ST_GEOMFROMTEXT(@star_center,-1));
1313
1314 --error ER_DATA_OUT_OF_RANGE
1315 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,-1024),ST_GEOMFROMTEXT(@star_center,-1024));
1316
1317 --error ER_DATA_OUT_OF_RANGE
1318 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4294967295000),ST_GEOMFROMTEXT(@star_center,4294967295000));
1319
1320 --echo #####################################################################################
1321 --echo # Invalid function calls
1322 --echo #####################################################################################
1323
1324 --echo #====================================================================================
1325 --echo # ST_DISJOINT(g1,g2)
1326 --echo #====================================================================================
1327 --error ER_GIS_DIFFERENT_SRIDS
1328 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
1329
1330 --error ER_GIS_DIFFERENT_SRIDS
1331 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
1332
1333 --error ER_GIS_DIFFERENT_SRIDS
1334 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
1335
1336 SELECT ST_DISJOINT(NULL,ST_GEOMFROMTEXT(@star_top));
1337
1338 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),NULL);
1339
1340 SELECT ST_DISJOINT(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1341
1342 SELECT ST_DISJOINT(NULL,NULL);
1343
1344 SELECT ST_DISJOINT(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1345
1346 --error ER_GIS_INVALID_DATA
1347 SELECT ST_DISJOINT(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1348
1349 --error ER_GIS_INVALID_DATA
1350 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1351
1352 --error ER_GIS_INVALID_DATA
1353 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1354
1355 --error ER_GIS_INVALID_DATA
1356 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1357
1358 --error ER_PARSE_ERROR
1359 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1360
1361 --error ER_GIS_INVALID_DATA
1362 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1363
1364 --error ER_GIS_INVALID_DATA
1365 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1366
1367 --error ER_GIS_INVALID_DATA
1368 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1369
1370 --error ER_PARSE_ERROR
1371 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1372
1373 --error ER_GIS_INVALID_DATA
1374 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1375
1376 --error ER_GIS_INVALID_DATA
1377 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1378
1379 --error ER_GIS_INVALID_DATA
1380 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1381
1382 --error ER_PARSE_ERROR
1383 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1384
1385 --error ER_GIS_INVALID_DATA
1386 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1387
1388 --error ER_GIS_INVALID_DATA
1389 SELECT ST_DISJOINT(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1390
1391 --error ER_PARSE_ERROR
1392 SELECT ST_DISJOINT(,);
1393
1394 --error ER_PARSE_ERROR
1395 SELECT ST_DISJOINT(ST_GEOMFROMTEXT(@star_of_elems),);
1396
1397 --error ER_PARSE_ERROR
1398 SELECT ST_DISJOINT(,ST_GEOMFROMTEXT(@star_top));
1399
1400 --echo #====================================================================================
1401 --echo # MBRDISJOINT(g1,g2)
1402 --echo #====================================================================================
1403 --error ER_GIS_DIFFERENT_SRIDS
1404 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top),ST_GEOMFROMTEXT(@star_center,4326));
1405
1406 --error ER_GIS_DIFFERENT_SRIDS
1407 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
1408
1409 --error ER_GIS_DIFFERENT_SRIDS
1410 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_top,4145),ST_GEOMFROMTEXT(@star_center,4326));
1411
1412 SELECT MBRDISJOINT(NULL,ST_GEOMFROMTEXT(@star_top));
1413
1414 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),NULL);
1415
1416 SELECT MBRDISJOINT(g,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1417
1418 SELECT MBRDISJOINT(NULL,NULL);
1419
1420 SELECT MBRDISJOINT(fid,NULL) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1421
1422 --error ER_GIS_INVALID_DATA
1423 SELECT MBRDISJOINT(fid,ST_GEOMFROMTEXT(@star_top)) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1424
1425 --error ER_GIS_INVALID_DATA
1426 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),fid) FROM gis_geometrycollection,gis_geometrycollection_2 WHERE fid=103 and fid2=103;
1427
1428 --error ER_GIS_INVALID_DATA
1429 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(a 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1430
1431 --error ER_GIS_INVALID_DATA
1432 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(! 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1433
1434 --error ER_PARSE_ERROR
1435 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT('!' 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1436
1437 --error ER_GIS_INVALID_DATA
1438 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POINT(12,34 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1439
1440 --error ER_GIS_INVALID_DATA
1441 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1442
1443 --error ER_GIS_INVALID_DATA
1444 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1445
1446 --error ER_PARSE_ERROR
1447 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1448
1449 --error ER_GIS_INVALID_DATA
1450 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1451
1452 --error ER_GIS_INVALID_DATA
1453 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1454
1455 --error ER_GIS_INVALID_DATA
1456 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1457
1458 --error ER_PARSE_ERROR
1459 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1460
1461 --error ER_GIS_INVALID_DATA
1462 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1463
1464 --error ER_GIS_INVALID_DATA
1465 SELECT MBRDISJOINT(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0)'),ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'));
1466
1467 --error ER_PARSE_ERROR
1468 SELECT MBRDISJOINT(,);
1469
1470 --error ER_PARSE_ERROR
1471 SELECT MBRDISJOINT(ST_GEOMFROMTEXT(@star_of_elems),);
1472
1473 --error ER_PARSE_ERROR
1474 SELECT MBRDISJOINT(,ST_GEOMFROMTEXT(@star_top));
1475
1476 # Test with all combinations of geometry types, including types inside geometry collections
1477
1478 CREATE TABLE t1 (g GEOMETRY NOT NULL);
1479
1480 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POINT(1 1)'));
1481 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('LINESTRING(1 1, 2 2)'));
1482 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'));
1483 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1484 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4))'));
1485 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTIPOINT(1 1, 2 2)'));
1486 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('MULTILINESTRING((1 1, 2 2),'
1487 '(3 3, 4 4))'));
1488 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1489 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)),((5 5, 10 5, 10 10, 5 10, 5 5)))'));
1490 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1491 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
1492 '(6 6, 7 6, 7 7, 6 7, 6 6)))'));
1493 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1494 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((1 1, 10 1, 10 10, 1 10, 1 1), '
1495 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
1496 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(1 1))'));
1497 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1498 'GEOMETRYCOLLECTION(LINESTRING(1 1, 2 2))'));
1499 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0, 1 0, 1'
1500 ' 1, 0 1, 0 0)))'));
1501 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1502 'GEOMETRYCOLLECTION(POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), '
1503 '(4 4, 6 4, 6 6, 4 6, 4 4)))'));
1504 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1505 'GEOMETRYCOLLECTION(MULTIPOINT(1 1, 2 2))'));
1506 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1507 'GEOMETRYCOLLECTION(MULTILINESTRING((1 1, 2 2), (3 3, 4 4)))'));
1508 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1509 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1510 '((5 5, 10 5, 10 10, 5 10, 5 5))))'));
1511 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1512 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1513 '((5 5, 10 5, 10 10, 5 10, 5 5), (6 6, 7 6, 7 7, 6 7, 6 6))))'));
1514 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1515 'GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), '
1516 '((1 1, 10 1, 10 10, 1 10, 1 1), (4 4, 6 4, 6 6, 4 6, 4 4))))'));
1517 INSERT INTO t1 VALUES (ST_GEOMFROMTEXT(
1518 'GEOMETRYCOLLECTION(POINT(1 1),LINESTRING(1 1, 2 2),'
1519 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)),'
1520 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0), (4 4, 6 4, 6 6, 4 6, 4 4)),'
1521 'MULTIPOINT(1 1, 2 2),MULTILINESTRING((1 1, 2 2), (3 3, 4 4)),'
1522 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))),'
1523 'MULTIPOLYGON(((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5), '
1524 '(6 6, 7 6, 7 7, 6 7, 6 6))))'));
1525
1526 INSERT INTO t1 VALUES(
1527 GEOMETRYCOLLECTION(POINT(1,1),LINESTRING(POINT(1,1),POINT(2,2)),
1528 POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),POINT(0,0))),
1529 POLYGON(LINESTRING(POINT(0,0),POINT(10,0),POINT(10,10),POINT(0,10),
1530 POINT(0,0)),LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),POINT(4,6),
1531 POINT(4,4))),MULTIPOINT(POINT(1,1),POINT(2,2)),
1532 MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),LINESTRING(POINT(3,3),
1533 POINT(4,4))),MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
1534 POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1535 POINT(10,10),POINT(5,10),POINT(5,5)))),
1536 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),POINT(0,1),
1537 POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),POINT(10,10),
1538 POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),POINT(7,7),
1539 POINT(6,7),POINT(6,6)))),GEOMETRYCOLLECTION(POINT(1,1)),
1540 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
1541 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),POINT(1,1),
1542 POINT(0,1),POINT(0,0)))),GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(0,0),
1543 POINT(10,0),POINT(10,10),POINT(0,10),POINT(0,0)),LINESTRING(POINT(4,4),
1544 POINT(6,4),POINT(6,6),POINT(4,6),POINT(4,4)))),
1545 GEOMETRYCOLLECTION(MULTIPOINT(POINT(1,1),POINT(2,2))),
1546 GEOMETRYCOLLECTION(MultiLINESTRING(LINESTRING(POINT(1,1),POINT(2,2)),
1547 LINESTRING(POINT(3,3),POINT(4,4)))),
1548 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
1549 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1550 POINT(10,10),POINT(5,10),POINT(5,5))))),
1551 GEOMETRYCOLLECTION(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0),POINT(1,0),
1552 POINT(1,1),POINT(0,1),POINT(0,0))),POLYGON(LINESTRING(POINT(5,5),POINT(10,5),
1553 POINT(10,10),POINT(5,10),POINT(5,5)),LINESTRING(POINT(6,6),POINT(7,6),
1554 POINT(7,7),POINT(6,7),POINT(6,6)))))));
1555 INSERT INTO t1 VALUES (
1556 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(1,1)),
1557 GEOMETRYCOLLECTION(LINESTRING(POINT(1,1),POINT(2,2))),
1558 GEOMETRYCOLLECTION(POLYGON(LINESTRING(POINT(1,1), POINT(10,1), POINT(10,10),
1559 POINT(1,10), POINT(1,1)), LINESTRING(POINT(4,4),POINT(6,4),POINT(6,6),
1560 POINT(4,6),POINT(4,4))))));
1561
1562 # We don't care about the result. We just want to put all parameter type
1563 # combinations through the function.
1564 --disable_result_log
1565 SELECT ST_DISJOINT(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
1566 SELECT MBRDISJOINT(a.g, b.g) FROM t1 AS a JOIN t1 AS b;
1567
1568 SELECT ST_DISJOINT(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
1569 FROM t1 AS a JOIN t1 AS b;
1570 SELECT MBRDISJOINT(ST_SRID(a.g, 4326), ST_SRID(b.g, 4326))
1571 FROM t1 AS a JOIN t1 AS b;
1572 --enable_result_log
1573
1574 --echo # clean up
1575 DROP TABLE t1;
1576 DROP TABLE gis_geometrycollection;
1577 DROP TABLE gis_geometrycollection_2;
1578
1579 --echo #
1580 --echo # WL#8579 Spatial Reference Systems
1581 --echo #
1582
1583 --echo # SRID 0 (should pass)
1584 SELECT ST_DISJOINT(
1585 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1586 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1587 );
1588 SELECT MBRDISJOINT(
1589 ST_GEOMFROMTEXT('POINT(0 0)', 0),
1590 ST_GEOMFROMTEXT('POINT(0 0)', 0)
1591 );
1592
1593 --echo # Projected SRS (should pass)
1594 SELECT ST_DISJOINT(
1595 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1596 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1597 );
1598 SELECT MBRDISJOINT(
1599 ST_GEOMFROMTEXT('POINT(0 0)', 2000),
1600 ST_GEOMFROMTEXT('POINT(0 0)', 2000)
1601 );
1602
1603 --echo # Geographic SRS (should pass)
1604 SELECT ST_DISJOINT(
1605 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1606 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1607 );
1608 SELECT MBRDISJOINT(
1609 ST_GEOMFROMTEXT('POINT(0 0)', 4326),
1610 ST_GEOMFROMTEXT('POINT(0 0)', 4326)
1611 );
1612
1613 --echo #
1614 --echo # WL#10827 Ellipsoidal R-tree support functions
1615 --echo #
1616
1617 SET @pt = ST_GeomFromText('POINT(0 0)', 4326);
1618
1619 # SRID=4326, long=0, lat=-91.
1620 SET @pt_lat_minus_91 = x'E6100000010100000000000000000000000000000000C056C0';
1621
1622 # SRID=4326, long=0, lat=91.
1623 SET @pt_lat_plus_91 = x'E6100000010100000000000000000000000000000000C05640';
1624
1625 # SRID=4326, long=-181, lat=0.
1626 SET @pt_long_minus_181 = x'E610000001010000000000000000A066C00000000000000000';
1627
1628 # SRID=4326, long=181, lat=0.
1629 SET @pt_long_plus_181 = x'E610000001010000000000000000A066400000000000000000';
1630
1631 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1632 SELECT ST_Disjoint(@pt_lat_minus_91, @pt);
1633 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1634 SELECT ST_Disjoint(@pt_lat_plus_91, @pt);
1635 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1636 SELECT ST_Disjoint(@pt_long_minus_181, @pt);
1637 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1638 SELECT ST_Disjoint(@pt_long_plus_181, @pt);
1639 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1640 SELECT MBRDisjoint(@pt_lat_minus_91, @pt);
1641 --error ER_GEOMETRY_PARAM_LATITUDE_OUT_OF_RANGE
1642 SELECT MBRDisjoint(@pt_lat_plus_91, @pt);
1643 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1644 SELECT MBRDisjoint(@pt_long_minus_181, @pt);
1645 --error ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE
1646 SELECT MBRDisjoint(@pt_long_plus_181, @pt);
1647
1648 CREATE TABLE t1 (
1649 id INT,
1650 c GEOMETRY NOT NULL SRID 0,
1651 g GEOMETRY AS (ST_SRID(c, 4326)) STORED NOT NULL SRID 4326,
1652 SPATIAL INDEX c_idx (c),
1653 SPATIAL INDEX g_idx (g)
1654 );
1655
1656 INSERT INTO t1 (id, c) VALUES
1657 (0, ST_GeomFromText('POINT(0 0)')),
1658 (1, ST_GeomFromText('POINT(1 1)')),
1659 (2, ST_GeomFromText('POINT(2 2)')),
1660 (3, ST_GeomFromText('POINT(3 3)')),
1661 (4, ST_GeomFromText('POINT(4 4)')),
1662 (5, ST_GeomFromText('POINT(5 5.00001)')),
1663 (6, ST_GeomFromText('POINT(6 6)')),
1664 (7, ST_GeomFromText('POINT(7 7)'));
1665
1666 SET @py = 'POLYGON((0 0, 10 0, 10 5, 0 5, 0 0))';
1667 SET @cart_py = ST_GeomFromText(@py);
1668 SET @geo_py = ST_GeomFromText(@py, 4326, 'axis-order=long-lat');
1669
1670 SET @mpt = 'MULTIPOINT((0 0), (10 5))';
1671 SET @cart_mpt = ST_GeomFromText(@mpt);
1672 SET @geo_mpt = ST_GeomFromText(@mpt, 4326, 'axis-order=long-lat');
1673
1674 --echo # Cartesian ST_Disjoint
1675 SELECT id, ST_AsText(c)
1676 FROM t1 IGNORE INDEX(c_idx)
1677 WHERE ST_Disjoint(c, @cart_py)
1678 ORDER BY id;
1679 SELECT id, ST_AsText(c)
1680 FROM t1 FORCE INDEX(c_idx)
1681 WHERE ST_Disjoint(c, @cart_py)
1682 ORDER BY id;
1683
1684 --echo # Geographic ST_Disjoint
1685 SELECT id, ST_AsText(g)
1686 FROM t1 IGNORE INDEX(g_idx)
1687 WHERE ST_Disjoint(g, @geo_py)
1688 ORDER BY id;
1689 SELECT id, ST_AsText(g)
1690 FROM t1 FORCE INDEX(g_idx)
1691 WHERE ST_Disjoint(g, @geo_py)
1692 ORDER BY id;
1693
1694 --echo # Cartesian MBRDisjoint
1695 SELECT id, ST_AsText(c)
1696 FROM t1 IGNORE INDEX(c_idx)
1697 WHERE MBRDisjoint(c, @cart_py)
1698 ORDER BY id;
1699 SELECT id, ST_AsText(c)
1700 FROM t1 FORCE INDEX(c_idx)
1701 WHERE MBRDisjoint(c, @cart_py)
1702 ORDER BY id;
1703 SELECT id, ST_AsText(c)
1704 FROM t1 IGNORE INDEX(c_idx)
1705 WHERE MBRDisjoint(c, @cart_mpt)
1706 ORDER BY id;
1707 SELECT id, ST_AsText(c)
1708 FROM t1 FORCE INDEX(c_idx)
1709 WHERE MBRDisjoint(c, @cart_mpt)
1710 ORDER BY id;
1711
1712 --echo # Geographic MBRDisjoint
1713 SELECT id, ST_AsText(g)
1714 FROM t1 IGNORE INDEX(g_idx)
1715 WHERE MBRDisjoint(g, @geo_py)
1716 ORDER BY id;
1717 SELECT id, ST_AsText(g)
1718 FROM t1 FORCE INDEX(g_idx)
1719 WHERE MBRDisjoint(g, @geo_py)
1720 ORDER BY id;
1721 SELECT id, ST_AsText(g)
1722 FROM t1 IGNORE INDEX(g_idx)
1723 WHERE MBRDisjoint(g, @geo_mpt)
1724 ORDER BY id;
1725 SELECT id, ST_AsText(g)
1726 FROM t1 FORCE INDEX(g_idx)
1727 WHERE MBRDisjoint(g, @geo_mpt)
1728 ORDER BY id;
1729
1730 DROP TABLE t1;
1731
1732 --echo #
1733 --echo # WL#11096 Don't do Cartesian computations on geographic geometries
1734 --echo #
1735
1736 --echo # Assume SRID 10 is not defined.
1737 --error ER_SRS_NOT_FOUND
1738 DO MBRDISJOINT(
1739 x'0A000000010100000000000000000000000000000000000000',
1740 x'0A000000010100000000000000000000000000000000000000'
1741 );
1742 --error ER_SRS_NOT_FOUND
1743 DO ST_DISJOINT(
1744 x'0A000000010100000000000000000000000000000000000000',
1745 x'0A000000010100000000000000000000000000000000000000'
1746 );