Hi everybody!

Some weeks ago I posted a problem with corrupted tables, but unfortunatly nobody answerd. Well, I'll try my luck again :) Here is the problem:

CREATE TABLE test ( gnr INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, url VARCHAR(80) DEFAULT '' NOT NULL, shortdesc VARCHAR(200) DEFAULT '' NOT NULL, longdesc text DEFAULT '' NOT NULL, description VARCHAR(80) DEFAULT '' NOT NULL, name VARCHAR(80) DEFAULT '' NOT NULL, FULLTEXT(url,description,shortdesc,longdesc), PRIMARY KEY(gnr) );

insert into test (url,shortdesc,longdesc,description,name) VALUES ("http:/test.at", "kurz", "lang","desc", "name"); insert into test (url,shortdesc,longdesc,description,name) VALUES ("http:/test.at", "kurz", "","desc", "name"); update test set url='test', description='ddd', name='nam' where gnr=2; update test set url='test', shortdesc='ggg', longdesc='mmm', description='ddd', name='nam' where gnr=2;

results in a corrupted table. (Incorrect key file for table: 'test'. Try to repair it)

I tested this at the linux (3.23.27-beta) and solaris (3.23.33) version of mysql.

Is there any patch or workaround to avoid this?

cheers Georg