Hi! On Dec 10, Al Caponi wrote: > 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: > > > > > > 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
This one is old. (June 2001) The bug you've hit was fixed in Jule. 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