Debian Codegraph @

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

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