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

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

    XMLWordPrintable

    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: