I upgraded to MySQL 8.0.13 and tried to add a new field using
ALGORITHM=INSTANT but got the following error:
Error Code: 1845. ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY/INPLACE
Then I recreated the same table in MySQL 8.0.13 and tried to add the same field using
ALGORITHM=INSTANT and it works!
Will this new feature of MySQL
(ALGORITHM=INSTANT) only work on newly created tables in the upgraded version?