We're updating the issue view to help you get more done. 

alter table engine error when set row_format

Description

In 5.7, we can't alter tokudb table engine to innodb if we have set row_format, it will give errors as:
```
mysql> alter table sbtest3 engine=tokudb row_format=tokudb_snappy;
Query OK, 36790 rows affected (0.53 sec)
Records: 36790 Duplicates: 0 Warnings: 0

mysql> show create table sbtest3\G

  •  

    •  

      •  

        •  

          •  

            •  

              •  

                •  

                  •  

                    •  

                      •  

                        •  

                          •  

                            •  

                              •  

                                •  

                                  •  

                                    •  

                                      •  

                                        •  

                                          •  

                                            •  

                                              •  

                                                •  

                                                  •  

                                                    •  

                                                      • 1. row ***************************
                                                        Table: sbtest3
                                                        Create Table: CREATE TABLE `sbtest3` (
                                                        `id` int(10) unsigned NOT NULL,
                                                        `k` int(10) unsigned NOT NULL DEFAULT '0',
                                                        `c` char(120) NOT NULL DEFAULT '',
                                                        `pad` char(60) NOT NULL DEFAULT '',
                                                        PRIMARY KEY (`id`),
                                                        KEY `k_3` (`k`)
                                                        ) ENGINE=TokuDB DEFAULT CHARSET=latin1 MAX_ROWS=1000000 ROW_FORMAT=TOKUDB_SNAPPY
                                                        1 row in set (0.01 sec)

mysql> alter table sbtest3 engine=innodb;
ERROR 1031 (HY000): Table storage engine for '#sql-b54_2b4' doesn't have this option
```

Environment

None

Status

Assignee

Unassigned

Reporter

Bohu TANG

Labels

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

External issue ID

None

Freshdesk Tickets

None

Affects versions

Percona-Server-5.7.14-7

Priority

Major