Import SQLite 3.8.7.4.

third_party/sqlite/src/test/fts3ab.test

 # 2006 September 13
 #
 # 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 97 matching lines @@
 #    invert:    words for the bits of ~rowid
 #
 db eval {
    CREATE VIRTUAL TABLE t4 USING fts3([norm],'plusone',"invert");
 }
 for {set i 1} {$i<=15} {incr i} {
   set vset [list [wordset $i] [wordset [expr {$i+1}]] [wordset [expr {~$i}]]]
   db eval "INSERT INTO t4(norm,plusone,invert) VALUES([join $vset ,]);"
 }
 
-breakpoint
 do_test fts3ab-4.1 {
   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'norm:one'}
 } {1 3 5 7 9 11 13 15}
 do_test fts3ab-4.2 {
   execsql {SELECT rowid FROM t4 WHERE norm MATCH 'one'}
 } {1 3 5 7 9 11 13 15}
 do_test fts3ab-4.3 {
   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'one'}
 } {1 2 3 4 5 6 7 8 9 10 11 12 13 14 15}
 do_test fts3ab-4.4 {
@@ skipping 10 matching lines @@
 } {1 3 5 7 9 11 13 15}
 do_test fts3ab-4.8 {
   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'plusone:two norm:one'}
 } {1 5 9 13}
 do_test fts3ab-4.9 {
   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'two norm:one'}
 } {1 3 5 7 9 11 13 15}
 
 
 finish_test