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
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.38
• OS: Windows
• 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.