Opened 4 weeks ago
Last modified 4 weeks ago
#37320 assigned New feature
Add support for ST_Transform on MySQL
| Reported by: | Jacob Walls | Owned by: | Vishy |
|---|---|---|---|
| Component: | GIS | Version: | 6.1 |
| Severity: | Normal | Keywords: | mysql, transform, srs |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
MySQL has an ST_Transform function since 8.0.13, and "all" Cartesian transforms are supported since 8.0.32, so we should add support for the Transform geo function.
It is likely that we should first tackle #33120 (implement Spatial Reference System (SRS)) to avoid rework, but an implementer could confirm.
Gates on supports_transform should be checked to see if they can use the new functionality safely, or if they should fallback to the old read/write SRID-0 behavior described in #27464.
This is a blocker for fixing #27464, which is a pain point that has come up on the forum a couple times.
Change History (3)
comment:1 by , 4 weeks ago
| Description: | modified (diff) |
|---|
comment:2 by , 4 weeks ago
| Triage Stage: | Unreviewed → Accepted |
|---|
comment:3 by , 4 weeks ago
| Owner: | set to |
|---|---|
| Status: | new → assigned |
Note:
See TracTickets
for help on using tickets.
Sounds good.
One note for someone implementing this is that while MySQL supports the function, MariaDB does not. Given they share a database backend there'll need to be some kind of check to limit the availability of the function to supported databases.