Debian Codegraph @

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

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