Bug #64719 WB always update VIEW when synchronize model with database
Submitted: 21 Mar 2012 11:03 Modified: 6 Nov 2012 4:15
Reporter: Dragon Chuang Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.38 OS:Windows
Assigned to: CPU Architecture:Any

[21 Mar 2012 11:03] Dragon Chuang
Description:
WB always update VIEW when synchronize model with database, even if I did not modify anything.

I tried below environment:

MySQL Workbench 5.2.38 on Windows XP SP3 (traditional chinese) and Windows 7 (traditional chinese).
MySQL Server 5.1 and 5.5 on Windows XP SP3 (traditional chinese), Windows 7 (traditional chinese) , Windows Server 2003 (traditional chinese) and Ubuntu Server 11.10 .

All got same result.

I have 4 views in a model, WB always update VIEW when synchronize model with database and some views generated EMPTY command.

thank you.

How to repeat:
1. create schema:

CREATE TABLE IF NOT EXISTS `wb_sync_test`.`table1` (
  `table1_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
  PRIMARY KEY (`table1_id`) )
ENGINE = MyISAM

CREATE VIEW `wb_sync_test`.`view1` AS
SELECT * FROM `table1`

2. Synchronize Model with Database (it update server's view)
3. Synchronize Model with Database (it update server's view again)
4. ...
[21 Mar 2012 12:08] MySQL Verification Team
Thank you for the bug report.
[11 Aug 2012 0:20] Alfredo Kojima
Bug #63838 is a dup
[6 Nov 2012 4:15] Alfredo Kojima
Duplicate of bug #65108
[12 Dec 2013 17:03] Chris Thielen
This is marked as a dupe of bug #65108 which was fixed in 6.0.3.  

However, WB 6.0.8 still always updates your VIEWs when you synchronize from the model to a SQL file (Forward Engineered).

This should be reopened against 6.0.8, or I would be happy to create a new bug if that's more appropriate.