Import SQLite 3.7.6.3.

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 58 matching lines @@
   execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR five'}
 } {1 3} 
 
 do_test fts3near-1.14 {
   execsql {SELECT docid FROM t1 WHERE content MATCH 'four NEAR four'}
 } {} 
 do_test fts3near-1.15 {
   execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR two NEAR one'}
 } {3} 
 
+do_test fts3near-1.16 {
+  execsql {
+    SELECT docid FROM t1 WHERE content MATCH '"one three" NEAR/0 "four five"'
+  }
+} {1} 
+do_test fts3near-1.17 {
+  execsql {
+    SELECT docid FROM t1 WHERE content MATCH '"four five" NEAR/0 "one three"'
+  }
+} {1} 
+
 
 # Output format of the offsets() function:
 #
 #     <column number> <term number> <starting offset> <number of bytes>
 #
 db eval {
   INSERT INTO t1(content) VALUES('A X B C D A B');
 }
 do_test fts3near-2.1 {
   execsql {
@@ skipping 58 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.
   ') 
 }
 do_test fts3near-4.1 {
   execsql {
     SELECT snippet(t1) FROM t1 WHERE content MATCH 'specification NEAR supports'
   }
-} {{<b>...</b> devices, handheld devices, etc. This <b>specification</b> also <b>supports</b> content positioning, downloadable fonts, <b>...</b>}}
+} {{<b>...</b>braille devices, handheld devices, etc. This <b>specification</b> also <b>supports</b> content positioning, downloadable fonts, table layout<b>...</b>}}
 
 do_test fts3near-5.1 {
   execsql {
     SELECT docid FROM t1 WHERE content MATCH 'specification attach'
   }
 } {2}
 do_test fts3near-5.2 {
   execsql {
     SELECT docid FROM t1 WHERE content MATCH 'specification NEAR attach'
   }
@@ skipping 379 matching lines @@
   }
 } {}
 do_test fts3near-6.5 {
   execsql {
     SELECT docid FROM t1 WHERE content MATCH 'abbrev NEAR/10000 zygosis'
   }
 } {3}
 
 
 finish_test