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

ALTER S3 table to InnoDB fails without error

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

          claudio.nanni Claudio Nanni created issue -
          julien.fritsch Julien Fritsch made changes -
          Field Original Value New Value
          Affects Version/s 10.4 [ 22408 ]
          julien.fritsch Julien Fritsch made changes -
          Affects Version/s 10.4 [ 22408 ]
          julien.fritsch Julien Fritsch made changes -
          Affects Version/s 10.4.15 [ 24507 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.4 [ 22408 ]
          julien.fritsch Julien Fritsch made changes -
          Assignee Michael Widenius [ monty ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.4 [ 22408 ]
          Affects Version/s 10.5 [ 23123 ]
          Affects Version/s 10.4.15 [ 24507 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 116772 ] MariaDB v4 [ 142431 ]
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 139688

          People

            monty Michael Widenius
            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.