MySQL Bugs: #49006: WB shows both default table type and default storage engine

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:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2 r4753	OS:	Windows (XP)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

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

Todd, could you tell more? In particular:
- connect from - OS and its version;
- connect to - OS and its version.

Thanks!

Windows XP, connecting on localhost to MySQL 5.0.67.

default-table-type option was removed from the options list

fixed in repository

fixed in repository

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.