Bug - Mysql Generated Column - STORED not PERSISTENT

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

This issue is still there.

I'm running into the same issue as the OP. MySql 5.7.22 using 'Stored' through the command line works but using 'Persistent' with Heidi does not.

This option would be a great addition to an already great piece of software!

Thanks!

Also the expression for generated column is wrapped into the additional pair of brackets.