Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-4351

CREATE TABLE ... LIKE ... does not use source row_format on target table

    Details

      Description

      mysql> create table a(i int) engine=tokudb, row_format=tokudb_snappy;
      Query OK, 0 rows affected (0.08 sec)
      
      mysql> create table b like a;
      Query OK, 0 rows affected (0.06 sec)
      
      mysql> show create table b;
      +-------+--------------------------------------------------------------------------------------+
      | Table | Create Table                                                                         |
      +-------+--------------------------------------------------------------------------------------+
      | b     | CREATE TABLE `b` (
        `i` int(11) DEFAULT NULL
      ) ENGINE=TokuDB DEFAULT CHARSET=latin1 |
      +-------+--------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
      

      Confirmed is a problem on both 5.6 and 5.7. Similar actions with InnoDB properly copies row_format from source to destination table.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                george.lorch George Lorch
                Reporter:
                pz Peter Zaitsev
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: