Bug #83616 MySQL Workbench Schema Transfer Wizard can't handle apostrophe

• Submitted: 31 Oct 2016 7:21
• Modified: 24 Jan 2017 23:55
• Reporter: David Webb
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S2 (Serious)
• Version: 6.3.8
• OS: Any
• CPU Architecture: Any

[31 Oct 2016 7:21] David Webb

Description:
When using the Schema Transfer Wizard, if a table contains a text (Char or VarChar) column with an apostrophe in the data (also known as a single-quote), then the routine fails, because it treats this symbol as the start of a name. This makes the wizard unusable for any schema which includes English text.

How to repeat:
Create a table with a VarChar column and enter the text "Something's broken" (without the double-quotes) as data. Then try using the wizard to transfer the schema to another machine.

Suggested fix:
Fix the code (I believe this is running Python?). Obviously the code needs to replace "'" with "''" (i.e. escape the ') in all text fields before using them in an INSERT instruction.

[31 Oct 2016 15:15] MySQL Verification Team

Thank you for the bug report.

[10 Nov 2016 9:40] MySQL Verification Team

http://bugs.mysql.com/bug.php?id=83762 marked as duplicate of this one.

[10 Nov 2016 9:54] David Webb

The link takes me to a page which says:
"You do not have access to bug #83762."

[10 Nov 2016 10:02] MySQL Verification Team

Yes for option of the reporter that bug was flagged as private.

[23 Nov 2016 19:29] MySQL Verification Team

http://bugs.mysql.com/bug.php?id=83936 marked as duplicate of this one.

[16 Dec 2016 12:18] Dario Rigolin

I confirm this bug on Windows migrating from SQLServer via standard ODBC Driver from a MSSQLServer 2008 to a MySQL 5.7 on Windows 7 x64

[23 Dec 2016 22:56] MySQL Verification Team

http://bugs.mysql.com/bug.php?id=84328 marked as duplicate of this one.

[26 Dec 2016 9:12] MySQL Verification Team

http://bugs.mysql.com/bug.php?id=84336 marked as duplicate of this one.

[23 Jan 2017 20:08] John Coggeshall

Is there any update on this particular bug? It basically makes the entire migration tool non-functional (unless you just want it to create a schema).

[23 Jan 2017 20:19] John Coggeshall

For those of you struggling with this bug and find yourself here it's worth noting that the previous version (Workbench 6.2) seems to work.

[24 Jan 2017 23:55] Christine Cole

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.9 release, and here's the changelog entry:

Having a single quotation mark (') in the text field of a table caused the MySQL Schema Transfer wizard to fail.

Thank you for the bug report.