3308
MariaDBERRORNotableSpatial / GISHIGH confidence
Spatial Reference System name cannot be an empty string
Production Risk
Low — DDL rejected immediately.
How to reproduce
trigger — this will error
trigger — this will error
CREATE SPATIAL REFERENCE SYSTEM 12345 NAME '' DEFINITION '...';
expected output
ERROR 3308 (HY000): The spatial reference system name can't be an empty string.
Fix
Use a descriptive name
Use a descriptive name
CREATE SPATIAL REFERENCE SYSTEM 12345 NAME 'WGS 84 / UTM zone 32N' DEFINITION '...';
Why this works
A meaningful name helps administrators identify the CRS.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3308 ER_SRS_NAME_CANT_BE_EMPTY_STRING
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev