Bug #62569 Synchronize model does not alter views
Submitted: 28 Sep 2011 23:00 Modified: 19 Apr 2012 22:42
Reporter: Jorge Mariani Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.2.35.7915 OS:MacOS (10.7.1)
Assigned to: CPU Architecture:Any
Tags: ALTER VIEW, synchronize model

[28 Sep 2011 23:00] Jorge Mariani
Description:
When synchronizing a model, existing views doesn't get altered when you add a field to them.

How to repeat:
Create a view in the model.
Synchronize model.
Add a new field to the view's field list.
Synchronize model again.
The view will stay the same.

The only way to update the view is to drop it first.
[30 Sep 2011 19:15] Armando Lopez Valencia
Thanks a lot for your report Jorge.
[30 Sep 2011 19:32] Jorge Mariani
Yr welcome.
[19 Apr 2012 22:42] Philip Olson
Fixed as of 5.2.40, and here's the changelog entry:

"Database", "Synchronize Model" would not update the view after a new
field was added.