Bug #84606 can not reverse engineering a table which has JSON data type fileds
Submitted: 23 Jan 2017 9:55 Modified: 23 Jan 2017 10:06
Reporter: SHUICHI ASAI Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:6.3.8 OS:Any
Assigned to: CPU Architecture:Any
Tags: json, reverse engineering

[23 Jan 2017 9:55] SHUICHI ASAI
Description:
MySQL workbench 6.3.8 on Windows can't reverse engineering a table which has JSON data type fields from a create script.

How to repeat:
1. make a create script file which include below.

CREATE TABLE `dummy_table` (
  `id` int(11) NOT NULL,
  `json_data` json DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

2. choose [File]-[Import]-[Reverse Engineer Mysql Create Script...]

3. Select a file you make on #1. and execute.

4. You will success but it import nothing.
[23 Jan 2017 10:06] Umesh Shastry
Hello SHUICHI ASAI,

Thank you for the report and test case.
Verified as described.

Thanks,
Umesh