Import SQLite 3.7.6.3.

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 15 matching lines @@
   }
 } {1 2 3 2 hello world 3 4.53 {}}
 do_test whereA-1.2 {
   db eval {
     PRAGMA reverse_unordered_selects=1;
     SELECT * FROM t1;
   }
 } {3 4.53 {} 2 hello world 1 2 3}
 
 do_test whereA-1.3 {
+  db close
+  sqlite3 db test.db
+  db eval {
+    PRAGMA reverse_unordered_selects=1;
+    SELECT * FROM t1;
+  }
+} {3 4.53 {} 2 hello world 1 2 3}
+do_test whereA-1.4 {
+  db close
+  sqlite3 db test.db
   db eval {
     PRAGMA reverse_unordered_selects=1;
     SELECT * FROM t1 ORDER BY rowid;
   }
 } {1 2 3 2 hello world 3 4.53 {}}
+do_test whereA-1.5 {
+  db eval {
+    VACUUM;
+    SELECT * FROM t1 ORDER BY rowid;
+  }
+} {1 2 3 2 hello world 3 4.53 {}}
+do_test whereA-1.6 {
+  db eval {
+    PRAGMA reverse_unordered_selects;
+  }
+} {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_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