Hi! On Jul 02, Thomas Spahni wrote: > On Tue, 2 Jul 2002, Erlend Hops? Str?msvik wrote: > > > Download the 4.0.2 source and compile it. > > Things seem to work a lot better with the 4.0.2. And it won't crash with > > special combinations of words :) > > Hi, > > Some things with BOOLEAN MODE seem still broken. Especially the '*' > jokers. I have 4.0.2 taken from the source tree yesterday. I'm querying > against a table with 14579 documents containing 187621564 bytes of data > and a fulltext index. > ...
> SELECT doc FROM plaintext \ > WHERE MATCH (bgetxt) AGAINST ('integr* ad?qu*' IN BOOLEAN MODE); > > Conclusion: > > combinations of 2 words with asterisk joker IN BOOLEAN MODE > do not work. Hmm... According to the mysql-test/t/fulltext.test it DOES work: select * from t1 where MATCH a,b AGAINST ("+call* +coll*" IN BOOLEAN MODE); I've also tried the same query w/o '+' (to make it similar to yours) - it worked also. Could you try to create a test case for the bug ? 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