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


Subject
Views
Written By
Posted
4286
February 07, 2013 10:43AM
Re: match against fails on mixed case
2035
February 08, 2013 10:03AM
2058
February 08, 2013 03:06PM
1975
February 14, 2013 03:50PM
2013
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.