Bug #69520 MySQL Workbench error - unsupported format character ';'

• Submitted: 20 Jun 2013 7:37
• Modified: 9 Jul 2013 0:33
• Reporter: Jan Veres
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 5.2.47 CE
• OS: Windows (7 Professional)
• CPU Architecture: Any
• Tags: replicate-wild-ignore-table, replication, unsupported format character

[20 Jun 2013 7:37] Jan Veres

Description:
In the previous version Workbench i had set in replicate-wild-ignore-table (in Replication card) several tables separated ';'. The tooltip this item says: To convert option to a multi-line one, use ; to separate values. The symbol ; should not be the first char.
In actual version Workbench (5.2.47) i get the error on Replication card: Unhandled exception: unsupported format character ';' (0x3b) at index 15.

How to repeat:
Downgrade to a previous version.

[20 Jun 2013 7:44] Jan Veres

PrtScn

Attachment: ErrorPicture.jpg (image/pjpeg, text), 254.83 KiB.

[20 Jun 2013 14:52] Alfredo Kojima

Can you provide the string you're entering?

[21 Jun 2013 5:02] Jan Veres

OK, this is sring for replicate-wild-ignore-table item: dpcdata.__temp%;dpcdata.filter%;dpcdata.businessyear;dpcdata.%log

In my.ini:

replicate-wild-ignore-table = dpcdata.__temp%

replicate-wild-ignore-table = dpcdata.filter%

replicate-wild-ignore-table = dpcdata.businessyear

replicate-wild-ignore-table = dpcdata.%log

The last stable version without error is 5.2.44.

[21 Jun 2013 13:03] Alfredo Kojima

Thanks, I can repeat with the values you provided.

[9 Jul 2013 0:33] Philip Olson

Fixed as of MySQL Workbench 6.0.3 (BETA 2), and here's the changelog entry:

The ";" separator for passing in multiple values to the
"replicate-wild-ignore-table" option was not parsed correctly, and
MySQL Workbench would throw an unhandled exception.

Thank you for the bug report.