re: Re: Bug using truncation in 4.0.4-beta
On Sunday 22 December 2002 20:16, Salam Baker Shanawa wrote: Hello Victoria, Is there any plan to make operators work with phrase searches. something like: against ('comput* scie*') in boolean mode Yes, it's still in TODO :) I have tested 4.0.6-gamma and I can see that the bug is fixed: Empty set is returned when truncation operator is used :-) Victoria Reznichenko wrote: sbs, Tuesday, October 29, 2002, 7:31:03 AM, you wrote: samdldlds Description: samdldlds Special case: using SELECT with truncation doesn't return some records samdldlds when the searched query appears at the end of the line. Note that the last record will samdldlds be matched and returned because there is a space character at the end. samdldlds I am using ft_min_word_len = 1; Currently phrase search doesn't work with operators. If they work for somebody, it's a bug, too :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: Bug using truncation in 4.0.4-beta
Hello Victoria, Is there any plan to make operators work with phrase searches. something like: against ('comput* scie*') in boolean mode I have tested 4.0.6-gamma and I can see that the bug is fixed: Empty set is returned when truncation operator is used :-) Regards Salam Victoria Reznichenko wrote: sbs, Tuesday, October 29, 2002, 7:31:03 AM, you wrote: samdldlds Description: samdldlds Special case: using SELECT with truncation doesn't return some records samdldlds when the searched query appears at the end of the line. Note that the last record will samdldlds be matched and returned because there is a space character at the end. samdldlds I am using ft_min_word_len = 1; Currently phrase search doesn't work with operators. If they work for somebody, it's a bug, too :-) - 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
re: Bug using truncation in 4.0.4-beta
sbs, Tuesday, October 29, 2002, 7:31:03 AM, you wrote: samdldlds Description: samdldlds Special case: using SELECT with truncation doesn't return some records samdldlds when the searched query appears at the end of the line. Note that the last record will samdldlds be matched and returned because there is a space character at the end. samdldlds I am using ft_min_word_len = 1; Currently phrase search doesn't work with operators. If they work for somebody, it's a bug, too :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Bug using truncation in 4.0.4-beta
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 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 16 15:52 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 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