Description:
Intro:
-------
From inside plugins, the schema's character set and collation settings can be read from the schema properties
schema.defaultCollationName
schema.defaultCharacterSetName .
These settings are linked to each other under "Edit Table..." in the table's dropdown box named "Collation", value "Schema Default".
Description:
-------------
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
schema.defaultStorageEngineName
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
schema.defaultStorageEngineName
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.
Description: Intro: ------- From inside plugins, the schema's character set and collation settings can be read from the schema properties schema.defaultCollationName schema.defaultCharacterSetName . These settings are linked to each other under "Edit Table..." in the table's dropdown box named "Collation", value "Schema Default". Description: ------------- 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 schema.defaultStorageEngineName 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 schema.defaultStorageEngineName 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.