You wrote:
>Description: > Documentation section 6.5.7 regarding create index states: "For CHAR and >VARCHAR columns, indexes can be created that use only part of a column, using >col_name(length) syntax. (On BLOB and TEXT columns the length is required.)" > 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. > Same problem occurs with fulltext indexes -- indeed, I had an index created as >a concatenation of two text fields (Name,Description). On running check-table and >then show index, this fulltext index had a null cardinality; and, when dropped, it >dropped immediately (too quickly to have data in it). > > We're using mysql4 in production since we need the fast fulltext indexing. >http://ftp.avsim.com/library/ is the site running your backend. > >How-To-Repeat: > Create table with field-type of TEXT. > CREATE INDEX AnyName ON Table(TextField); > Issue an update to a pre-existing record for the incorrectly indexed TextField. 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. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- 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