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:
None 
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
Description:
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
Sorry.

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
"Apply".

Thank you for the bug report.