>Description: According to the documentation at http://www.mysql.com/doc/F/u/Fulltext_Search.html, placing double-quotes around a phrase within the AGAINST clause of a full-text boolean mode search should match only rows which contain this phrase exactly as typed. Instead, it appears that the server returns all rows containing those words in any order, as if the double-quotes were not present. >How-To-Repeat: create table test (id int, data text not null, fulltext(data)); insert into test (data) values ('This is a phrase to search for'); insert into test (data) values ('We will search for this phrase'); insert into test (data) values ('Another bit of text'); insert into test (data) values ('Yet more text'); insert into test (data) values ('etc etc'); select data, match(data) against('"phrase to search for"' in boolean mode) as rank from test where match(data) against('"phrase to search for"' in boolean mode);
This search should only return the row with data 'This is a phrase to search for', or should at least give that row higher relevance - instead, the first two rows are given identical relevance, exactly as if the double-quotes had been omitted. >Fix: Haven't found a way to duplicate the missing functionality. >Submitter-Id: <submitter ID> >Originator: Carl J Meyer >Organization: Mennonite.net >MySQL support: none >Synopsis: fulltext boolean mode search, double-quotes do not work as documented >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug | doc-bug >Release: mysql-4.0.1-alpha (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 4 min 53 sec Threads: 2 Questions: 5 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.017 >Environment: System: Linux mennonet1 2.4.17 #2 SMP Tue Jan 29 12:37:22 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 10 17:12 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x 2 root root 1285788 Apr 2 11:58 /lib/libc-2.2.4.so -rw-r--r-- 1 root root 27332668 Apr 2 11:42 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Apr 2 11:42 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' --------------------------------------------------------------------- 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