Bug #44550 "Server Default" storage engine attribute missing (plugins + no GUI control)
Submitted: 29 Apr 2009 17:57 Modified: 19 Sep 2014 19:50
Reporter: Karsten Wutzke Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1.10 OS:Any
Assigned to: CPU Architecture:Any
Tags: DEFAULT, default server, dropdown, list box, schema, storage engine

[29 Apr 2009 17:57] Karsten Wutzke

From inside plugins, the schema's character set and collation settings can be read from the schema properties

schema.defaultCharacterSetName .

These settings are linked to each other under "Edit Table..." in the table's dropdown box named "Collation", value "Schema Default".


1. Under the "Collation" dropdown box ("Edit Table..." -> "Table" tab) there's another dropdown box named "Storage Engine". This schema-wise setting in the schema object like


or similar is non-existent (I couldn't find one).

2. There's no GUI control available that represents this setting (as opposed to character set and collation). The dropdown box under "Tools" -> "Options" -> "MySQL" is an option that does *not* represent each table's "Server Default" value ("Edit Table..." -> "Table" tab -> "Engine" dropdown) but only the *default* each *new* table is set to.

3. The "Tools" -> "Options..." -> "MySQL" dropdown should also include "Server Default" as in the "Edit Table..." GUI.

How to repeat:
There's no schema.defaultStorageEngineName setting accessible from within plugin code (only per table).

There is no GUI dropdown box for "Server Default" (only new table preset).

Suggested fix:
1. Extend the schema object by adding an attribute called


2. Offer a schema-wise "Server Default" dropdown box for that setting which includes all storage engines.

3. Add "Server Default" to the "Tools" -> "Options..." -> "MySQL" dropdown box, so all new tables are handled via the schema storage engine setting.
[4 May 2009 21:55] MySQL Verification Team
Thank you for the bug report.
[4 May 2009 21:56] MySQL Verification Team
Thank you for the bug report.
[19 Sep 2014 19:50] Alfredo Kojima
Closing old FR, this can be accomplished with grt.root.wb.options.options.get("db.mysql.Table:tableEngine")