Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24390

ALTER S3 table to InnoDB fails without error

    XMLWordPrintable

    Details

      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 |
      +---------+---------------------------------------------------------------------------------------------------------+
      
      

        Attachments

          Activity

            People

            Assignee:
            monty Michael Widenius
            Reporter:
            claudio.nanni Claudio Nanni
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.