Bug #38211 Database Synchronization Produces Incorrect Output Script
Submitted: 17 Jul 2008 19:38 Modified: 23 Aug 2008 14:34
Reporter: Moises M Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:5.0.23 SE OS:Windows (Vista Business SP1)
Assigned to: CPU Architecture:Any
Tags: Synch, synchronization

[17 Jul 2008 19:38] Moises M 
Description:
Synchronization Model with Live Server generates a valid SQL Synch Tree with found changes, but doesn't output the correct script. There were many differences that were found and it only outputed the following script:

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

How to repeat:
Synchronize Model with Live MySQL Database
[17 Jul 2008 19:44] Moises M 
The output script that I'm refering to is in the SQL Synch Script Window.
[23 Jul 2008 14:34] MySQL Verification Team 
Thank you for the bug report. Could you please provide the model project file and the database dump for the live server. Thanks in advance.
[23 Aug 2008 23: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".