0

I have synchronized a table between a model and a live server database in Workbench, but every time I rerun the "Synchronize With Any Source..." wizard, Workbench detects (falsely) that there is a difference between the model and the server for that table and wants to execute the exact same SQL query.

The SQL in this case is the following:

ALTER TABLE `mydb`.`user_info`
CHANGE COLUMN `last_update` `last_update` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

This statement has already been executed in my first run of the Wizard, and I can see that the table user_info is up to date on the live server. Why does it keep detecting it as a difference? Is it a known bug with MySQL Workbench or something...?

  • have you re-launched the wizard as it might be reading from some cached file which may have generated at first run. – Nawaz Sohail Jul 11 '16 at 13:35
  • Yes, a couple of times.. the weird thing is everytime I run the wizard it says that all the SQL was executed successfully – Neo_999 Jul 11 '16 at 13:37
  • make sure collations are same as well – Nawaz Sohail Jul 11 '16 at 13:44
  • I checked the collations. They are the same. – Neo_999 Aug 5 '16 at 16:52
0

Probably a bug. Some of the change detection is not catching this specific case (or interpreting it wrongly). Best is to file a bug report (http://bugs.mysql.com).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.