MySQL Bugs: #2888: FULLTEXT-Search does not work

Bug #2888	FULLTEXT-Search does not work
Submitted:	19 Feb 2004 3:07	Modified:	4 Aug 2005 23:28
Reporter:	Ingo Schniertshauer	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.0	OS:	Windows (Win XP Home SP1)
Assigned to:		CPU Architecture:	Any

Description:
I've created a Fulltext indexed Table and now i want to use the fulltext-syntax match-against but it does not work.I became an empty resultset.
Here may table creation script:# phpMyAdmin SQL Dump
# version 2.5.5-rc1
# http://www.phpmyadmin.net
#
# Host: 
# Erstellungszeit: 19. Februar 2004 um 12:00
# Server Version: 5.0.0-alpha-nt
# PHP-Version: 4.2.3
# 
# Datenbank: `test_db`
# 

# --------------------------------------------------------

#
# Tabellenstruktur für Tabelle `solution`
#

DROP TABLE IF EXISTS `solution`;
CREATE TABLE `solution` (
  `PK_SOLID` tinyint(12) unsigned NOT NULL auto_increment,
  `sshort` text NOT NULL,
  `slong` text NOT NULL,
  `find` varchar(250) default 'NULL',
  PRIMARY KEY  (`PK_SOLID`),
  FULLTEXT KEY `solution_Fulltext` (`sshort`,`slong`,`find`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Daten für Tabelle `solution`
#

INSERT DELAYED INTO `solution` (`PK_SOLID`, `sshort`, `slong`, `find`) VALUES (1, 'Alias-Verzeichnisse anlegen', 'In der htpd.conf ($APACHE/conf)sind die Alias-Verzeichnisse angegeben durch:\r\n<IfModule mod_alias.c>\r\n  Alias /mytest/ "<DEINPFAD>/"\r\n</IfModule>\r\n\r\n<Directory "<DEINPFAD>/">\r\n    Options Indexes MultiViews\r\n    AllowOverride All\r\n    Order allow,deny\r\n    Allow from all\r\n</Directory>', ''),
(2, 'kühlende Wadenwickel', '1.Um das Fieber zu senken, können bei Kindern ab 1J. kühlende Wadenwickel gemacht werden.\r\n2. Körper mit kaltem Pfefferminztee abreiben.', '');

SQL-Request:
SELECT * FROM solution WHERE MATCH (`sshort`,`slong`,`find`) AGAINST ('Wadenwickel');

How to repeat:
Match against to a new table has the same answer

This full-text search does not work with Suse Linux either

We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.