Bug #49006 WB shows both default table type and default storage engine
Submitted: 23 Nov 2009 23:21 Modified: 15 Feb 2010 16:06
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2 r4753 OS:Microsoft Windows (XP)
Assigned to: Alfredo Kojima CPU Architecture:Any

[23 Nov 2009 23:21] Todd Farmer
In the General tab for Configuration, I see the following fields:

"Default table type"
"Default storage engine"

Both have identical descriptions, and the fact that the former is deprecated in version 5.0 (I am using 5.0.67 here) is not referenced at all.

Furthermore, setting this field does not appear to have the anticipated result.  When I preview the file, I see this at the end:

max_allowed_packet=64Mdefault-table-type = Heap

Not good, but then when I press "apply", nothing changes in the my.ini file.

When I close the tab for this server and reconnect, the changes made have been reverted (or never saved).

How to repeat:
View the general configuration tab.

Suggested fix:
At minimum:

1.  Note deprecation of default table type in description
2.  Make make application of changes work correctly.
[24 Nov 2009 15:03] Maksym Yehorov
Todd, could you tell more? In particular:
- connect from - OS and its version;
- connect to - OS and its version.

[24 Nov 2009 15:12] Todd Farmer
Windows XP, connecting on localhost to MySQL 5.0.67.
[8 Feb 2010 20:52] Alfredo Kojima
default-table-type option was removed from the options list
[12 Feb 2010 23:02] Johannes Taxacher
fixed in repository
[12 Feb 2010 23:02] Johannes Taxacher
fixed in repository
[15 Feb 2010 16:06] Tony Bedford
An entry has been added to the 5.2.16 changelog:

In the General tab of the configuration file editor, the option Default table type was present, even though it was deprecated in MySQL Server 5.0. Further, selecting this option and applying changes did not change the server configuration file.