Debian Codegraph @

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

raw
1 # Creating the spatial objects
2 CREATE TABLE gis_point_srid (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
3 CREATE TABLE gis_linestring_srid (fid INTEGER NOT NULL PRIMARY KEY, g LINESTRING);
4 CREATE TABLE gis_polygon_srid (fid INTEGER NOT NULL PRIMARY KEY, g POLYGON);
5 CREATE TABLE gis_multi_point_srid (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOINT);
6 CREATE TABLE gis_multi_linestring_srid (fid INTEGER NOT NULL PRIMARY KEY, g MULTILINESTRING);
7 CREATE TABLE gis_multi_polygon_srid (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOLYGON);
8 CREATE TABLE gis_geometrycollection_srid (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRYCOLLECTION);
9 # Inserting POINT Geometry Values
10 INSERT INTO gis_point_srid VALUES
11 (101, ST_POINTFROMTEXT('POINT(0 0)')),
12 (102, ST_POINTFROMTEXT('POINT(1 0)')),
13 (103, ST_POINTFROMTEXT('POINT(0 1)')),
14 (104, ST_POINTFROMTEXT('POINT(1 1)')),
15 (105, ST_POINTFROMTEXT('POINT(-1 1)'));
16 INSERT INTO gis_point_srid VALUES
17 (106, ST_POINTFROMWKB(ST_ASWKB(POINT(0,0)))),
18 (107, ST_POINTFROMWKB(ST_ASWKB(POINT(10,0)))),
19 (108, ST_POINTFROMWKB(ST_ASWKB(POINT(0,10)))),
20 (109, ST_POINTFROMWKB(ST_ASWKB(POINT(-10,0)))),
21 (110, ST_POINTFROMWKB(ST_ASWKB(POINT(0,-10))));
22 INSERT INTO gis_point_srid VALUES
23 (111, ST_POINTFROMWKB(ST_ASWKB(ST_POINTFROMTEXT('POINT(1 1)'))));
24 # Retrieving table of POINT geometries and SRID values
25 # (the latter should be 0 by default)
26 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_point_srid;
27 ST_ASTEXT(g) ST_SRID(g)
28 POINT(0 0) 0
29 POINT(1 0) 0
30 POINT(0 1) 0
31 POINT(1 1) 0
32 POINT(-1 1) 0
33 POINT(0 0) 0
34 POINT(10 0) 0
35 POINT(0 10) 0
36 POINT(-10 0) 0
37 POINT(0 -10) 0
38 POINT(1 1) 0
39 # Update all fields of the table to have the same SRID
40 UPDATE gis_point_srid SET g=ST_SRID(g, 4326);
41 # Check that SRIDs are now updated, and check that ST_SRID(g)
42 # returns a geometry in the second column
43 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_point_srid;
44 ST_ASTEXT(g) ST_SRID(g)
45 POINT(0 0) 4326
46 POINT(0 1) 4326
47 POINT(1 0) 4326
48 POINT(1 1) 4326
49 POINT(1 -1) 4326
50 POINT(0 0) 4326
51 POINT(0 10) 4326
52 POINT(10 0) 4326
53 POINT(0 -10) 4326
54 POINT(-10 0) 4326
55 POINT(1 1) 4326
56 # Inserting LINESTRING Geometry Values
57 INSERT INTO gis_linestring_srid VALUES
58 (201, ST_LINEFROMTEXT('LINESTRING(0 0,5 5)')),
59 (202, ST_LINEFROMTEXT('LINESTRING(0 0,2 2,4 4)')),
60 (203, ST_LINEFROMTEXT('LINESTRING(0 0,5 5,10 10)'));
61 INSERT INTO gis_linestring_srid VALUES
62 (204, ST_LINESTRINGFROMTEXT('LINESTRING(10 10,5 5)')),
63 (205, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,12 12,24 24)')),
64 (206, ST_LINESTRINGFROMTEXT('LINESTRING(0 0,50 50,90 90)'));
65 INSERT INTO gis_linestring_srid VALUES
66 (207, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
67 (208, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-5,-5), POINT(-10,10))))),
68 (209, ST_LINEFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)))));
69 INSERT INTO gis_linestring_srid VALUES
70 (210, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(5,5))))),
71 (211, ST_LINESTRINGFROMWKB(ST_ASWKB(LINESTRING(POINT(0,0), POINT(-50,-50), POINT(10,-10)))));
72 # Retrieving table of LINESTRING geometries and SRID values (the latter should be 0 by default)
73 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_linestring_srid;
74 ST_ASTEXT(g) ST_SRID(g)
75 LINESTRING(0 0,5 5) 0
76 LINESTRING(0 0,2 2,4 4) 0
77 LINESTRING(0 0,5 5,10 10) 0
78 LINESTRING(10 10,5 5) 0
79 LINESTRING(0 0,12 12,24 24) 0
80 LINESTRING(0 0,50 50,90 90) 0
81 LINESTRING(0 0,5 5) 0
82 LINESTRING(0 0,-5 -5,-10 10) 0
83 LINESTRING(0 0,2 2,4 4,6 6,8 8) 0
84 LINESTRING(0 0,5 5) 0
85 LINESTRING(0 0,-50 -50,10 -10) 0
86 # Update all fields of the table to have the same SRID
87 UPDATE gis_linestring_srid SET g=ST_SRID(g, 4326);
88 # Check that SRIDs are now updated, and check that ST_SRID(g)
89 # returns a geometry in the second column
90 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_linestring_srid;
91 ST_ASTEXT(g) ST_SRID(g)
92 LINESTRING(0 0,5 5) 4326
93 LINESTRING(0 0,2 2,4 4) 4326
94 LINESTRING(0 0,5 5,10 10) 4326
95 LINESTRING(10 10,5 5) 4326
96 LINESTRING(0 0,12 12,24 24) 4326
97 LINESTRING(0 0,50 50,90 90) 4326
98 LINESTRING(0 0,5 5) 4326
99 LINESTRING(0 0,-5 -5,10 -10) 4326
100 LINESTRING(0 0,2 2,4 4,6 6,8 8) 4326
101 LINESTRING(0 0,5 5) 4326
102 LINESTRING(0 0,-50 -50,-10 10) 4326
103 # Inserting POLYGON Geometry Values
104 INSERT INTO gis_polygon_srid VALUES
105 (301, ST_POLYFROMTEXT('POLYGON((0 0,5 5,0 5, 0 0))')),
106 (302, ST_POLYFROMTEXT('POLYGON((0 0,5 0,5 5,0 5,0 0))')),
107 (303, ST_POLYFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'));
108 INSERT INTO gis_polygon_srid VALUES
109 (304, ST_POLYGONFROMTEXT('POLYGON((0 0,50 0,50 50,0 50,0 0))')),
110 (305, ST_POLYGONFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))')),
111 (306, ST_POLYGONFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6))'));
112 INSERT INTO gis_polygon_srid VALUES
113 (307, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(5,5), POINT(0,5), POINT(0,0)))))),
114 (308, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(15,0), POINT(15,15), POINT(0,15), POINT(0,0)))))),
115 (309, ST_POLYFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
116 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))));
117 INSERT INTO gis_polygon_srid VALUES
118 (310, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(0,0), POINT(5,5), POINT(0,5), POINT(0,0)))))),
119 (311, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(15,10), POINT(15,15), POINT(10,15), POINT(10,10)))))),
120 (312, ST_POLYGONFROMWKB(ST_ASWKB(POLYGON(LINESTRING(POINT(10,10), POINT(20,10), POINT(20,20), POINT(10,20), POINT(10,10)),
121 LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))));
122 INSERT INTO gis_polygon_srid VALUES
123 (313, ST_POLYFROMWKB(ST_ASWKB(ST_POLYFROMTEXT('POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 9,10 -10,10 0))')))),
124 (314, ST_POLYFROMWKB(ST_ASWKB(ST_POLYGONFROMTEXT('POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 10,10 -10,10 0))')))),
125 (315, ST_POLYGONFROMWKB(ST_ASWKB(ST_POLYGONFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0),(2 2,4 2,4 4,2 4,2 2),(6 6,8 6,8 8,6 8,6 6))'))));
126 # Retrieving table of POLYGON geometries and SRID values
127 # (the latter should be 0 by default)
128 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_polygon_srid;
129 ST_ASTEXT(g) ST_SRID(g)
130 POLYGON((0 0,5 5,0 5,0 0)) 0
131 POLYGON((0 0,5 0,5 5,0 5,0 0)) 0
132 POLYGON((0 0,10 0,10 10,0 10,0 0)) 0
133 POLYGON((0 0,50 0,50 50,0 50,0 0)) 0
134 POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)) 0
135 POLYGON((0 0,10 0,10 10,0 10,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6)) 0
136 POLYGON((0 0,5 5,0 5,0 0)) 0
137 POLYGON((0 0,15 0,15 15,0 15,0 0)) 0
138 POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)) 0
139 POLYGON((0 0,5 5,0 5,0 0)) 0
140 POLYGON((10 10,15 10,15 15,10 15,10 10)) 0
141 POLYGON((10 10,20 10,20 20,10 20,10 10),(14 14,14 16,16 16,16 14,14 14)) 0
142 POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 9,10 -10,10 0)) 0
143 POLYGON((10 0,10 10,0 10,-10 10,-10 0,-10 -10,0 10,10 -10,10 0)) 0
144 POLYGON((0 0,10 0,10 10,0 10,0 0),(2 2,4 2,4 4,2 4,2 2),(6 6,8 6,8 8,6 8,6 6)) 0
145 # Update all fields of the table to have the same SRID
146 UPDATE gis_polygon_srid SET g=ST_SRID(g, 4326);
147 # Check that SRIDs are now updated, and check that ST_SRID(g)
148 # returns a geometry in the second column
149 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_polygon_srid;
150 ST_ASTEXT(g) ST_SRID(g)
151 POLYGON((0 0,5 5,5 0,0 0)) 4326
152 POLYGON((0 0,0 5,5 5,5 0,0 0)) 4326
153 POLYGON((0 0,0 10,10 10,10 0,0 0)) 4326
154 POLYGON((0 0,0 50,50 50,50 0,0 0)) 4326
155 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)) 4326
156 POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,4 2,4 4,2 4,2 2),(6 6,8 6,8 8,6 8,6 6)) 4326
157 POLYGON((0 0,5 5,5 0,0 0)) 4326
158 POLYGON((0 0,0 15,15 15,15 0,0 0)) 4326
159 POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)) 4326
160 POLYGON((0 0,5 5,5 0,0 0)) 4326
161 POLYGON((10 10,10 15,15 15,15 10,10 10)) 4326
162 POLYGON((10 10,10 20,20 20,20 10,10 10),(14 14,16 14,16 16,14 16,14 14)) 4326
163 POLYGON((0 10,10 10,10 0,10 -10,0 -10,-10 -10,9 0,-10 10,0 10)) 4326
164 POLYGON((0 10,10 10,10 0,10 -10,0 -10,-10 -10,10 0,-10 10,0 10)) 4326
165 POLYGON((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4 4,4 2,2 2),(6 6,6 8,8 8,8 6,6 6)) 4326
166 # Inserting MULTIPOINT Geometry Values
167 INSERT INTO gis_multi_point_srid VALUES
168 (401, ST_MPOINTFROMTEXT('MULTIPOINT((0 0))')),
169 (402, ST_MPOINTFROMTEXT('MULTIPOINT((0 0),(2 2),(4 4))')),
170 (403, ST_MPOINTFROMTEXT('MULTIPOINT((0 0),(5 5),(10 10))'));
171 INSERT INTO gis_multi_point_srid VALUES
172 (407, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0))))),
173 (408, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(10,10))))),
174 (409, ST_MPOINTFROMWKB(ST_ASWKB(MULTIPOINT(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6)))));
175 # Retrieving table of MULTIPOINT geometries and SRID values
176 # (the latter should be 0 by default)
177 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_multi_point_srid;
178 ST_ASTEXT(g) ST_SRID(g)
179 MULTIPOINT((0 0)) 0
180 MULTIPOINT((0 0),(2 2),(4 4)) 0
181 MULTIPOINT((0 0),(5 5),(10 10)) 0
182 MULTIPOINT((0 0)) 0
183 MULTIPOINT((0 0),(10 10)) 0
184 MULTIPOINT((0 0),(2 2),(4 4),(6 6)) 0
185 # Update all fields of the table to have the same SRID
186 UPDATE gis_multi_point_srid SET g=ST_SRID(g, 4326);
187 # Check that SRIDs are now updated, and check that ST_SRID(g) returns
188 # a geometry in the second column
189 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_multi_point_srid;
190 ST_ASTEXT(g) ST_SRID(g)
191 MULTIPOINT((0 0)) 4326
192 MULTIPOINT((0 0),(2 2),(4 4)) 4326
193 MULTIPOINT((0 0),(5 5),(10 10)) 4326
194 MULTIPOINT((0 0)) 4326
195 MULTIPOINT((0 0),(10 10)) 4326
196 MULTIPOINT((0 0),(2 2),(4 4),(6 6)) 4326
197 # Inserting MULTILINESTRING Geometry Values
198 INSERT INTO gis_multi_linestring_srid VALUES
199 (501, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2))')),
200 (502, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4))')),
201 (503, ST_MLINEFROMTEXT('MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10))'));
202 INSERT INTO gis_multi_linestring_srid VALUES
203 (504, ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,90 90,-90 -90))'));
204 INSERT INTO gis_multi_linestring_srid VALUES
205 (507, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2)))))),
206 (508, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)))))),
207 (509, ST_MLINEFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)),
208 LINESTRING(POINT(6,6), POINT(8,8), POINT(10,10))))));
209 INSERT INTO gis_multi_linestring_srid VALUES
210 (510, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4)))))),
211 (511, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(1,1), POINT(2,2)))))),
212 (512, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(MULTILINESTRING(LINESTRING(POINT(0,0), POINT(12,12), POINT(24,24)),
213 LINESTRING(POINT(36,36), POINT(48,48), POINT(50,50))))));
214 INSERT INTO gis_multi_linestring_srid VALUES
215 (513, ST_MLINEFROMWKB(ST_ASWKB(ST_MLINEFROMTEXT('MULTILINESTRING((0 0,10 10),(0 10,10 0))')))),
216 (514, ST_MLINEFROMWKB(ST_ASWKB(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0))')))),
217 (515, ST_MULTILINESTRINGFROMWKB(ST_ASWKB(ST_MULTILINESTRINGFROMTEXT('MULTILINESTRING((0 0,0 90),(0 0,90 0),(0 0,0 -90),(0 0,-90 0))'))));
218 # Retrieving table of MULTILINESTRING geometries and SRID values
219 # (the latter should be 0 by default)
220 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_multi_linestring_srid;
221 ST_ASTEXT(g) ST_SRID(g)
222 MULTILINESTRING((0 0,2 2)) 0
223 MULTILINESTRING((0 0,2 2,4 4)) 0
224 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10)) 0
225 MULTILINESTRING((0 0,90 90,-90 -90)) 0
226 MULTILINESTRING((0 0,2 2)) 0
227 MULTILINESTRING((0 0,12 12,24 24)) 0
228 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10)) 0
229 MULTILINESTRING((0 0,2 2,4 4)) 0
230 MULTILINESTRING((0 0,1 1,2 2)) 0
231 MULTILINESTRING((0 0,12 12,24 24),(36 36,48 48,50 50)) 0
232 MULTILINESTRING((0 0,10 10),(0 10,10 0)) 0
233 MULTILINESTRING((0 0,10 10,-10 10,0 0),(0 0,-10 -10,10 -10,0 0)) 0
234 MULTILINESTRING((0 0,0 90),(0 0,90 0),(0 0,0 -90),(0 0,-90 0)) 0
235 # Update all fields of the table to have the same SRID
236 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, 4326);
237 # Check that SRIDs are now updated
238 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_multi_linestring_srid;
239 ST_ASTEXT(g) ST_SRID(g)
240 MULTILINESTRING((0 0,2 2)) 4326
241 MULTILINESTRING((0 0,2 2,4 4)) 4326
242 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10)) 4326
243 MULTILINESTRING((0 0,90 90,-90 -90)) 4326
244 MULTILINESTRING((0 0,2 2)) 4326
245 MULTILINESTRING((0 0,12 12,24 24)) 4326
246 MULTILINESTRING((0 0,2 2,4 4),(6 6,8 8,10 10)) 4326
247 MULTILINESTRING((0 0,2 2,4 4)) 4326
248 MULTILINESTRING((0 0,1 1,2 2)) 4326
249 MULTILINESTRING((0 0,12 12,24 24),(36 36,48 48,50 50)) 4326
250 MULTILINESTRING((0 0,10 10),(10 0,0 10)) 4326
251 MULTILINESTRING((0 0,10 10,10 -10,0 0),(0 0,-10 -10,-10 10,0 0)) 4326
252 MULTILINESTRING((0 0,90 0),(0 0,0 90),(0 0,-90 0),(0 0,0 -90)) 4326
253 # Inserting MULTIPOLGYON Geometry Values
254 INSERT INTO gis_multi_polygon_srid VALUES
255 (601, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,5 5,0 5,0 0)))')),
256 (602, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5)))')),
257 (603, ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,6 4,6 6,4 6,4 4)))'));
258 INSERT INTO gis_multi_polygon_srid VALUES
259 (604, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 5,0 5, 0 0)))')),
260 (605, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,6 4,6 6,4 6, 4 4)),((0 0,-2 -2,0 -2, 0 0)))')),
261 (606, ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0)))'));
262 INSERT INTO gis_multi_polygon_srid VALUES
263 (607, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(0,5), POINT(5,5), POINT(5,0), POINT(0,0))))))),
264 (608, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
265 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
266 (609, ST_MPOLYFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(5,0), POINT(5,5), POINT(0,5), POINT(0,0))),
267 POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
268 INSERT INTO gis_multi_polygon_srid VALUES
269 (610, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0))))))),
270 (611, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(10,10), POINT(10,20), POINT(20,20), POINT(20,10), POINT(10,10)),
271 LINESTRING(POINT(14,14), POINT(14,16), POINT(16,16), POINT(16,14), POINT(14,14))))))),
272 (612, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
273 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
274 POLYGON(LINESTRING(POINT(0,0), POINT(-5,0), POINT(-5,-5), POINT(0,-5), POINT(0,0)))))));
275 INSERT INTO gis_multi_polygon_srid VALUES
276 (613, ST_MPOLYFROMWKB(ST_ASWKB(ST_MPOLYFROMTEXT('MULTIPOLYGON(((0 0,-5 5,5 5,0 0)),((0 0,-5 5,-5 -5,0 0)))')))),
277 (614, ST_MPOLYFROMWKB(ST_ASWKB(ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0)))')))),
278 (615, ST_MULTIPOLYGONFROMWKB(ST_ASWKB(ST_MULTIPOLYGONFROMTEXT('MULTIPOLYGON(((0 0,5 -5,10 0,5 5,0 0)))'))));
279 # Retrieving table of MULTIPOLYGON geometries and SRID values
280 # (the latter should be 0 by default)
281 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_multi_polygon_srid;
282 ST_ASTEXT(g) ST_SRID(g)
283 MULTIPOLYGON(((0 0,5 5,0 5,0 0))) 0
284 MULTIPOLYGON(((0 0,0 5,5 5,0 0)),((5 5,5 10,10 10,5 5))) 0
285 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,6 4,6 6,4 6,4 4))) 0
286 MULTIPOLYGON(((0 0,5 5,0 5,0 0))) 0
287 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,-2 -2,0 -2,0 0))) 0
288 MULTIPOLYGON(((0 0,5 5,-5 5,0 0)),((0 0,-5 -5,5 -5,0 0))) 0
289 MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0))) 0
290 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))) 0
291 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((0 0,-5 0,-5 -5,0 -5,0 0))) 0
292 MULTIPOLYGON(((0 0,-5 0,-5 -5,0 -5,0 0))) 0
293 MULTIPOLYGON(((10 10,10 20,20 20,20 10,10 10),(14 14,14 16,16 16,16 14,14 14))) 0
294 MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-5 0,-5 -5,0 -5,0 0))) 0
295 MULTIPOLYGON(((0 0,-5 5,5 5,0 0)),((0 0,-5 5,-5 -5,0 0))) 0
296 MULTIPOLYGON(((0 0,10 10,-10 10,0 0)),((0 0,-10 -10,10 -10,0 0))) 0
297 MULTIPOLYGON(((0 0,5 -5,10 0,5 5,0 0))) 0
298 # Update all fields of the table to have the same SRID
299 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, 4326);
300 # Check that SRIDs are now updated, and check that ST_SRID(g)
301 # returns a geometry in the second column
302 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_multi_polygon_srid;
303 ST_ASTEXT(g) ST_SRID(g)
304 MULTIPOLYGON(((0 0,5 5,5 0,0 0))) 4326
305 MULTIPOLYGON(((0 0,5 0,5 5,0 0)),((5 5,10 5,10 10,5 5))) 4326
306 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4))) 4326
307 MULTIPOLYGON(((0 0,5 5,5 0,0 0))) 4326
308 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-2 -2,-2 0,0 0))) 4326
309 MULTIPOLYGON(((0 0,5 5,5 -5,0 0)),((0 0,-5 -5,-5 5,0 0))) 4326
310 MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0))) 4326
311 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4))) 4326
312 MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((0 0,0 -5,-5 -5,-5 0,0 0))) 4326
313 MULTIPOLYGON(((0 0,0 -5,-5 -5,-5 0,0 0))) 4326
314 MULTIPOLYGON(((10 10,20 10,20 20,10 20,10 10),(14 14,16 14,16 16,14 16,14 14))) 4326
315 MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,0 -5,-5 -5,-5 0,0 0))) 4326
316 MULTIPOLYGON(((0 0,5 -5,5 5,0 0)),((0 0,5 -5,-5 -5,0 0))) 4326
317 MULTIPOLYGON(((0 0,10 10,10 -10,0 0)),((0 0,-10 -10,-10 10,0 0))) 4326
318 MULTIPOLYGON(((0 0,-5 5,0 10,5 5,0 0))) 4326
319 # Inserting GEOMETRYCOLLECTION Geometry Values
320 INSERT INTO gis_geometrycollection_srid VALUES
321 (701, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))')),
322 (702, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
323 (703, ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION(POINT(5 5), POLYGON((0 0,10 0,10 10,0 10,0 0)))'));
324 INSERT INTO gis_geometrycollection_srid VALUES
325 (704, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))')),
326 (705, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0),'
327 'LINESTRING(0 0,10 10),'
328 'POLYGON((0 0,10 0,10 10,0 10, 0 0)))')),
329 (706, ST_GEOMETRYCOLLECTIONFROMTEXT('GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),'
330 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
331 'MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)),'
332 '((0 0,-10 0,-10 -10,0 -10,0 0))))'));
333 INSERT INTO gis_geometrycollection_srid VALUES
334 (707, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0))))),
335 (708, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
336 LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
337 POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
338 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
339 (709, ST_GEOMCOLLFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(0,0), POINT(5,5), POINT(10,10)),
340 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
341 LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
342 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
343 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
344 POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
345 INSERT INTO gis_geometrycollection_srid VALUES
346 (710, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(0,0),
347 LINESTRING(POINT(0,0), POINT(90,90)))))),
348 (711, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(POINT(10,10),
349 LINESTRING(POINT(10,10), POINT(12,12), POINT(14,14), POINT(16,16), POINT(18,18)),
350 POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
351 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))))))),
352 (712, ST_GEOMETRYCOLLECTIONFROMWKB(ST_ASWKB(GEOMETRYCOLLECTION(MULTIPOINT(POINT(10,10), POINT(15,15), POINT(20,20)),
353 MULTILINESTRING(LINESTRING(POINT(0,0), POINT(2,2), POINT(4,4), POINT(6,6), POINT(8,8)),
354 LINESTRING(POINT(10,10), POINT(5,5), POINT(0,10))),
355 MULTIPOLYGON(POLYGON(LINESTRING(POINT(0,0), POINT(10,0), POINT(10,10), POINT(0,10), POINT(0,0)),
356 LINESTRING(POINT(4,4), POINT(4,6), POINT(6,6), POINT(6,4), POINT(4,4))),
357 POLYGON(LINESTRING(POINT(0,0), POINT(-10,0), POINT(-10,-10), POINT(0,0))))))));
358 INSERT INTO gis_geometrycollection_srid VALUES
359 (713, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
360 'POINT(0 0),'
361 'LINESTRING(0 0,10 10),'
362 'POLYGON((0 0,10 0,10 10,0 10, 0 0)),'
363 'MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),'
364 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
365 'MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((5 5,10 5,10 10,5 10,5 5))))')))),
366 (714, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
367 'GEOMETRYCOLLECTION('
368 'POINT(0 0)),'
369 'GEOMETRYCOLLECTION('
370 'LINESTRING(0 0,10 10)),'
371 'GEOMETRYCOLLECTION('
372 'POLYGON((0 0,10 0,10 10,0 10, 0 0))),'
373 'GEOMETRYCOLLECTION('
374 'MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10))),'
375 'GEOMETRYCOLLECTION('
376 'MULTILINESTRING((0 0,10 10),(0 10,10 0))),'
377 'GEOMETRYCOLLECTION('
378 'MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((5 5,10 5,10 10,5 10,5 5)))))')))),
379 (715, ST_GEOMCOLLFROMWKB(ST_ASWKB(ST_GEOMCOLLFROMTEXT('GEOMETRYCOLLECTION('
380 'GEOMETRYCOLLECTION(),'
381 'POINT(0 0),'
382 'GEOMETRYCOLLECTION('
383 'LINESTRING(0 0,10 10),'
384 'GEOMETRYCOLLECTION('
385 'GEOMETRYCOLLECTION())),'
386 'GEOMETRYCOLLECTION(),'
387 'GEOMETRYCOLLECTION('
388 'GEOMETRYCOLLECTION()),'
389 'POLYGON((0 0,10 0,10 10,0 10, 0 0)),'
390 'MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),'
391 'MULTILINESTRING((0 0,10 10),(0 10,10 0)),'
392 'MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((5 5,10 5,10 10,5 10,5 5))))'))));
393 # Retrieving table of MULTIPOLYGON geometries and SRID values
394 # (the latter should be 0 by default)
395 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_geometrycollection_srid;
396 ST_ASTEXT(g) ST_SRID(g)
397 GEOMETRYCOLLECTION(POINT(0 0)) 0
398 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10)) 0
399 GEOMETRYCOLLECTION(POINT(5 5),POLYGON((0 0,10 0,10 10,0 10,0 0))) 0
400 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10)) 0
401 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,10 0,10 10,0 10,0 0))) 0
402 GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0)),((0 0,-10 0,-10 -10,0 -10,0 0)))) 0
403 GEOMETRYCOLLECTION(POINT(0 0)) 0
404 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,2 2,4 4,6 6,8 8),POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))) 0
405 GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),MULTILINESTRING((0 0,2 2,4 4,6 6,8 8),(10 10,5 5,0 10)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-10 0,-10 -10,0 0)))) 0
406 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,90 90)) 0
407 GEOMETRYCOLLECTION(POINT(10 10),LINESTRING(10 10,12 12,14 14,16 16,18 18),POLYGON((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4))) 0
408 GEOMETRYCOLLECTION(MULTIPOINT((10 10),(15 15),(20 20)),MULTILINESTRING((0 0,2 2,4 4,6 6,8 8),(10 10,5 5,0 10)),MULTIPOLYGON(((0 0,10 0,10 10,0 10,0 0),(4 4,4 6,6 6,6 4,4 4)),((0 0,-10 0,-10 -10,0 0)))) 0
409 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((5 5,10 5,10 10,5 10,5 5)))) 0
410 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 0)),GEOMETRYCOLLECTION(LINESTRING(0 0,10 10)),GEOMETRYCOLLECTION(POLYGON((0 0,10 0,10 10,0 10,0 0))),GEOMETRYCOLLECTION(MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10))),GEOMETRYCOLLECTION(MULTILINESTRING((0 0,10 10),(0 10,10 0))),GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((5 5,10 5,10 10,5 10,5 5))))) 0
411 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY,POINT(0 0),GEOMETRYCOLLECTION(LINESTRING(0 0,10 10),GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)),GEOMETRYCOLLECTION EMPTY,GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY),POLYGON((0 0,10 0,10 10,0 10,0 0)),MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),MULTILINESTRING((0 0,10 10),(0 10,10 0)),MULTIPOLYGON(((0 0,5 0,5 5,0 5,0 0)),((5 5,10 5,10 10,5 10,5 5)))) 0
412 # Update all fields of the table to have the same SRID
413 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, 4326);
414 # Check that SRIDs are now updated, and check that ST_SRID(g) returns
415 # a geometry in the second column
416 SELECT ST_ASTEXT(g), ST_SRID(g) FROM gis_geometrycollection_srid;
417 ST_ASTEXT(g) ST_SRID(g)
418 GEOMETRYCOLLECTION(POINT(0 0)) 4326
419 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10)) 4326
420 GEOMETRYCOLLECTION(POINT(5 5),POLYGON((0 0,0 10,10 10,10 0,0 0))) 4326
421 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10)) 4326
422 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,0 10,10 10,10 0,0 0))) 4326
423 GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),MULTILINESTRING((0 0,10 10),(10 0,0 10)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0)),((0 0,0 -10,-10 -10,-10 0,0 0)))) 4326
424 GEOMETRYCOLLECTION(POINT(0 0)) 4326
425 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,2 2,4 4,6 6,8 8),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4))) 4326
426 GEOMETRYCOLLECTION(MULTIPOINT((0 0),(5 5),(10 10)),MULTILINESTRING((0 0,2 2,4 4,6 6,8 8),(10 10,5 5,10 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,0 -10,-10 -10,0 0)))) 4326
427 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,90 90)) 4326
428 GEOMETRYCOLLECTION(POINT(10 10),LINESTRING(10 10,12 12,14 14,16 16,18 18),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4))) 4326
429 GEOMETRYCOLLECTION(MULTIPOINT((10 10),(15 15),(20 20)),MULTILINESTRING((0 0,2 2,4 4,6 6,8 8),(10 10,5 5,10 0)),MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,6 4,6 6,4 6,4 4)),((0 0,0 -10,-10 -10,0 0)))) 4326
430 GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),MULTILINESTRING((0 0,10 10),(10 0,0 10)),MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))) 4326
431 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 0)),GEOMETRYCOLLECTION(LINESTRING(0 0,10 10)),GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0))),GEOMETRYCOLLECTION(MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10))),GEOMETRYCOLLECTION(MULTILINESTRING((0 0,10 10),(10 0,0 10))),GEOMETRYCOLLECTION(MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5))))) 4326
432 GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY,POINT(0 0),GEOMETRYCOLLECTION(LINESTRING(0 0,10 10),GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)),GEOMETRYCOLLECTION EMPTY,GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY),POLYGON((0 0,0 10,10 10,10 0,0 0)),MULTIPOINT((0 0),(2 2),(4 4),(6 6),(8 8),(10 10)),MULTILINESTRING((0 0,10 10),(10 0,0 10)),MULTIPOLYGON(((0 0,0 5,5 5,5 0,0 0)),((5 5,5 10,10 10,10 5,5 5)))) 4326
433 # Try to use ST_SRID with out of range SRID values (Should give error message)
434 UPDATE gis_point_srid SET g=ST_SRID(g, -100);
435 ERROR 22003: SRID value is out of range in 'st_srid'
436 UPDATE gis_point_srid SET g=ST_SRID(g, 5094967295);
437 ERROR 22003: SRID value is out of range in 'st_srid'
438 UPDATE gis_linestring_srid SET g=ST_SRID(g, -100);
439 ERROR 22003: SRID value is out of range in 'st_srid'
440 UPDATE gis_linestring_srid SET g=ST_SRID(g, 5094967295);
441 ERROR 22003: SRID value is out of range in 'st_srid'
442 UPDATE gis_polygon_srid SET g=ST_SRID(g, -100);
443 ERROR 22003: SRID value is out of range in 'st_srid'
444 UPDATE gis_polygon_srid SET g=ST_SRID(g, 5094967295);
445 ERROR 22003: SRID value is out of range in 'st_srid'
446 UPDATE gis_multi_point_srid SET g=ST_SRID(g, -100);
447 ERROR 22003: SRID value is out of range in 'st_srid'
448 UPDATE gis_multi_point_srid SET g=ST_SRID(g, 5094967295);
449 ERROR 22003: SRID value is out of range in 'st_srid'
450 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, -100);
451 ERROR 22003: SRID value is out of range in 'st_srid'
452 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, 5094967295);
453 ERROR 22003: SRID value is out of range in 'st_srid'
454 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, -100);
455 ERROR 22003: SRID value is out of range in 'st_srid'
456 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, 5094967295);
457 ERROR 22003: SRID value is out of range in 'st_srid'
458 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, -100);
459 ERROR 22003: SRID value is out of range in 'st_srid'
460 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, 5094967295);
461 ERROR 22003: SRID value is out of range in 'st_srid'
462 # Try to use ST_SRID with incorrect parameter count (>2 or <1)
463 UPDATE gis_point_srid SET g=ST_SRID();
464 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
465 UPDATE gis_point_srid SET g=ST_SRID(g, 4145, 0);
466 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
467 UPDATE gis_linestring_srid SET g=ST_SRID();
468 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
469 UPDATE gis_linestring_srid SET g=ST_SRID(g, 4145, 0);
470 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
471 UPDATE gis_polygon_srid SET g=ST_SRID();
472 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
473 UPDATE gis_polygon_srid SET g=ST_SRID(g, 4145, 0);
474 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
475 UPDATE gis_multi_point_srid SET g=ST_SRID();
476 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
477 UPDATE gis_multi_point_srid SET g=ST_SRID(g, 4145, 0);
478 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
479 UPDATE gis_multi_linestring_srid SET g=ST_SRID();
480 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
481 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, 4145, 0);
482 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
483 UPDATE gis_multi_polygon_srid SET g=ST_SRID();
484 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
485 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, 4145, 0);
486 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
487 UPDATE gis_geometrycollection_srid SET g=ST_SRID();
488 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
489 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, 4145, 0);
490 ERROR 42000: Incorrect parameter count in the call to native function 'ST_SRID'
491 # Try to use the mutator SRID function with an undefined SRID
492 UPDATE gis_point_srid SET g=ST_SRID(g, 10101);
493 ERROR SR001: There's no spatial reference system with SRID 10101.
494 UPDATE gis_linestring_srid SET g=ST_SRID(g, 10101);
495 ERROR SR001: There's no spatial reference system with SRID 10101.
496 UPDATE gis_polygon_srid SET g=ST_SRID(g, 10101);
497 ERROR SR001: There's no spatial reference system with SRID 10101.
498 UPDATE gis_multi_point_srid SET g=ST_SRID(g, 10101);
499 ERROR SR001: There's no spatial reference system with SRID 10101.
500 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, 10101);
501 ERROR SR001: There's no spatial reference system with SRID 10101.
502 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, 10101);
503 ERROR SR001: There's no spatial reference system with SRID 10101.
504 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, 10101);
505 ERROR SR001: There's no spatial reference system with SRID 10101.
506 # Testing ST_SRID mutator function with badly formed wkb strings
507 # Note: Here the binary representation is applied directly to the
508 # mutator ST_SRID function because if other helper functions were
509 # to be used, such as ST_GEOMFROMTEXT or similar, then the error
510 # would be caught in those functions instead of in the ST_SRID function.
511 # Testing with wkb of size less than 13 bytes
512 SET @geom_obj_too_short=x'311000000101';
513 # Testing with wkb that does not correspond to a valid geometry
514 SET @geom_obj_badly_formed=x'311000000101FFFFFF1221111100000011';
515 SELECT ST_SRID(@geom_obj_too_short, 4145);
516 ERROR 22023: Invalid GIS data provided to function st_srid.
517 SELECT ST_SRID(@geom_obj_badly_formed, 4145);
518 ERROR 22023: Invalid GIS data provided to function st_srid.
519 # Test for geometry = NULL:
520 SELECT ST_SRID(g, NULL) FROM gis_point_srid;
521 ST_SRID(g, NULL)
522 NULL
523 NULL
524 NULL
525 NULL
526 NULL
527 NULL
528 NULL
529 NULL
530 NULL
531 NULL
532 NULL
533 SELECT ST_SRID(g, NULL) FROM gis_linestring_srid;
534 ST_SRID(g, NULL)
535 NULL
536 NULL
537 NULL
538 NULL
539 NULL
540 NULL
541 NULL
542 NULL
543 NULL
544 NULL
545 NULL
546 SELECT ST_SRID(g, NULL) FROM gis_polygon_srid;
547 ST_SRID(g, NULL)
548 NULL
549 NULL
550 NULL
551 NULL
552 NULL
553 NULL
554 NULL
555 NULL
556 NULL
557 NULL
558 NULL
559 NULL
560 NULL
561 NULL
562 NULL
563 SELECT ST_SRID(g, NULL) FROM gis_multi_point_srid;
564 ST_SRID(g, NULL)
565 NULL
566 NULL
567 NULL
568 NULL
569 NULL
570 NULL
571 SELECT ST_SRID(g, NULL) FROM gis_multi_linestring_srid;
572 ST_SRID(g, NULL)
573 NULL
574 NULL
575 NULL
576 NULL
577 NULL
578 NULL
579 NULL
580 NULL
581 NULL
582 NULL
583 NULL
584 NULL
585 NULL
586 SELECT ST_SRID(g, NULL) FROM gis_multi_polygon_srid;
587 ST_SRID(g, NULL)
588 NULL
589 NULL
590 NULL
591 NULL
592 NULL
593 NULL
594 NULL
595 NULL
596 NULL
597 NULL
598 NULL
599 NULL
600 NULL
601 NULL
602 NULL
603 SELECT ST_SRID(g, NULL) FROM gis_geometrycollection_srid;
604 ST_SRID(g, NULL)
605 NULL
606 NULL
607 NULL
608 NULL
609 NULL
610 NULL
611 NULL
612 NULL
613 NULL
614 NULL
615 NULL
616 NULL
617 NULL
618 NULL
619 NULL
620 # Test for SRID = NULL:
621 SELECT ST_SRID(NULL, 4145) FROM gis_point_srid;
622 ST_SRID(NULL, 4145)
623 NULL
624 NULL
625 NULL
626 NULL
627 NULL
628 NULL
629 NULL
630 NULL
631 NULL
632 NULL
633 NULL
634 SELECT ST_SRID(NULL, 4145) FROM gis_linestring_srid;
635 ST_SRID(NULL, 4145)
636 NULL
637 NULL
638 NULL
639 NULL
640 NULL
641 NULL
642 NULL
643 NULL
644 NULL
645 NULL
646 NULL
647 SELECT ST_SRID(NULL, 4145) FROM gis_polygon_srid;
648 ST_SRID(NULL, 4145)
649 NULL
650 NULL
651 NULL
652 NULL
653 NULL
654 NULL
655 NULL
656 NULL
657 NULL
658 NULL
659 NULL
660 NULL
661 NULL
662 NULL
663 NULL
664 SELECT ST_SRID(NULL, 4145) FROM gis_multi_point_srid;
665 ST_SRID(NULL, 4145)
666 NULL
667 NULL
668 NULL
669 NULL
670 NULL
671 NULL
672 SELECT ST_SRID(NULL, 4145) FROM gis_multi_linestring_srid;
673 ST_SRID(NULL, 4145)
674 NULL
675 NULL
676 NULL
677 NULL
678 NULL
679 NULL
680 NULL
681 NULL
682 NULL
683 NULL
684 NULL
685 NULL
686 NULL
687 SELECT ST_SRID(NULL, 4145) FROM gis_multi_polygon_srid;
688 ST_SRID(NULL, 4145)
689 NULL
690 NULL
691 NULL
692 NULL
693 NULL
694 NULL
695 NULL
696 NULL
697 NULL
698 NULL
699 NULL
700 NULL
701 NULL
702 NULL
703 NULL
704 SELECT ST_SRID(NULL, 4145) FROM gis_geometrycollection_srid;
705 ST_SRID(NULL, 4145)
706 NULL
707 NULL
708 NULL
709 NULL
710 NULL
711 NULL
712 NULL
713 NULL
714 NULL
715 NULL
716 NULL
717 NULL
718 NULL
719 NULL
720 NULL
721 # Test for geometry = NULL and SRID = NULL:
722 SELECT ST_SRID(NULL, NULL) FROM gis_point_srid;
723 ST_SRID(NULL, NULL)
724 NULL
725 NULL
726 NULL
727 NULL
728 NULL
729 NULL
730 NULL
731 NULL
732 NULL
733 NULL
734 NULL
735 SELECT ST_SRID(NULL, NULL) FROM gis_linestring_srid;
736 ST_SRID(NULL, NULL)
737 NULL
738 NULL
739 NULL
740 NULL
741 NULL
742 NULL
743 NULL
744 NULL
745 NULL
746 NULL
747 NULL
748 SELECT ST_SRID(NULL, NULL) FROM gis_polygon_srid;
749 ST_SRID(NULL, NULL)
750 NULL
751 NULL
752 NULL
753 NULL
754 NULL
755 NULL
756 NULL
757 NULL
758 NULL
759 NULL
760 NULL
761 NULL
762 NULL
763 NULL
764 NULL
765 SELECT ST_SRID(NULL, NULL) FROM gis_multi_point_srid;
766 ST_SRID(NULL, NULL)
767 NULL
768 NULL
769 NULL
770 NULL
771 NULL
772 NULL
773 SELECT ST_SRID(NULL, NULL) FROM gis_multi_linestring_srid;
774 ST_SRID(NULL, NULL)
775 NULL
776 NULL
777 NULL
778 NULL
779 NULL
780 NULL
781 NULL
782 NULL
783 NULL
784 NULL
785 NULL
786 NULL
787 NULL
788 SELECT ST_SRID(NULL, NULL) FROM gis_multi_polygon_srid;
789 ST_SRID(NULL, NULL)
790 NULL
791 NULL
792 NULL
793 NULL
794 NULL
795 NULL
796 NULL
797 NULL
798 NULL
799 NULL
800 NULL
801 NULL
802 NULL
803 NULL
804 NULL
805 SELECT ST_SRID(NULL, NULL) FROM gis_geometrycollection_srid;
806 ST_SRID(NULL, NULL)
807 NULL
808 NULL
809 NULL
810 NULL
811 NULL
812 NULL
813 NULL
814 NULL
815 NULL
816 NULL
817 NULL
818 NULL
819 NULL
820 NULL
821 NULL
822 # Setting SRID to minimum value of zero (should be allowed)
823 UPDATE gis_point_srid SET g=ST_SRID(g, 0);
824 UPDATE gis_linestring_srid SET g=ST_SRID(g, 0);
825 UPDATE gis_polygon_srid SET g=ST_SRID(g, 0);
826 UPDATE gis_multi_point_srid SET g=ST_SRID(g, 0);
827 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, 0);
828 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, 0);
829 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, 0);
830 # Using non-numeric value as SRID (should set SRID as zero)
831 SELECT ST_SRID(ST_SRID(g, 'a')) from gis_point_srid;
832 ST_SRID(ST_SRID(g, 'a'))
833 0
834 0
835 0
836 0
837 0
838 0
839 0
840 0
841 0
842 0
843 0
844 Warnings:
845 Warning 1292 Truncated incorrect INTEGER value: 'a'
846 Warning 1292 Truncated incorrect INTEGER value: 'a'
847 Warning 1292 Truncated incorrect INTEGER value: 'a'
848 Warning 1292 Truncated incorrect INTEGER value: 'a'
849 Warning 1292 Truncated incorrect INTEGER value: 'a'
850 Warning 1292 Truncated incorrect INTEGER value: 'a'
851 Warning 1292 Truncated incorrect INTEGER value: 'a'
852 Warning 1292 Truncated incorrect INTEGER value: 'a'
853 Warning 1292 Truncated incorrect INTEGER value: 'a'
854 Warning 1292 Truncated incorrect INTEGER value: 'a'
855 Warning 1292 Truncated incorrect INTEGER value: 'a'
856 SELECT ST_SRID(ST_SRID(g, 'a')) from gis_linestring_srid;
857 ST_SRID(ST_SRID(g, 'a'))
858 0
859 0
860 0
861 0
862 0
863 0
864 0
865 0
866 0
867 0
868 0
869 Warnings:
870 Warning 1292 Truncated incorrect INTEGER value: 'a'
871 Warning 1292 Truncated incorrect INTEGER value: 'a'
872 Warning 1292 Truncated incorrect INTEGER value: 'a'
873 Warning 1292 Truncated incorrect INTEGER value: 'a'
874 Warning 1292 Truncated incorrect INTEGER value: 'a'
875 Warning 1292 Truncated incorrect INTEGER value: 'a'
876 Warning 1292 Truncated incorrect INTEGER value: 'a'
877 Warning 1292 Truncated incorrect INTEGER value: 'a'
878 Warning 1292 Truncated incorrect INTEGER value: 'a'
879 Warning 1292 Truncated incorrect INTEGER value: 'a'
880 Warning 1292 Truncated incorrect INTEGER value: 'a'
881 SELECT ST_SRID(ST_SRID(g, 'a')) from gis_polygon_srid;
882 ST_SRID(ST_SRID(g, 'a'))
883 0
884 0
885 0
886 0
887 0
888 0
889 0
890 0
891 0
892 0
893 0
894 0
895 0
896 0
897 0
898 Warnings:
899 Warning 1292 Truncated incorrect INTEGER value: 'a'
900 Warning 1292 Truncated incorrect INTEGER value: 'a'
901 Warning 1292 Truncated incorrect INTEGER value: 'a'
902 Warning 1292 Truncated incorrect INTEGER value: 'a'
903 Warning 1292 Truncated incorrect INTEGER value: 'a'
904 Warning 1292 Truncated incorrect INTEGER value: 'a'
905 Warning 1292 Truncated incorrect INTEGER value: 'a'
906 Warning 1292 Truncated incorrect INTEGER value: 'a'
907 Warning 1292 Truncated incorrect INTEGER value: 'a'
908 Warning 1292 Truncated incorrect INTEGER value: 'a'
909 Warning 1292 Truncated incorrect INTEGER value: 'a'
910 Warning 1292 Truncated incorrect INTEGER value: 'a'
911 Warning 1292 Truncated incorrect INTEGER value: 'a'
912 Warning 1292 Truncated incorrect INTEGER value: 'a'
913 Warning 1292 Truncated incorrect INTEGER value: 'a'
914 SELECT ST_SRID(ST_SRID(g, 'a')) from gis_multi_point_srid;
915 ST_SRID(ST_SRID(g, 'a'))
916 0
917 0
918 0
919 0
920 0
921 0
922 Warnings:
923 Warning 1292 Truncated incorrect INTEGER value: 'a'
924 Warning 1292 Truncated incorrect INTEGER value: 'a'
925 Warning 1292 Truncated incorrect INTEGER value: 'a'
926 Warning 1292 Truncated incorrect INTEGER value: 'a'
927 Warning 1292 Truncated incorrect INTEGER value: 'a'
928 Warning 1292 Truncated incorrect INTEGER value: 'a'
929 SELECT ST_SRID(ST_SRID(g, 'a')) from gis_multi_linestring_srid;
930 ST_SRID(ST_SRID(g, 'a'))
931 0
932 0
933 0
934 0
935 0
936 0
937 0
938 0
939 0
940 0
941 0
942 0
943 0
944 Warnings:
945 Warning 1292 Truncated incorrect INTEGER value: 'a'
946 Warning 1292 Truncated incorrect INTEGER value: 'a'
947 Warning 1292 Truncated incorrect INTEGER value: 'a'
948 Warning 1292 Truncated incorrect INTEGER value: 'a'
949 Warning 1292 Truncated incorrect INTEGER value: 'a'
950 Warning 1292 Truncated incorrect INTEGER value: 'a'
951 Warning 1292 Truncated incorrect INTEGER value: 'a'
952 Warning 1292 Truncated incorrect INTEGER value: 'a'
953 Warning 1292 Truncated incorrect INTEGER value: 'a'
954 Warning 1292 Truncated incorrect INTEGER value: 'a'
955 Warning 1292 Truncated incorrect INTEGER value: 'a'
956 Warning 1292 Truncated incorrect INTEGER value: 'a'
957 Warning 1292 Truncated incorrect INTEGER value: 'a'
958 SELECT ST_SRID(ST_SRID(g, 'a')) from gis_multi_polygon_srid;
959 ST_SRID(ST_SRID(g, 'a'))
960 0
961 0
962 0
963 0
964 0
965 0
966 0
967 0
968 0
969 0
970 0
971 0
972 0
973 0
974 0
975 Warnings:
976 Warning 1292 Truncated incorrect INTEGER value: 'a'
977 Warning 1292 Truncated incorrect INTEGER value: 'a'
978 Warning 1292 Truncated incorrect INTEGER value: 'a'
979 Warning 1292 Truncated incorrect INTEGER value: 'a'
980 Warning 1292 Truncated incorrect INTEGER value: 'a'
981 Warning 1292 Truncated incorrect INTEGER value: 'a'
982 Warning 1292 Truncated incorrect INTEGER value: 'a'
983 Warning 1292 Truncated incorrect INTEGER value: 'a'
984 Warning 1292 Truncated incorrect INTEGER value: 'a'
985 Warning 1292 Truncated incorrect INTEGER value: 'a'
986 Warning 1292 Truncated incorrect INTEGER value: 'a'
987 Warning 1292 Truncated incorrect INTEGER value: 'a'
988 Warning 1292 Truncated incorrect INTEGER value: 'a'
989 Warning 1292 Truncated incorrect INTEGER value: 'a'
990 Warning 1292 Truncated incorrect INTEGER value: 'a'
991 SELECT ST_SRID(ST_SRID(g, 'a')) from gis_geometrycollection_srid;
992 ST_SRID(ST_SRID(g, 'a'))
993 0
994 0
995 0
996 0
997 0
998 0
999 0
1000 0
1001 0
1002 0
1003 0
1004 0
1005 0
1006 0
1007 0
1008 Warnings:
1009 Warning 1292 Truncated incorrect INTEGER value: 'a'
1010 Warning 1292 Truncated incorrect INTEGER value: 'a'
1011 Warning 1292 Truncated incorrect INTEGER value: 'a'
1012 Warning 1292 Truncated incorrect INTEGER value: 'a'
1013 Warning 1292 Truncated incorrect INTEGER value: 'a'
1014 Warning 1292 Truncated incorrect INTEGER value: 'a'
1015 Warning 1292 Truncated incorrect INTEGER value: 'a'
1016 Warning 1292 Truncated incorrect INTEGER value: 'a'
1017 Warning 1292 Truncated incorrect INTEGER value: 'a'
1018 Warning 1292 Truncated incorrect INTEGER value: 'a'
1019 Warning 1292 Truncated incorrect INTEGER value: 'a'
1020 Warning 1292 Truncated incorrect INTEGER value: 'a'
1021 Warning 1292 Truncated incorrect INTEGER value: 'a'
1022 Warning 1292 Truncated incorrect INTEGER value: 'a'
1023 Warning 1292 Truncated incorrect INTEGER value: 'a'
1024 # Setting SRID to maximum allowed value of 2^32-1=4294967295
1025 # (Should return ER_SRS_NOT_FOUND)
1026 UPDATE gis_point_srid SET g=ST_SRID(g, 4294967295);
1027 ERROR SR001: There's no spatial reference system with SRID 4294967295.
1028 UPDATE gis_linestring_srid SET g=ST_SRID(g, 4294967295);
1029 ERROR SR001: There's no spatial reference system with SRID 4294967295.
1030 UPDATE gis_polygon_srid SET g=ST_SRID(g, 4294967295);
1031 ERROR SR001: There's no spatial reference system with SRID 4294967295.
1032 UPDATE gis_multi_point_srid SET g=ST_SRID(g, 4294967295);
1033 ERROR SR001: There's no spatial reference system with SRID 4294967295.
1034 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, 4294967295);
1035 ERROR SR001: There's no spatial reference system with SRID 4294967295.
1036 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, 4294967295);
1037 ERROR SR001: There's no spatial reference system with SRID 4294967295.
1038 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, 4294967295);
1039 ERROR SR001: There's no spatial reference system with SRID 4294967295.
1040 # Setting SRID to one less than minimum value (-1)
1041 UPDATE gis_point_srid SET g=ST_SRID(g, -1);
1042 ERROR 22003: SRID value is out of range in 'st_srid'
1043 UPDATE gis_linestring_srid SET g=ST_SRID(g, -1);
1044 ERROR 22003: SRID value is out of range in 'st_srid'
1045 UPDATE gis_polygon_srid SET g=ST_SRID(g, -1);
1046 ERROR 22003: SRID value is out of range in 'st_srid'
1047 UPDATE gis_multi_point_srid SET g=ST_SRID(g, -1);
1048 ERROR 22003: SRID value is out of range in 'st_srid'
1049 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, -1);
1050 ERROR 22003: SRID value is out of range in 'st_srid'
1051 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, -1);
1052 ERROR 22003: SRID value is out of range in 'st_srid'
1053 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, -1);
1054 ERROR 22003: SRID value is out of range in 'st_srid'
1055 # Setting SRID to one more than maximum value (4294967296)
1056 UPDATE gis_point_srid SET g=ST_SRID(g, 4294967296);
1057 ERROR 22003: SRID value is out of range in 'st_srid'
1058 UPDATE gis_linestring_srid SET g=ST_SRID(g, 4294967296);
1059 ERROR 22003: SRID value is out of range in 'st_srid'
1060 UPDATE gis_polygon_srid SET g=ST_SRID(g, 4294967296);
1061 ERROR 22003: SRID value is out of range in 'st_srid'
1062 UPDATE gis_multi_point_srid SET g=ST_SRID(g, 4294967296);
1063 ERROR 22003: SRID value is out of range in 'st_srid'
1064 UPDATE gis_multi_linestring_srid SET g=ST_SRID(g, 4294967296);
1065 ERROR 22003: SRID value is out of range in 'st_srid'
1066 UPDATE gis_multi_polygon_srid SET g=ST_SRID(g, 4294967296);
1067 ERROR 22003: SRID value is out of range in 'st_srid'
1068 UPDATE gis_geometrycollection_srid SET g=ST_SRID(g, 4294967296);
1069 ERROR 22003: SRID value is out of range in 'st_srid'
1070 # Check that SRID values are set to 0 (and thus haven't been
1071 # altered by the other boundary case tests
1072 SELECT ST_SRID(g) FROM gis_point_srid;
1073 ST_SRID(g)
1074 0
1075 0
1076 0
1077 0
1078 0
1079 0
1080 0
1081 0
1082 0
1083 0
1084 0
1085 SELECT ST_SRID(g) FROM gis_linestring_srid;
1086 ST_SRID(g)
1087 0
1088 0
1089 0
1090 0
1091 0
1092 0
1093 0
1094 0
1095 0
1096 0
1097 0
1098 SELECT ST_SRID(g) FROM gis_polygon_srid;
1099 ST_SRID(g)
1100 0
1101 0
1102 0
1103 0
1104 0
1105 0
1106 0
1107 0
1108 0
1109 0
1110 0
1111 0
1112 0
1113 0
1114 0
1115 SELECT ST_SRID(g) FROM gis_multi_point_srid;
1116 ST_SRID(g)
1117 0
1118 0
1119 0
1120 0
1121 0
1122 0
1123 SELECT ST_SRID(g) FROM gis_multi_linestring_srid;
1124 ST_SRID(g)
1125 0
1126 0
1127 0
1128 0
1129 0
1130 0
1131 0
1132 0
1133 0
1134 0
1135 0
1136 0
1137 0
1138 SELECT ST_SRID(g) FROM gis_multi_polygon_srid;
1139 ST_SRID(g)
1140 0
1141 0
1142 0
1143 0
1144 0
1145 0
1146 0
1147 0
1148 0
1149 0
1150 0
1151 0
1152 0
1153 0
1154 0
1155 SELECT ST_SRID(g) FROM gis_geometrycollection_srid;
1156 ST_SRID(g)
1157 0
1158 0
1159 0
1160 0
1161 0
1162 0
1163 0
1164 0
1165 0
1166 0
1167 0
1168 0
1169 0
1170 0
1171 0
1172 # Dropping tables to leave test database in original state
1173 DROP TABLE gis_point_srid;
1174 DROP TABLE gis_linestring_srid;
1175 DROP TABLE gis_polygon_srid;
1176 DROP TABLE gis_multi_point_srid;
1177 DROP TABLE gis_multi_linestring_srid;
1178 DROP TABLE gis_multi_polygon_srid;
1179 DROP TABLE gis_geometrycollection_srid;
1180 # Bug 23857035 Test case
1181 SET @@sql_mode='';
1182 CREATE TABLE t1 (g GEOMETRY);
1183 INSERT INTO t1 VALUES (POINT(10, 10)), (NULL);
1184 SELECT ST_AsText(ST_SRID(g, 4326)) FROM t1;
1185 ST_AsText(ST_SRID(g, 4326))
1186 POINT(10 10)
1187 NULL
1188 DROP TABLE t1;
1189 #
1190 # Bug #27892138 ST_LONGITUD() RETURNS LATITUDE OUT OF RANGE ERROR
1191 #
1192 CREATE TABLE t1 (srid INT);
1193 INSERT INTO t1 VALUES (NULL), (4326);
1194 SELECT srid, HEX(ST_SRID(POINT(0, 0), srid)) FROM t1;
1195 srid HEX(ST_SRID(POINT(0, 0), srid))
1196 NULL NULL
1197 4326 E6100000010100000000000000000000000000000000000000
1198 DROP TABLE t1;
1199 CREATE TABLE t1 (pk INT PRIMARY KEY, g GEOMETRY);
1200 INSERT INTO t1 VALUES (0, NULL), (1, ST_GEOMFROMTEXT('POINT(0 0)'));
1201 SELECT pk, ST_SRID(g) FROM t1;
1202 pk ST_SRID(g)
1203 0 NULL
1204 1 0
1205 SELECT pk, HEX(ST_SRID(g, 4326)) FROM t1;
1206 pk HEX(ST_SRID(g, 4326))
1207 0 NULL
1208 1 E6100000010100000000000000000000000000000000000000
1209 DROP TABLE t1;