Sharepoint 2010 FullTextSqlQuery using LIKE predicate does not find anything

I'm trying to execute a search in SharePoint 2010 with the FullTextSqlQuery class:

using (SPSite site = new SPSite("http://localhost"))
{
  using (FullTextSqlQuery query = new FullTextSqlQuery(site))
  {
    query.QueryText = "SELECT Title, FooText FROM scope() WHERE FooText = 'Foo2'";
    query.ResultTypes = ResultType.RelevantResults;

    //result output here...
  }
}

The SQL statement used above returns some results. But with the following statement, replacing '=' with 'LIKE', no results are returned:

SELECT Title, FooText FROM scope() WHERE FooText LIKE 'Foo2'

Note: FooText is a Managed Property of type Text and single valued.

Answers


Setting the "Reduce storage requirements for text properties by using a hash for comparison" option in the settings of the managed property makes the LIKE predicate work.


Need Your Help

How to fix template does not exist error on production server using django?

python django templates settings production

UPDATE: See self-answer. I failed to restart apache when i made the changes.