Import SQLite 3.8.7.4.

third_party/sqlite/src/test/fts3near.test

 
 # 2007 October 15
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
@@ skipping 147 matching lines @@
   execsql {SELECT offsets(t1) FROM t1 WHERE content MATCH 'three NEAR/2 two'}
 } {{0 1 4 3 0 0 8 5 0 1 14 3 0 0 27 5}}
 do_test fts3near-3.5 {
   execsql {SELECT offsets(t1) FROM t1 WHERE content MATCH 'two NEAR/2 three'}
 } {{0 0 4 3 0 1 8 5 0 0 14 3 0 1 27 5}}
 do_test fts3near-3.6 {
   execsql {
     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'}
 } {{0 2 8 5 0 0 14 3 0 1 18 4}}
 
 db eval {
   INSERT INTO t1(content) VALUES('
     This specification defines Cascading Style Sheets, level 2 (CSS2). CSS2 is a style sheet language that allows authors and users to attach style (e.g., fonts, spacing, and aural cues) to structured documents (e.g., HTML documents and XML applications). By separating the presentation style of documents from the content of documents, CSS2 simplifies Web authoring and site maintenance.
 
     CSS2 builds on CSS1 (see [CSS1]) and, with very few exceptions, all valid CSS1 style sheets are valid CSS2 style sheets. CSS2 supports media-specific style sheets so that authors may tailor the presentation of their documents to visual browsers, aural devices, printers, braille devices, handheld devices, etc. This specification also supports content positioning, downloadable fonts, table layout, features for internationalization, automatic counters and numbering, and some properties related to user interface.
@@ skipping 394 matching lines @@
   execsql {
     SELECT docid FROM t1 WHERE content MATCH 'abbrev NEAR/1000 zygosis'
   }
 } {}
 do_test fts3near-6.5 {
   execsql {
     SELECT docid FROM t1 WHERE content MATCH 'abbrev NEAR/10000 zygosis'
   }
 } {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