3309
MySQLERRORNotableSpatial / GISHIGH confidence
SRS organization name cannot be NULL or empty
Production Risk
Low — DDL rejected immediately.
How to reproduce
trigger — this will error
trigger — this will error
CREATE SPATIAL REFERENCE SYSTEM 12345 NAME 'test' ORGANIZATION NULL IDENTIFIED BY 0 DEFINITION '...';
expected output
ERROR 3309 (HY000): The spatial reference system organization name can't be NULL or an empty string.
Fix
Omit or fill ORGANIZATION
Omit or fill ORGANIZATION
CREATE SPATIAL REFERENCE SYSTEM 12345 NAME 'test' DEFINITION '...';
Why this works
The ORGANIZATION clause is optional; omit it when not needed.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3309 ER_SRS_ORGANIZATION_CANT_BE_NULL_OR_EMPTY_STRING
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev