1790
MySQLERRORNotableDDLHIGH confidence
INPLACE ALTER not supported — FULLTEXT-related reason
Production Risk
Low — DDL rejected.
What this means
A general FULLTEXT-related reason prevents the ALTER TABLE operation from using ALGORITHM=INPLACE.
Why it happens
- 1Any FULLTEXT interaction that prevents in-place execution, not covered by 1788 or 1789.
How to reproduce
trigger — this will error
trigger — this will error
ALTER TABLE articles ALGORITHM=INPLACE, ADD FULLTEXT INDEX ft_title (title);
expected output
ERROR 1790 (0A000): ALGORITHM=INPLACE is not supported. Reason: FULLTEXT.
Fix
Use ALGORITHM=COPY or let MySQL choose the algorithm
Use ALGORITHM=COPY or let MySQL choose the algorithm
ALTER TABLE articles ADD FULLTEXT INDEX ft_title (title);
Why this works
Omitting the algorithm hint allows MySQL to fall back to COPY when needed.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 1790 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FTS
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev