EC
1789
MySQLERRORNotableDDLHIGH confidence

INPLACE ALTER not supported — FULLTEXT index change

Production Risk

Low — DDL rejected.

What this means

Adding, dropping, or modifying a FULLTEXT index is not supported with ALGORITHM=INPLACE.

Why it happens
  1. 1DROP INDEX or ADD FULLTEXT INDEX on an InnoDB table using ALGORITHM=INPLACE.
How to reproduce
trigger — this will error
trigger — this will error
ALTER TABLE articles ALGORITHM=INPLACE, DROP INDEX ft_body;

expected output

ERROR 1789 (0A000): ALGORITHM=INPLACE is not supported. Reason: Fulltext index change requires COPY.

Fix

Remove the ALGORITHM=INPLACE hint for FULLTEXT index changes

Remove the ALGORITHM=INPLACE hint for FULLTEXT index changes
ALTER TABLE articles DROP INDEX ft_body;

Why this works

MySQL will select an appropriate algorithm automatically for FULLTEXT changes.

What not to do

✕

Sources
Official documentation ↗

MySQL 8.0 — 1789 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_CHANGE_FTS

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

← All MySQL errors