Mark Maunder wrote: > 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
Just an update to the original post: The table doesn't crash, but the update does not succeed if the regular index is removed - so this isn't a workaround. --------------------------------------------------------------------- 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
