3278
MariaDBERRORNotableGIS / GeometryHIGH confidence
Wrong coordinate system type for spatial function
Production Risk
Low — affects advanced or custom SRS configurations.
How to reproduce
trigger — this will error
trigger — this will error
-- Triggered by using a geocentric SRS with a function that requires geographic 2D.
expected output
ERROR 3278 (HY000): Spatial reference system has a wrong coordinate system type for this function.
Fix
Use compatible SRS
Use compatible SRS
-- Switch to a geographic 2D SRS such as SRID 4326 for surface-based spatial functions.
Why this works
Geographic 2D SRS values are supported by the widest range of MySQL spatial functions.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3278 ER_SRS_WRONG_CS_TYPE
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev