List:General Discussion« Previous MessageNext Message »
From:Sergei Golubchik Date:January 29 2003 10:06pm
Subject:Re: problems creating fulltext index
View as plain text  
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
       <___/
Thread
problems creating fulltext indexDuncan Salada28 Jan
  • Re: problems creating fulltext indexDan Nelson29 Jan
RE: problems creating fulltext indexErlend Hopsø Strømsvik29 Jan
RE: problems creating fulltext indexDuncan Salada29 Jan
  • Re: problems creating fulltext indexSergei Golubchik29 Jan
RE: problems creating fulltext indexDuncan Salada31 Jan