Debian Codegraph @

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

raw
1 # valid characters
2 SELECT ST_LONGFROMGEOHASH("0");
3 ST_LONGFROMGEOHASH("0")
4 -158
5 SELECT ST_LONGFROMGEOHASH("z");
6 ST_LONGFROMGEOHASH("z")
7 158
8 SELECT ST_LONGFROMGEOHASH("0z");
9 ST_LONGFROMGEOHASH("0z")
10 -141
11 SELECT ST_LONGFROMGEOHASH("upbp");
12 ST_LONGFROMGEOHASH("upbp")
13 0
14 SELECT ST_LONGFROMGEOHASH("h000");
15 ST_LONGFROMGEOHASH("h000")
16 0
17 SELECT ST_LONGFROMGEOHASH("s000");
18 ST_LONGFROMGEOHASH("s000")
19 0
20 SELECT ST_LONGFROMGEOHASH("0123456789");
21 ST_LONGFROMGEOHASH("0123456789")
22 -179.55743
23 SELECT ST_LONGFROMGEOHASH("9876543210");
24 ST_LONGFROMGEOHASH("9876543210")
25 -107.79609
26 SELECT ST_LONGFROMGEOHASH("bcdefghjkmnpqrstuvwxyz");
27 ST_LONGFROMGEOHASH("bcdefghjkmnpqrstuvwxyz")
28 -142.6078415216915
29 SELECT ST_LONGFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb");
30 ST_LONGFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb")
31 179.55743439816956
32 SELECT ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz");
33 ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz")
34 180
35 SELECT ST_LONGFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb");
36 ST_LONGFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb")
37 180
38 SELECT ST_LONGFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp");
39 ST_LONGFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp")
40 -180
41 SELECT ST_LONGFROMGEOHASH("00000000000000000000");
42 ST_LONGFROMGEOHASH("00000000000000000000")
43 -180
44 SELECT ST_LONGFROMGEOHASH("rzzzzzzzzzzzzzzzzzzz");
45 ST_LONGFROMGEOHASH("rzzzzzzzzzzzzzzzzzzz")
46 180
47 SELECT ST_LONGFROMGEOHASH("2pbpbpbpbpbpbpbpbpbp");
48 ST_LONGFROMGEOHASH("2pbpbpbpbpbpbpbpbpbp")
49 -180
50 SELECT ST_LONGFROMGEOHASH("7zzzzzzzzzzzzzzzzzzz");
51 ST_LONGFROMGEOHASH("7zzzzzzzzzzzzzzzzzzz")
52 0
53 SELECT ST_LONGFROMGEOHASH("gzzzzzzzzzzzzzzzzzzz");
54 ST_LONGFROMGEOHASH("gzzzzzzzzzzzzzzzzzzz")
55 0
56 SELECT ST_LONGFROMGEOHASH("5bpbpbpbpbpbpbpbpbpb");
57 ST_LONGFROMGEOHASH("5bpbpbpbpbpbpbpbpbpb")
58 0
59 SELECT ST_LONGFROMGEOHASH("0000000000zzzzzzzzzz");
60 ST_LONGFROMGEOHASH("0000000000zzzzzzzzzz")
61 -179.999989271164
62 SELECT ST_LONGFROMGEOHASH("zzzzzzzzzz0000000000");
63 ST_LONGFROMGEOHASH("zzzzzzzzzz0000000000")
64 179.999989271164
65 SELECT ST_LONGFROMGEOHASH("s000000001z7wsg7zzm6");
66 ST_LONGFROMGEOHASH("s000000001z7wsg7zzm6")
67 0.00001
68 SELECT ST_LONGFROMGEOHASH("kpbpbpbpbnpkqe5kpbtm");
69 ST_LONGFROMGEOHASH("kpbpbpbpbnpkqe5kpbtm")
70 0.00001
71 SELECT ST_LONGFROMGEOHASH("ebpbpbpbpcbe9kuebp6d");
72 ST_LONGFROMGEOHASH("ebpbpbpbpcbe9kuebp6d")
73 -0.00001
74 SELECT ST_LONGFROMGEOHASH("7zzzzzzzzy0s37hs00dt");
75 ST_LONGFROMGEOHASH("7zzzzzzzzy0s37hs00dt")
76 -0.00001
77 SELECT ST_LONGFROMGEOHASH("tzzzzzzzzzzzzzzzzzzz");
78 ST_LONGFROMGEOHASH("tzzzzzzzzzzzzzzzzzzz")
79 90
80 SELECT ST_LONGFROMGEOHASH("jzzzzzzzzzzzzzzzzzzz");
81 ST_LONGFROMGEOHASH("jzzzzzzzzzzzzzzzzzzz")
82 90
83 SELECT ST_LONGFROMGEOHASH("9zzzzzzzzzzzzzzzzzzz");
84 ST_LONGFROMGEOHASH("9zzzzzzzzzzzzzzzzzzz")
85 -90
86 SELECT ST_LONGFROMGEOHASH("1zzzzzzzzzzzzzzzzzzz");
87 ST_LONGFROMGEOHASH("1zzzzzzzzzzzzzzzzzzz")
88 -90
89 SELECT ST_LONGFROMGEOHASH("ypzpgxczbzurypzpgxcz");
90 ST_LONGFROMGEOHASH("ypzpgxczbzurypzpgxcz")
91 100
92 SELECT ST_LONGFROMGEOHASH("czbzurypzpgxczbzuryp");
93 ST_LONGFROMGEOHASH("czbzurypzpgxczbzuryp")
94 -100
95 SELECT ST_LONGFROMGEOHASH("0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z");
96 ST_LONGFROMGEOHASH("0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z")
97 -145.16129032258067
98 SELECT ST_LONGFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz");
99 ST_LONGFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz")
100 -179.55743439816956
101 SELECT ST_LONGFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ");
102 ST_LONGFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ")
103 -179.55743439816956
104 SELECT ST_LONGFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210");
105 ST_LONGFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210")
106 179.55743439816956
107 SELECT ST_LONGFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210");
108 ST_LONGFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210")
109 179.55743439816956
110 SELECT ST_LONGFROMGEOHASH("1e1");
111 ST_LONGFROMGEOHASH("1e1")
112 -110
113 SELECT ST_LONGFROMGEOHASH("100");
114 ST_LONGFROMGEOHASH("100")
115 -134
116 SELECT ST_LONGFROMGEOHASH(CAST(100 AS CHAR));
117 ST_LONGFROMGEOHASH(CAST(100 AS CHAR))
118 -134
119 SELECT ST_LONGFROMGEOHASH("10111000110001111001");
120 ST_LONGFROMGEOHASH("10111000110001111001")
121 -133.549761770805
122 SELECT ST_LONGFROMGEOHASH("11111111111111111111");
123 ST_LONGFROMGEOHASH("11111111111111111111")
124 -133.548387096774
125 SELECT ST_LONGFROMGEOHASH("99999999999999999999");
126 ST_LONGFROMGEOHASH("99999999999999999999")
127 -110.3225806451612
128 SELECT ST_LONGFROMGEOHASH(NULL);
129 ST_LONGFROMGEOHASH(NULL)
130 NULL
131 SELECT ST_LONGFROMGEOHASH(null);
132 ST_LONGFROMGEOHASH(null)
133 NULL
134 # invalid characters and inputs
135 SELECT ST_LONGFROMGEOHASH("0123a45");
136 ERROR HY000: Incorrect geohash value: '0123a45' for function ST_LONGFROMGEOHASH
137 SELECT ST_LONGFROMGEOHASH("xyzi");
138 ERROR HY000: Incorrect geohash value: 'xyzi' for function ST_LONGFROMGEOHASH
139 SELECT ST_LONGFROMGEOHASH("zyxLwv");
140 ERROR HY000: Incorrect geohash value: 'zyxLwv' for function ST_LONGFROMGEOHASH
141 SELECT ST_LONGFROMGEOHASH("bcdjo");
142 ERROR HY000: Incorrect geohash value: 'bcdjo' for function ST_LONGFROMGEOHASH
143 SELECT ST_LONGFROMGEOHASH("zyx**wv");
144 ERROR HY000: Incorrect geohash value: 'zyx**wv' for function ST_LONGFROMGEOHASH
145 SELECT ST_LONGFROMGEOHASH("1 2 3 4");
146 ERROR HY000: Incorrect geohash value: '1 2 3 4' for function ST_LONGFROMGEOHASH
147 SELECT ST_LONGFROMGEOHASH("1''2345");
148 ERROR HY000: Incorrect geohash value: '1''2345' for function ST_LONGFROMGEOHASH
149 SELECT ST_LONGFROMGEOHASH("12.345");
150 ERROR HY000: Incorrect geohash value: '12.345' for function ST_LONGFROMGEOHASH
151 SELECT ST_LONGFROMGEOHASH(" ");
152 ERROR HY000: Incorrect geohash value: ' ' for function ST_LONGFROMGEOHASH
153 SELECT ST_LONGFROMGEOHASH("NULL");
154 ERROR HY000: Incorrect geohash value: 'NULL' for function ST_LONGFROMGEOHASH
155 SELECT ST_LONGFROMGEOHASH("0ë 0Ñ");
156 ERROR HY000: Incorrect geohash value: '0ë 0Ñ' for function ST_LONGFROMGEOHASH
157 SELECT ST_LONGFROMGEOHASH("-100");
158 ERROR HY000: Incorrect geohash value: '-100' for function ST_LONGFROMGEOHASH
159 SELECT ST_LONGFROMGEOHASH("");
160 ERROR HY000: Incorrect geohash value: '' for function ST_LONGFROMGEOHASH
161 SELECT ST_LONGFROMGEOHASH(9876543210);
162 ERROR HY000: Incorrect type for argument geohash in function ST_LONGFROMGEOHASH.
163 SELECT ST_LONGFROMGEOHASH(0123456789);
164 ERROR HY000: Incorrect type for argument geohash in function ST_LONGFROMGEOHASH.
165 SELECT ST_LONGFROMGEOHASH(1e1);
166 ERROR HY000: Incorrect type for argument geohash in function ST_LONGFROMGEOHASH.
167 SELECT ST_LONGFROMGEOHASH(CAST("012" AS BINARY));
168 ERROR HY000: Incorrect type for argument geohash in function ST_LONGFROMGEOHASH.
169 SELECT ST_LONGFROMGEOHASH();
170 ERROR 42000: Incorrect parameter count in the call to native function 'ST_LONGFROMGEOHASH'
171 SELECT ST_LONGFROMGEOHASH("123","456");
172 ERROR 42000: Incorrect parameter count in the call to native function 'ST_LONGFROMGEOHASH'
173 SELECT ST_LONGFROMGEOHASH("123",);
174 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
175 SELECT ST_LONGFROMGEOHASH(,"456");
176 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 ',"456")' at line 1
177 SELECT ST_LONGFROMGEOHASH(,);
178 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',)' at line 1
179 SELECT ST_LONGFROMGEOHASH("0123456"789);
180 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 '789)' at line 1
181 SELECT ST_LONGFROMGEOHASH(abcdef);
182 ERROR 42S22: Unknown column 'abcdef' in 'field list'
183 # very long geohash
184 SELECT ST_LONGFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz0123456789bcdefghjkm"
185 "npqrstuvwxyz0123456789bcdefghjkmnpqrstuvwxyz01234567"
186 "89bcdefghjkmnpqrstuvwxyz");
187 ST_LONGFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz0123456789bcdefghjkm"
188 "npqrstuvwxyz0123456789bcdefghjkmnpqrstuvwxyz01234567"
189 "89bcdefghjkmnpqrstuvwxyz")
190 -179.55743439816956
191 SELECT ST_LONGFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ0123456789BCDEFGHJKM"
192 "NPQRSTUVWXYZ0123456789BCDEFGHJKMNPQRSTUVWXYZ01234567"
193 "89BCDEFGHJKMNPQRSTUVWXYZ");
194 ST_LONGFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ0123456789BCDEFGHJKM"
195 "NPQRSTUVWXYZ0123456789BCDEFGHJKMNPQRSTUVWXYZ01234567"
196 "89BCDEFGHJKMNPQRSTUVWXYZ")
197 -179.55743439816956
198 SELECT ST_LONGFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210zyxwvutsrqpnmkjhgfed"
199 "cb9876543210zyxwvutsrqpnmkjhgfedcb9876543210zyxwvuts"
200 "rqpnmkjhgfedcb9876543210");
201 ST_LONGFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210zyxwvutsrqpnmkjhgfed"
202 "cb9876543210zyxwvutsrqpnmkjhgfedcb9876543210zyxwvuts"
203 "rqpnmkjhgfedcb9876543210")
204 179.55743439816956
205 SELECT ST_LONGFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTSRQPNMKJHGFED"
206 "CB9876543210ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTS"
207 "RQPNMKJHGFEDCB9876543210");
208 ST_LONGFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTSRQPNMKJHGFED"
209 "CB9876543210ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTS"
210 "RQPNMKJHGFEDCB9876543210")
211 179.55743439816956
212 CREATE TABLE geohashes (gid INT NOT NULL PRIMARY KEY, hash_value VARCHAR(255));
213 INSERT INTO geohashes VALUES
214 (1, "000000000000000000000"),
215 (2, "zzzzzzzzzzzzzzzzzzzzz"),
216 (3, NULL),
217 (4, "s00t"),
218 (5, "7zzzm"),
219 (6, "s00d"),
220 (7, "0"),
221 (8, "z"),
222 (9, "3ejh6z75ddt2d839zh2u"),
223 (10, "twtsuqg3q7vh3nrbt0nn"),
224 (11, "yw8s10dxddhe4s06nsph"),
225 (12, "h4g4h9yrjtgzvewxm0ru"),
226 (13, "9kqbredcnhq1b44ue48s"),
227 (14, "1pckwjkqw3km0v6ye5d2"),
228 (15, "wm313fnr92ggsysm64e6"),
229 (16, "vqghx20fx6d8r5vfkbgf"),
230 (17, "wvetm3u23kr9r6663k31"),
231 (18, "e5t2p7sk291vpyb08pwu");
232 # different random geohash values
233 SELECT ST_LONGFROMGEOHASH(hash_value) FROM geohashes;
234 ST_LONGFROMGEOHASH(hash_value)
235 -180
236 180
237 NULL
238 1
239 -0.1
240 1
241 -158
242 158
243 -105.343666081393
244 75.4258807526218
245 113.2506169687463
246 4.4253282778628
247 -113.9241805635394
248 -132.9724051824284
249 102.7417962437673
250 60.7886982739903
251 128.908488386749
252 -37.292723368146
253 # valid characters
254 SELECT ST_LATFROMGEOHASH("0");
255 ST_LATFROMGEOHASH("0")
256 -68
257 SELECT ST_LATFROMGEOHASH("z");
258 ST_LATFROMGEOHASH("z")
259 68
260 SELECT ST_LATFROMGEOHASH("0z");
261 ST_LATFROMGEOHASH("0z")
262 -48
263 SELECT ST_LATFROMGEOHASH("xbpb");
264 ST_LATFROMGEOHASH("xbpb")
265 0
266 SELECT ST_LATFROMGEOHASH("8000");
267 ST_LATFROMGEOHASH("8000")
268 0
269 SELECT ST_LATFROMGEOHASH("s000");
270 ST_LATFROMGEOHASH("s000")
271 0
272 SELECT ST_LATFROMGEOHASH("0123456789");
273 ST_LATFROMGEOHASH("0123456789")
274 -82.774507
275 SELECT ST_LATFROMGEOHASH("9876543210");
276 ST_LATFROMGEOHASH("9876543210")
277 1.770175
278 SELECT ST_LATFROMGEOHASH("bcdefghjkmnpqrstuvwxyz");
279 ST_LATFROMGEOHASH("bcdefghjkmnpqrstuvwxyz")
280 54.11408847964353
281 SELECT ST_LATFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb");
282 ST_LATFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb")
283 82.77450549262497
284 SELECT ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz");
285 ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz")
286 90
287 SELECT ST_LATFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp");
288 ST_LATFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp")
289 90
290 SELECT ST_LATFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb");
291 ST_LATFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb")
292 -90
293 SELECT ST_LATFROMGEOHASH("00000000000000000000");
294 ST_LATFROMGEOHASH("00000000000000000000")
295 -90
296 SELECT ST_LATFROMGEOHASH("gzzzzzzzzzzzzzzzzzzz");
297 ST_LATFROMGEOHASH("gzzzzzzzzzzzzzzzzzzz")
298 90
299 SELECT ST_LATFROMGEOHASH("5bpbpbpbpbpbpbpbpbpb");
300 ST_LATFROMGEOHASH("5bpbpbpbpbpbpbpbpbpb")
301 -90
302 SELECT ST_LATFROMGEOHASH("7zzzzzzzzzzzzzzzzzzz");
303 ST_LATFROMGEOHASH("7zzzzzzzzzzzzzzzzzzz")
304 0
305 SELECT ST_LATFROMGEOHASH("rzzzzzzzzzzzzzzzzzzz");
306 ST_LATFROMGEOHASH("rzzzzzzzzzzzzzzzzzzz")
307 0
308 SELECT ST_LATFROMGEOHASH("2pbpbpbpbpbpbpbpbpbp");
309 ST_LATFROMGEOHASH("2pbpbpbpbpbpbpbpbpbp")
310 0
311 SELECT ST_LATFROMGEOHASH("0000000000zzzzzzzzzz");
312 ST_LATFROMGEOHASH("0000000000zzzzzzzzzz")
313 -89.999994635582
314 SELECT ST_LATFROMGEOHASH("zzzzzzzzzz0000000000");
315 ST_LATFROMGEOHASH("zzzzzzzzzz0000000000")
316 89.999994635582
317 SELECT ST_LATFROMGEOHASH("s000000001z7wsg7zzm6");
318 ST_LATFROMGEOHASH("s000000001z7wsg7zzm6")
319 0.00001
320 SELECT ST_LATFROMGEOHASH("ebpbpbpbpcbe9kuebp6d");
321 ST_LATFROMGEOHASH("ebpbpbpbpcbe9kuebp6d")
322 0.00001
323 SELECT ST_LATFROMGEOHASH("kpbpbpbpbnpkqe5kpbtm");
324 ST_LATFROMGEOHASH("kpbpbpbpbnpkqe5kpbtm")
325 -0.00001
326 SELECT ST_LATFROMGEOHASH("7zzzzzzzzy0s37hs00dt");
327 ST_LATFROMGEOHASH("7zzzzzzzzy0s37hs00dt")
328 -0.00001
329 SELECT ST_LATFROMGEOHASH("tzzzzzzzzzzzzzzzzzzz");
330 ST_LATFROMGEOHASH("tzzzzzzzzzzzzzzzzzzz")
331 45
332 SELECT ST_LATFROMGEOHASH("9zzzzzzzzzzzzzzzzzzz");
333 ST_LATFROMGEOHASH("9zzzzzzzzzzzzzzzzzzz")
334 45
335 SELECT ST_LATFROMGEOHASH("jzzzzzzzzzzzzzzzzzzz");
336 ST_LATFROMGEOHASH("jzzzzzzzzzzzzzzzzzzz")
337 -45
338 SELECT ST_LATFROMGEOHASH("1zzzzzzzzzzzzzzzzzzz");
339 ST_LATFROMGEOHASH("1zzzzzzzzzzzzzzzzzzz")
340 -45
341 SELECT ST_LATFROMGEOHASH("zbzurypzpgxczbzurypz");
342 ST_LATFROMGEOHASH("zbzurypzpgxczbzurypz")
343 50
344 SELECT ST_LATFROMGEOHASH("5zpgxczbzurypzpgxczb");
345 ST_LATFROMGEOHASH("5zpgxczbzurypzpgxczb")
346 -50
347 SELECT ST_LATFROMGEOHASH("0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z");
348 ST_LATFROMGEOHASH("0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z")
349 -49.35483870967742
350 SELECT ST_LATFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz");
351 ST_LATFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz")
352 -82.77450549262497
353 SELECT ST_LATFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ");
354 ST_LATFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ")
355 -82.77450549262497
356 SELECT ST_LATFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210");
357 ST_LATFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210")
358 82.77450549262497
359 SELECT ST_LATFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210");
360 ST_LATFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210")
361 82.77450549262497
362 SELECT ST_LATFROMGEOHASH("1e1");
363 ST_LATFROMGEOHASH("1e1")
364 -72
365 SELECT ST_LATFROMGEOHASH("100");
366 ST_LATFROMGEOHASH("100")
367 -89
368 SELECT ST_LATFROMGEOHASH(CAST(100 AS CHAR));
369 ST_LATFROMGEOHASH(CAST(100 AS CHAR))
370 -89
371 SELECT ST_LATFROMGEOHASH("10111000110001111001");
372 ST_LATFROMGEOHASH("10111000110001111001")
373 -89.8242133801793
374 SELECT ST_LATFROMGEOHASH("11111111111111111111");
375 ST_LATFROMGEOHASH("11111111111111111111")
376 -84.1935483870967
377 SELECT ST_LATFROMGEOHASH("99999999999999999999");
378 ST_LATFROMGEOHASH("99999999999999999999")
379 8.7096774193548
380 SELECT ST_LATFROMGEOHASH(NULL);
381 ST_LATFROMGEOHASH(NULL)
382 NULL
383 SELECT ST_LATFROMGEOHASH(null);
384 ST_LATFROMGEOHASH(null)
385 NULL
386 # invalid characters and inputs
387 SELECT ST_LATFROMGEOHASH("0123a45");
388 ERROR HY000: Incorrect geohash value: '0123a45' for function ST_LATFROMGEOHASH
389 SELECT ST_LATFROMGEOHASH("xyzi");
390 ERROR HY000: Incorrect geohash value: 'xyzi' for function ST_LATFROMGEOHASH
391 SELECT ST_LATFROMGEOHASH("zyxLwv");
392 ERROR HY000: Incorrect geohash value: 'zyxLwv' for function ST_LATFROMGEOHASH
393 SELECT ST_LATFROMGEOHASH("bcdjo");
394 ERROR HY000: Incorrect geohash value: 'bcdjo' for function ST_LATFROMGEOHASH
395 SELECT ST_LATFROMGEOHASH("zyx**wv");
396 ERROR HY000: Incorrect geohash value: 'zyx**wv' for function ST_LATFROMGEOHASH
397 SELECT ST_LATFROMGEOHASH("1 2 3 4");
398 ERROR HY000: Incorrect geohash value: '1 2 3 4' for function ST_LATFROMGEOHASH
399 SELECT ST_LATFROMGEOHASH("1''2345");
400 ERROR HY000: Incorrect geohash value: '1''2345' for function ST_LATFROMGEOHASH
401 SELECT ST_LATFROMGEOHASH("12.345");
402 ERROR HY000: Incorrect geohash value: '12.345' for function ST_LATFROMGEOHASH
403 SELECT ST_LATFROMGEOHASH(" ");
404 ERROR HY000: Incorrect geohash value: ' ' for function ST_LATFROMGEOHASH
405 SELECT ST_LATFROMGEOHASH("NULL");
406 ERROR HY000: Incorrect geohash value: 'NULL' for function ST_LATFROMGEOHASH
407 SELECT ST_LATFROMGEOHASH("0ë 0Ñ");
408 ERROR HY000: Incorrect geohash value: '0ë 0Ñ' for function ST_LATFROMGEOHASH
409 SELECT ST_LATFROMGEOHASH("-100");
410 ERROR HY000: Incorrect geohash value: '-100' for function ST_LATFROMGEOHASH
411 SELECT ST_LATFROMGEOHASH("");
412 ERROR HY000: Incorrect geohash value: '' for function ST_LATFROMGEOHASH
413 SELECT ST_LATFROMGEOHASH(9876543210);
414 ERROR HY000: Incorrect type for argument geohash in function ST_LATFROMGEOHASH.
415 SELECT ST_LATFROMGEOHASH(0123456789);
416 ERROR HY000: Incorrect type for argument geohash in function ST_LATFROMGEOHASH.
417 SELECT ST_LATFROMGEOHASH(1e1);
418 ERROR HY000: Incorrect type for argument geohash in function ST_LATFROMGEOHASH.
419 SELECT ST_LATFROMGEOHASH(CAST("012" AS BINARY));
420 ERROR HY000: Incorrect type for argument geohash in function ST_LATFROMGEOHASH.
421 SELECT ST_LATFROMGEOHASH();
422 ERROR 42000: Incorrect parameter count in the call to native function 'ST_LATFROMGEOHASH'
423 SELECT ST_LATFROMGEOHASH("123","456");
424 ERROR 42000: Incorrect parameter count in the call to native function 'ST_LATFROMGEOHASH'
425 SELECT ST_LATFROMGEOHASH("123",);
426 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
427 SELECT ST_LATFROMGEOHASH(,"456");
428 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 ',"456")' at line 1
429 SELECT ST_LATFROMGEOHASH(,);
430 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',)' at line 1
431 SELECT ST_LATFROMGEOHASH("0123456"789);
432 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 '789)' at line 1
433 SELECT ST_LATFROMGEOHASH(abcdef);
434 ERROR 42S22: Unknown column 'abcdef' in 'field list'
435 # very long geohash
436 SELECT ST_LATFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz0123456789bcdefghjkmn"
437 "pqrstuvwxyz0123456789bcdefghjkmnpqrstuvwxyz0123456789"
438 "bcdefghjkmnpqrstuvwxyz");
439 ST_LATFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz0123456789bcdefghjkmn"
440 "pqrstuvwxyz0123456789bcdefghjkmnpqrstuvwxyz0123456789"
441 "bcdefghjkmnpqrstuvwxyz")
442 -82.77450549262497
443 SELECT ST_LATFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ0123456789BCDEFGHJKMN"
444 "PQRSTUVWXYZ0123456789BCDEFGHJKMNPQRSTUVWXYZ0123456789"
445 "BCDEFGHJKMNPQRSTUVWXYZ");
446 ST_LATFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ0123456789BCDEFGHJKMN"
447 "PQRSTUVWXYZ0123456789BCDEFGHJKMNPQRSTUVWXYZ0123456789"
448 "BCDEFGHJKMNPQRSTUVWXYZ")
449 -82.77450549262497
450 SELECT ST_LATFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210zyxwvutsrqpnmkjhgfedc"
451 "b9876543210zyxwvutsrqpnmkjhgfedcb9876543210zyxwvutsrq"
452 "pnmkjhgfedcb9876543210");
453 ST_LATFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210zyxwvutsrqpnmkjhgfedc"
454 "b9876543210zyxwvutsrqpnmkjhgfedcb9876543210zyxwvutsrq"
455 "pnmkjhgfedcb9876543210")
456 82.77450549262497
457 SELECT ST_LATFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTSRQPNMKJHGFEDC"
458 "B9876543210ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTSRQ"
459 "PNMKJHGFEDCB9876543210");
460 ST_LATFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTSRQPNMKJHGFEDC"
461 "B9876543210ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTSRQ"
462 "PNMKJHGFEDCB9876543210")
463 82.77450549262497
464 # different random geohash values
465 SELECT ST_LATFROMGEOHASH(hash_value) FROM geohashes;
466 ST_LATFROMGEOHASH(hash_value)
467 -90
468 90
469 NULL
470 1
471 -0.1
472 0.4
473 -68
474 68
475 -27.3374899367448
476 37.4347752334972
477 82.269670295412
478 -74.168840669129
479 23.9696161514665
480 -45.5852718924236
481 29.763254995923
482 83.7602082514146
483 31.8700305354552
484 19.7074618731612
485 # valid characters
486 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0", 0));
487 ST_ASTEXT(ST_POINTFROMGEOHASH("0", 0))
488 POINT(-158 -68)
489 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("z", 0));
490 ST_ASTEXT(ST_POINTFROMGEOHASH("z", 0))
491 POINT(158 68)
492 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0z", 0));
493 ST_ASTEXT(ST_POINTFROMGEOHASH("0z", 0))
494 POINT(-141 -48)
495 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("xbpb", 0));
496 ST_ASTEXT(ST_POINTFROMGEOHASH("xbpb", 0))
497 POINT(180 0)
498 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("8000", 0));
499 ST_ASTEXT(ST_POINTFROMGEOHASH("8000", 0))
500 POINT(-180 0)
501 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("s000", 0));
502 ST_ASTEXT(ST_POINTFROMGEOHASH("s000", 0))
503 POINT(0 0)
504 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789", 0));
505 ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789", 0))
506 POINT(-179.55743 -82.774507)
507 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("9876543210", 0));
508 ST_ASTEXT(ST_POINTFROMGEOHASH("9876543210", 0))
509 POINT(-107.79609 1.770175)
510 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("bcdefghjkmnpqrstuvwxyz", 0));
511 ST_ASTEXT(ST_POINTFROMGEOHASH("bcdefghjkmnpqrstuvwxyz", 0))
512 POINT(-142.6078415216915 54.11408847964353)
513 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb", 0));
514 ST_ASTEXT(ST_POINTFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb", 0))
515 POINT(179.55743439816956 82.77450549262497)
516 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz", 0));
517 ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz", 0))
518 POINT(180 90)
519 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp", 0));
520 ST_ASTEXT(ST_POINTFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp", 0))
521 POINT(-180 90)
522 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb", 0));
523 ST_ASTEXT(ST_POINTFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb", 0))
524 POINT(180 -90)
525 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", 0));
526 ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", 0))
527 POINT(-180 -90)
528 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("gzzzzzzzzzzzzzzzzzzz", 0));
529 ST_ASTEXT(ST_POINTFROMGEOHASH("gzzzzzzzzzzzzzzzzzzz", 0))
530 POINT(0 90)
531 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("5bpbpbpbpbpbpbpbpbpb", 0));
532 ST_ASTEXT(ST_POINTFROMGEOHASH("5bpbpbpbpbpbpbpbpbpb", 0))
533 POINT(0 -90)
534 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("7zzzzzzzzzzzzzzzzzzz", 0));
535 ST_ASTEXT(ST_POINTFROMGEOHASH("7zzzzzzzzzzzzzzzzzzz", 0))
536 POINT(0 0)
537 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("rzzzzzzzzzzzzzzzzzzz", 0));
538 ST_ASTEXT(ST_POINTFROMGEOHASH("rzzzzzzzzzzzzzzzzzzz", 0))
539 POINT(180 0)
540 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("2pbpbpbpbpbpbpbpbpbp", 0));
541 ST_ASTEXT(ST_POINTFROMGEOHASH("2pbpbpbpbpbpbpbpbpbp", 0))
542 POINT(-180 0)
543 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0000000000zzzzzzzzzz", 0));
544 ST_ASTEXT(ST_POINTFROMGEOHASH("0000000000zzzzzzzzzz", 0))
545 POINT(-179.999989271164 -89.999994635582)
546 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzz0000000000", 0));
547 ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzz0000000000", 0))
548 POINT(179.999989271164 89.999994635582)
549 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("s000000001z7wsg7zzm6", 0));
550 ST_ASTEXT(ST_POINTFROMGEOHASH("s000000001z7wsg7zzm6", 0))
551 POINT(0.00001 0.00001)
552 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("ebpbpbpbpcbe9kuebp6d", 0));
553 ST_ASTEXT(ST_POINTFROMGEOHASH("ebpbpbpbpcbe9kuebp6d", 0))
554 POINT(-0.00001 0.00001)
555 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("kpbpbpbpbnpkqe5kpbtm", 0));
556 ST_ASTEXT(ST_POINTFROMGEOHASH("kpbpbpbpbnpkqe5kpbtm", 0))
557 POINT(0.00001 -0.00001)
558 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("7zzzzzzzzy0s37hs00dt", 0));
559 ST_ASTEXT(ST_POINTFROMGEOHASH("7zzzzzzzzy0s37hs00dt", 0))
560 POINT(-0.00001 -0.00001)
561 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("tzzzzzzzzzzzzzzzzzzz", 0));
562 ST_ASTEXT(ST_POINTFROMGEOHASH("tzzzzzzzzzzzzzzzzzzz", 0))
563 POINT(90 45)
564 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("9zzzzzzzzzzzzzzzzzzz", 0));
565 ST_ASTEXT(ST_POINTFROMGEOHASH("9zzzzzzzzzzzzzzzzzzz", 0))
566 POINT(-90 45)
567 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("jzzzzzzzzzzzzzzzzzzz", 0));
568 ST_ASTEXT(ST_POINTFROMGEOHASH("jzzzzzzzzzzzzzzzzzzz", 0))
569 POINT(90 -45)
570 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("1zzzzzzzzzzzzzzzzzzz", 0));
571 ST_ASTEXT(ST_POINTFROMGEOHASH("1zzzzzzzzzzzzzzzzzzz", 0))
572 POINT(-90 -45)
573 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zbzurypzpgxczbzurypz", 0));
574 ST_ASTEXT(ST_POINTFROMGEOHASH("zbzurypzpgxczbzurypz", 0))
575 POINT(180 50)
576 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("5zpgxczbzurypzpgxczb", 0));
577 ST_ASTEXT(ST_POINTFROMGEOHASH("5zpgxczbzurypzpgxczb", 0))
578 POINT(0 -50)
579 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z", 0));
580 ST_ASTEXT(ST_POINTFROMGEOHASH("0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z0z", 0))
581 POINT(-145.16129032258067 -49.35483870967742)
582 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz", 0));
583 ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz", 0))
584 POINT(-179.55743439816956 -82.77450549262497)
585 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ", 0));
586 ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ", 0))
587 POINT(-179.55743439816956 -82.77450549262497)
588 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210", 0));
589 ST_ASTEXT(ST_POINTFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210", 0))
590 POINT(179.55743439816956 82.77450549262497)
591 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210", 0));
592 ST_ASTEXT(ST_POINTFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210", 0))
593 POINT(179.55743439816956 82.77450549262497)
594 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("1e1", " "));
595 ST_ASTEXT(ST_POINTFROMGEOHASH("1e1", " "))
596 POINT(-110 -72)
597 Warnings:
598 Warning 1292 Truncated incorrect INTEGER value: ' '
599 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("100", " 0"));
600 ST_ASTEXT(ST_POINTFROMGEOHASH("100", " 0"))
601 POINT(-134 -89)
602 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(CAST(100 AS CHAR), 0));
603 ST_ASTEXT(ST_POINTFROMGEOHASH(CAST(100 AS CHAR), 0))
604 POINT(-134 -89)
605 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("10111000110001111001", "0"));
606 ST_ASTEXT(ST_POINTFROMGEOHASH("10111000110001111001", "0"))
607 POINT(-133.549761770805 -89.8242133801793)
608 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("11111111111111111111", 0));
609 ST_ASTEXT(ST_POINTFROMGEOHASH("11111111111111111111", 0))
610 POINT(-133.548387096774 -84.1935483870967)
611 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("99999999999999999999", 0));
612 ST_ASTEXT(ST_POINTFROMGEOHASH("99999999999999999999", 0))
613 POINT(-110.3225806451612 8.7096774193548)
614 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", " ***** "));
615 ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", " ***** "))
616 POINT(-180 -90)
617 Warnings:
618 Warning 1292 Truncated incorrect INTEGER value: ' ***** '
619 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", " 0 "));
620 ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", " 0 "))
621 POINT(-180 -90)
622 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz", (CAST(0 AS CHAR))));
623 ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz", (CAST(0 AS CHAR))))
624 POINT(180 90)
625 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(NULL, 0));
626 ST_ASTEXT(ST_POINTFROMGEOHASH(NULL, 0))
627 NULL
628 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(null, 0));
629 ST_ASTEXT(ST_POINTFROMGEOHASH(null, 0))
630 NULL
631 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("tzzzzzzzzzzzzzzzzzzz", NULL));
632 ST_ASTEXT(ST_POINTFROMGEOHASH("tzzzzzzzzzzzzzzzzzzz", NULL))
633 NULL
634 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("9zzzzzzzzzzzzzzzzzzz", null));
635 ST_ASTEXT(ST_POINTFROMGEOHASH("9zzzzzzzzzzzzzzzzzzz", null))
636 NULL
637 # invalid characters and inputs
638 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0123a45", 0));
639 ERROR HY000: Incorrect geohash value: '0123a45' for function st_pointfromgeohash
640 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("xyzi", 0));
641 ERROR HY000: Incorrect geohash value: 'xyzi' for function st_pointfromgeohash
642 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zyxLwv", 0));
643 ERROR HY000: Incorrect geohash value: 'zyxLwv' for function st_pointfromgeohash
644 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("bcdjo", 0));
645 ERROR HY000: Incorrect geohash value: 'bcdjo' for function st_pointfromgeohash
646 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zyx**wv", 0));
647 ERROR HY000: Incorrect geohash value: 'zyx**wv' for function st_pointfromgeohash
648 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("1 2 3 4", 0));
649 ERROR HY000: Incorrect geohash value: '1 2 3 4' for function st_pointfromgeohash
650 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("1''2345", 0));
651 ERROR HY000: Incorrect geohash value: '1''2345' for function st_pointfromgeohash
652 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("12.345", 0));
653 ERROR HY000: Incorrect geohash value: '12.345' for function st_pointfromgeohash
654 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(" ", 0));
655 ERROR HY000: Incorrect geohash value: ' ' for function st_pointfromgeohash
656 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("NULL", 0));
657 ERROR HY000: Incorrect geohash value: 'NULL' for function st_pointfromgeohash
658 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0ë 0Ñ", 0));
659 ERROR HY000: Incorrect geohash value: '0ë 0Ñ' for function st_pointfromgeohash
660 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("-100", 0));
661 ERROR HY000: Incorrect geohash value: '-100' for function st_pointfromgeohash
662 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("", 2000));
663 ERROR HY000: Incorrect geohash value: '' for function st_pointfromgeohash
664 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(9876543210, 0));
665 ERROR HY000: Incorrect type for argument geohash in function st_pointfromgeohash.
666 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(0123456789, 0));
667 ERROR HY000: Incorrect type for argument geohash in function st_pointfromgeohash.
668 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(1e1, 0));
669 ERROR HY000: Incorrect type for argument geohash in function st_pointfromgeohash.
670 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(CAST("012" AS BINARY), 0));
671 ERROR HY000: Incorrect type for argument geohash in function st_pointfromgeohash.
672 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz", (CAST(0 AS BINARY))));
673 ERROR HY000: Incorrect type for argument SRID in function st_pointfromgeohash.
674 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz", 4294967296));
675 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
676 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp", 10000000000));
677 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
678 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb", 4294967295000));
679 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
680 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("gzzzzzzzzzzzzzzzzzzz", -1));
681 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
682 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("5bpbpbpbpbpbpbpbpbpb", -1024));
683 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
684 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("7zzzzzzzzzzzzzzzzzzz", -04294967295));
685 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
686 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", "4294967296"));
687 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
688 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", "10000000000"));
689 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
690 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", "-1"));
691 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
692 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("00000000000000000000", "-1024"));
693 ERROR 22003: SRID value is out of range in 'st_pointfromgeohash'
694 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("123",));
695 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1
696 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(,"456"));
697 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 ',"456"))' at line 1
698 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(,));
699 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',))' at line 1
700 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0123456"789));
701 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 '789))' at line 1
702 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("7zzzzzzzzzzzzzzzzzzz", ****));
703 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '****))' at line 1
704 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"));
705 ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTFROMGEOHASH'
706 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH());
707 ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTFROMGEOHASH'
708 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(abcdef));
709 ERROR 42000: Incorrect parameter count in the call to native function 'ST_POINTFROMGEOHASH'
710 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH((1, 1), 1));
711 ERROR 21000: Operand should contain 1 column(s)
712 # very long geohash
713 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz0123456789bc"
714 "defghjkmnpqrstuvwxyz0123456789bcdefghjkmnpqr"
715 "stuvwxyz0123456789bcdefghjkmnpqrstuvwxyz", 0));
716 ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz0123456789bc"
717 "defghjkmnpqrstuvwxyz0123456789bcdefghjkmnpqr"
718 "stuvwxyz0123456789bcdefghjkmnpqrstuvwxyz", 0))
719 POINT(-179.55743439816956 -82.77450549262497)
720 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ0123456789BC"
721 "DEFGHJKMNPQRSTUVWXYZ0123456789BCDEFGHJKMNPQR"
722 "STUVWXYZ0123456789BCDEFGHJKMNPQRSTUVWXYZ", 0));
723 ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789BCDEFGHJKMNPQRSTUVWXYZ0123456789BC"
724 "DEFGHJKMNPQRSTUVWXYZ0123456789BCDEFGHJKMNPQR"
725 "STUVWXYZ0123456789BCDEFGHJKMNPQRSTUVWXYZ", 0))
726 POINT(-179.55743439816956 -82.77450549262497)
727 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210zyxwvutsrqpn"
728 "mkjhgfedcb9876543210zyxwvutsrqpnmkjhgfedcb98"
729 "76543210zyxwvutsrqpnmkjhgfedcb9876543210", 0));
730 ST_ASTEXT(ST_POINTFROMGEOHASH("zyxwvutsrqpnmkjhgfedcb9876543210zyxwvutsrqpn"
731 "mkjhgfedcb9876543210zyxwvutsrqpnmkjhgfedcb98"
732 "76543210zyxwvutsrqpnmkjhgfedcb9876543210", 0))
733 POINT(179.55743439816956 82.77450549262497)
734 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTSRQPN"
735 "MKJHGFEDCB9876543210ZYXWVUTSRQPNMKJHGFEDCB98"
736 "76543210ZYXWVUTSRQPNMKJHGFEDCB9876543210", 0));
737 ST_ASTEXT(ST_POINTFROMGEOHASH("ZYXWVUTSRQPNMKJHGFEDCB9876543210ZYXWVUTSRQPN"
738 "MKJHGFEDCB9876543210ZYXWVUTSRQPNMKJHGFEDCB98"
739 "76543210ZYXWVUTSRQPNMKJHGFEDCB9876543210", 0))
740 POINT(179.55743439816956 82.77450549262497)
741 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz0123456789bc"
742 "defghjkmnpqrstuvwxyz0123456789bcdefghjkmnpqr"
743 "stuvwxyz0123456789bcdefghjkmnpqrstuvwxyz0123"
744 "456789bcdefghjkmnpqrstuvwxyz0123456789bcdefg"
745 "hjkmnpqrstuvwxyz0123456789bcdefghjkmnpqrstuv"
746 "wxyz01234567890123456789bcdefghjkmnpqrstuvwx"
747 "yz0123456789bcdefghjkmnpqrstuvwxyz0123456789"
748 "bcdefghjkmnpqrstuvwxyz0123456789bcdefghjkmnp"
749 "qrstuvwxyz0123456789bcdefghjkmnpqrstuvwxyz01"
750 "23456789bcdefghjkmnpqrstuvwxyz0123456789bcde"
751 "fghjkmnpqrstuvwxyz", 4326));
752 ST_ASTEXT(ST_POINTFROMGEOHASH("0123456789bcdefghjkmnpqrstuvwxyz0123456789bc"
753 "defghjkmnpqrstuvwxyz0123456789bcdefghjkmnpqr"
754 "stuvwxyz0123456789bcdefghjkmnpqrstuvwxyz0123"
755
756 POINT(-82.77450549262497 -179.55743439816956)
757 # different random geohash values
758 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(hash_value,0)) FROM geohashes;
759 ST_ASTEXT(ST_POINTFROMGEOHASH(hash_value,0))
760 POINT(-180 -90)
761 POINT(180 90)
762 NULL
763 POINT(1 1)
764 POINT(-0.1 -0.1)
765 POINT(1 0.4)
766 POINT(-158 -68)
767 POINT(158 68)
768 POINT(-105.343666081393 -27.3374899367448)
769 POINT(75.4258807526218 37.4347752334972)
770 POINT(113.2506169687463 82.269670295412)
771 POINT(4.4253282778628 -74.168840669129)
772 POINT(-113.9241805635394 23.9696161514665)
773 POINT(-132.9724051824284 -45.5852718924236)
774 POINT(102.7417962437673 29.763254995923)
775 POINT(60.7886982739903 83.7602082514146)
776 POINT(128.908488386749 31.8700305354552)
777 POINT(-37.292723368146 19.7074618731612)
778 # Test create table from SELECT statement
779 CREATE TABLE t1 AS SELECT ST_POINTFROMGEOHASH("0123", 4326);
780 EXPLAIN t1;
781 Field Type Null Key Default Extra
782 ST_POINTFROMGEOHASH("0123", 4326) point NO NULL
783 DROP TABLE t1;
784 # valid inputs
785 SELECT ST_GEOHASH(0,0,1);
786 ST_GEOHASH(0,0,1)
787 s
788 SELECT ST_GEOHASH(180,0,20);
789 ST_GEOHASH(180,0,20)
790 xbpbpbpbpbpbpbpbpbpb
791 SELECT ST_GEOHASH(-180,0,20);
792 ST_GEOHASH(-180,0,20)
793 80000000000000000000
794 SELECT ST_GEOHASH(0,90,20);
795 ST_GEOHASH(0,90,20)
796 upbpbpbpbpbpbpbpbpbp
797 SELECT ST_GEOHASH(0,-90,20);
798 ST_GEOHASH(0,-90,20)
799 h0000000000000000000
800 SELECT ST_GEOHASH(180,90,20);
801 ST_GEOHASH(180,90,20)
802 zzzzzzzzzzzzzzzzzzzz
803 SELECT ST_GEOHASH(180,-90,20);
804 ST_GEOHASH(180,-90,20)
805 pbpbpbpbpbpbpbpbpbpb
806 SELECT ST_GEOHASH(-180,90,20);
807 ST_GEOHASH(-180,90,20)
808 bpbpbpbpbpbpbpbpbpbp
809 SELECT ST_GEOHASH(-180,-90,20);
810 ST_GEOHASH(-180,-90,20)
811 00000000000000000000
812 SELECT ST_GEOHASH(100,45,5);
813 ST_GEOHASH(100,45,5)
814 y0p05
815 SELECT ST_GEOHASH(100,-45,10);
816 ST_GEOHASH(100,-45,10)
817 q0p0581b0b
818 SELECT ST_GEOHASH(-100,45,+50);
819 ST_GEOHASH(-100,45,+50)
820 cb0bh2n0p0581b0bh2n0p8
821 SELECT ST_GEOHASH(0.0001,0.0001,10);
822 ST_GEOHASH(0.0001,0.0001,10)
823 s0000000d6
824 SELECT ST_GEOHASH(0.0001,-0.0001,30);
825 ST_GEOHASH(0.0001,-0.0001,30)
826 kpbpbpbp6m6e6p6bpntebbpkpnqbuf
827 SELECT ST_GEOHASH(-0.0001,0.0001,90);
828 ST_GEOHASH(-0.0001,0.0001,90)
829 ebpbpbpbtdtktbtpbc6kppbebc9p5q000000000000000000000000000000000000000000000000000000000000
830 SELECT ST_GEOHASH(-0.0001,-0.0001,100);
831 ST_GEOHASH(-0.0001,-0.0001,100)
832 7zzzzzzzmtm7mzm00yd7z00s0y30g60000000000000000000000000000000000000000000000000000000000000000000000
833 SELECT ST_GEOHASH("",90,10);
834 ST_GEOHASH("",90,10)
835 upbpbpbpbp
836 SELECT ST_GEOHASH(0,"90",10);
837 ST_GEOHASH(0,"90",10)
838 upbpbpbpbp
839 SELECT ST_GEOHASH("0","0",10);
840 ST_GEOHASH("0","0",10)
841 s000000000
842 SELECT ST_GEOHASH(180,90,"20");
843 ST_GEOHASH(180,90,"20")
844 zzzzzzzzzzzzzzzzzzzz
845 SELECT ST_GEOHASH("180","90","20");
846 ST_GEOHASH("180","90","20")
847 zzzzzzzzzzzzzzzzzzzz
848 SELECT ST_GEOHASH("***",90,"20");
849 ST_GEOHASH("***",90,"20")
850 upbpbpbpbpbpbpbpbpbp
851 Warnings:
852 Warning 1292 Truncated incorrect DOUBLE value: '***'
853 SELECT ST_GEOHASH(180,"***",20);
854 ST_GEOHASH(180,"***",20)
855 xbpbpbpbpbpbpbpbpbpb
856 Warnings:
857 Warning 1292 Truncated incorrect DOUBLE value: '***'
858 SELECT ST_GEOHASH("abcd",90,20);
859 ST_GEOHASH("abcd",90,20)
860 upbpbpbpbpbpbpbpbpbp
861 Warnings:
862 Warning 1292 Truncated incorrect DOUBLE value: 'abcd'
863 SELECT ST_GEOHASH(180,"abcd",25-5);
864 ST_GEOHASH(180,"abcd",25-5)
865 xbpbpbpbpbpbpbpbpbpb
866 Warnings:
867 Warning 1292 Truncated incorrect DOUBLE value: 'abcd'
868 SELECT ST_GEOHASH(NULL,90,10);
869 ST_GEOHASH(NULL,90,10)
870 NULL
871 SELECT ST_GEOHASH(180,NULL,10);
872 ST_GEOHASH(180,NULL,10)
873 NULL
874 SELECT ST_GEOHASH(180,90,NULL);
875 ST_GEOHASH(180,90,NULL)
876 NULL
877 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),10);
878 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),10)
879 s000000000
880 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 0)'),20);
881 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 0)'),20)
882 xbpbpbpbpbpbpbpbpbpb
883 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 0)'),25);
884 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 0)'),25)
885 8000000000000000000002pbp
886 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 90)'),30);
887 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 90)'),30)
888 upbpbpbpbpbpbpbpbpbpbpbpbpbpbp
889 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 -90)'),35);
890 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 -90)'),35)
891 h000000000000000000001bpbpbpbpbpbpb
892 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 90)'),40);
893 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 90)'),40)
894 zzzzzzzzzzzzzzzzzzzzzz
895 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 -90)'),45);
896 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 -90)'),45)
897 pbpbpbpbpbpbpbpbpbpbpc
898 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 90)'),50);
899 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 90)'),50)
900 bpbpbpbpbpbpbpbpbpbpbr
901 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 -90)'),55);
902 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 -90)'),55)
903 0000000000000000000003
904 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(100 45)'),60);
905 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(100 45)'),60)
906 y0p0581b0bh2n0p0581b0b
907 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(100 -45)'),65);
908 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(100 -45)'),65)
909 q0p0581b0bh2n0p0581b0b
910 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-100 45)'),70);
911 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-100 45)'),70)
912 cb0bh2n0p0581b0bh2n0p8
913 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-100 -45)'),75);
914 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-100 -45)'),75)
915 3b0bh2n0p0581b0bh2n0p8
916 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(0.0001 0.0001)'))),80);
917 ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(0.0001 0.0001)'))),80)
918 s0000000d6dsd0dzz1ms0zz7z1wzhy00000000000000000000000000000000000000000000000000
919 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(0.0001 -0.0001)'))),85);
920 ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(0.0001 -0.0001)'))),85)
921 kpbpbpbp6m6e6p6bpntebbpkpnqbuf0000000000000000000000000000000000000000000000000000000
922 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(-0.0001 0.0001)'))),90);
923 ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(-0.0001 0.0001)'))),90)
924 ebpbpbpbtdtktbtpbc6kppbebc9p5q000000000000000000000000000000000000000000000000000000000000
925 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(-0.0001 -0.0001)'))),100);
926 ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(-0.0001 -0.0001)'))),100)
927 7zzzzzzzmtm7mzm00yd7z00s0y30g60000000000000000000000000000000000000000000000000000000000000000000000
928 SELECT ST_GEOHASH(ST_GEOMFROMWKB(0x010100000000000000008066400000000000805640),20);
929 ST_GEOHASH(ST_GEOMFROMWKB(0x010100000000000000008066400000000000805640),20)
930 zzzzzzzzzzzzzzzzzzzz
931 SELECT ST_GEOHASH(ST_GEOMFROMWKB(0x010100000000000000008066C00000000000805640),20);
932 ST_GEOHASH(ST_GEOMFROMWKB(0x010100000000000000008066C00000000000805640),20)
933 bpbpbpbpbpbpbpbpbpbp
934 SELECT ST_GEOHASH(ST_GEOMFROMWKB(0x00000000014066800000000000C056800000000000),20);
935 ST_GEOHASH(ST_GEOMFROMWKB(0x00000000014066800000000000C056800000000000),20)
936 pbpbpbpbpbpbpbpbpbpb
937 SELECT ST_GEOHASH(ST_GEOMFROMWKB(0x0000000001C066800000000000C056800000000000),20);
938 ST_GEOHASH(ST_GEOMFROMWKB(0x0000000001C066800000000000C056800000000000),20)
939 00000000000000000000
940 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),"1");
941 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),"1")
942 s
943 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)')," 10 ");
944 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)')," 10 ")
945 s000000000
946 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),"+100");
947 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),"+100")
948 s000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
949 SELECT ST_GEOHASH(NULL,100);
950 ST_GEOHASH(NULL,100)
951 NULL
952 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-0.0001 -0.0001)'),NULL);
953 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-0.0001 -0.0001)'),NULL)
954 NULL
955 SELECT ST_GEOHASH(ST_DIFFERENCE(ST_GEOMFROMTEXT('POINT(180 90)'),ST_GEOMFROMTEXT('POINT(0 0)')),20);
956 ST_GEOHASH(ST_DIFFERENCE(ST_GEOMFROMTEXT('POINT(180 90)'),ST_GEOMFROMTEXT('POINT(0 0)')),20)
957 zzzzzzzzzzzzzzzzzzzz
958 SELECT ST_GEOHASH(ST_DIFFERENCE(ST_GEOMFROMTEXT('POINT(-180 90)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,100 100)')),20);
959 ST_GEOHASH(ST_DIFFERENCE(ST_GEOMFROMTEXT('POINT(-180 90)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,100 100)')),20)
960 bpbpbpbpbpbpbpbpbpbp
961 SELECT ST_GEOHASH(ST_INTERSECTION(ST_GEOMFROMTEXT('POINT(180 -90)'),ST_GEOMFROMTEXT('POINT(180 -90)')),20);
962 ST_GEOHASH(ST_INTERSECTION(ST_GEOMFROMTEXT('POINT(180 -90)'),ST_GEOMFROMTEXT('POINT(180 -90)')),20)
963 pbpbpbpbpbpbpbpbpbpb
964 SELECT ST_GEOHASH(ST_INTERSECTION(ST_GEOMFROMTEXT('POINT(-180 -90)'),ST_GEOMFROMTEXT('POINT(-180 -90)')),20);
965 ST_GEOHASH(ST_INTERSECTION(ST_GEOMFROMTEXT('POINT(-180 -90)'),ST_GEOMFROMTEXT('POINT(-180 -90)')),20)
966 00000000000000000000
967 # invalid inputs
968 SELECT ST_GEOHASH(181,0,10);
969 ERROR 22003: longitude value is out of range in 'st_geohash'
970 SELECT ST_GEOHASH(1000,90,10);
971 ERROR 22003: longitude value is out of range in 'st_geohash'
972 SELECT ST_GEOHASH(180.0000000000001,-90,10);
973 ERROR 22003: longitude value is out of range in 'st_geohash'
974 SELECT ST_GEOHASH(-181,0,10);
975 ERROR 22003: longitude value is out of range in 'st_geohash'
976 SELECT ST_GEOHASH(-1000,90,10);
977 ERROR 22003: longitude value is out of range in 'st_geohash'
978 SELECT ST_GEOHASH(-180.0000000000001,-90,10);
979 ERROR 22003: longitude value is out of range in 'st_geohash'
980 SELECT ST_GEOHASH(0,91,10);
981 ERROR 22003: latitude value is out of range in 'st_geohash'
982 SELECT ST_GEOHASH(180,500,10);
983 ERROR 22003: latitude value is out of range in 'st_geohash'
984 SELECT ST_GEOHASH(-180,90.0000000000001,10);
985 ERROR 22003: latitude value is out of range in 'st_geohash'
986 SELECT ST_GEOHASH(0,-91,10);
987 ERROR 22003: latitude value is out of range in 'st_geohash'
988 SELECT ST_GEOHASH(180,-500,10);
989 ERROR 22003: latitude value is out of range in 'st_geohash'
990 SELECT ST_GEOHASH(-180,-90.0000000000001,10);
991 ERROR 22003: latitude value is out of range in 'st_geohash'
992 SELECT ST_GEOHASH(180,90,0);
993 ERROR 22003: max geohash length value is out of range in 'st_geohash'
994 SELECT ST_GEOHASH(-180,90,-1);
995 ERROR 22003: max geohash length value is out of range in 'st_geohash'
996 SELECT ST_GEOHASH(180,-90,-100);
997 ERROR 22003: max geohash length value is out of range in 'st_geohash'
998 SELECT ST_GEOHASH(-180,-90,101);
999 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1000 SELECT ST_GEOHASH(0,90,1000);
1001 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1002 SELECT ST_GEOHASH("181",90,20);
1003 ERROR 22003: longitude value is out of range in 'st_geohash'
1004 SELECT ST_GEOHASH("-181",90,20);
1005 ERROR 22003: longitude value is out of range in 'st_geohash'
1006 SELECT ST_GEOHASH(180,"91",20);
1007 ERROR 22003: latitude value is out of range in 'st_geohash'
1008 SELECT ST_GEOHASH(180,"-91",20);
1009 ERROR 22003: latitude value is out of range in 'st_geohash'
1010 SELECT ST_GEOHASH(180,90,"0");
1011 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1012 SELECT ST_GEOHASH(180,90,"-1");
1013 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1014 SELECT ST_GEOHASH(180,90,"-100");
1015 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1016 SELECT ST_GEOHASH(180,90,"101");
1017 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1018 SELECT ST_GEOHASH(180,90,"1000");
1019 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1020 SELECT ST_GEOHASH(180,90,"");
1021 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1022 SELECT ST_GEOHASH(180,90,"****");
1023 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1024 SELECT ST_GEOHASH();
1025 ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOHASH'
1026 SELECT ST_GEOHASH(1);
1027 ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOHASH'
1028 SELECT ST_GEOHASH(1,2);
1029 ERROR HY000: Incorrect type for argument point in function st_geohash.
1030 SELECT ST_GEOHASH(-100,-45,100.1);
1031 ERROR HY000: Incorrect type for argument geohash max length in function st_geohash.
1032 SELECT ST_GEOHASH(, ,);
1033 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', ,)' at line 1
1034 SELECT ST_GEOHASH(1,2,);
1035 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
1036 SELECT ST_GEOHASH(*,0,10);
1037 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)' at line 1
1038 SELECT ST_GEOHASH(0,*,10);
1039 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 '*,10)' at line 1
1040 SELECT ST_GEOHASH(0,0,*);
1041 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*)' at line 1
1042 SELECT ST_GEOHASH(a,90,10);
1043 ERROR 42S22: Unknown column 'a' in 'field list'
1044 SELECT ST_GEOHASH(180,p,10);
1045 ERROR 42S22: Unknown column 'p' in 'field list'
1046 SELECT ST_GEOHASH(180,90,z);
1047 ERROR 42S22: Unknown column 'z' in 'field list'
1048 SELECT ST_GEOHASH((CAST(180 AS DATE)),90,10);
1049 ERROR HY000: Incorrect type for argument longitude in function st_geohash.
1050 SELECT ST_GEOHASH(180,(CAST(90 AS DATE)),10);
1051 ERROR HY000: Incorrect type for argument latitude in function st_geohash.
1052 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(181 0)'),10);
1053 ERROR 22003: longitude value is out of range in 'st_geohash'
1054 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1000 90)'),10);
1055 ERROR 22003: longitude value is out of range in 'st_geohash'
1056 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180.0000000000001 -90)'),10);
1057 ERROR 22003: longitude value is out of range in 'st_geohash'
1058 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-181 0)'),10);
1059 ERROR 22003: longitude value is out of range in 'st_geohash'
1060 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1000 90)'),10);
1061 ERROR 22003: longitude value is out of range in 'st_geohash'
1062 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180.0000000000001 -90)'),10);
1063 ERROR 22003: longitude value is out of range in 'st_geohash'
1064 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 91)'),10);
1065 ERROR 22003: latitude value is out of range in 'st_geohash'
1066 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 500)'),10);
1067 ERROR 22003: latitude value is out of range in 'st_geohash'
1068 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 90.0000000000001)'),10);
1069 ERROR 22003: latitude value is out of range in 'st_geohash'
1070 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 -91)'),10);
1071 ERROR 22003: latitude value is out of range in 'st_geohash'
1072 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 -500)'),10);
1073 ERROR 22003: latitude value is out of range in 'st_geohash'
1074 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 -90.0000000000001)'),10);
1075 ERROR 22003: latitude value is out of range in 'st_geohash'
1076 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 90)'),0);
1077 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1078 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 -90)'),-1);
1079 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1080 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 90)'),-100);
1081 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1082 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-180 -90)'),101);
1083 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1084 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),10000);
1085 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1086 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(180 90)'))),"0");
1087 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1088 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(180 -90)'))),"-1");
1089 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1090 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(-180 90)'))),"-100");
1091 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1092 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(-180 -90)'))),"101");
1093 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1094 SELECT ST_GEOHASH(ST_GEOMFROMWKB(ST_ASWKB(ST_GEOMFROMTEXT('POINT(0 0)'))),"10000");
1095 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1096 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)')," ");
1097 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1098 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),"***");
1099 ERROR 22003: max geohash length value is out of range in 'st_geohash'
1100 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'));
1101 ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOHASH'
1102 SELECT ST_GEOHASH(ST_GEOMFROMTEXT(),20);
1103 ERROR 42000: Incorrect parameter count in the call to native function 'ST_GEOMFROMTEXT'
1104 SELECT ST_GEOHASH((ST_GEOMFROMTEXT('POINT(0 0)'),);
1105 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
1106 SELECT ST_GEOHASH(,10);
1107 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 ',10)' at line 1
1108 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)'),a);
1109 ERROR 42S22: Unknown column 'a' in 'field list'
1110 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('LINESTRING(0 0,10 10)'),10);
1111 ERROR HY000: Incorrect type for argument point in function st_geohash.
1112 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POLYGON((0 0,10 0,10 10,0 10,0 0))'),10);
1113 ERROR HY000: Incorrect type for argument point in function st_geohash.
1114 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('MULTIPOINT(0 0,10 10)'),10);
1115 ERROR HY000: Incorrect type for argument point in function st_geohash.
1116 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('MULTILINESTRING((0 0,10 10),(20 20,30 30))'),10);
1117 ERROR HY000: Incorrect type for argument point in function st_geohash.
1118 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0,0 10,10 10,10 0,0 0),(4 4,4 6,6 6,6 4,4 4)))'),10);
1119 ERROR HY000: Incorrect type for argument point in function st_geohash.
1120 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))'),10);
1121 ERROR HY000: Incorrect type for argument point in function st_geohash.
1122 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 90)'),20.0001);
1123 ERROR HY000: Incorrect type for argument geohash max length in function st_geohash.
1124 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 90)'),(CAST(10 AS DATE)));
1125 ERROR HY000: Incorrect type for argument geohash max length in function st_geohash.
1126 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 90)'),(CAST(10 AS BINARY)));
1127 ERROR HY000: Incorrect type for argument geohash max length in function st_geohash.
1128 SELECT ST_GEOHASH((CAST(10 AS BINARY)),20,1);
1129 ERROR HY000: Incorrect type for argument longitude in function st_geohash.
1130 SELECT ST_GEOHASH(10,(CAST(20 AS BINARY)),1);
1131 ERROR HY000: Incorrect type for argument latitude in function st_geohash.
1132 SELECT ST_GEOHASH((CAST(10 AS BINARY)),(CAST(20 AS BINARY)),1);
1133 ERROR HY000: Incorrect type for argument longitude in function st_geohash.
1134 SELECT ST_GEOHASH(ST_INTERSECTION(ST_GEOMFROMTEXT('POINT(180 90)'),ST_GEOMFROMTEXT('POINT(1 1)')),20);
1135 ERROR HY000: Incorrect type for argument point in function st_geohash.
1136 SELECT ST_GEOHASH(ST_UNION(ST_GEOMFROMTEXT('POINT(180 90)'),ST_GEOMFROMTEXT('POINT(-180 -90)')),20);
1137 ERROR HY000: Incorrect type for argument point in function st_geohash.
1138 SELECT ST_GEOHASH(ST_DIFFERENCE(ST_GEOMFROMTEXT('POINT(180 90)'),ST_GEOMFROMTEXT('MULTIPOINT(0 0,180 90)')),20);
1139 ERROR HY000: Incorrect type for argument point in function st_geohash.
1140 SELECT ST_GEOHASH(ST_SYMDIFFERENCE(ST_GEOMFROMTEXT('POINT(180 90)'),ST_GEOMFROMTEXT('POINT(0 0)')),20);
1141 ERROR HY000: Incorrect type for argument point in function st_geohash.
1142 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT()'),20);
1143 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
1144 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1)'),20);
1145 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
1146 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1 a)'),20);
1147 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
1148 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180,90)'),20);
1149 ERROR 22023: Invalid GIS data provided to function st_geomfromtext.
1150 #=============================================================
1151 # ST_LONGFROMGEOHASH()
1152 #=============================================================
1153 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(180,90,20));
1154 ST_LONGFROMGEOHASH(ST_GEOHASH(180,90,20))
1155 180
1156 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(180,-90,20));
1157 ST_LONGFROMGEOHASH(ST_GEOHASH(180,-90,20))
1158 180
1159 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(-180,90,20));
1160 ST_LONGFROMGEOHASH(ST_GEOHASH(-180,90,20))
1161 -180
1162 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(-180,-90,20));
1163 ST_LONGFROMGEOHASH(ST_GEOHASH(-180,-90,20))
1164 -180
1165 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(180,0,20));
1166 ST_LONGFROMGEOHASH(ST_GEOHASH(180,0,20))
1167 180
1168 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(-180,0,20));
1169 ST_LONGFROMGEOHASH(ST_GEOHASH(-180,0,20))
1170 -180
1171 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(-0,0,20));
1172 ST_LONGFROMGEOHASH(ST_GEOHASH(-0,0,20))
1173 0
1174 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(0.10,90,20));
1175 ST_LONGFROMGEOHASH(ST_GEOHASH(0.10,90,20))
1176 0.1
1177 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(100,45,20));
1178 ST_LONGFROMGEOHASH(ST_GEOHASH(100,45,20))
1179 100
1180 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(179.999999,90,20));
1181 ST_LONGFROMGEOHASH(ST_GEOHASH(179.999999,90,20))
1182 179.999999
1183 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(-179.999999,0,20));
1184 ST_LONGFROMGEOHASH(ST_GEOHASH(-179.999999,0,20))
1185 -179.999999
1186 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(18*10,900/10,20));
1187 ST_LONGFROMGEOHASH(ST_GEOHASH(18*10,900/10,20))
1188 180
1189 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(100 10)'),10));
1190 ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(100 10)'),10))
1191 100
1192 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 10)'),10));
1193 ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 10)'),10))
1194 10
1195 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-10 10)'),10));
1196 ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-10 10)'),10))
1197 -10
1198 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1.000 10)'),10));
1199 ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1.000 10)'),10))
1200 1
1201 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1.000 10)'),10));
1202 ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1.000 10)'),10))
1203 -1
1204 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1.00101 90)'),20));
1205 ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1.00101 90)'),20))
1206 1.00101
1207 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1.00101 90)'),20));
1208 ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1.00101 90)'),20))
1209 -1.00101
1210 SELECT ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(20 20)'),10));
1211 ST_LONGFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(20 20)'),10))
1212 20
1213 #=============================================================
1214 # ST_LATFROMGEOHASH()
1215 #=============================================================
1216 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(180,90,20));
1217 ST_LATFROMGEOHASH(ST_GEOHASH(180,90,20))
1218 90
1219 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(180,-90,20));
1220 ST_LATFROMGEOHASH(ST_GEOHASH(180,-90,20))
1221 -90
1222 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(-180,90,20));
1223 ST_LATFROMGEOHASH(ST_GEOHASH(-180,90,20))
1224 90
1225 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(-180,-90,20));
1226 ST_LATFROMGEOHASH(ST_GEOHASH(-180,-90,20))
1227 -90
1228 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(0,90,20));
1229 ST_LATFROMGEOHASH(ST_GEOHASH(0,90,20))
1230 90
1231 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(0,-90,20));
1232 ST_LATFROMGEOHASH(ST_GEOHASH(0,-90,20))
1233 -90
1234 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(0,-0,20));
1235 ST_LATFROMGEOHASH(ST_GEOHASH(0,-0,20))
1236 0
1237 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(180,0.101,20));
1238 ST_LATFROMGEOHASH(ST_GEOHASH(180,0.101,20))
1239 0.101
1240 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(100,45,20));
1241 ST_LATFROMGEOHASH(ST_GEOHASH(100,45,20))
1242 45
1243 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(180,89.99999990,20));
1244 ST_LATFROMGEOHASH(ST_GEOHASH(180,89.99999990,20))
1245 89.9999999
1246 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(0,89.999999,20));
1247 ST_LATFROMGEOHASH(ST_GEOHASH(0,89.999999,20))
1248 89.999999
1249 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(18*10,900/10,20));
1250 ST_LATFROMGEOHASH(ST_GEOHASH(18*10,900/10,20))
1251 90
1252 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 50)'),10));
1253 ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 50)'),10))
1254 50
1255 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 10)'),10));
1256 ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 10)'),10))
1257 10
1258 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 -10)'),10));
1259 ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 -10)'),10))
1260 -10
1261 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 1.000)'),10));
1262 ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 1.000)'),10))
1263 1
1264 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 -1.0000)'),10));
1265 ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 -1.0000)'),10))
1266 -1
1267 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 1.00101)'),20));
1268 ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(180 1.00101)'),20))
1269 1.00101
1270 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-100 -1.00101)'),20));
1271 ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-100 -1.00101)'),20))
1272 -1.00101
1273 SELECT ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(20 -20)'),10));
1274 ST_LATFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(20 -20)'),10))
1275 -20
1276 #=============================================================
1277 # ST_POINTFROMGEOHASH()
1278 #=============================================================
1279 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,90,20),0));
1280 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,90,20),0))
1281 POINT(180 90)
1282 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,-90,20),0));
1283 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,-90,20),0))
1284 POINT(180 -90)
1285 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-180,90,20),0));
1286 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-180,90,20),0))
1287 POINT(-180 90)
1288 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-180,-90,20),0));
1289 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-180,-90,20),0))
1290 POINT(-180 -90)
1291 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,0,20),0));
1292 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,0,20),0))
1293 POINT(180 0)
1294 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-180,0,20),0));
1295 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-180,0,20),0))
1296 POINT(-180 0)
1297 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,90,20),0));
1298 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,90,20),0))
1299 POINT(0 90)
1300 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,-90,20),0));
1301 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,-90,20),0))
1302 POINT(0 -90)
1303 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,0,20),0));
1304 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,0,20),0))
1305 POINT(0 0)
1306 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-0,0,20),0));
1307 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-0,0,20),0))
1308 POINT(0 0)
1309 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,-0,20),0));
1310 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,-0,20),0))
1311 POINT(0 0)
1312 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0.10,90,20),0));
1313 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0.10,90,20),0))
1314 POINT(0.1 90)
1315 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(100,45,20),0));
1316 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(100,45,20),0))
1317 POINT(100 45)
1318 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(179.999999,90,20),0));
1319 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(179.999999,90,20),0))
1320 POINT(179.999999 90)
1321 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-179.999999,0,20),0));
1322 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(-179.999999,0,20),0))
1323 POINT(-179.999999 0)
1324 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,89.999999,20),0));
1325 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(180,89.999999,20),0))
1326 POINT(180 89.999999)
1327 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,-89.999999,20),0));
1328 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(0,-89.999999,20),0))
1329 POINT(0 -89.999999)
1330 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(18*10,900/10,20),0));
1331 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(18*10,900/10,20),0))
1332 POINT(180 90)
1333 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(100 50)'),10),0));
1334 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(100 50)'),10),0))
1335 POINT(100 50)
1336 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 10)'),10),0));
1337 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(10 10)'),10),0))
1338 POINT(10 10)
1339 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-10 10)'),10),0));
1340 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-10 10)'),10),0))
1341 POINT(-10 10)
1342 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1.000 1.00010)'),10),0));
1343 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1.000 1.00010)'),10),0))
1344 POINT(1 1.0001)
1345 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1.000 -1.1010)'),10),0));
1346 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1.000 -1.1010)'),10),0))
1347 POINT(-1 -1.101)
1348 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1.00101 1.000)'),10),0));
1349 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(1.00101 1.000)'),10),0))
1350 POINT(1.00101 1)
1351 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1.00101 -1.0000)'),20),0));
1352 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(-1.00101 -1.0000)'),20),0))
1353 POINT(-1.00101 -1)
1354 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(20 20)'),10),0));
1355 ST_ASTEXT(ST_POINTFROMGEOHASH(ST_GEOHASH(ST_GEOMFROMTEXT('POINT(20 20)'),10),0))
1356 POINT(20 20)
1357 #=============================================================
1358 # ST_GEOHASH()
1359 #=============================================================
1360 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("upbp",0),4);
1361 ST_GEOHASH(ST_POINTFROMGEOHASH("upbp",0),4)
1362 upbp
1363 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("h000",0),8);
1364 ST_GEOHASH(ST_POINTFROMGEOHASH("h000",0),8)
1365 h0000000
1366 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("s000",0),10);
1367 ST_GEOHASH(ST_POINTFROMGEOHASH("s000",0),10)
1368 s000000000
1369 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("zzzzm",0),10);
1370 ST_GEOHASH(ST_POINTFROMGEOHASH("zzzzm",0),10)
1371 zzzzmtz1my
1372 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("pbpbt",0),10);
1373 ST_GEOHASH(ST_POINTFROMGEOHASH("pbpbt",0),10)
1374 pbpbtdpntc
1375 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("bpbp6",0),10);
1376 ST_GEOHASH(ST_POINTFROMGEOHASH("bpbp6",0),10)
1377 bpbp6mbc6n
1378 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("0000d",0),10);
1379 ST_GEOHASH(ST_POINTFROMGEOHASH("0000d",0),10)
1380 0000d60yd1
1381 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("xbpbpbpbp",0),9);
1382 ST_GEOHASH(ST_POINTFROMGEOHASH("xbpbpbpbp",0),9)
1383 xbpbpbpbp
1384 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("800000000",0),12);
1385 ST_GEOHASH(ST_POINTFROMGEOHASH("800000000",0),12)
1386 800000000000
1387 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz",0),20);
1388 ST_GEOHASH(ST_POINTFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz",0),20)
1389 zzzzzzzzzzzzzzzzzzzz
1390 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("00000000000000000000",0),20);
1391 ST_GEOHASH(ST_POINTFROMGEOHASH("00000000000000000000",0),20)
1392 00000000000000000000
1393 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb",0),20);
1394 ST_GEOHASH(ST_POINTFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb",0),20)
1395 pbpbpbpbpbpbpbpbpbpb
1396 SELECT ST_GEOHASH(ST_POINTFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp",0),20);
1397 ST_GEOHASH(ST_POINTFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp",0),20)
1398 bpbpbpbpbpbpbpbpbpbp
1399 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),20);
1400 ST_GEOHASH(ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),20)
1401 zzzzzzzzzzzzzzzzzzzz
1402 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("00000000000000000000"),ST_LATFROMGEOHASH("00000000000000000000"),20);
1403 ST_GEOHASH(ST_LONGFROMGEOHASH("00000000000000000000"),ST_LATFROMGEOHASH("00000000000000000000"),20)
1404 00000000000000000000
1405 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),ST_LATFROMGEOHASH("00000000000000000000"),20);
1406 ST_GEOHASH(ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),ST_LATFROMGEOHASH("00000000000000000000"),20)
1407 pbpbpbpbpbpbpbpbpbpb
1408 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("00000000000000000000"),ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),20);
1409 ST_GEOHASH(ST_LONGFROMGEOHASH("00000000000000000000"),ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),20)
1410 bpbpbpbpbpbpbpbpbpbp
1411 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb"),ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),20);
1412 ST_GEOHASH(ST_LONGFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb"),ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),20)
1413 zzzzzzzzzzzzzzzzzzzz
1414 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),ST_LATFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb"),20);
1415 ST_GEOHASH(ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),ST_LATFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb"),20)
1416 pbpbpbpbpbpbpbpbpbpb
1417 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),ST_LATFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp"),20);
1418 ST_GEOHASH(ST_LONGFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),ST_LATFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp"),20)
1419 zzzzzzzzzzzzzzzzzzzz
1420 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp"),ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),20);
1421 ST_GEOHASH(ST_LONGFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp"),ST_LATFROMGEOHASH("zzzzzzzzzzzzzzzzzzzz"),20)
1422 bpbpbpbpbpbpbpbpbpbp
1423 SELECT ST_GEOHASH(ST_LONGFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp"),ST_LATFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb"),20);
1424 ST_GEOHASH(ST_LONGFROMGEOHASH("bpbpbpbpbpbpbpbpbpbp"),ST_LATFROMGEOHASH("pbpbpbpbpbpbpbpbpbpb"),20)
1425 00000000000000000000
1426 SELECT
1427 ST_LONGFROMGEOHASH(
1428 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1429 AS CHAR CHARACTER SET utf8) COLLATE utf8_persian_ci);
1430 ST_LONGFROMGEOHASH(
1431 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1432 AS CHAR CHARACTER SET utf8) COLLATE utf8_persian_ci)
1433 -179.55743439816956
1434 Warnings:
1435 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1436 SELECT
1437 ST_LONGFROMGEOHASH(
1438 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1439 AS CHAR CHARACTER SET utf8) COLLATE utf8_czech_ci);
1440 ST_LONGFROMGEOHASH(
1441 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1442 AS CHAR CHARACTER SET utf8) COLLATE utf8_czech_ci)
1443 -179.55743439816956
1444 Warnings:
1445 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1446 SELECT
1447 ST_LONGFROMGEOHASH(
1448 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1449 AS CHAR CHARACTER SET utf8) COLLATE utf8_unicode_ci);
1450 ST_LONGFROMGEOHASH(
1451 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1452 AS CHAR CHARACTER SET utf8) COLLATE utf8_unicode_ci)
1453 -179.55743439816956
1454 Warnings:
1455 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1456 SELECT
1457 ST_LONGFROMGEOHASH(
1458 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1459 AS CHAR CHARACTER SET utf8) COLLATE utf8_hungarian_ci);
1460 ST_LONGFROMGEOHASH(
1461 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1462 AS CHAR CHARACTER SET utf8) COLLATE utf8_hungarian_ci)
1463 -179.55743439816956
1464 Warnings:
1465 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1466 SELECT
1467 ST_LONGFROMGEOHASH(
1468 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1469 AS CHAR CHARACTER SET gb18030) COLLATE gb18030_unicode_520_ci);
1470 ST_LONGFROMGEOHASH(
1471 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1472 AS CHAR CHARACTER SET gb18030) COLLATE gb18030_unicode_520_ci)
1473 -179.55743439816956
1474 SELECT
1475 ST_LATFROMGEOHASH(
1476 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1477 AS CHAR CHARACTER SET utf8) COLLATE utf8_persian_ci);
1478 ST_LATFROMGEOHASH(
1479 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1480 AS CHAR CHARACTER SET utf8) COLLATE utf8_persian_ci)
1481 -82.77450549262497
1482 Warnings:
1483 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1484 SELECT
1485 ST_LATFROMGEOHASH(
1486 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1487 AS CHAR CHARACTER SET utf8) COLLATE utf8_czech_ci);
1488 ST_LATFROMGEOHASH(
1489 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1490 AS CHAR CHARACTER SET utf8) COLLATE utf8_czech_ci)
1491 -82.77450549262497
1492 Warnings:
1493 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1494 SELECT
1495 ST_LATFROMGEOHASH(
1496 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1497 AS CHAR CHARACTER SET utf8) COLLATE utf8_unicode_ci);
1498 ST_LATFROMGEOHASH(
1499 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1500 AS CHAR CHARACTER SET utf8) COLLATE utf8_unicode_ci)
1501 -82.77450549262497
1502 Warnings:
1503 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1504 SELECT
1505 ST_LATFROMGEOHASH(
1506 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1507 AS CHAR CHARACTER SET utf8) COLLATE utf8_hungarian_ci);
1508 ST_LATFROMGEOHASH(
1509 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1510 AS CHAR CHARACTER SET utf8) COLLATE utf8_hungarian_ci)
1511 -82.77450549262497
1512 Warnings:
1513 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1514 SELECT
1515 ST_LATFROMGEOHASH(
1516 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1517 AS CHAR CHARACTER SET gb18030) COLLATE gb18030_unicode_520_ci);
1518 ST_LATFROMGEOHASH(
1519 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1520 AS CHAR CHARACTER SET gb18030) COLLATE gb18030_unicode_520_ci)
1521 -82.77450549262497
1522 SELECT
1523 ST_ASTEXT(
1524 ST_POINTFROMGEOHASH(
1525 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1526 AS CHAR CHARACTER SET utf8) COLLATE utf8_persian_ci,
1527 4326
1528 )
1529 );
1530 ST_ASTEXT(
1531 ST_POINTFROMGEOHASH(
1532 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1533 AS CHAR CHARACTER SET utf8) COLLATE utf8_persian_ci,
1534 4326
1535 )
1536 )
1537 POINT(-82.77450549262497 -179.55743439816956)
1538 Warnings:
1539 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1540 SELECT
1541 ST_ASTEXT(
1542 ST_POINTFROMGEOHASH(
1543 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1544 AS CHAR CHARACTER SET utf8) COLLATE utf8_czech_ci,
1545 4326
1546 )
1547 );
1548 ST_ASTEXT(
1549 ST_POINTFROMGEOHASH(
1550 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1551 AS CHAR CHARACTER SET utf8) COLLATE utf8_czech_ci,
1552 4326
1553 )
1554 )
1555 POINT(-82.77450549262497 -179.55743439816956)
1556 Warnings:
1557 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1558 SELECT
1559 ST_ASTEXT(
1560 ST_POINTFROMGEOHASH(
1561 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1562 AS CHAR CHARACTER SET utf8) COLLATE utf8_unicode_ci,
1563 4326
1564 )
1565 );
1566 ST_ASTEXT(
1567 ST_POINTFROMGEOHASH(
1568 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1569 AS CHAR CHARACTER SET utf8) COLLATE utf8_unicode_ci,
1570 4326
1571 )
1572 )
1573 POINT(-82.77450549262497 -179.55743439816956)
1574 Warnings:
1575 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1576 SELECT
1577 ST_ASTEXT(
1578 ST_POINTFROMGEOHASH(
1579 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1580 AS CHAR CHARACTER SET utf8) COLLATE utf8_hungarian_ci,
1581 4326
1582 )
1583 );
1584 ST_ASTEXT(
1585 ST_POINTFROMGEOHASH(
1586 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1587 AS CHAR CHARACTER SET utf8) COLLATE utf8_hungarian_ci,
1588 4326
1589 )
1590 )
1591 POINT(-82.77450549262497 -179.55743439816956)
1592 Warnings:
1593 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
1594 SELECT
1595 ST_ASTEXT(
1596 ST_POINTFROMGEOHASH(
1597 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1598 AS CHAR CHARACTER SET gb18030) COLLATE gb18030_unicode_520_ci,
1599 4326
1600 )
1601 );
1602 ST_ASTEXT(
1603 ST_POINTFROMGEOHASH(
1604 CAST("0123456789bcdefghjkmnpqrstuvwxyz0123456789BCDEFGHJKMNPQRSTUVWXYZ"
1605 AS CHAR CHARACTER SET gb18030) COLLATE gb18030_unicode_520_ci,
1606 4326
1607 )
1608 )
1609 POINT(-82.77450549262497 -179.55743439816956)
1610 CREATE TABLE t1 (val DOUBLE);
1611 INSERT INTO t1 (val) VALUES (12.2);
1612 SELECT val INTO @double FROM t1;
1613 DROP TABLE t1;
1614 SET @null = NULL;
1615 SET @geohash = "01bbgcee";
1616 PREPARE stmt FROM "SELECT ST_LONGFROMGEOHASH(?)";
1617 EXECUTE stmt USING @geohash;
1618 ST_LONGFROMGEOHASH(?)
1619 -178.7755
1620 DEALLOCATE PREPARE stmt;
1621 SELECT ST_LONGFROMGEOHASH(@geohash);
1622 ST_LONGFROMGEOHASH(@geohash)
1623 -178.7755
1624 SELECT ST_LONGFROMGEOHASH(@null);
1625 ST_LONGFROMGEOHASH(@null)
1626 NULL
1627 PREPARE stmt FROM "SELECT ST_LATFROMGEOHASH(?)";
1628 EXECUTE stmt USING @geohash;
1629 ST_LATFROMGEOHASH(?)
1630 -80.0156
1631 DEALLOCATE PREPARE stmt;
1632 SELECT ST_LATFROMGEOHASH(@geohash);
1633 ST_LATFROMGEOHASH(@geohash)
1634 -80.0156
1635 SELECT ST_LATFROMGEOHASH(@null);
1636 ST_LATFROMGEOHASH(@null)
1637 NULL
1638 PREPARE stmt FROM "SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(?, 0))";
1639 EXECUTE stmt USING @geohash;
1640 ST_ASTEXT(ST_POINTFROMGEOHASH(?, 0))
1641 POINT(-178.7755 -80.0156)
1642 DEALLOCATE PREPARE stmt;
1643 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(@geohash, 0));
1644 ST_ASTEXT(ST_POINTFROMGEOHASH(@geohash, 0))
1645 POINT(-178.7755 -80.0156)
1646 SET @srid = 4326;
1647 PREPARE stmt FROM "SELECT ST_ASTEXT(ST_POINTFROMGEOHASH(\"00\", ?))";
1648 EXECUTE stmt USING @srid;
1649 ST_ASTEXT(ST_POINTFROMGEOHASH("00", ?))
1650 POINT(-87 -174)
1651 DEALLOCATE PREPARE stmt;
1652 SELECT ST_ASTEXT(ST_POINTFROMGEOHASH("00", @srid));
1653 ST_ASTEXT(ST_POINTFROMGEOHASH("00", @srid))
1654 POINT(-87 -174)
1655 SET @maxlen = 3;
1656 PREPARE stmt FROM "SELECT ST_GeoHash(POINT(10, 10), ?)";
1657 EXECUTE stmt USING @maxlen;
1658 ST_GeoHash(POINT(10, 10), ?)
1659 s1z
1660 DEALLOCATE PREPARE stmt;
1661 SELECT ST_GeoHash(POINT(10, 10), @maxlen);
1662 ST_GeoHash(POINT(10, 10), @maxlen)
1663 s1z
1664 SELECT ST_GeoHash(POINT(10, 10), @null);
1665 ST_GeoHash(POINT(10, 10), @null)
1666 NULL
1667 SET @point = POINT(10, 10);
1668 PREPARE stmt FROM "SELECT ST_GeoHash(?, 10)";
1669 EXECUTE stmt USING @point;
1670 ST_GeoHash(?, 10)
1671 s1z0gs3y0z
1672 DEALLOCATE PREPARE stmt;
1673 SELECT ST_GeoHash(@point, 10);
1674 ST_GeoHash(@point, 10)
1675 s1z0gs3y0z
1676 SELECT ST_GeoHash(@null, 10);
1677 ST_GeoHash(@null, 10)
1678 NULL
1679 SET @long = 22.0311;
1680 PREPARE stmt FROM "SELECT ST_GeoHash(?, 10, 10)";
1681 EXECUTE stmt USING @long;
1682 ST_GeoHash(?, 10, 10)
1683 s3z8vk6w1z
1684 DEALLOCATE PREPARE stmt;
1685 SELECT ST_GeoHash(@long, 10, 10);
1686 ST_GeoHash(@long, 10, 10)
1687 s3z8vk6w1z
1688 SELECT ST_GeoHash(@null, 10, 10);
1689 ST_GeoHash(@null, 10, 10)
1690 NULL
1691 SET @lat = -54.123;
1692 PREPARE stmt FROM "SELECT ST_GeoHash(10, ?, 10)";
1693 EXECUTE stmt USING @lat;
1694 ST_GeoHash(10, ?, 10)
1695 hnrh5e1y8v
1696 DEALLOCATE PREPARE stmt;
1697 SELECT ST_GeoHash(10, @lat, 10);
1698 ST_GeoHash(10, @lat, 10)
1699 hnrh5e1y8v
1700 SELECT ST_GeoHash(10, @null, 10);
1701 ST_GeoHash(10, @null, 10)
1702 NULL
1703 PREPARE stmt FROM "SELECT ST_GeoHash(10, 10, ?)";
1704 EXECUTE stmt USING @maxlen;
1705 ST_GeoHash(10, 10, ?)
1706 s1z
1707 DEALLOCATE PREPARE stmt;
1708 SELECT ST_GeoHash(10, 10, @maxlen);
1709 ST_GeoHash(10, 10, @maxlen)
1710 s1z
1711 SELECT ST_GeoHash(@double, @double, 10);
1712 ST_GeoHash(@double, @double, 10)
1713 s60tmsgy0s
1714 SELECT ST_GeoHash(POINT(10, 10), @double);
1715 ERROR HY000: Incorrect type for argument geohash max length in function st_geohash.
1716 SELECT ST_POINTFROMGEOHASH("00", @double);
1717 ERROR HY000: Incorrect type for argument SRID in function st_pointfromgeohash.
1718 DROP TABLE IF EXISTS t1;
1719 Warnings:
1720 Note 1051 Unknown table 'test.t1'
1721 CREATE TABLE t1 (a VARCHAR(255));
1722 INSERT INTO t1 (a) VALUES (' ');
1723 SELECT ST_LONGFROMGEOHASH(a) FROM t1;
1724 ERROR HY000: Incorrect geohash value: ' ' for function ST_LONGFROMGEOHASH
1725 SELECT ST_LATFROMGEOHASH(a) FROM t1;
1726 ERROR HY000: Incorrect geohash value: ' ' for function ST_LATFROMGEOHASH
1727 SELECT ST_POINTFROMGEOHASH(a, 0) FROM t1;
1728 ERROR HY000: Incorrect geohash value: ' ' for function st_pointfromgeohash
1729 DELETE FROM t1;
1730 INSERT INTO t1 VALUES ('swpwwwwww'), ('guqtjvooguqtjvoo');
1731 SELECT ST_LONGFROMGEOHASH(a) FROM t1;
1732 ERROR HY000: Incorrect geohash value: 'guqtjvooguqtjvoo' for function ST_LONGFROMGEOHASH
1733 SELECT ST_LATFROMGEOHASH(a) FROM t1;
1734 ERROR HY000: Incorrect geohash value: 'guqtjvooguqtjvoo' for function ST_LATFROMGEOHASH
1735 SELECT ST_POINTFROMGEOHASH(a, 0) FROM t1;
1736 ERROR HY000: Incorrect geohash value: 'guqtjvooguqtjvoo' for function st_pointfromgeohash
1737 # Clean up
1738 DROP TABLE geohashes;
1739 DROP TABLE t1;
1740 #
1741 # Bug#22165582 ST_*FROMGEOHASH ROUNDS INCORRECTLY
1742 #
1743 SELECT ST_GeoHash(ST_PointFromGeoHash('xkcd', 0), 4);
1744 ST_GeoHash(ST_PointFromGeoHash('xkcd', 0), 4)
1745 xkcd
1746 SELECT ST_LongFromGeoHash('xkcd');
1747 ST_LongFromGeoHash('xkcd')
1748 148.5
1749 SELECT ST_LatFromGeoHash('xkcd');
1750 ST_LatFromGeoHash('xkcd')
1751 27.2
1752 SELECT ST_GeoHash(ST_PointFromGeoHash('ebrb', 0), 4);
1753 ST_GeoHash(ST_PointFromGeoHash('ebrb', 0), 4)
1754 s020
1755 SELECT ST_LatFromGeoHash('m7s9pyctu9bbwqkgbw5x6vutzkztd9szjh86gmz9w9nsz6792d');
1756 ST_LatFromGeoHash('m7s9pyctu9bbwqkgbw5x6vutzkztd9szjh86gmz9w9nsz6792d')
1757 -25.098643334722453
1758 #
1759 # Bug#22838668 CRASH IN ITEM_FUNC_LATLONGFROMGEOHASH::VAL_REAL
1760 # WITH BAD PARAMETERS
1761 #
1762 DO ST_Disjoint(
1763 POLYGON(
1764 LINESTRING(POINT(1, 1))
1765 ),
1766 ST_LatFromGeoHash(ExtractValue(1, NULL))
1767 );
1768 ERROR 22023: Invalid GIS data provided to function linestring.
1769 DO ST_Disjoint(
1770 POLYGON(
1771 LINESTRING(POINT(1, 1))
1772 ),
1773 ST_LongFromGeoHash(ExtractValue(1, NULL))
1774 );
1775 ERROR 22023: Invalid GIS data provided to function linestring.
1776 DO ST_Disjoint(
1777 POLYGON(
1778 LINESTRING(POINT(1, 1))
1779 ),
1780 ST_LatFromGeoHash(UpdateXML(1, NULL, NULL))
1781 );
1782 ERROR 22023: Invalid GIS data provided to function linestring.
1783 DO ST_Disjoint(
1784 POLYGON(
1785 LINESTRING(POINT(1, 1))
1786 ),
1787 ST_LongFromGeoHash(UpdateXML(1, NULL, NULL))
1788 );
1789 ERROR 22023: Invalid GIS data provided to function linestring.
1790 #
1791 # WL#8579 Spatial Reference Systems
1792 #
1793 # SRID 0 (should pass)
1794 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)', 0), 10);
1795 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)', 0), 10)
1796 s000000000
1797 # Projected SRS (should fail)
1798 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)', 2000), 10);
1799 ERROR 22S00: Function st_geohash is only defined for SRID 0 and SRID 4326.
1800 # Geographic SRS (should pass)
1801 SELECT ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 10);
1802 ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 10)
1803 s000000000
1804 #
1805 # Bug#25912557 ST_LATFROMGEOHASH/ST_LONGFROMGEOHASH ODD INPUT TYPE
1806 # REQUIREMENT
1807 #
1808 CREATE TABLE t1 (col1 CHAR(4));
1809 INSERT INTO t1 VALUES ('bbbb');
1810 SELECT ST_LatFromGeohash(col1) FROM t1;
1811 ST_LatFromGeohash(col1)
1812 49.3
1813 SELECT ST_LongFromGeohash(col1) FROM t1;
1814 ST_LongFromGeohash(col1)
1815 -145
1816 SELECT ST_AsText(ST_PointFromGeohash(col1, 4326)) FROM t1;
1817 ST_AsText(ST_PointFromGeohash(col1, 4326))
1818 POINT(49.3 -145)
1819 DROP TABLE t1;
1820 #
1821 # WL#11096 Don't do Cartesian computations on geographic geometries
1822 #
1823 # Assume SRID 10 is not defined.
1824 DO ST_GEOHASH(x'0A000000010100000000000000000000000000000000000000', 10);
1825 ERROR SR001: There's no spatial reference system with SRID 10.
1826 DO ST_POINTFROMGEOHASH('0', 10);
1827 ERROR SR001: There's no spatial reference system with SRID 10.
1828 # The only geographic SRS allowed is 4326.
1829 DO ST_GEOHASH(ST_GEOMFROMTEXT('POINT(0 0)', 3819), 10);
1830 ERROR 22S00: Function st_geohash is only defined for SRID 0 and SRID 4326.