Index: third_party/sqlite/src/test/fts3near.test |
diff --git a/third_party/sqlite/src/test/fts3near.test b/third_party/sqlite/src/test/fts3near.test |
index 9c4409e1ed3cd885750a8d9abd2ec3f559591bfb..2d9981e5355197acfb28382c391005cfeadb6bb6 100644 |
--- a/third_party/sqlite/src/test/fts3near.test |
+++ b/third_party/sqlite/src/test/fts3near.test |
@@ -165,7 +165,6 @@ do_test fts3near-3.6 { |
SELECT offsets(t1) FROM t1 WHERE content MATCH 'three NEAR/0 "two four"' |
} |
} {{0 0 8 5 0 1 14 3 0 2 18 4}} |
-breakpoint |
do_test fts3near-3.7 { |
execsql { |
SELECT offsets(t1) FROM t1 WHERE content MATCH '"two four" NEAR/0 three'} |
@@ -580,5 +579,19 @@ do_test fts3near-6.5 { |
} |
} {3} |
+# Ticket 38b1ae018f. |
+# |
+do_execsql_test fts3near-7.1 { |
+ CREATE VIRTUAL TABLE x USING fts4(y,z); |
+ INSERT INTO x VALUES('aaa bbb ccc ddd', 'bbb ddd aaa ccc'); |
+ SELECT * FROM x where y MATCH 'bbb NEAR/6 aaa'; |
+} {{aaa bbb ccc ddd} {bbb ddd aaa ccc}} |
+ |
+do_execsql_test fts3near-7.2 { |
+ CREATE VIRTUAL TABLE t2 USING fts4(a, b); |
+ INSERT INTO t2 VALUES('A B C', 'A D E'); |
+ SELECT * FROM t2 where t2 MATCH 'a:A NEAR E' |
+} {} |
+ |
finish_test |