Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(130)

Unified Diff: third_party/sqlite/src/ext/fts5/test/fts5aux.test

Issue 2751253002: [sql] Import SQLite 3.17.0. (Closed)
Patch Set: also clang on Linux i386 Created 3 years, 9 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
Index: third_party/sqlite/src/ext/fts5/test/fts5aux.test
diff --git a/third_party/sqlite/src/ext/fts5/test/fts5aux.test b/third_party/sqlite/src/ext/fts5/test/fts5aux.test
index 995fe857845e1715f07e4fddca5222119a4d9a43..fa3167a4d118118a853a6f59b270a063d924aa0f 100644
--- a/third_party/sqlite/src/ext/fts5/test/fts5aux.test
+++ b/third_party/sqlite/src/ext/fts5/test/fts5aux.test
@@ -246,5 +246,37 @@ foreach {tn lRow res} {
} $res
}
+#-------------------------------------------------------------------------
+# Test the built-in bm25() demo.
+#
+reset_db
+do_execsql_test 9.1 {
+ CREATE VIRTUAL TABLE t1 USING fts5(a, b);
+ INSERT INTO t1 VALUES('a', NULL); -- 1
+ INSERT INTO t1 VALUES('a', NULL); -- 2
+ INSERT INTO t1 VALUES('a', NULL); -- 3
+ INSERT INTO t1 VALUES('a', NULL); -- 4
+ INSERT INTO t1 VALUES('a', NULL); -- 5
+ INSERT INTO t1 VALUES('a', NULL); -- 6
+ INSERT INTO t1 VALUES('a', NULL); -- 7
+ INSERT INTO t1 VALUES('a', NULL); -- 8
+ INSERT INTO t1 VALUES(NULL, 'a a b'); -- 9
+ INSERT INTO t1 VALUES(NULL, 'b b a'); -- 10
+}
+
+do_execsql_test 9.2 {
+ SELECT rowid FROM t1('a AND b') ORDER BY rank;
+} {
+ 10 9
+}
+
+do_execsql_test 9.3 {
+ SELECT rowid FROM t1('b:a AND b:b') ORDER BY rank;
+} {
+ 9 10
+}
+
+
+
finish_test
« no previous file with comments | « third_party/sqlite/src/ext/fts5/test/fts5auto.test ('k') | third_party/sqlite/src/ext/fts5/test/fts5bigtok.test » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698