We are seeing odd search results when using the full-text search feature on the advanced search page. The first is that if you enter two values it seems to do an OR search when most users would expect an AND search. The second is that it seems to search the word “and” as an actual value instead of ignoring it. Here is an example.
If I use the Search by Value fields to construct a search for any field has Garrop AND any field has Helios, I get 3 records. This is what I would expect.
If I enter Garrop Helios in the full-text search, I get 6 results. That is all the records that have Garrop OR Helios.
If I enter Garrop and Helios in the full-text search, I get pretty much all the records since most have an “and” in the description.
Is this default behavior or something wonky with our installation?