Bug #91921 Reverse engineer cannot reverse tables with json
Submitted: 7 Aug 2018 13:34 Modified: 7 Aug 2018 13:39
Reporter: panda small Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.12 OS:Linux (Ubuntu 18.04 x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[7 Aug 2018 13:34] panda small
Description:
If there is a json column, reverse engineer cannot reverse this table into model.

How to repeat:
Create a table with json column, and then try to reverse it into model with reverse engineer. The log is: 
ERROR: (3, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...

Suggested fix:
add json type for reverse engineer
[7 Aug 2018 13:39] MySQL Verification Team
Thank you for the bug report. Duplicate/related with bug: https://bugs.mysql.com/bug.php?id=85648
[14 Nov 2018 16:46] Tomer Eshckoly
Hi,
The problem is still not resolved at Workbench v8.0.13
Reverse engineering process doesn't process tables with JSON fields..

ERROR: (245, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (262, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (275, 13) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (313, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (327, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (397, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (435, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (451, 12) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (451, 13) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (480, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (556, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (587, 13) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (587, 15) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (587, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (619, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (619, 15) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (633, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (633, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (662, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
ERROR: (818, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ...
[16 Jan 2019 15:01] Bhargav Reddy Kolla
Still facing the problem in v8.0.13
[3 Mar 2021 17:04] Petronel MALUTAN
It affects me too in 2021 :) I will see if there is any upgrade option on ubuntu 20
[3 Mar 2021 17:13] Petronel MALUTAN
8.0.23 is presenting same error in march 2021
[3 Mar 2021 17:13] Petronel MALUTAN
8.0.23 is presenting same error in march 2021