Hi Sergei! Thanks for the reply! That was fast :) > -----Original Message----- > From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 10, 2001 10:48 PM > To: Al Caponi > Cc: MySQL Mailing List > Subject: Re: Limitation of Full-Text indexing in MyISAM table? > > > Hi! > > On Dec 10, Al Caponi wrote: > > Hi all, > > Is there any limitation in creating full-text indexes on MyISAM tables? > > Currently, I have a table like this: > > CREATE TABLE IF NOT EXISTS mytable ( > > UId BIGINT(20) NOT NULL AUTO_INCREMENT, > > Title VARCHAR(255) NOT NULL, > > Field1 TEXT, > > Field2 TEXT, > > Field3 VARCHAR(255), > > Field4 TEXT, > > Field5 TEXT, > > Field6 VARCHAR(50), > > Field7 VARCHAR(50), > > Field8 VARCHAR(50), > > Field9 TIMESTAMP NOT NULL, > > Field10 TIMESTAMP NOT NULL, > > PRIMARY KEY(UId), > > INDEX article_idx1(Field6), > > INDEX article_idx2(Field7), > > INDEX article_idx3(Field8), > > FULLTEXT article_idx4(Field1, Field2, Field3, Field4, > Field5, Field6, > > Field7, Field8) > > ) TYPE=MyISAM; > > > > But I keep getting the following error when I try to delete some row: > > > > java.sql.SQLException: General error: Incorrect key file for table: > > 'mytable'. Try to repair it > > > > So far, I've figured out that the error is due to mixing > VARCHAR and TEXT > > type in the FULLTEXT index but I dunno why is there a problem. > Haven't found > > much in MySQL doc about that yet. > > No, mixing VARCHAR and TEXT is perfectly legal > (even fulltext search example in the manual does it).
Yup, seen that... which makes me even more frustrated :( > > What version of MySQL are you using ? I'm using MySQL 3.23.39 on Win98SE with JSDK 1.3 > Can you create a testcase for that ? I'm not too sure of how to go about creating that... Do you mean the test code or just a rough idea of the testing? Roughly, I'm just inserting a record and deleting it based on the UId field. Regards, Al _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
