ALTER TABLE t1 ENGINE=InnoDB keeps bad options when t1 ENGINE is CONNECT

Description

Start with the following CONNECT table definition:

Now convert to InnoDB: ALTER TABLE test_alter ENGINE=InnoDB;

The resulting table definition looks like:

Basic tests show that the new 'test_alter' table is a fully functional InnoDB table. However, the CREATE TABLE statement from the SHOW CREATE TABLE output is unusable and will fail.

It should be possible to change the storage engine and the ALTER TABLE operation should 'clean up' the invalid options.

Environment

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 12.04.3 LTS
Release: 12.04
Codename: precise

Status

Assignee

Sergei Golubchik

Reporter

Gerardo Narvaja

Labels

None

External issue ID

None

External issue ID

None

Fix versions

Affects versions

Priority

Major
Configure