Bug #71307 Variable names become character strings, parsing mode not checked
Submitted: 6 Jan 2014 15:10 Modified: 12 Mar 2016 8:59
Reporter: Programmer Old Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.0.7.11215 OS:Windows (Vista)
Assigned to: CPU Architecture:Any

[6 Jan 2014 15:10] Programmer Old 
Description:
As for quote-marks and vertical bars, I use only ANSI mode. I tryed Workbench for copying all my stuff from the 5.5.8 database to the new 5.6.14, but for every table s first variable there was in the log a complaint that a character string was out of place. Nothing was copied but the database-names.

It looked as if Workbench was not taking "sql_mode" s parsing modes into account.

How to repeat:
Set up an old database and a new one, with "ANSI" in both s "sql_mode". Create a table in the old database, and use Workbench to copy the old to the new.

Suggested fix:
That Workbench find the parsing modes for carrying out its migration.
[12 Feb 2016 8:59] Mike Lischke 
Has this issue been resolved in the latest WB version (6.3.6)?
[13 Mar 2016 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".