ERROR 1030 (HY000) — Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine" from storage engine MyISAM

13.0.1-opt>CREATE TABLE t1 (id INT, a VARCHAR) ENGINE=MYISAM;

Query OK, 0 rows affected (0.009 sec)

13.0.1-opt>ALTER TABLE t1 CHANGE id id2 INT;

Query OK, 0 rows affected (0.013 sec)

Records: 0  Duplicates: 0  Warnings: 0

13.0.1-opt>ALTER TABLE t1 ADD b INT;

ERROR 1030 (HY000): Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You can try REPAIR TABLE ... USE_FRM possibly followed by ALTER TABLE ... FORCE or dump and restore the table to fix this" from storage engine MyISAM

13.0.1-opt>

CREATE TABLE t1 (id INT, a VARCHAR) ENGINE=MYISAM;

ALTER TABLE t1 CHANGE id id2 INT;

ALTER TABLE t1 ADD b INT;

#cleanup

DROP TABLE t1;