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

Matt W writes:
> 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;
> 
> 


HI!

First of all there is no need to run both OPTIMIZE / ANALYZE as first
will do the second.

Next, with dynamic records OPTIMIZE always has something to do.

-- 

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus


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