Description:
The table with full-text indexing reports an instant DDL error, so after deleting the full-text index, it still reports an error.
How to repeat:
mysql> CREATE TABLE t (content longtext, FULLTEXT KEY idx_content (content));
Query OK, 0 rows affected (0.48 sec)
mysql> alter table t add a int, algorithm = instant;
ERROR 1846 (0A000): ALGORITHM=INSTANT is not supported. Reason: InnoDB presently supports one FULLTEXT index creation at a time. Try ALGORITHM=COPY/INPLACE.
mysql> alter table t drop index idx_content, algorithm = inplace;
Query OK, 0 rows affected (0.17 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table t add a int, algorithm = instant;
ERROR 1845 (0A000): ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY/INPLACE.
mysql> optimize table t;
+--------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------+----------+----------+-------------------------------------------------------------------+
| test.t | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| test.t | optimize | status | OK |
+--------+----------+----------+-------------------------------------------------------------------+
2 rows in set (0.21 sec)
mysql> alter table t add a int, algorithm = instant;
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
