MySQL Forums
Forum List  »  Full-Text Search

Re: match against fails on mixed case
Posted by: Rick James
Date: February 08, 2013 10:03AM

The fields and their names do not agree between the CREATE, INSERT, and SELECT. This makes it difficult for us to test.

In the particular SELECT you gave, RIGHT JOIN will return the same results as JOIN. Otherwise, RIGHT JOIN may produce NULLs for all the test1 fields, including those being check in the WHERE clause. NULL probably does not "MATCH".

Please provide the EXPLAIN for the SELECT.

Options: ReplyQuote

Written By
February 07, 2013 10:43AM
Re: match against fails on mixed case
February 08, 2013 10:03AM
February 08, 2013 03:06PM
February 14, 2013 03:50PM
February 20, 2013 04:59PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.