Bug #87561 Failed to Syncronize Model with database when table has JSON Type column
Submitted: 28 Aug 2017 10:33 Modified: 28 Aug 2017 10:40
Reporter: Gedean Dias Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S2 (Serious)
Version:6.3.9 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[28 Aug 2017 10:33] Gedean Dias 
Description:
When syncronize model with database, if a given table has a JSON type column the MySQL Workbench generated DML is to (re) create table, instead generate a DML just with the modifications (ALTER TABLE) of table (like ADD or RENAME others COLUMN).

The same occurs with when table has calculated column.

How to repeat:
Step 1: Create a table with JSON Type column OR a calculated column and sync it with database.

Step 2: Update table structure (add a new column or rename a existing column)

Step 3: Sync model with database (ctrl + shift + z) and check the generated DML is CREATE table INSTEAD of ALTER TABLE with table modifications
[28 Aug 2017 10:40] MySQL Verification Team 
Hello Gedean Dias,

Thank you for the report.
This is most likely duplicate of Bug #82081.

Thanks,
Umesh