>Description:
- I have "bk pulled" the last version of 4.0.2 as of 6/6. After each "new" mysql build
I have done an 'alter table document set type=myisam' to rebuild the indexes.
- Use of phrases in boolean mode doesn't seem to work properly. It seem that it in
addition to match the correct phrase also matches documents where every word in the
phrase is present in the documenttext.
For example with the query below:
mysql> select doc_id, title, createdate from document2 where match (title)
against('+"fiskefusk vil"' IN BOOLEAN MODE)
order by 2 desc;
+--------+---------------------------------------+---------------------+
| doc_id | title | createdate |
+--------+---------------------------------------+---------------------+
| 37865 | Økokrim vil også ha tips om fiskefusk | 2001-10-31 18:17:00 |
| 37869 | Økokrim vil også ha tips om fiskefusk | 2001-10-31 18:29:00 |
| 37948 | Økokrim vil også ha tips om fiskefusk | 2001-10-31 18:17:00 |
| 37884 | Vil ha tips om fiskefusk | 2001-10-31 18:27:00 |
+--------+---------------------------------------+---------------------+
>How-To-Repeat:
-
>Fix:
-
>Submitter-Id: <submitter ID>
>Originator: [EMAIL PROTECTED]
>Organization: Magenta News AS
>MySQL support: none
>Synopsis: -
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.2-alpha (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, 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.2
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql4.sock
Uptime: 3 days 13 hours 13 min 18 sec
Threads: 2 Questions: 7614 Slow queries: 0 Opens: 434 Flush tables: 1 Open
tables: 24 Queries per second avg: 0.025
>Environment:
System: Linux capone.magentanews.com 2.4.8-26mdk #1 Sun Sep 23 17:06:39 CEST 2001 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/i586-mandrake-linux-gnu/2.96/specs
gcc version 2.96 20000731 (Mandrake Linux 8.1 2.96-0.62mdk)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jan 2 15:07 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 1285480 Sep 10 2001 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27470790 Dec 18 03:05 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Dec 18 03:05 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql402 --with-tcp-port=3304
--with-unix-socket-path=/tmp/mysql4.sock --without-innodb
---------------------------------------------------------------------
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
