Re: match-function in fulltext search return 0 - Sergei Golubchik - com.mysql.lists.bugs

2 messages in com.mysql.lists.bugsRe: match-function in fulltext search...

From	Sent On	Attachments
Stefan Armbruster	19 Sep 2001 09:01
Sergei Golubchik	19 Sep 2001 09:59

Subject:	Re: match-function in fulltext search return 0
From:	Sergei Golubchik (se...@mysql.com)
Date:	09/19/2001 09:59:31 AM
List:	com.mysql.lists.bugs

Hi!

You can send your test case to me, but first read the manual about 50% threshold in fulltext search. If it won't match your case, send me your script.

On Sep 19, Stefan Armbruster wrote:

Description:

I have a reproduceable case, where a fulltext search using the match funtion returns 0 but the data in the table matches the searched word. This does not only happen on my box, I was also able to reproduce this bug on a Cobalt RAQ. Maybe this has something todo with using a longtext within the table.I'm running a unmodified SuSE Linux 7.2 (kernel 2.4.4) on a Dell Inspiron 8000. MySQL version is 3.23.37, the version shipped by SuSE.

How-To-Repeat:

I have a sql script (size ~36k), but it exeeds your mail size limit. Please give me a email address to send it to you. apply this SQL script to a database: mysql -t test < auftrag.sql The script creates a table with a fulltext index on 'gemeinde'. It inserts two rows, containing binary data and the value 'Munchen' for gemeinde. Last it performs a fulltext search, that produces the following output: stefan@darthvader:~/mobiltech/database > mysql -t test < auftrag.sql +----------+-------------------------------------+ | gemeinde | match(gemeinde) against ('Munchen') | +----------+-------------------------------------+ | Munchen | 0 | | Puchheim | 0 | +----------+-------------------------------------+ Obviosly the match result for the first row is wrong, because the search string exactly matches the data.

Fix: none, so far Submitter-Id: don't know Originator: Stefan Armbruster Organization: Freelancer MySQL support: none Synopsis: fulltext search failed Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.19 Distrib 3.23.37, for suse-linux

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 3.23.37-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 4 hours 46 min 15 sec

Threads: 3 Questions: 439 Slow queries: 0 Opens: 35 Flush tables: 1 Open tables: 8 Queries per second avg: 0.026

Environment:

<machine, os, target, libraries (multiple lines)> System: Linux darthvader 2.4.4-4GB #1 Wed May 16 00:37:55 GMT 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/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='-O2 -m486 -mcpu=i486 -march=i486 -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' LDFLAGS='' LIBC: -rwxr-xr-x 1 root root 1343073 Mai 11 16:50 /lib/libc.so.6 -rw-r--r-- 1 root root 24539184 Mai 11 16:43 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Mai 11 16:43 /usr/lib/libc.so Configure command: ./configure --enable-shared --enable-assembler --enable-large-files --infodir=/usr/share/info --libdir=/usr/lib --libexecdir=/usr/sbin --localstatedir=/var/lib/mysql --mandir=/usr/share/man --prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --without-debug --datadir=/usr/share --includedir=/usr/include --with-extra-charsets=complex --with-unix-socket-path=/var/lib/mysql/mysql.sock --without-berkeley-db --without-innodb

To request this thread, e-mail bugs...@lists.mysql.com To unsubscribe, e-mail <bugs...@lists.mysql.com>

Regards, Sergei