Hi,
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.
Is it the 'UPDATE|DELETE) ...WHERE MATCH bugfix' in MySQL 3.23.45?
I'm not performing a delete using a WHERE MATCH but on a BIGINT column type.
Anyway, I'll upgrade my MySQL version and check it out.
Thanx
Al
7 messages in com.mysql.lists.mysqlRE: Limitation of Full-Text indexing ...