Error Code: 1845. ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY/INPLACE 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?
According to my research, this is a bug

https://bugs.mysql.com/bug.php?id=92194

which is explaining 
 " For ALTER TABLE, ALGORITHM=INSTANT was incorrectly rejected on tables
created in a MySQL version prior to 8.0.12 " 
" Fixed in 8.0.14. "

I didn't tested it with 8.0.14. I will post here the results once I tested it with 8.0.14.



[update]

Tested it in 8.0.14 and it works