I found out, that the fulltext engine is misbehaving with less than 5 entries. Seems to me, that this is exactly the same case...
Perhaps a flush inside the engine or so isn't made with such less entries? The bug is also in 3.23 gamma. Workaround: Enter more rows to fix it. :) I send this bug 1 month ago to the developer who has done the fulltext engine (I just forgot the name and the adresses are in the company - a russian name). Perhaps I should have sent it better to bugs... -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris ---------- Forwarded message ---------- Date: Sat, 2 Feb 2002 11:41:36 +0300 From: Alexander Belyaev <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Fulltext problems 4.0.1 part two Hello, I have found a bug( or bad feature? :) ) in 4.0.1 boolean fulltext search Please help... Test case with table can be found at http://logo.nino.ru/fulltextbug.tar.gz Alexander ( "sql database query table" for you, spam protector:) -------------- show variables like 'ft%' -------------- +--------------------------+----------------+ | Variable_name | Value | +--------------------------+----------------+ | ft_min_word_len | 2 | | ft_max_word_len | 254 | | ft_max_word_len_for_sort | 20 | | ft_boolean_syntax | + -><()~*:""&| | +--------------------------+----------------+ 4 rows in set (0.00 sec) -------------- show index from logo_text -------------- +-----------+------------+----------+--------------+-------------+---------- -+-------------+----------+--------+----------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-----------+------------+----------+--------------+-------------+---------- -+-------------+----------+--------+----------+ | logo_text | 0 | PRIMARY | 1 | id | A | 38347 | NULL | NULL | | | logo_text | 1 | ffff | 1 | txt | A | 38347 | 1 | NULL | FULLTEXT | +-----------+------------+----------+--------------+-------------+---------- -+-------------+----------+--------+----------+ 2 rows in set (0.00 sec) -------------- check table logo_text -------------- +----------------+-------+----------+--------------------------------------- --------------+ | Table | Op | Msg_type | Msg_text | +----------------+-------+----------+--------------------------------------- --------------+ | test.logo_text | check | warning | Found 38347 parts Should be: 0 parts | | test.logo_text | check | status | OK | +----------------+-------+----------+--------------------------------------- --------------+ 2 rows in set (0.40 sec) -------------- repair table logo_text -------------- +----------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +----------------+--------+----------+----------+ | test.logo_text | repair | status | OK | +----------------+--------+----------+----------+ 1 row in set (3.02 sec) -------------- check table logo_text -------------- +----------------+-------+----------+--------------------------------------- --------------+ | Table | Op | Msg_type | Msg_text | +----------------+-------+----------+--------------------------------------- --------------+ | test.logo_text | check | warning | Found 38347 parts Should be: 0 parts | | test.logo_text | check | status | OK | +----------------+-------+----------+--------------------------------------- --------------+ 2 rows in set (0.45 sec) -------------- select id,txt from test.logo_text where match(txt) against ('+desig* +service' in boolean mode) -------------- +-------+------------------------------------------------------------------- -------------+ | id | txt | +-------+------------------------------------------------------------------- -------------+ | 26570 | wave design a full service design agency seth brewer http://www.wavedesign.com | | 38847 | manucom hands on it service j.shannon design | +-------+------------------------------------------------------------------- -------------+ 2 rows in set (0.03 sec) -------------- select id,txt from test.logo_text where match(txt) against ('+design +service' in boolean mode) -------------- +-------+------------------------------------------------------------------- -------------+ | id | txt | +-------+------------------------------------------------------------------- -------------+ | 1405 | design service ?????? ?????? | | 1480 | edv-service grafik-design | | 26570 | wave design a full service design agency seth brewer http://www.wavedesign.com | | 38847 | manucom hands on it service j.shannon design | +-------+------------------------------------------------------------------- -------------+ 4 rows in set (0.03 sec) Bye --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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