Bug #69115 Options File setting for replicate-wild-do-table= can give Unhandled exception
Submitted: 1 May 2013 17:58 Modified: 12 Jun 2013 4:38
Reporter: David Williams Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.47 CE OS:Windows
Assigned to: CPU Architecture:Any

[1 May 2013 17:58] David Williams 
Description:
In Server Administration (of a server) Options File, a setting shows differently than it is in the file itself, or cannot be viewed/modified.

If the desired setting in my.ini is 
  replicate-wild-do-table = dbname.%
this can be created using Workbench. But once that session is closed, none of the settings under the Replication tab show up in a new session. Instead there is a popup Error
  Unhandled exception: incomplete format

If the desired setting in my.ini is 
  replicate-wild-do-table = dbname%.%
then in a new session the setting shows as 
  dbname%
even as the my.ini file has dbname%.% (and no error popup).

If the desired setting in my.ini is 
  replicate-wild-do-table = dbname.%%
(this seems wrong to me) then in a new session the setting shows as 
  dbname.%
even as the my.ini file has dbname.%% (and no error popup).

If (by mistake) the option is repeated in my.ini then the error changes
  Unhandled exception: unsupported format character ';' (0x3b) at index 8

When the error pops up, the my.ini file has to be edited apart from Workbench before the options can be viewed/searched in Workbench.

How to repeat:
Add 
  replicate-wild-do-table = dbname.%
to the mysql server's configuration file.
Start Admining the server using Workbench.
Click on Options File.
Click on Replication tab or type repl into Locate option and click on Find.
[2 May 2013 11:42] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[12 Jun 2013 4:38] Philip Olson 
Fixed as of the upcoming MySQL Workbench 6.0.2 release, and here's the changelog entry:

The "Server Administration", "Configuration", "Options File" editor
would sometimes fail to display the options.

Thank you for the bug report.