Bug #82393 Synchronize Model from database to model not working
Submitted: 1 Aug 2016 5:25 Modified: 1 Aug 2016 19:57
Reporter: John Doe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:6.3.6 Build 511 CE (64-bit) Community OS:Windows (Windows 7 Professional 64-bit)
Assigned to: CPU Architecture:Any
Tags: synchronization

[1 Aug 2016 5:25] John Doe 
Description:
Synchronization from database to model no longer seem to work. Model to database works though.

How to repeat:
1. Open the attched test.mwb in Workbench and use Databases > Synchronize Model to synchronize the model to a database. 
2. Edit the database (say, add a new column). 
3. Use Databases > Synchronize Model to synchronize from database to model
4. Observe that Workbench does not detect the new column in the direction of database to model per attached screenshot (it detects it in the direction of model to database though).
[1 Aug 2016 5:26] John Doe 
test workbench file

Attachment: test.mwb (application/octet-stream, text), 6.67 KiB.
[1 Aug 2016 5:29] John Doe 
Observe the absence of DDL statements for database to model synchornization

Attachment: database_to_model_synchronization.png (image/png, text), 75.46 KiB.
[1 Aug 2016 12:07] MySQL Verification Team 
adding a column

Attachment: add_column.png (image/png, text), 74.44 KiB.
[1 Aug 2016 12:08] MySQL Verification Team 
Thank you for the bug report. I couldn't epeat with 6.3.7 (use Update Model button).
[1 Aug 2016 19:55] John Doe 
1. Where is "Update Model" button?
2. I see you have added a column to MySQL 5.6. I assumed from Workbench file I attached that you could see (from Default Target MySQL Version setting) I was working with MySQL 5.7.
3. How does adding a column prove that problem is not reproducible? The problem was that Workbench 6.3.6 (again you have used a more recent version which Workbench 6.3.6 Help > Check for Updates does not report as available as an update) could not synchronize a change to database in model. See the screenshot I attached the original report, doesn't it look odd to you? It indicates there is a change in database (source) but does not display the details of the change as DDL statement (instead says Update Source)!
[1 Aug 2016 19:57] John Doe 
Also, please attached your test Workbench file so I can see if it works for me.