Bug #69433 Cannot change table engine from MyISAM to InnoDB
Submitted: 8 Jun 2013 19:44 Modified: 20 Jul 2013 2:54
Reporter: John David Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.47 CE OS:Microsoft Windows (XP SP3)
Assigned to: CPU Architecture:Any
Tags: engine
Triage: Needs Triage: D2 (Serious)

[8 Jun 2013 19:44] John David
I select "Alter Table" from the schema tables list.
I changed the Engine drop down from MyISAM to InnoDB and click Apply.

It says there are no changes to apply.

15:42:08	Apply changes to build	No changes detected	

I even wen so far as to change the column type of a column to force the change.
It then applys the column change but there is no reference to the engine change in the "ALTER TABLE..." command that comes up.

I can do this by hand but I figured I'd let you know.

How to repeat:
Select a MyISAM table, change the engine to InnoDB and hit apply.
[8 Jun 2013 19:47] John David

Forgot to give you the MySQL database version: 5.5.32
Running on Linux RedHat 5.9
[10 Jun 2013 11:57] Miguel Solorzano
Thank you for the bug report.
[20 Jul 2013 2:54] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.4 release, and here's the changelog entry:

Clicking "Alter Table" from the schema tables list and changing the engine
from the engine drop down would not alter the database after pressing

Thank you for the bug report.