MyIsam table won't allow full text indexes
I have a MyIsam table to which I'm trying to add a full text index. I'm getting an error back "The used table type doesn't support FULLTEXT indexes" even though I'm using a MyIsam table.
Here's the short create table script:
use demo_MyIsam;
DROP TABLE IF EXISTS yellow;
CREATE TABLE yellow (
BusinessName varchar(64),
TileX int(11),
TileY int(11),
TileYHashKey int(11),
INDEX TileXIndex (TileX),
INDEX TileYIndex (TileY),
FULLTEXT INDEX BusinessNameIndex (BusinessName)
)
engine = MYISAM
partition by range (TileX)
subpartition by hash (TileYHashKey) subpartitions 25
(
partition p1 values less than (400),
partition p2 values less than (450),
partition p3 values less than (500),
partition p4 values less than (550),
partition p5 values less than (600),
partition p27 values less than maxvalue
);
If I take out the fulltext index line it works correctly, and I can see that it really does create a MyIsam table. Show table status gives
'yellow', 'MyISAM', 10, 'Dynamic', 0, 1, 0, 0, 153600, 0, , '2009-02-06 18:57:05', '2009-02-06 18:57:05', '', 'latin1_swedish_ci', , 'partitioned', ''
I tried several things, none of which worked
1) Setting default engine in my.ini to MYISAM
2) Creating the index after the table with create fulltext index BusinessNameIndex on Yellow (BusinessName);
3) Using ALTER TABLE Yellow ENGINE = MyISAM; then trying to create the table
I'm using the latest version, 5.1.30-community
So how do I fix this? Thanks in advance for your help.