Hi,
I think this is a bug. The script to recreate the problem is included
below. This problem appears consistently as long as there's a fulltext
index and a regular index on the same field and you do an update to
change the case of a single char. It doesn't matter if the fulltext
index includes other fields. If the regular index is removed, then after
the insert (where the case of one char in a field is changed) the table
is briefly marked as crashed, and then seems to automagically fix itself
(which is worrying).
The bug also occurs when you change the case of a single char in a
varchar field and add a word to the sentence e.g.:
'experience with c required' changes to 'experience with C is required'
also causes the problem.
Thanks as always,
~mark
ps: If anyone knows of a workaround please let me know. thanks.
__BEGIN__
#This works fine on mysql 3 but crashes the table on 4 alpha
CREATE TABLE tester (
id int(11) auto_increment,
title varchar(100) default '',
PRIMARY KEY (id),
#If you comment out the following index, then the table is briefly
marked as crashed
# but appears to recover.
KEY ind5 (title),
#The fulltext index appears to be the root of this prob.
FULLTEXT KEY FT1 (title)
) TYPE=MyISAM;
insert into tester (title) values ('this is a test');
update tester set title='this is A test' where id=1;
check table tester;
__END__
Gives us:
Table Op Msg_type Msg_text
freeusall.tester check warning Table is marked as crashed
freeusall.tester check error Checksum for key: 2 doesn't
match checksum for records
freeusall.tester check error Corrupt
We're running MySQL 4.0 alpha on Linux kernel 2.4.2 intel. Using MyISAM
tables.
---------------------------------------------------------------------
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
