I am using acts_as_ferret to do full text search on my models and I am
having problem on three-letter word searches.
I am going to use an example to explain my problem. Here it is:
There is a table called users and it has login, first_name, last_name
columns. There are three rows inside it.
login first_name last_name
bob bob henry
longbob nil nil
existingbob nil nil
Now I am expecting to get all three rows as the search result and my
search query is: “bob OR bob OR bob* OR *bob”
However, I am only getting longbob and existingbob rows, not the user
I have tried many other queries and still no luck. At first I thought
that some columns might not be indexed properly but doing login:bob
returns me with the user bob, so I don’t think that it’s indexing
Thank you in advance for the help.