Interesting difference between SQL and Lucene search

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Interesting difference between SQL and Lucene search

Post by AbleMods » 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?
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply