Interesting difference between SQL and Lucene search
Posted: Wed Aug 13, 2014 5:34 am
I noticed this week an interesting behavior while testing Able search:
Assume a keywords field contains the following:
Joe,Judy, Mike, Katie
Take special note of spaces and commas
With Lucene enabled, a search for Judy or Joe will not work. Searching for Mike or Katie will. It appears the space between keywords is necessary.
Whereas with SQL FTS, I can find any of the four names.
I don't recall any discussions that the keywords field must be adapted to the appropriate search engine provider configured in the store.
Is this behavior intended?
Assume a keywords field contains the following:
Joe,Judy, Mike, Katie
Take special note of spaces and commas
With Lucene enabled, a search for Judy or Joe will not work. Searching for Mike or Katie will. It appears the space between keywords is necessary.
Whereas with SQL FTS, I can find any of the four names.
I don't recall any discussions that the keywords field must be adapted to the appropriate search engine provider configured in the store.
Is this behavior intended?