[MDEV-31822] ALTER TABLE ENGINE=x started failing instead of producing warning on unsupported TRANSACTIONAL=1 Created: 2023-08-01  Updated: 2023-08-11  Resolved: 2023-08-02

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Affects Version/s: N/A
Fix Version/s: 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2

Type: Bug Priority: Blocker
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: regression

Issue Links:
Problem/Incident
is caused by MDEV-29727 ALTER and CREATE with default partiti... Closed
Relates
relates to MDEV-31794 Preserved unsupported table flags bre... Open

 Description    

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

10.5 65405308

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

The failure started happening after this commit in 10.5

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


Generated at Thu Feb 08 10:26:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.