Replace FTS in the history_service with a brute force text search.

chrome/browser/history/url_database.cc

 // Copyright (c) 2012 The Chromium Authors. All rights reserved.
 // Use of this source code is governed by a BSD-style license that can be
 // found in the LICENSE file.
 
 #include "chrome/browser/history/url_database.h"
 
 #include <algorithm>
 #include <limits>
 #include <string>
 #include <vector>
@@ skipping 340 matching lines @@
   statement.BindInt(3, min_typed);
 
   if (!statement.Step())
     return false;
 
   DCHECK(info);
   FillURLRow(statement, info);
   return true;
 }
 
+bool URLDatabase::GetTextMatches(const string16& query,
+                                 URLRows* results) {
+  ScopedVector<QueryNode> query_nodes;
+  query_parser_.ParseQueryNodes(query, &query_nodes.get());
+
+  sql::Statement statement(GetDB().GetCachedStatement(SQL_FROM_HERE,
+      "SELECT" HISTORY_URL_ROW_FIELDS "FROM urls WHERE hidden = 0"));
+
+  while (statement.Step()) {
+    std::vector<QueryWord> query_words;
+    string16 url = base::i18n::ToLower(UTF8ToUTF16(statement.ColumnString(1)));

[Scott Hess - ex-Googler, 2013/06/13 19:45:58]

Replace UTF8ToUTF16(ColumnString()) with ColumnString16().

[rmcilroy, 2013/06/14 12:45:41]

Done.

+    query_parser_.ExtractQueryWords(url, &query_words);
+    string16 title = base::i18n::ToLower(statement.ColumnString16(2));
+    query_parser_.ExtractQueryWords(title, &query_words);
+
+    if (query_parser_.DoesQueryMatch(query_words, query_nodes.get())) {
+      history::URLResult info;
+      FillURLRow(statement, &info);
+      if (info.url().is_valid())
+        results->push_back(info);
+    }
+  }
+  return !results->empty();

[Scott Hess - ex-Googler, 2013/06/13 19:45:58]

If this is your success metric, do you want results->clear() before the loop? 
I'm not entirely sure whether this would be more appropriately "Fill |results|
with the matches" versus "Append matches to |results|", though, in which case
this might not be the right metric.

[rmcilroy, 2013/06/14 12:45:41]

Done.

+}
+
 bool URLDatabase::InitKeywordSearchTermsTable() {
   has_keyword_search_terms_ = true;
   if (!GetDB().DoesTableExist("keyword_search_terms")) {
     if (!GetDB().Execute("CREATE TABLE keyword_search_terms ("
         "keyword_id INTEGER NOT NULL,"      // ID of the TemplateURL.
         "url_id INTEGER NOT NULL,"          // ID of the url.
         "lower_term LONGVARCHAR NOT NULL,"  // The search term, in lower case.
         "term LONGVARCHAR NOT NULL)"))      // The actual search term.
       return false;
   }
@@ skipping 198 matching lines @@
   return GetDB().Execute(sql.c_str());
 }
 
 bool URLDatabase::CreateMainURLIndex() {
   // Index over URLs so we can quickly look up based on URL.
   return GetDB().Execute(
       "CREATE INDEX IF NOT EXISTS urls_url_index ON urls (url)");
 }
 
 }  // namespace history