3272
MySQLERRORNotableGIS / GeometryHIGH confidence

Source CRS for ST_Transform is not supported

Production Risk

Medium — coordinate transformation fails.

How to reproduce
trigger — this will error
trigger — this will error
SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(1 1)', 0), 4326));

expected output

ERROR 3272 (HY000): The transformation source CRS is not supported.

Fix

Use a geographic source SRS

Use a geographic source SRS
SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(139.7 35.7)', 4326), 32654));

Why this works

ST_Transform works between geographic SRS values; use a lat/long SRS as source.

What not to do

Sources
Official documentation ↗

MySQL 8.0 — 3272 ER_TRANSFORM_SOURCE_CRS_NOT_SUPPORTED

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors