I am trying to convert an aria table to InnoDB. My problem is
MariaDB> alter table materiales engine=innodb;
ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the create option 'TRANSACTIONAL=1'
I searched for this problem and didn't found a solution. Some people sugests using sql-mode = '', but it only changes the error and the conversion can't be done.
It looks like a bug, because the conversion to innodb should ignore this option but I think it could be walked arround by removing the "transactional=1" option.
Then my question is: I can modify options like ROW_FORMAT or TRANSACTIONAL, but how can I completely remove it? (whitout dumpling and re-creating the table because it is BIG)