Bug #83791 Workbench fail to open table's structure when 'WITH PARSER ngram' is executed
Submitted: 11 Nov 2016 18:29 Modified: 15 Jan 2018 1:45
Reporter: jing da Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.7 build 1199 CE (32bits) OS:Windows (7 Ultimate)
Assigned to: CPU Architecture:Any
Tags: fail to open table, WITH PARSER ngram, workbench

[11 Nov 2016 18:29] jing da 
Description:
When a FullText Index with 'WITH PARSER ngram' is executed, MySQL Workbench will can not open the table's structure.

How to repeat:
mysql> USE test;

mysql> CREATE TABLE articles (
      id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
      title VARCHAR(200),
      body TEXT 
    ) ENGINE=InnoDB CHARACTER SET utf8;

INSERT INTO articles (title,body) VALUES
    ('数据库管理','在本教程中我将向你展示如何管理数据库'),
    ('数据库应用开发','学习开发数据库应用程序');

ALTER TABLE articles ADD FULLTEXT INDEX ft_index (title,body) WITH PARSER ngram;

Launch MySQL Workbanch, click Schemas in Navigator panel, click articles table's wrench icon,(or right-click articles table,then click Alter Table), you will see:

Error Paring DDL for 'test'.'articles'
There was an error while parsing the DDL retrieved from the server.
Do you want to view the DDL or cancel processing it?

Suggested fix:
Please fix the bug. Thank you.
[11 Nov 2016 19:40] MySQL Verification Team 
Error Dialog

Attachment: 83791.png (image/png, text), 149.46 KiB.
[11 Nov 2016 19:41] MySQL Verification Team 
Thank you for the bug report.
[24 Feb 2017 16:14] jing da 
Hi. I just download and install MySQL 5.7.17.0, but I find this bug still here. When you can fix this bug? Thank you.

neo
[28 Feb 2017 9:23] Mike Lischke 
Duplicate of Bug #80760
[15 Jan 2018 1:45] jing da 
Hi, may I ask whether this bug has been solved?