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

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;


4.1.0-alpha-nt works correctly BTW.


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