Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
The GIS function ST_GeoHash takes as input:
- (longitude, latitude, max_length), OR
- (point, max_length)
The longitue parameter is a numeric value in the interval [180, -180], the latitude is a numeric value in the interval [90, -90].
In the case of point, the x coordinate is treated as the latitude and the y coordinate is treated as the latitude. Even in the case of a point, the same constraints apply.
The max_length parameter is the upper limit on the resulting string size and cannot exceed 100.
The function returns the geohash corresponding to the input values.
Attachments
Issue Links
- blocks
-
-
- In Testing
-
-
-
- In Testing
-
- is part of
-
MDEV-17398 Implement Geographic functions available in MySQL 8.0
-
- Stalled
-
-
-
- In Testing
-
Activity
NULL is expected:
MariaDB [test]> SELECT ST_GeoHash(45,-20,null);
|
+-------------------------+
|
| ST_GeoHash(45,-20,null) |
|
+-------------------------+
|
| mh2n0p0581b0bh2n0p0581g |
|
+-------------------------+
|
1 row in set (0,001 sec)
|
|
|
MariaDB [test]> SELECT ST_GeoHash(0,-20,null);
|
+------------------------------------------------------------------------------------------------------+
|
| ST_GeoHash(0,-20,null) |
|
+------------------------------------------------------------------------------------------------------+
|
| kh2n0p0581b0bh2n0p0581bpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbpbp |
|
+------------------------------------------------------------------------------------------------------+
|
1 row in set (0,000 sec)
|
julien.fritsch this is not critical fro 12.0 and will go into whatever release is pending at the point that testing is complete. So no need to rush a review or anything like that.
wrong error message- GIS is not invalid here:
MariaDB [test]> SELECT ST_GeoHash(( POINTFROMTEXT(' POINT( 4 1 ) ') ), 1e0) ;ERROR 3037 (22023): Invalid GIS data provided to function ST_GeoHash.maybe make a better error message - write smth like : max_length parameter should be in from 1 to 100 :
MariaDB [test]> SELECT ST_GeoHash(( POINTFROMTEXT(' POINT( 4 1 ) ') ), 0) ;ERROR 3048 (HY000): Out of range error: max geohash length value in function ST_GeoHash.