3225
MariaDBERRORNotablePartitioningHIGH confidence
Mixed explicit and implicit values in ENUM partition
Production Risk
Low — DDL error.
Why it happens
- 1Mixing explicitly numbered and implicitly numbered partition definitions in an ENUM-style partition scheme.
How to reproduce
trigger — this will error
trigger — this will error
-- Triggered by mixed explicit/implicit numbering in partition definitions.
expected output
ERROR 3225 (HY000): Mixed explicit and implicit values in ENUM partition.
Fix
Use consistent explicit numbering
Use consistent explicit numbering
-- Assign explicit values to all partitions or none.
Why this works
Consistency avoids ambiguity in partition value assignment.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3225 ER_MIXED_DEF_AND_IMPLICIT_DEF_IN_ENUM_PART_ERROR
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev