[instant add column] failed to add column for a table that previously had a full-text index

[xingyingone]

How to reproduce

mysql> create database tde_db;
Query OK, 1 row affected (0.05 sec)

mysql> CREATE TABLE tde_db.t_encrypt(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, c2 char(100), c3 BLOB , FULLTEXT INDEX `idx1` (c2))  ENGINE = InnoDB;
Query OK, 0 rows affected (1.81 sec)


mysql> ALTER TABLE tde_db.t_encrypt DROP INDEX idx1;
Query OK, 0 rows affected (0.29 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql> ALTER TABLE tde_db.t_encrypt ADD COLUMN c4 CHAR(20) DEFAULT 'text' not null;
ERROR 1815 (HY000): Internal error: InnoDB: ADD COLUMN...INSTANT

How to fix

fix as 8.0