With the dataset of
MDEV-14023, ALTER TABLE will fail in InnoDB with a misleading error message:
All of the following statements will lead to the above response:
We must fix this (insert the missing records to SYS_VIRTUAL), so that early users of virtual columns in 10.1 will be able to quickly create indexes on the virtual columns in 10.2 (
MDEV-5800), and to instantly add columns in 10.3 ( MDEV-11369), among other things.