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). What version of MySQL are you using ? Can you create a testcase for that ? > Is the problem more on the Java side? I doubt it. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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
