>Description:
Special case: using SELECT with truncation doesn't return some records
when the searched query appears at the end of the line. Note that the last
record will
be matched and returned because there is a space character at the end.
I am using ft_min_word_len = 1;
>How-To-Repeat:
Try this:
drop database if exists Test_Bug ;
create database Test_Bug;
use Test_Bug;
create table article (id int(10) primary key not null auto_increment, title text);
insert into article values
(0, 'Probability and Statistics with Reliability, Queueing and Computer Science
Applications'),
(0, 'Rasiowa-Sikorski deduction systems in computer science application'),
(0, 'Computer science today in the European Union'),
(0, 'Phase transition in a random fragmentation problem with applications to computer
science'),
(0, 'A Collection of Papers and Memoirs Celebrating the Contribution of Rod Burstall
to Advances in Computer Science'),
(0, 'KITE microprocessor and CAE for computer science'),
(0, 'What Makes Them Succeed? Entry, progression and graduation in Computer Science ');
create fulltext index ti_idx on article (title);
select id,title from article where match (title) against ('"computer science"' in
boolean mode);
select "......... Now using the truncation operator .......... " as '';
select id,title from article where match (title) against ('"computer science*"' in
boolean mode);
>Fix:
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-4.0.4-beta (Source distribution)
>Environment:
System: Linux nile.lub.lu.se 2.4.7-10smp #1 SMP Thu Sep 6 16:16:16 EDT 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/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Sep 16 15:52 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27304836 Sep 4 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 4 2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --with-raid
--with-named-curses-libs=/usr/lib/libncurses.so.5.2 --with-innodb
Regards
Salam
---------------------------------------------------------------------
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
