Debian Codegraph @

mysql-test/suite/gis/r/spatial_analysis_functions_envelope.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 # INSERT base star
24 INSERT INTO gis_geometrycollection VALUES
25 (100,ST_GEOMFROMTEXT(@star)),
26 (101,ST_GEOMFROMTEXT(@star_elem_vertical)),
27 (102,ST_GEOMFROMTEXT(@star_elem_horizontal)),
28 (103,ST_GEOMFROMTEXT(@star_of_elems)),
29 (104,ST_GEOMFROMTEXT(@star_top)),
30 (105,ST_GEOMFROMTEXT(@star_center)),
31 (106,ST_GEOMFROMTEXT(@star_bottom_left)),
32 (107,ST_GEOMFROMTEXT(@star_bottom_right)),
33 (108,ST_GEOMFROMTEXT(@star_bottom_points)),
34 (109,ST_GEOMFROMTEXT(@star_all_points)),
35 (110,ST_GEOMFROMTEXT(@star_line_horizontal)),
36 (111,ST_GEOMFROMTEXT(@star_line_vertical)),
37 (112,ST_GEOMFROMTEXT(@star_top_to_center)),
38 (113,ST_GEOMFROMTEXT(@star_lines_near_horizontal)),
39 (114,ST_GEOMFROMTEXT(@star_lines_near_vertical)),
40 (115,ST_GEOMFROMTEXT(@star_collection_elems)),
41 (116,ST_GEOMFROMTEXT(@star_collection_multilinestr));
42 # Checking the integrity of the above create/insert statements
43 # 17 rows.
44 SELECT count(ST_ASTEXT(g) != 'NULL') FROM gis_geometrycollection;
45 count(ST_ASTEXT(g) != 'NULL')
46 17
47 #####################################################################################
48 # ST_ENVELOPE(point)
49 #####################################################################################
50 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_center)));
51 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_center)))
52 POINT(15 10)
53 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top)));
54 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top)))
55 POINT(15 25)
56 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(-0 0)')));
57 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(-0 0)')))
58 POINT(-0 0)
59 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(2.34 -2.34)')));
60 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(2.34 -2.34)')))
61 POINT(2.34 -2.34)
62 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(1e308 -1e308)')));
63 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(1e308 -1e308)')))
64 POINT(1e308 -1e308)
65 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(-0.0000 0.000001)')));
66 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(-0.0000 0.000001)')))
67 POINT(-0 0.000001)
68 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=105;
69 ST_ASTEXT(ST_ENVELOPE(g))
70 POINT(15 10)
71 #####################################################################################
72 # ST_ENVELOPE(multipoint)
73 #####################################################################################
74 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_all_points)));
75 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_all_points)))
76 POLYGON((5 0,25 0,25 25,5 25,5 0))
77 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_bottom_points)));
78 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_bottom_points)))
79 LINESTRING(5 0,25 0)
80 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)')));
81 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 0,0 0,0 0)')))
82 POINT(0 0)
83 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0,0 0)')));
84 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(0 0,0 5,5 5,5 0,0 0)')))
85 POLYGON((0 0,5 0,5 5,0 5,0 0))
86 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1e308 -1e308,0.0001 0.000)')));
87 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT(1 -1,1e308 -1e308,0.0001 0.000)')))
88 POLYGON((0.0001 -1e308,1e308 -1e308,1e308 0,0.0001 0,0.0001 -1e308))
89 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=108;
90 ST_ASTEXT(ST_ENVELOPE(g))
91 LINESTRING(5 0,25 0)
92 #####################################################################################
93 # ST_ENVELOPE(linestring)
94 #####################################################################################
95 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top_to_center)));
96 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top_to_center)))
97 LINESTRING(15 10,15 25)
98 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_line_horizontal)));
99 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_line_horizontal)))
100 LINESTRING(10 15,20 15)
101 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(0 0,-0.00 0,0.0 0)')));
102 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(0 0,-0.00 0,0.0 0)')))
103 POINT(0 0)
104 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')));
105 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(0 0,0 5,5 5,5 0,0 0)')))
106 POLYGON((0 0,5 0,5 5,0 5,0 0))
107 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(1 -1,1e308 -1e308,0.0001 0.000)')));
108 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(1 -1,1e308 -1e308,0.0001 0.000)')))
109 POLYGON((0.0001 -1e308,1e308 -1e308,1e308 0,0.0001 0,0.0001 -1e308))
110 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=110;
111 ST_ASTEXT(ST_ENVELOPE(g))
112 LINESTRING(10 15,20 15)
113 #####################################################################################
114 # ST_ENVELOPE(multilinestring)
115 #####################################################################################
116 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_vertical)));
117 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_vertical)))
118 POLYGON((0 5,15 5,15 25,0 25,0 5))
119 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_horizontal)));
120 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_horizontal)))
121 POLYGON((0 0,25 0,25 30,0 30,0 0))
122 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,-0.00 0),(0.0 0))')));
123 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
124 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))')));
125 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,0 5,5 5,5 0,0 0))')))
126 POLYGON((0 0,5 0,5 5,0 5,0 0))
127 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))')));
128 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((0 10,10 0),(10 0,0 0),(0 0,10 10))')))
129 POLYGON((0 0,10 0,10 10,0 10,0 0))
130 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1e308 -1e308,0.0001 0.000),(2 2,4 -9.002))')));
131 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING((1 -1,1e308 -1e308,0.0001 0.000),(2 2,4 -9.002))')))
132 POLYGON((0.0001 -1e308,1e308 -1e308,1e308 2,0.0001 2,0.0001 -1e308))
133 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=114;
134 ST_ASTEXT(ST_ENVELOPE(g))
135 POLYGON((0 5,15 5,15 25,0 25,0 5))
136 #####################################################################################
137 # ST_ENVELOPE(polygon)
138 #####################################################################################
139 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star)));
140 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star)))
141 POLYGON((0 0,30 0,30 25,0 25,0 0))
142 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_elem_vertical)));
143 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_elem_vertical)))
144 POLYGON((5 0,25 0,25 25,5 25,5 0))
145 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5, 0 0))')));
146 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,5 5, 0 0))')))
147 POLYGON((0 0,5 0,5 5,0 5,0 0))
148 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))')));
149 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0))')))
150 POLYGON((0 0,10 0,10 10,0 10,0 0))
151 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((10 10,10 0,0 20,0 10,10 10))')));
152 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((10 10,10 0,0 20,0 10,10 10))')))
153 POLYGON((0 0,10 0,10 20,0 20,0 0))
154 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,-10 0,-10 -10,0 -10,0 0))')));
155 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0,-10 0,-10 -10,0 -10,0 0))')))
156 POLYGON((-10 -10,10 -10,10 10,-10 10,-10 -10))
157 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')));
158 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))')))
159 POLYGON((0 0,10 0,10 10,0 10,0 0))
160 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0))')));
161 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0))')))
162 POLYGON((0 0,10 0,10 10,0 10,0 0))
163 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0))')));
164 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0))')))
165 POLYGON((0 0,10 0,10 10,0 10,0 0))
166 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8))')));
167 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8))')))
168 POLYGON((4 4,10 4,10 10,4 10,4 4))
169 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=100;
170 ST_ASTEXT(ST_ENVELOPE(g))
171 POLYGON((0 0,30 0,30 25,0 25,0 0))
172 #####################################################################################
173 # ST_ENVELOPE(multipolygon)
174 #####################################################################################
175 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_of_elems)));
176 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_of_elems)))
177 POLYGON((0 0,30 0,30 25,0 25,0 0))
178 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5, 0 0)))')));
179 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5, 0 0)))')))
180 POLYGON((0 0,5 0,5 5,0 5,0 0))
181 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))')));
182 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 10,10 0,0 0,0 10)),((0 0,10 10,10 0,0 0)))')))
183 POLYGON((0 0,10 0,10 10,0 10,0 0))
184 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))')));
185 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,0 0)),((10 10,10 15,15 15,10 10)))')))
186 POLYGON((0 0,15 0,15 15,0 15,0 0))
187 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4,4 4)))')));
188 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((4 4,4 6,6 6,6 4,4 4)))')))
189 POLYGON((0 0,10 0,10 10,0 10,0 0))
190 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))')));
191 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))')))
192 POLYGON((0 0,10 0,10 10,0 10,0 0))
193 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)))')));
194 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)))')))
195 POLYGON((0 0,10 0,10 10,0 10,0 0))
196 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0)))')));
197 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(0 0,0 10,10 10,10 0,0 0)))')))
198 POLYGON((0 0,10 0,10 10,0 10,0 0))
199 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8)))')));
200 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((4 4,4 6,6 6,6 4,4 4),(8 8,8 10,10 10,10 8,8 8)))')))
201 POLYGON((4 4,10 4,10 10,4 10,4 4))
202 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 0,5 10,10 10)),((0 10,0 20,5 10,0 10)))')));
203 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((10 10,10 0,5 10,10 10)),((0 10,0 20,5 10,0 10)))')))
204 POLYGON((0 0,10 0,10 20,0 20,0 0))
205 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0)))')));
206 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),((0 0,0 10,10 10,10 0,0 0)))')))
207 POLYGON((0 0,10 0,10 10,0 10,0 0))
208 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),'
209 '((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,4 4)))')));
210 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(0 0,0 10,10 10,10 0,0 0)),'
211 '((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,4 4)))')))
212 POLYGON((0 0,10 0,10 10,0 10,0 0))
213 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=103;
214 ST_ASTEXT(ST_ENVELOPE(g))
215 POLYGON((0 0,30 0,30 25,0 25,0 0))
216 #####################################################################################
217 # ST_ENVELOPE(geometrycollection)
218 #####################################################################################
219 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_collection_elems)));
220 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_collection_elems)))
221 POLYGON((0 0,30 0,30 25,0 25,0 0))
222 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_collection_multilinestr)));
223 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_collection_multilinestr)))
224 POLYGON((0 0,30 0,30 30,0 30,0 0))
225 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')));
226 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION()')))
227 GEOMETRYCOLLECTION EMPTY
228 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())')));
229 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION())')))
230 GEOMETRYCOLLECTION EMPTY
231 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))')));
232 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))')))
233 GEOMETRYCOLLECTION EMPTY
234 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10))')));
235 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10))')))
236 POLYGON((0 0,10 0,10 10,0 10,0 0))
237 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10)))')));
238 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),MULTIPOINT(0 0,10 10)))')))
239 POLYGON((0 0,10 0,10 10,0 10,0 0))
240 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
241 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10)))')));
242 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
243 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10)))')))
244 POLYGON((0 0,15 0,15 15,0 15,0 0))
245 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10))')));
246 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10))')))
247 POLYGON((0 0,10 0,10 10,0 10,0 0))
248 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10),GEOMETRYCOLLECTION())')));
249 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(LINESTRING(0 0,0 10,10 10),GEOMETRYCOLLECTION())')))
250 POLYGON((0 0,10 0,10 10,0 10,0 0))
251 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),'
252 'MULTIPOINT(0 0,10 10),'
253 'LINESTRING(1 1,2 2,3 3),'
254 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10)))')));
255 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(10 10),'
256 'MULTIPOINT(0 0,10 10),'
257 'LINESTRING(1 1,2 2,3 3),'
258
259 POLYGON((0 0,15 0,15 15,0 15,0 0))
260 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))')));
261 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))')))
262 POLYGON((0 0,10 0,10 10,0 10,0 0))
263 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))))')));
264 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0, 0 0)))))')))
265 POLYGON((0 0,10 0,10 10,0 10,0 0))
266 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
267 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),((10 10,10 15,15 15,15 10,10 10))))')));
268 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
269 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),((10 10,10 15,15 15,15 10,10 10
270 POLYGON((0 0,15 0,15 15,0 15,0 0))
271 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
272 'MULTIPOINT(0 0,10 10)),'
273 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
274 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10))))')));
275 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
276 'MULTIPOINT(0 0,10 10)),'
277
278 POLYGON((0 0,15 0,15 15,0 15,0 0))
279 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
280 'MULTIPOINT(0 0,10 10)),'
281 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
282 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10))),'
283 'GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),'
284 'MULTIPOLYGON(((0 0,0 10,10 10,10 0, 0 0)),'
285 '((10 10,10 15,15 15,15 10,10 10)))))')));
286 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
287 'MULTIPOINT(0 0,10 10)),'
288
289 POLYGON((0 0,15 0,15 15,0 15,0 0))
290 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
291 'MULTIPOINT(0 0,10 10)),'
292 'GEOMETRYCOLLECTION(LINESTRING(1 1,2 2,3 3),'
293 'MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(10 10,10 15,15 15,10 10))),'
294 'GEOMETRYCOLLECTION(GEOMETRYCOLLECTION()))')));
295 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(10 10),'
296 'MULTIPOINT(0 0,10 10)),'
297
298 POLYGON((0 0,15 0,15 15,0 15,0 0))
299 SELECT ST_ASTEXT(ST_ENVELOPE(g)) FROM gis_geometrycollection WHERE fid=115;
300 ST_ASTEXT(ST_ENVELOPE(g))
301 POLYGON((0 0,30 0,30 25,0 25,0 0))
302 #####################################################################################
303 # ST_ENVELOPE(geometry) with different SRID values
304 #####################################################################################
305 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_center,-1024)));
306 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
307 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_all_points,-1)));
308 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
309 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top_to_center,0)));
310 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_top_to_center,0)))
311 LINESTRING(15 10,15 25)
312 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_vertical,2000)));
313 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_lines_near_vertical,2000)))
314 POLYGON((0 5,15 5,15 25,0 25,0 5))
315 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star,4326)));
316 ERROR 22S00: st_envelope(POLYGON) has not been implemented for geographic spatial reference systems.
317 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_elem_vertical,4145)));
318 ERROR 22S00: st_envelope(POLYGON) has not been implemented for geographic spatial reference systems.
319 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_of_elems,4294967296)));
320 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
321 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT(@star_collection_elems,4294967295000)));
322 ERROR 22003: SRID value is out of range in 'st_geomfromtext'
323 #####################################################################################
324 # Invalid function calls
325 #####################################################################################
326 SELECT ST_ASTEXT(ST_ENVELOPE());
327 ERROR 42000: Incorrect parameter count in the call to native function 'ST_ENVELOPE'
328 SELECT ST_ASTEXT(ST_ENVELOPE(NULL));
329 ST_ASTEXT(ST_ENVELOPE(NULL))
330 NULL
331 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT()')));
332 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
333 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING()')));
334 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
335 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON(())')));
336 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
337 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOINT()')));
338 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
339 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTILINESTRING(())')));
340 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
341 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON((()))')));
342 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
343 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(a 0)')));
344 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
345 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(! 0)')));
346 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
347 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT('!' 0)')));
348 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)')))' at line 1
349 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(12,34 0)')));
350 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
351 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(a 0,10 10)')));
352 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
353 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(0 0,! 10)')));
354 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
355 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING('!' 0,10 10)')));
356 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)')))' at line 1
357 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('LINESTRING(12,34 0,10 10)')));
358 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
359 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((a 0,10 10,10 0,0 0))')));
360 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
361 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,! 10,10 0,0 0))')));
362 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
363 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON(('!' 0,10 10,10 0,0 0))')));
364 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))')))' at line 1
365 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((12,34 0,10 10,10 0,0 0))')));
366 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
367 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0))')));
368 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
369 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,5 5))')));
370 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
371 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,10 10, 0 0))')));
372 ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,5 5,10 10, 0 0))')))
373 POLYGON((0 0,10 0,10 10,0 10,0 0))
374 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('POLYGON((0 0,0 5,10 10,0 0),(0 0))')));
375 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
376 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5)),((10 10)))')));
377 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
378 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5)),((1 1,1 1,1 1,1 1)))')));
379 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
380 SELECT ST_ASTEXT(ST_ENVELOPE(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,5 5,10 10)),((10 10))')));
381 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
382 SELECT ST_ASTEXT(ST_ENVELOPE(0x000000000200000000000000000000000000000000));
383 ERROR HY000: Geometry byte string must be little endian.
384 SELECT ST_ASTEXT(ST_ENVELOPE(0x010100000001000000010100000000000000000000));
385 ERROR HY000: Geometry byte string must be little endian.
386 SELECT ST_ASTEXT(ST_ENVELOPE(0x010100000002000000000000000000000000000000));
387 ERROR HY000: Geometry byte string must be little endian.
388 SELECT ST_ASTEXT(ST_ENVELOPE(0x000000000600000001000000000200000002000000));
389 ERROR HY000: Geometry byte string must be little endian.
390 SELECT ST_ASTEXT(ST_ENVELOPE(0x000000000200000001000000050000000000000000));
391 ERROR HY000: Geometry byte string must be little endian.
392 SELECT ST_ASTEXT(ST_ENVELOPE(0x010300000002000000010300000002000000050000));
393 ERROR HY000: Geometry byte string must be little endian.
394 SELECT ST_ASTEXT(ST_ENVELOPE(0x010400000002000000010100000000000000000000));
395 ERROR HY000: Geometry byte string must be little endian.
396 # Clean up
397 DROP TABLE gis_geometrycollection;
398 #
399 # WL#8579 Spatial Reference Systems
400 #
401 # SRID 0 (should pass)
402 DO ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(0 0)', 0));
403 # Projected SRS (should pass)
404 DO ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(0 0)', 2000));
405 # Geographic SRS (should fail)
406 DO ST_ENVELOPE(ST_GEOMFROMTEXT('POINT(0 0)', 4326));
407 ERROR 22S00: st_envelope(POINT) has not been implemented for geographic spatial reference systems.
408 #
409 # WL#11096 Don't do Cartesian computations on geographic geometries
410 #
411 # Assume SRID 10 is not defined.
412 DO ST_ENVELOPE(x'0A000000010100000000000000000000000000000000000000');
413 ERROR SR001: There's no spatial reference system with SRID 10.