Bug #46468 "Server Default" storage engine not selectable as default
Submitted: 30 Jul 2009 8:08 Modified: 29 Oct 2009 14:37
Reporter: Karsten Wutzke Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2 OS:Any
Assigned to: CPU Architecture:Any
Tags: preferences, server default, storage engine, tools

[30 Jul 2009 8:08] Karsten Wutzke
Description:
This one is item #3 in bug

http://bugs.mysql.com/bug.php?id=44550

There's no entry in the dropdown box in Tools -> Preferences -> MySQL to set "Server Default".

Currently all table's are set to "Server Default", any new table becomes InnoDB or whatever is selected globally. "Server Default" is missing.

How to repeat:
Set some tables' storage engines to "Server Default". Then set the default in Tools -> Preferences ... you'll never get the same as with your other tables. You'll have to set each table's storage engine "Server Default" manually (completely missing the point of such an preferences option).

Suggested fix:
Add "Server Default" in Tools -> Prefs etc. as in "Edit Table..."
[30 Jul 2009 8:43] Susanne Ebrecht
Many thanks for writing a feature request.

We will discuss it.
[29 Oct 2009 14:37] Alfredo Kojima
This feature will not be added because it leads to several problems during synchronization. It can also
produce unexpected behavior in case the same model is forward engineered into servers with different defaults. 

As a workaround for possible use cases of such feature, we will add a command to change the storage engine of all tables in the model at once.