Debian Codegraph @

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

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