List:General Discussion« Previous MessageNext Message »
From:Artem V. Ryabov Date:July 23 2002 2:12pm
Subject:Bug or feature fulltext search?
View as plain text  
Hello mysql,

see this 2 queries:
why they not equal?
why first skip many records?


mysql> select left(ftText,20) from Txt_index where match(ftText)
> against('+(wщd200206*) +wщ12p' in boolean mode);
+----------------------+
| left(ftText,20)      |
+----------------------+
| wщd20020601   wщ12p   wщ |
| wщd20020604   wщ12p   wщ |
| wщd20020604   wщ12p   wщ |
+----------------------+
3 rows in set (0.36 sec)

mysql> select left(ftText,20) from Txt_index where match(ftText) against('+wщd200206*
> +wщ12p' in boolean mode);
+----------------------+
| left(ftText,20)      |
+----------------------+
| wщd20020601   wщ12p   wщ |
| wщd20020601   wщnw    wщ1 |
| wщd20020604   wщ12p   wщ |
| wщd20020604   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020609   wщ12p   wщ |
| wщd20020611   wщ12p   wщ |
| wщd20020611   wщ12p   wщ |
| wщd20020611   wщ12p   wщ |
| wщd20020611   wщ12p   wщ |
| wщd20020611   wщ12p   wщ |
| wщd20020614   wщ12p   wщ |
| wщd20020614   wщ12p   wщ |
| wщd20020619   wщ12p   wщ |
| wщd20020619   wщ12p   wщ |
| wщd20020619   wщ12p   wщ |
| wщd20020619   wщ12p   wщ |
| wщd20020619   wщ12p   wщ |
| wщd20020625   wщ12p   wщ |
| wщd20020625   wщ12p   wщ |
| wщd20020625   wщ12p   wщ |
| wщd20020625   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
| wщd20020627   wщ12p   wщ |
+----------------------+
42 rows in set (8.00 sec)


mysql> show variables like 'version';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| version       | 4.0.2-alpha-log |
+---------------+-----------------+
1 row in set (0.00 sec)

-- 
Best regards,
 Artem                          mailto:artem@stripped

Thread
Bug or feature fulltext search?Artem V. Ryabov23 Jul
  • Re: Bug or feature fulltext search?Sergei Golubchik23 Jul
    • Re[2]: Bug or feature fulltext search?Artem V. Ryabov24 Jul
    • Re[2]: Bug or feature fulltext search?Artem V. Ryabov1 Aug
  • Re: Re[2]: Bug or feature fulltext search?Jocelyn Fournier24 Jul
    • Re: Bug or feature fulltext search?Sergei Golubchik24 Jul
  • Re: Bug or feature fulltext search?Jocelyn Fournier24 Jul
    • Re: Bug or feature fulltext search?Sergei Golubchik5 Aug