Altering table engine ARIA => InnoDB faulty

Hello,

just a notice for possible improvements:

When doing an ALTER TABLE DB.table ENGINE InnoDB;

on an ARIA table it fails with / SQL-Error (1005): Can't create table DB.table (errno: 140 "Wrong create options") /

because of the ROW_FORMAT=PAGE

in the ARIA table.

Removing this by hand solved the problem.

Checked with HeidySQL 12.4.0 / Windows.

For me that worked without errors in HeidiSQL's table designer.

Created the table:

CREATE TABLE aria_1 (id INT) ENGINE=Aria;

Altering:

ALTER TABLE `aria_1`
    ENGINE=InnoDB;

Please watch out for the row format dropdown in the "Options" tab of the table desigenr.