Import SQLite 3.8.7.4.

third_party/sqlite/src/test/fts3expr.test

 # 2006 September 9
 #
 # 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 10 matching lines @@
 ifcapable !fts3 {
   finish_test
   return
 }
 
 set sqlite_fts3_enable_parentheses 1
 
 proc test_fts3expr {expr} {
   db one {SELECT fts3_exprtest('simple', $expr, 'a', 'b', 'c')}
 }
+
 do_test fts3expr-1.0 {
   test_fts3expr "abcd"
 } {PHRASE 3 0 abcd}
 do_test fts3expr-1.1 {
   test_fts3expr " tag "
 } {PHRASE 3 0 tag}
 
 do_test fts3expr-1.2 {
   test_fts3expr "ab AND cd"
 } {AND {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
@@ skipping 447 matching lines @@
 
 do_test fts3expr-7.1 {
   execsql {
     CREATE VIRTUAL TABLE test USING fts3 (keyword);
     INSERT INTO test VALUES ('abc');
     SELECT * FROM test WHERE keyword MATCH '""';
   }
 } {}
 
 
+do_test fts3expr-8.0 { test_fts3expr "(blah)" } {PHRASE 3 0 blah}
+do_test fts3expr-8.1 { test_fts3expr "(blah.)" } {PHRASE 3 0 blah}
+do_test fts3expr-8.2 { test_fts3expr "(blah,)" } {PHRASE 3 0 blah}
+do_test fts3expr-8.3 { test_fts3expr "(blah!)" } {PHRASE 3 0 blah}
+do_test fts3expr-8.4 { test_fts3expr "(blah-)" } {PHRASE 3 0 blah}
+
+do_test fts3expr-8.5 { test_fts3expr "((blah.))" } {PHRASE 3 0 blah}
+do_test fts3expr-8.6 { test_fts3expr "(((blah,)))" } {PHRASE 3 0 blah}
+do_test fts3expr-8.7 { test_fts3expr "((((blah!))))" } {PHRASE 3 0 blah}
+
+do_test fts3expr-8.8 { test_fts3expr "(,(blah-),)" } {PHRASE 3 0 blah}
+
 set sqlite_fts3_enable_parentheses 0
+
+do_test fts3expr-9.1 {
+  test_fts3expr "f (e NEAR/2 a)"
+} {AND {PHRASE 3 0 f} {NEAR/2 {PHRASE 3 0 e} {PHRASE 3 0 a}}}
+
 finish_test