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

Modify Innodb storage engine to MyISAM_MRG will make data lost.

    XMLWordPrintable

    Details

      Description

      When I create a Innodb storage engine table, and I change it to MRG_MYISAM engine, the table data will be lost.

      MariaDB [zbdba]> show create table zbdba\G
      *************************** 1. row ***************************
             Table: zbdba
      Create Table: CREATE TABLE `zbdba` (
        `id` int(11) NOT NULL,
        `name` varchar(20) DEFAULT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8
      1 row in set (0.000 sec)
       
      MariaDB [zbdba]>
      MariaDB [zbdba]>
      MariaDB [zbdba]> insert into zbdba() values(1, 'aa');
      Query OK, 1 row affected (0.001 sec)
       
      MariaDB [zbdba]> insert into zbdba() values(2, 'bb');
      Query OK, 1 row affected (0.001 sec)
       
      MariaDB [zbdba]> insert into zbdba() values(3, 'cc');
      Query OK, 1 row affected (0.001 sec)
       
      MariaDB [zbdba]> select * from zbdba;
      +----+------+
      | id | name |
      +----+------+
      |  1 | aa   |
      |  2 | bb   |
      |  3 | cc   |
      +----+------+
      3 rows in set (0.001 sec)
       
      MariaDB [zbdba]>
      MariaDB [zbdba]>
      MariaDB [zbdba]> ALTER TABLE zbdba ENGINE = MRG_MYISAM;
      Query OK, 0 rows affected (0.005 sec)
      Records: 0  Duplicates: 0  Warnings: 0
       
      MariaDB [zbdba]> select * from zbdba;
      Empty set (0.000 sec)
       
      
      

        Attachments

          Activity

            People

            Assignee:
            danblack Daniel Black
            Reporter:
            zbdba jingbo zhao
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration