Bug #80177 Cannot create fulltext indexes for InnoDB tables

• Submitted: 27 Jan 2016 17:06
• Modified: 29 Jan 2016 16:03
• Reporter: Michael Maynard
• Status: Not a Bug
• Category: MySQL Workbench: Modeling
• Severity: S5 (Performance)
• Version: 6.3.3
• OS: Windows (Microsoft Windows 10 Pro)
• CPU Architecture: Any
• Tags: WBBugReporter

[27 Jan 2016 17:06] Michael Maynard

Description:
Workbench Modeling does not give you the option to create a FULLTEXT index on InnoDB table.  I have MySQL compatibility set to 5.6. FULLTEXT only appears as an option under MyISAM tables.

How to repeat:
Create Innodb table with at least one field, go to Indexes, only options are Index, Unique and Primary.  Change table to MyISAM, go to Indexes, options are Index, Unique, FULLTEXT, Spatial and Primary.

Suggested fix:
Allow for FULLTEXT Indexes if MySQL Compatibility level is set to a version which supports FULLTEXT InnoDB tables.

[27 Jan 2016 19:07] MySQL Verification Team

fulltext

Attachment: FT.png (image/png, text), 245.94 KiB.

[27 Jan 2016 19:08] MySQL Verification Team

FT

Attachment: FT_Created.png (image/png, text), 87.38 KiB.

[27 Jan 2016 19:09] MySQL Verification Team

Thank you for the bug report. I couldn't repeat with 6.3.6.

[29 Jan 2016 16:03] Michael Maynard

I upgraded to 6.3.6 and had the same issue.  I created a new model, imported the old model and I can now create the fulltext indexes on InnoDB tables.

Thank you!