MariaDB [test]> show create table  bad_with_key\G

*************************** 1. row ***************************

       Table: bad_with_key

Create Table: CREATE TABLE `bad_with_key` (

  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

  `id_md5` char(32) GENERATED ALWAYS AS (md5(`id`)) VIRTUAL,

  `f` float DEFAULT NULL,

  `ts` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),

  UNIQUE KEY `id` (`id`,`id_md5`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

1 row in set (0.000 sec)

MariaDB [test]> alter table bad_with_key change column id_len id_md5 binary(16) generated always as (unhex(md5(id))) PERSISTENT AFTER id;

ERROR 1054 (42S22): Unknown column 'id_len' in 'bad_with_key'

MariaDB [test]> alter table bad_with_key modify  column id_md5 binary(16) generated always as (unhex(md5(id))) PERSISTENT AFTER id;

ERROR 1907 (HY000): This is not yet supported for generated columns

MariaDB [test]> alter table bad_with_key modify column id_md5 char(32) generated always as (unhex(md5(id))) PERSISTENT AFTER id;

ERROR 1907 (HY000): This is not yet supported for generated columns

MariaDB [test]> alter table bad_with_key modify column id_md5 char(32) generated always as (md5(id)) PERSISTENT AFTER id;

ERROR 1907 (HY000): This is not yet supported for generated columns

MariaDB [test]> alter table bad_with_key modify  column id_md5 binary(16) as (unhex(md5(id))) PERSISTENT AFTER id;

ERROR 1907 (HY000): This is not yet supported for generated columns

MariaDB [test]> alter table bad_with_key modify  column id_md5 char(32) as (unhex(md5(id))) PERSISTENT AFTER id;

ERROR 1907 (HY000): This is not yet supported for generated columns

MariaDB [test]> alter table bad_with_key drop index id;

Query OK, 0 rows affected (0.030 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [test]> alter table bad_with_key modify  column id_md5 binary(16) generated always as (unhex(md5(id))) PERSISTENT AFTER id;

ERROR 1907 (HY000): This is not yet supported for generated columns

MariaDB [test]> show create table bad_with_key

    -> \G

*************************** 1. row ***************************

       Table: bad_with_key

Create Table: CREATE TABLE `bad_with_key` (

  `id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

  `id_md5` char(32) GENERATED ALWAYS AS (md5(`id`)) VIRTUAL,

  `f` float DEFAULT NULL,

  `ts` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

1 row in set (0.000 sec)

MariaDB [test]> alter table bad_with_key drop column  id_md5;

Query OK, 0 rows affected (0.035 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [test]> alter table bad_with_key add column id_md5 binary(16) generated always as (unhex(md5(id))) PERSISTENT AFTER id;

Query OK, 8 rows affected (0.059 sec)

Records: 8  Duplicates: 0  Warnings: 0