Debian Codegraph @

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