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) {
+  std::vector<string16> regexp_queries;
+  query_parser_.ParseQueryAsRegexps(query, &regexp_queries);
+
+  std::string sql("SELECT ");
+  sql.append(kURLRowFields);
+  sql.append(" FROM urls WHERE ");
+  for (size_t i = 0; i < regexp_queries.size(); ++i) {
+    sql.append(" (url REGEXP ? OR title REGEXP ?) AND ");
+  }
+  sql.append(" hidden = 0");
+  sql::Statement statement(GetDB().GetUniqueStatement(sql.c_str()));

[Scott Hess - ex-Googler, 2013/06/12 17:38:34]

You may want to reference http://crbug.com/248608 here.  Right now you cannot
use a cached statement, here, but I generally dislike constructed statements
like this, so consider it protection against the future.

[rmcilroy, 2013/06/13 15:32:05]

Ack (no longer required).

+  for (size_t i = 0; i < regexp_queries.size(); ++i) {
+    statement.BindString16(2 * i, regexp_queries[i]);
+    statement.BindString16((2 * i) + 1, regexp_queries[i]);
+  }
+
+  while (statement.Step()) {
+    history::URLRow info;
+    FillURLRow(statement, &info);
+    if (info.url().is_valid())
+      results->push_back(info);
+  }
+  return !results->empty();
+}
+
 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