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

[5 May 2010 21:11] Craig Sylvester
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).
[6 May 2010 3:43] Valeriy Kravchuk
Thank you for the bug report.
[16 May 2010 9:55] Maksym Yehorov
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
[10 Jun 2010 18:44] Maksym Yehorov
Fixed.
[22 Jun 2010 13:19] Mike Lischke
Fix confirmed in repository.
[29 Jun 2010 10:11] Tony Bedford
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.090 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.