>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
