[sql] Test that a Chromium fts change is actually in place.

sql/sqlite_features_unittest.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 <string>
 
 #include "base/bind.h"
 #include "base/files/file_util.h"
 #include "base/files/scoped_temp_dir.h"
 #include "sql/connection.h"
@@ skipping 53 matching lines @@
 }
 
 #if defined(SQLITE_ENABLE_FTS2)
 // fts2 is used for older history files, so we're signed on for keeping our
 // version up-to-date.
 // TODO(shess): Think up a crazy way to get out from having to support
 // this forever.
 TEST_F(SQLiteFeaturesTest, FTS2) {
   ASSERT_TRUE(db().Execute("CREATE VIRTUAL TABLE foo USING fts2(x)"));
 }
+
+// A standard SQLite will not include our patch.  This includes iOS.
+#if !defined(USE_SYSTEM_SQLITE)
+// Chromium fts2 was patched to treat "foo*" as a prefix search, though the icu
+// tokenizer will return it as two tokens {"foo", "*"}.
+TEST_F(SQLiteFeaturesTest, FTS2_Prefix) {
+  const char kCreateSql[] =
+      "CREATE VIRTUAL TABLE foo USING fts2(x, tokenize icu)";
+  ASSERT_TRUE(db().Execute(kCreateSql));
+
+  ASSERT_TRUE(db().Execute("INSERT INTO foo (x) VALUES ('test')"));
+
+  sql::Statement s(db().GetUniqueStatement(
+      "SELECT x FROM foo WHERE x MATCH 'te*'"));
+  ASSERT_TRUE(s.Step());
+  EXPECT_EQ("test", s.ColumnString(0));
+}
+#endif
 #endif
 
 // fts3 is used for current history files, and also for WebDatabase.
 TEST_F(SQLiteFeaturesTest, FTS3) {
   ASSERT_TRUE(db().Execute("CREATE VIRTUAL TABLE foo USING fts3(x)"));
 }
 
+#if !defined(USE_SYSTEM_SQLITE)
+// Test that fts3 doesn't need fts2's patch (see above).
+TEST_F(SQLiteFeaturesTest, FTS3_Prefix) {
+  const char kCreateSql[] =
+      "CREATE VIRTUAL TABLE foo USING fts3(x, tokenize icu)";
+  ASSERT_TRUE(db().Execute(kCreateSql));
+
+  ASSERT_TRUE(db().Execute("INSERT INTO foo (x) VALUES ('test')"));
+
+  sql::Statement s(db().GetUniqueStatement(
+      "SELECT x FROM foo WHERE x MATCH 'te*'"));
+  ASSERT_TRUE(s.Step());
+  EXPECT_EQ("test", s.ColumnString(0));
+}
+#endif
+
 }  // namespace