[MDEV-24390] ALTER S3 table to InnoDB fails without error Created: 2020-12-10  Updated: 2021-02-22

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - S3
Affects Version/s: 10.5
Fix Version/s: 10.5

Type: Bug Priority: Major
Reporter: Claudio Nanni Assignee: Michael Widenius
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Alter an S3 table back to InnoDB doesn't work, but no error:

MariaDB [s3_schema]> show create table ts3_001;
+---------+---------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                            |
+---------+---------------------------------------------------------------------------------------------------------+
| ts3_001 | CREATE TABLE `ts3_001` (
  `id` int(11) DEFAULT NULL
) ENGINE=S3 DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 |
+---------+---------------------------------------------------------------------------------------------------------+
1 row in set (0.622 sec)
 
MariaDB [s3_schema]> alter table ts3_001 engine=innodb;
Query OK, 0 rows affected (0.194 sec)              
 
MariaDB [s3_schema]> show create table ts3_001;
+---------+---------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                            |
+---------+---------------------------------------------------------------------------------------------------------+
| ts3_001 | CREATE TABLE `ts3_001` (
  `id` int(11) DEFAULT NULL
) ENGINE=S3 DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 |
+---------+---------------------------------------------------------------------------------------------------------+


Generated at Thu Feb 08 09:29:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.