> According to the documentation I should be able to index a column
> of type text if tye table type is myisam. This does not work.
> create table test (
> sometext text not null,
> index (sometext(10))
> ) type = myisam;
> I don't know.
> >Submitter-Id: Joseph Shraibman <jks@stripped>
> >Organization: Xtenit, Inc.
> >MySQL support: none
> >Synopsis: cannot create index on TEXT column
> >Severity: serious
> >Priority: high
> >Category: mysql
> >Class: doc-bug
> >Release: mysql-3.22.30 (Official MySQL RPM)
MyISAM was introduced in the 3.23.x versions. You're runnning 3.22.x.