Hi! On Jan 18, Gordan Bobic wrote: > Hi. > > I thought it would be useful to share my findings. They all relate to the > 4.0.1 release. It would be nice to have some clarification on whether this is > expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted > index, etc), and what you guys think could be causing it. > > 1.1) Full Text Search can, according to the manual, be performed without the > FTS index, but it is slower. > 1.2) MySQL can only use 1 index per join per table. > > => This means that if I specify the USE INDEX (some_non_fulltext_index), the > FTS will be performed without the index, and this will only work IN BOOLEAN > MODE. Otherwise, MySQL returns an error, complaining about the lack of an > index.
Gordan, you're right. It's the way it was expected to behave :-) It's not a "known" bug as the code is rather new. Can you create a test case for this ? 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
