Bug #85648 Table does not exists when synchronizing a data model with JSON data types

• Submitted: 27 Mar 2017 12:38
• Modified: 6 Feb 2020 15:56
• Reporter: Schalk van der Sandt
• Status: Closed
• Category: MySQL Workbench: Modeling
• Severity: S2 (Serious)
• Version: 6.3.9, 6.3.10
• OS: Windows (Windows 7 x64)
• CPU Architecture: Any
• Tags: 6.3.9, json, workbench

[27 Mar 2017 12:38] Schalk van der Sandt

Description:
When attempting to synchronize the data model with the database with an existing table that contains a JSON field the data model tries to create the table instead of altering the table.

If you remove the JSON fields from the data modeler and the database the model syncs as expected.

How to repeat:
1. Create table with JSON data type in data modeler and database.
2. Synchronize model under database >> synchronize model
3. Pick schema
4. Observe the modeler does not see that the table exists which already exists on the database

Suggested fix:
N/A

[27 Mar 2017 13:27] MySQL Verification Team

Hello Schalk van der Sandt!

Thank you for the report.

Thanks,
Umesh

[4 Apr 2017 6:08] Schalk van der Sandt

Upped the severity as it is slowing down development.

[6 May 2017 10:58] Alberto Ureña

Same here,
- add a field into a table as JSON type
- Synchronize model 

When i try again to Synchronize the schema, MySQL Workbench try to create the tables with JSON fields but these tables exists so doesn't allow update the table

Any news about this bug??

[13 Dec 2017 11:41] Chiranjeevi Battula

http://bugs.mysql.com/bug.php?id=88880 marked as duplicate of this one.

[18 Dec 2017 12:47] Davis Jaunzems

Any updates/status of this bug? Makes working with JSON columns and workbench impossible.

[7 Aug 2018 13:40] MySQL Verification Team

https://bugs.mysql.com/bug.php?id=91921 marked as duplicate of this one.

[17 Apr 2019 17:29] Christian Walch

problem still exists: version 8.0.15

[13 Jul 2019 11:41] David Valverde

problem still exists: version 8.0.16

[15 Jul 2019 8:38] David Valverde

This problem is easy to resolve:

The default version set for Modeling MySQL was set as 5.6.30. Changed it to 5.7.x and works the table schema modification.

Go to Edit -> Preferences > Modeling > MySQL ... in MySQL Workbench and change Default Target MySQL Version.

https://stackoverflow.com/questions/52480055/type-not-supported-the-json-data-is-not-avail...

[6 Feb 2020 15:56] Christine Cole

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.21 release, and here's the proposed changelog entry from the documentation team:

The synchronization operation between a database that included a table
with JSON fields and a data model produced new, separate tables for the
JSON data, instead of updating the original table. In this instance, the
target MySQL version set in the modeling preference, 5.6.30 by default,
does not support the operation. This fix sets the default version to MySQL
8.0, but the value can be adjusted by selecting Preferences, Modeling, and
then MySQL from the Edit menu.

Thank you for the bug report.