Bug #67111 | Synchronize with any datasource | ||
---|---|---|---|
Submitted: | 6 Oct 2012 13:22 | Modified: | 27 Sep 2013 5:10 |
Reporter: | Christian Jacobs | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: Modeling | Severity: | S3 (Non-critical) |
Version: | 5.2.44 | OS: | Windows (Microsoft Windows XP Professional Service Pack 3 (build 2600)) |
Assigned to: | CPU Architecture: | Any | |
Tags: | WBBugReporter |
[6 Oct 2012 13:22]
Christian Jacobs
[8 Oct 2012 1:20]
MySQL Verification Team
http://bugs.mysql.com/bug.php?id=67113 marked as duplicate of this one.
[8 Oct 2012 11:47]
Christian Jacobs
Hi Miguel, I appreciate your quick response but ticket #67111 and #67113 are not the same. Regarding #67111: I attached some screenshots to visualize it. Eample: First run: I use the pre-selected suggested connection for source (db01). I change the connection for destination (db02). Second run: The pre-selected suggested connection has changed to db02 but I haven't changed it. => It saves the last change but source and destination not independent. Regarding #67113: Synchronize with any source doesn't execute the synchronization. When I select one table pair to synchronize, it shows me the sql statement below. When I'm going to the next screen it shows me just the following standard lines but not the sql statements. 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'; <<MISSING SQL STATEMENTS>>> SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; When I click on execute, it doesn't execute the synchronization. You can proof it when you run the process again and the tables are not synchronized.
[25 Oct 2012 15:20]
Armando Lopez Valencia
Thanks for your report. Verified in: Windows 7x64 WB 5.2.44 rev 9933 What the reporter suggest is that the source connection should be pre-populated with the latest SOURCE connection used, instead of the last connection used (DESTINATION connection).
[27 Sep 2013 5:10]
Philip Olson
Fixed as of MySQL Workbench 6.0.4, and here's the changelog entry: After synchronizing with a data source by defining the source and destination databases, the previously selected stored connections would sometimes be incorrect. Thank you for the bug report.