Index: third_party/sqlite/src/test/fts3ad.test |
diff --git a/third_party/sqlite/src/test/fts3ad.test b/third_party/sqlite/src/test/fts3ad.test |
index 420b5b27453f4b2bbdad63da5012bc6ae6160cc5..e373339d4e74b10991efac46192c1e00c397a475 100644 |
--- a/third_party/sqlite/src/test/fts3ad.test |
+++ b/third_party/sqlite/src/test/fts3ad.test |
@@ -61,5 +61,46 @@ do_test fts3ad-1.6 { |
} |
} {3 {The value is <b>123456789</b>}} |
+do_test fts3ad-2.1 { |
+ execsql { |
+ DROP TABLE t1; |
+ CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize porter); |
+ INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping'); |
+ SELECT rowid FROM t1 WHERE content MATCH 'run jump'; |
+ } |
+} {1} |
+do_test fts3ad-2.2 { |
+ execsql { |
+ DROP TABLE t1; |
+ CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= porter); |
+ INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping'); |
+ SELECT rowid FROM t1 WHERE content MATCH 'run jump'; |
+ } |
+} {1} |
+do_test fts3ad-2.3 { |
+ execsql { |
+ DROP TABLE t1; |
+ CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= simple); |
+ INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping'); |
+ SELECT rowid FROM t1 WHERE content MATCH 'run jump'; |
+ } |
+} {} |
+do_test fts3ad-2.4 { |
+ execsql { |
+ DROP TABLE t1; |
+ CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= porter); |
+ INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping'); |
+ SELECT rowid FROM t1 WHERE content MATCH 'run jump'; |
+ } |
+} {1} |
+do_test fts3ad-2.5 { |
+ execsql { |
+ DROP TABLE t1; |
+ CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize = porter); |
+ INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping'); |
+ SELECT rowid FROM t1 WHERE content MATCH 'run jump'; |
+ } |
+} {1} |
+ |
finish_test |