Bug #97602 Reverse engineer does not work for json columns
Submitted: 12 Nov 2019 21:40 Modified: 13 Nov 2019 23:29
Reporter: Chris Wegener Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:8.0.18 OS:MacOS (macOS 10.15.x Catalina x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[12 Nov 2019 21:40] Chris Wegener 
Description:
When using the MySQLWorkbench -> Database -> Reverse engineer option the error log message:
ERROR: (13, 9) "json" is not valid at this position, expecting: BIT, BOOL, BOOLEAN, DATETIME, DATE, ENUM, ..

is received for every table that contains a JSON datatype column

How to repeat:
Test option with a table that contains a JSON column

Suggested fix:
Pretty obvious I think ;) 

Thank you
[13 Nov 2019 0:51] Chris Wegener 
Subsequent investigation has shown that this is controlled by the 'Default Target MySQL Version' preference setting. Changing to 8.0 resolves this. 
Having the error message reference this would be of benefit.
Bug can be closed.
Thanks.
[13 Nov 2019 23:29] MySQL Verification Team 
Thank you for the feedback.