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
