ALTER TABLE ENGINE=x started failing instead of producing warning on unsupported TRANSACTIONAL=1

CREATE TABLE t (a INT) ENGINE=Aria TRANSACTIONAL=1;

ALTER TABLE t ENGINE=MyISAM;

DROP TABLE t;

mysqltest: At line 2: query 'ALTER TABLE t ENGINE=MyISAM' failed: 1478: Table storage engine 'MyISAM' does not support the create option 'TRANSACTIONAL=1'

commit 35533dc0b381ddbc665531d39ce3d3e9a8af2e88 (origin/bb-10.5-midenok)

Author: Aleksey Midenkov

Date:   Thu Jul 27 14:21:35 2023 +0300

    MDEV-29727 ALTER and CREATE with default partitioning

               differently react to SQL_MODE => unusable SHOW CREATE