Debian Codegraph @

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