Hello,
Sergey, thanks for the patch, I applied it for 4.0.1 and seems like
mentioned bug closed.
But I found new bug :)
Strange, but the query WORKS AS EXPECTED without fulltext index!
The results for 4.0.1 with latest fulltext patch applied:
If you need full testcase, please conteact me.
Thanks, Alexander
--------------
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 | fff | 1 | txt | A
| 38347 | 1 | NULL | FULLTEXT |
+-----------+------------+----------+--------------+-------------+----------
-+-------------+----------+--------+----------+
2 rows in set (0.00 sec)
--------------
select * from logo_text where match(txt) against ('+sony -play*' in boolean
mode)
--------------
+-------+-------------------------------------------------------------------
-------+
| id | txt
|
+-------+-------------------------------------------------------------------
-------+
| 3198 | sony
|
| 3199 | sony
|
| 5947 | cd changer 6 sony
|
| 5948 | wega fd trinitron sony
|
| 7539 | playstation sony
|
| 11814 | my first sony
|
| 11815 | my first sony
|
| 11835 | sony music
|
| 11836 | sony versity
|
| 11869 | it's a sony sony
|
| 19720 | playstation 2 sony
|
| 19721 | playstation sony
|
| 20417 | sony music 550
|
| 21186 | sony mobile
|
| 21187 | xplod sony
|
| 21188 | memory stick sony
|
| 27096 | sdds sony dynamic digital sound digital movie sound system
|
| 29512 | playstation sony
|
| 30292 | vaio sony
|
| 37280 | sony ericsson mobile communications
http://www.sonyericssonmobile.com/ |
| 37281 | sony ericsson mobile communications
http://www.sonyericssonmobile.com/ |
| 39170 | sony computer entertainment
|
| 39548 | ali the movie will smith sony pictures entertainment
|
| 40117 | digital cinematography sony
|
| 40133 | cinealta sony
|
| 40134 | cinealta sony
|
| 40310 | superslim sony monitors
|
| 40506 | sony walkman
|
+-------+-------------------------------------------------------------------
-------+
28 rows in set (0.00 sec)
--------------
ALTER TABLE logo_text DROP INDEX fff
--------------
Query OK, 38347 rows affected (1.44 sec)
Records: 38347 Duplicates: 0 Warnings: 0
--------------
select * from logo_text where match(txt) against ('+sony -play*' in boolean
mode)
--------------
+-------+-------------------------------------------------------------------
-------+
| id | txt
|
+-------+-------------------------------------------------------------------
-------+
| 3198 | sony
|
| 3199 | sony
|
| 5947 | cd changer 6 sony
|
| 5948 | wega fd trinitron sony
|
| 11814 | my first sony
|
| 11815 | my first sony
|
| 11835 | sony music
|
| 11836 | sony versity
|
| 11869 | it's a sony sony
|
| 20417 | sony music 550
|
| 21186 | sony mobile
|
| 21187 | xplod sony
|
| 21188 | memory stick sony
|
| 27096 | sdds sony dynamic digital sound digital movie sound system
|
| 30292 | vaio sony
|
| 37280 | sony ericsson mobile communications
http://www.sonyericssonmobile.com/ |
| 37281 | sony ericsson mobile communications
http://www.sonyericssonmobile.com/ |
| 39170 | sony computer entertainment
|
| 39548 | ali the movie will smith sony pictures entertainment
|
| 40117 | digital cinematography sony
|
| 40133 | cinealta sony
|
| 40134 | cinealta sony
|
| 40310 | superslim sony monitors
|
| 40506 | sony walkman
|
+-------+-------------------------------------------------------------------
-------+
24 rows in set (0.43 sec)
Bye
Server version: 4.0.1-alpha
Uptime: 23 min 52 sec
Threads: 2 Questions: 164 Slow queries: 4 Opens: 94 Flush tables: 1
Open tables: 4 Queries per second avg: 0.115
--------------
---------------------------------------------------------------------
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
