In article <[EMAIL PROTECTED]>, Sinisa Milivojevic <[EMAIL PROTECTED]> writes >MattJ wrote: >> It's still possible in the mysql client to request the creation >>of an index with indexlength NULL on TEXT fields. This apparently >>works okay on creation of the index, insert and select operations, but >>breaks horribly (marks table as crashed with corrupted indexes) on >>update or delete operations. >Hi! > >I have tested your case. > >The above bug was already fixed in our BK repository. > >Fix will come up in 4.0.1, that is scheduled to come out soon.
Just as a followup to this, this past weekend I installed the BK head version of mysql-4.0.1-alpha (last changeset 1.980) on the server with the table-marked-as-crashed problems, and since then, having performed operations which would have caused a crashed table on the previous server, the tables have remained clean and functioning -- looks like the bug is fixed. :-) It's now been up for just over 75 hours, and it's a fairly busy server: Uptime: 272983 Threads: 6 Questions: 53688790 Slow queries: 505 Opens: 180 Flush tables: 1 Open tables: 174 Queries per second avg: 196.674 ...so the 4.0.1 in BK is looking good! Thanks for your help! :-) Regards, -- Matt Johnson <[EMAIL PROTECTED]> AVSIM Online! --------------------------------------------------------------------- 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