Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.x
Description
While adding checks to pt-online-schema-change I tried to create a table as follows:
CREATE TABLE `test`.`t1` ( `ID` int(11) NOT NULL, `Column2` int(11) DEFAULT NULL, `Column3` int(11) GENERATED ALWAYS AS ((`Column2` + 1)) STORED, PRIMARY KEY (`ID`) ) ENGINE=RocksDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
and I am getting this error:
ERROR 3106 (HY000): 'Specified storage engine' is not supported for generated columns.
Even if generated columns is a MySQL 5.7+/InnoDB specific feature, I think it worth mentioning it in the MyRocks limitations page at https://www.percona.com/doc/percona-server/LATEST/myrocks/limitations.html
