[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/fts3aux1.test

 # 2011 January 27
 #
 # 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 99 matching lines @@
   EXPLAIN QUERY PLAN SELECT * FROM terms WHERE +term='braid'
 } {0 0 0 {SCAN TABLE terms VIRTUAL TABLE INDEX 0:}}
 
 # Now show that using "term='braid'" means the virtual table returns
 # only 1 row to SQLite, but "+term='braid'" means all 19 are returned.
 #
 do_test 2.1.2.1 {
   set cnt 0
   execsql { SELECT * FROM terms_v WHERE rec('cnt', term) AND term='braid' }
   set cnt
-} {2}
+} {1}
 do_test 2.1.2.2 {
   set cnt 0
   execsql { SELECT * FROM terms_v WHERE rec('cnt', term) AND +term='braid' }
   set cnt
-} {38}
+} {19}
 
 # Similar to the test immediately above, but using a term ("breakfast") that 
 # is not featured in the dataset.
 #
 do_test 2.1.3.1 {
   set cnt 0
   execsql { SELECT * FROM terms_v WHERE rec('cnt', term) AND term='breakfast' }
   set cnt
 } {0}
 do_test 2.1.3.2 {
   set cnt 0
   execsql { SELECT * FROM terms_v WHERE rec('cnt', term) AND +term='breakfast' }
   set cnt
-} {38}
+} {19}
 
 do_execsql_test 2.1.4.1 { SELECT * FROM terms_v WHERE term='braid' } {braid 1 1}
 do_execsql_test 2.1.4.2 { SELECT * FROM terms_v WHERE +term='braid'} {braid 1 1}
 do_execsql_test 2.1.4.3 { SELECT * FROM terms_v WHERE term='breakfast'  } {}
 do_execsql_test 2.1.4.4 { SELECT * FROM terms_v WHERE +term='breakfast' } {}
 
 do_execsql_test 2.1.4.5 { SELECT * FROM terms_v WHERE term='cba'  } {}
 do_execsql_test 2.1.4.6 { SELECT * FROM terms_v WHERE +term='cba' } {}
 do_execsql_test 2.1.4.7 { SELECT * FROM terms_v WHERE term='abc'  } {}
 do_execsql_test 2.1.4.8 { SELECT * FROM terms_v WHERE +term='abc' } {}
@@ skipping 362 matching lines @@
 do_test 8.1 {
   catchsql { CREATE VIRTUAL TABLE att.aux3 USING fts4aux(main, ft1) }
 } {1 {invalid arguments to fts4aux constructor}}
 
 do_test 8.2 {
   execsql {DETACH att}
   catchsql { SELECT * FROM aux2 }
 } {1 {SQL logic error or missing database}}
 
 finish_test