Re: [4.0.14] Small bug with OPTIMIZE/ANALYZE and FULLTEXT index

Hi!

On Aug 23, Matt W wrote:
> Hi all,
> 
> I am running 4.0.14-nt on Win2k and discovered that running OPTIMIZE or
> ANALYZE on a table that 1) has a FULLTEXT index and 2) hasn't been
> modified since the last OPTIMIZE/ANALYZE does not say "Table is already
> up to date" but instead "OK" after it runs, as if the table has changed.
> The exception, where the expected behavior occurs, is if there's a small
> amount of text/words in the column (table?).
> 
> Run these queries to see the problem:
> 
> CREATE TABLE test (text TEXT NOT NULL, FULLTEXT (text));
> INSERT INTO test VALUES ('Some words.');
> OPTIMIZE TABLE test;
> 
> -- Works as expected
> OPTIMIZE TABLE test;
> ANALYZE TABLE test;
> 
> -- ...But use more text/words
> UPDATE test SET text='Four words test text.';
> OPTIMIZE TABLE test;
> 
> -- Doesn't work as before
> -- Says "OK" instead of "Table is already up to date"
> OPTIMIZE TABLE test;
> ANALYZE TABLE test;

Thanks. Fixed in 4.0.15
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]