Bug #13979 InnoDB engine doesn't support FULLTEXT

• Submitted: 12 Oct 2005 22:24
• Reporter: Ian Gulliver
• Status: Open
• Category: Server: InnoDB
• Severity: S4 (Feature request)
• Version: 5.0.13
• OS: Linux (Debian Sarge)
• Assigned to: Sunny Bains
• Triage: D5 (Feature request)

[12 Oct 2005 22:24] Ian Gulliver

Description:
InnoDB doesn't support FULLTEXT indexes.  This is one of the few remaining features
present in MyISAM and not in InnoDB, preventing migration.

How to repeat:
CREATE TABLE a (id TEXT, FULLTEXT (id));

CREATE TABLE b (id TEXT, FULLTEXT (id)) ENGINE=InnoDB;

/* ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes */

Suggested fix:
Add FULLTEXT support to the InnoDB engine.