So I was just in Season Maintenance trying to search for one of my 2015 products, and I keep getting some very strange results.
I am doing a text search for the phrase: bard college orchestra -- and I'm getting back practically everything in my Spring season. I did a full update of the fulltext search index just to be sure, but this didn't affect anything.
What's wild is that if I run SELECT * FROM T_INVENTORY WHERE fulltext LIKE '%bard college orchestra%', I get back only the one performance row I'm looking for. And in fact, for many of the rows that ARE returned, their fulltext fields don't contain ANY of the three words in my search phrase!
The row that I am looking for doesn't even have a high relevance ranking -- it's at 15, while the top result is at 111.
Does anyone have any hints as to how the fulltext search is actually operating? Or does this sound like something I should submit to TASK?