FullTextSqlQuery RowLimit setting defaulted when adding WHERE criteria

Question

We are experiencing an issue where a FullTextSqlQuery is only returning the default 100 results whenever certain criteria are added in the WHERE clause. We are setting the RowLimit to int.MaxValue, and when a wide-open search is done, we are receiving the max results. It's only an issue when tacking-on CONTAINS clauses. Has anyone else seen this issue? I wasn't able to dig up anything on Google/Bing.

FullTextSqlQuery kRequest = new FullTextSqlQuery(ServerContext.Current);
kRequest.KeywordInclusion = KeywordInclusion.AnyKeyword;
kRequest.ResultTypes = ResultType.RelevantResults;
kRequest.TrimDuplicates = false;
kRequest.RowLimit = int.MaxValue;
kRequest.Timeout = 120000;
ResultTableCollection resultTbls = kRequest.Execute();

Query Code:

string query = "SELECT Title, Path, Facility, OwnerDepartment, 
    FacilityActiveDate, FacilityInactiveDate, ScheduledReviewDate, DocID, 
    Version FROM SCOPE() WHERE ";
query += "Path like '%" + site.Url + "%'";

// when it hits the else statement is an example of when it will only 
// return 100 results
if (FacilitySelectedIndex == 1)
  {
    query += " AND Facility IS NOT NULL";
  }
else
  {
    query += " AND CONTAINS(Facility, '\"*" + FacilityShortName.Trim() + "*\"')";
    queryText.Add("Facility=" + FacilityShortName);
  }
}

Answer 1

If I recall correctly, the RowLimit max value is actually less than int.MaxValue, only it won't tell you that. Try setting the RowLimit to some arbitrary large number that is still smaller than int.MaxValue, such as 99999