Queries on a table with one row and a FULLTEXT index returns that one row no matter what the query is. I have included the queries to reproduce this. If a second row is added, the FULLTEXT index it works fine. This happens on 3.23.47 and 4.0.1. I have looked through the mail archives but found nothing on this.

mysql> CREATE TABLE pubtemp0 ( -> pmid int(11) default NULL, -> title text, -> FULLTEXT KEY title (title) -> ) TYPE=MyISAM; Query OK, 0 rows affected (0.03 sec)

mysql> insert into pubtemp0 values (1,"I wonder why the fulltext index doesnt work?"); Query OK, 1 row affected (0.00 sec)

mysql> select * from pubtemp0; +------+----------------------------------------------+ | pmid | title | +------+----------------------------------------------+ | 1 | I wonder why the fulltext index doesnt work? | +------+----------------------------------------------+ 1 row in set (0.00 sec)

mysql> SELECT * from pubtemp0 where MATCH (title) AGAINST ('apples'); +------+----------------------------------------------+ | pmid | title | +------+----------------------------------------------+ | 1 | I wonder why the fulltext index doesnt work? | +------+----------------------------------------------+ 1 row in set (0.00 sec)

mysql> insert into pubtemp0 values (2,"What if I add a second row to the fulltext index?"); Query OK, 1 row affected (0.00 sec)

mysql> select * from pubtemp0; +------+---------------------------------------------------+ | pmid | title | +------+---------------------------------------------------+ | 1 | I wonder why the fulltext index doesnt work? | | 2 | What if I add a second row to the fulltext index? | +------+---------------------------------------------------+ 2 rows in set (0.00 sec)

mysql> SELECT * from pubtemp0 where MATCH (title) AGAINST ('apples'); Empty set (0.00 sec)

mysql>

none known

<machine, os, target, libraries (multiple lines)> System: SunOS sanger 5.7 Generic_106541-16 sun4u sparc SUNW,Ultra-4 Architecture: sun4

Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/local/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1707752 May 18 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Dec 5 2000 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 May 18 2001 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1707752 May 18 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Dec 5 2000 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125056 May 18 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/database/mysql-3.23.47 --with-innodb