1343
MariaDBerrorddlmedium confidence

Table has unsupported extension in CREATE/ALTER

Production Risk

Low — DDL fails; no data affected.

What this means

A CREATE TABLE or ALTER TABLE used a storage engine extension option that is not supported by the server.

Why it happens
  1. 1Using engine-specific options for an engine that is not loaded
  2. 2Restoring a dump containing proprietary engine options
How to reproduce
trigger — this will error
trigger — this will error
-- Engine-specific; e.g. Aria or TokuDB options on standard InnoDB build.

expected output

ERROR 1343 (HY000): Table has unsupported extension in CREATE/ALTER

Fix

Remove unsupported options

Why this works

Check the documentation for the target engine and remove unsupported clauses.

Sources
Official documentation ↗

MySQL 8.0 — 1343 ER_UNSUPPORTED_EXTENSION

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

← All MariaDB errors