Hi! On Sep 19, Michael Stassen wrote: > This doesn't surprise me. I haven't looked at the code, but I'd bet > that double-quoted, exact phrase matches are handled the usual way by > mysql: First, do a regular fulltext search (using the index) to find > rows with your search words, then check the found rows to see if they > exactly contain the double-quoted string. Your result seems to show > that no additional constraints are placed on the second step, or at > least that the beginning of the phrase doesn't have to be a word boundary. > > Hence, "verandover andover" does not match "overandover andover" because > it doesn't conatain the word "verandover". It would have passed the > second step, as it does contain the quoted string. > > On the other hand, "andover andover" does match "overandover andover" > because the fulltext search is looking for "andover", which it finds, > and the exact phrase "andover andover" can be found in the row. > > If I'm right, I'd expect "andover and" to match, but "andover ando" > would not. > > Whether it should work this way is a philosophical matter, I suppose.
I think it should not. Fixed, thanks. (hint: http://bugs.mysql.com/ next time) Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]