Hi!
> > > I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on
> > > i686. I'm
> > > trying to create a fulltext index on an existing myisam table
> > > and running up
> > > against an error. From what I can tell, I'm using the alter
> > > table command
> > > correctly, but I keep getting errno 140. Can anyone point
> > > out my error?
> > >
> > > mysql> alter table materials add fulltext title
> > > (title,variant_title,ss_title,term_1,term_2,term_3,term_4,
> > > term_5,abstract,notes,personal_name_1,personal_name_2,
> > > personal_name_3,personal_name_4,
> > > personal_name_5,personal_name_6);
> > >
> > > ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140)
Too many columns.
No more than 14 is allowed in FULLTEXT index in MySQL before 4.1,
because MySQL adds two columns internally to each FULLTEXT index.
In 4.1 it was fixed, but the way it was fixed cannot be backported to
4.0 :(
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
