Thanks for the tip about the 14 columns, Sergei and Dan. I reduced the
number of columns by two and the index seemed to build just fine. I would
like to make a suggestion though. I originally tried to create the fulltext
index with more than 16 columns and received an error saying that I could
have at most 16 columns in a fulltext index. It would be great if the error
message could be changed to say 14 instead of 16. If that can't be done, a
note in the manual discussing the limitation would be helpful. Just my 2
cents!
Thanks,
Duncan
> From: Sergei Golubchik [mailto:serg@stripped]
>
> 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
> <___/
