Opened 47 minutes ago
#37320 new New feature
Add support for ST_Transform on MySQL
| Reported by: | Jacob Walls | Owned by: | |
|---|---|---|---|
| Component: | GIS | Version: | 6.1 |
| Severity: | Normal | Keywords: | mysql, transform, srs |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
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 #27574.
This is a blocker for fixing #27574, which is a pain point that has come up on the forum a couple times.
Note:
See TracTickets
for help on using tickets.