Hi! On Mar 07, Thomas Spahni wrote: > On Wed, 6 Mar 2002, Sergei Golubchik wrote: > > > > mysql> SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN > > > BOOLEAN MODE); > > > Empty set (0.00 sec) > > > > It is a bug. > > > > You can - either create a repeatable test case, to be sure, > > the bug will be fixed in 4.0.2, ... > > Hello Sergei, > > here is your testcase. I reduced the dataset to 2 rows containing the word > I'm looking for. I was lucky and the bug persisted. You may save the > appendix to a file like 'testcase.sql' and then pipe it through mysql. For > me this happens: > > > cat testcase.sql | mysql -t > +-------------+ > | doc | > +-------------+ > | 122 III 150 | > | 84 II 304 | > +-------------+ > > The same result should appear twice!
Thank you for a test case ! The bug will be fixed in 4.0.2. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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