Debian Codegraph @

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

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