Debian Codegraph @

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

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