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
| Field | Original Value | New Value |
|---|---|---|
| Link | This issue is part of MDEV-17398 [ MDEV-17398 ] |
| Link | This issue is part of MDEV-34120 [ MDEV-34120 ] |
| Link | This issue blocks MDEV-34159 [ MDEV-34159 ] |
| Link | This issue blocks MDEV-34160 [ MDEV-34160 ] |
| Assignee | Dave Gosselin [ JIRAUSER52216 ] |
| Fix Version/s | 11.7 [ 29815 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Dave Gosselin [ JIRAUSER52216 ] | Alexey Botchkov [ holyfoot ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | In Testing [ 10301 ] |
| Assignee | Alexey Botchkov [ holyfoot ] | Dave Gosselin [ JIRAUSER52216 ] |
| Link | This issue is part of TODO-4907 [ TODO-4907 ] |
| Labels | Compatibility GIS gsoc24 | Compatibility GIS Preview_11.7 gsoc24 |
| Fix Version/s | 11.8 [ 29921 ] | |
| Fix Version/s | 11.7 [ 29815 ] | |
| Assignee | Dave Gosselin [ JIRAUSER52216 ] | Alice Sherepa [ alice ] |
| Link | This issue is part of TODO-5071 [ TODO-5071 ] |
| Labels | Compatibility GIS Preview_11.7 gsoc24 | Compatibility GIS Preview_11.7 Preview_11.8 gsoc24 |
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)
|
| Assignee | Alice Sherepa [ alice ] | Dave Gosselin [ JIRAUSER52216 ] |
| Status | In Testing [ 10301 ] | Stalled [ 10000 ] |
| Fix Version/s | 12.0 [ 29945 ] | |
| Fix Version/s | 11.8 [ 29921 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Dave Gosselin [ JIRAUSER52216 ] | Daniel Black [ danblack ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Daniel Black [ danblack ] | Dave Gosselin [ JIRAUSER52216 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
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.
| Fix Version/s | 12.0.2 [ 30117 ] | |
| Fix Version/s | 12.0 [ 29945 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Fix Version/s | 12.1 [ 29992 ] | |
| Fix Version/s | 12.0.2 [ 30117 ] |
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.