3274
MySQLERRORNotableGIS / GeometryHIGH confidence
ST_Transform source CRS is not geographic
Production Risk
Medium — transformation fails; geometry remains untransformed.
How to reproduce
trigger — this will error
trigger — this will error
SELECT ST_Transform(ST_GeomFromText('POINT(500000 4000000)', 32632), 4326);expected output
ERROR 3274 (HY000): ST_Transform source SRS is not geographic.
Fix
Ensure source is geographic
Ensure source is geographic
-- Store or convert geometry in a geographic SRS like 4326 before transforming.
Why this works
ST_Transform in MySQL 8.0 requires a geographic source SRS.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3274 ER_TRANSFORM_SOURCE_CRS_NOT_GEOGRAPHIC
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev