RE: Failure to enforce length of fields to index corrupts tables -- fully resolved in BK

2001-12-11 Thread Shen, Lei (CIT)
Dear Dose anyone know, if i install MySql in NFS, are there any problem? and is that a good idea? why? lei shen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Failure to enforce length of fields to index corrupts tables -- fully resolved in BK

2001-12-11 Thread Matt Johnson
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 opera

Re: Failure to enforce length of fields to index corrupts tables

2001-11-28 Thread Matt Johnson
In article <[EMAIL PROTECTED]>, Michael Widenius <[EMAIL PROTECTED]> writes >I just tested this with the upcoming MySQL 4.0.1: > >mysql> create table t1 (a text); >Query OK, 0 rows affected (0.01 sec) > >mysql> CREATE INDEX t1 ON t1(a); >ERROR 1170: BLOB column 'a' used in key specification witho

Re: Failure to enforce length of fields to index corrupts tables

2001-11-28 Thread Sinisa Milivojevic
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

Re: Failure to enforce length of fields to index corrupts tables

2001-11-26 Thread Sinisa Milivojevic
Thank you for your report. We shall check it out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysq