MySQL Bugs: #53449: No way to turn innodb_support

Bug #53449	No way to turn innodb_support_xa parameter to FALSE/TRUE
Submitted:	5 May 2010 21:11	Modified:	29 Jun 2010 10:11
Reporter:	Craig Sylvester	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.20	OS:	MacOS (10.6.3)
Assigned to:	Maksym Yehorov	CPU Architecture:	Any
Tags:	innodb xa transactions

Description:
In the "Admin->Configuration->InnoDB Parameters" tab, there is simply a checkbox for "innodb_support_xa". Checking the innodb_support_xa box and then clicking Apply brings up the confirmation dialog window. The confirmation dialog indicated the following changes were made:
Added:  [mysqld] innodb_support_xa = True

However, what actually gets added in the my.cnf file is "innodb_support_xa".

But the real issue is that this parameter defaults to TRUE and there is no way to set it to FALSE through Workbench.

How to repeat:
Start Workbench
Open an Admin tab for a local server
Goto Configuration tab
Click InnoDB Parameters subtab
Click the innodb_support_xa checkbox
Click Apply
Click Apply in the "Apply Changes to MySQL Configuration File" dialog.

Suggested fix:
Make it so this can be set to FALSE (and maybe show what the current value is).

Thank you for the bug report.

This is a preview bug only. It does not affect option file saved.
When switch option, like innodb_support_xa is set it will appear in configuration file, if unset it will be erased from the file. That ' = True' text occasionally crept in the preview window from the internal representation.
This is fixed

Fixed.

Fix confirmed in repository.

An entry has been added to the 5.2.25 changelog:

In the Configuration tab of the Administrator, the parameter innodb_support_xa, on the InnoDB Parameters tab, has a corresponding checkbox. If this was selected and changes applied the confirmation dialog indicated the following changes were made:

Added:  [mysqld] innodb_support_xa = True

However, what was added to the my.cnf file was “innodb_support_xa”. This meant there was no way to set this parameter, which defaults to True, to False using MySQL Workbench.