Import SQLite 3.8.7.4.

third_party/sqlite/src/test/whereA.test

 # 2009 February 23
 #
 # 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 50 matching lines @@
 } {1}
 do_test whereA-1.7 {
   db close
   sqlite3 db test.db
   db eval {
     PRAGMA reverse_unordered_selects=1;
     VACUUM;
     SELECT * FROM t1;
   }
 } {3 4.53 {} 2 hello world 1 2 3}
+do_execsql_test whereA-1.8 {
+  SELECT * FROM t1 WHERE b=2 AND a IS NULL;
+} {}
+do_execsql_test whereA-1.9 {
+  SELECT * FROM t1 WHERE b=2 AND a IS NOT NULL;
+} {1 2 3}
 
 do_test whereA-2.1 {
   db eval {
     PRAGMA reverse_unordered_selects=0;
     SELECT * FROM t1 WHERE a>0;
   }
 } {1 2 3 2 hello world 3 4.53 {}}
 do_test whereA-2.2 {
   db eval {
     PRAGMA reverse_unordered_selects=1;
@@ skipping 66 matching lines @@
   }
 } {1 2 1}
 do_test whereA-4.6 {
   count {
     SELECT x FROM t2 ORDER BY x DESC;
   }
 } {2 1 1}
 
 
 finish_test