Bug #64615 Fulltext
Submitted: 12 Mar 2012 0:17 Modified: 12 Apr 2012 4:51
Reporter: stephen reave Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:Mysql 5.5.8 OS:Windows
Assigned to: CPU Architecture:Any
Tags: fulltext error in mysql 5.5.8

[12 Mar 2012 0:17] stephen reave 
Description:
maybe in previous version will work but:

just a sample code:

create table news(
  id int auto_increment not null primary key,
  title VARCHAR(255),
  body   TEXT,
  FULLTEXT (title,body)); //errors goes here when I execute it then  error 1214
                          //the used table type doesn't support FULLTEXT INDEXES

How to repeat:
Is there any way how can i declare fulltext or any syntax for it?

Suggested fix:
Can you give me any suggestions?
[12 Mar 2012 4:51] Valeriy Kravchuk 
Try this one:

create table news(
  id int auto_increment not null primary key,
  title VARCHAR(255),
  body   TEXT,
  FULLTEXT (title,body)) engine=MyISAM;

MySQL 5.5.x uses InnoDB storage engine by default and it does not support fulltext indexes (in 5.5.x).
[13 Apr 2012 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".