3279
MariaDBERRORCriticalGIS / GeometryHIGH confidence

SRS definition has an invalid latitude of origin

Production Risk

Low — affects custom SRS definitions only.

How to reproduce
trigger — this will error
trigger — this will error
CREATE SPATIAL REFERENCE SYSTEM 100001 NAME 'Bad SRS' DEFINITION 'PROJCS[...,PARAMETER["latitude_of_origin",91],...]';

expected output

ERROR 3279 (HY000): Invalid latitude of origin in spatial reference system definition.

Fix

Use valid latitude

Use valid latitude
-- Set latitude_of_origin to a value between -90 and 90 in the SRS DEFINITION string.

Why this works

Valid latitude values are constrained to the Earth's polar range.

What not to do

Sources
Official documentation ↗

MySQL 8.0 — 3279 ER_SRS_INVALID_LATITUDE_OF_ORIGIN

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

← All MariaDB errors