HeidiSQL version 9.3.0.5124 MySQL 5.7.13
When I try to change virtuality for a generated column in MySQL, I have the option 'PERSISTENT' which is not supported by the server.
When I run the query "ALTER TABLE users
add COLUMN gender
ENUM('M','F') GENERATED ALWAYS AS (json_unquote(meta->'$.gender')) STORED;" it works.
You have to replace 'PERSISTENT' with 'STORED' for MySQL.
Thank you