distal-attribute
distal-attribute
distal-attribute
distal-attribute

Bug - Mysql Generated Column - STORED not PERSISTENT

alex_giuvara posted 6 months ago in General

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

1 attachment(s):
  • heidi_bug
endo64 posted 1 month ago

This issue is still there.

Please login to leave a reply, or register at first.