4026
MariaDBERRORNotableSystem VersioningHIGH confidence
Storage engine does not support system versioning
What this means
ER_VERS_ENGINE_UNSUPPORTED (4026) is returned when attempting to create a WITH SYSTEM VERSIONING table using a storage engine that does not support temporal (system-versioned) tables. Only InnoDB, Aria, and MyISAM support system versioning in MariaDB.
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t (id INT) ENGINE=MEMORY WITH SYSTEM VERSIONING;
expected output
ERROR 4026 (HY000): Storage engine MEMORY does not support system-versioned tables
Fix
Use InnoDB as the storage engine
WHEN Creating a system-versioned table.
Use InnoDB as the storage engine
CREATE TABLE t (id INT) ENGINE=InnoDB WITH SYSTEM VERSIONING;
Why this works
InnoDB fully supports system versioning and is the recommended engine for all transactional MariaDB tables.
Version notes
MariaDB 10.3
System versioning is supported by InnoDB, Aria, and MyISAM. MEMORY, CSV, and BLACKHOLE engines do not support it.
Sources
Official documentation ↗
MariaDB — System-Versioned Tables
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev