Import SQLite 3.8.7.4.

third_party/sqlite/src/test/descidx1.test

 # 2005 December 21
 #
 # 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 179 matching lines @@
       SELECT count(*) FROM t2;
     }
   } {9}
   do_test descidx1-4.2 {
     execsql {
       SELECT d FROM t2 ORDER BY a;
     }
   } {1.0 2.2 2.0 2.1 2.3 3.0 4.0 5.0 6.0}
   do_test descidx1-4.3 {
     execsql {
-      SELECT d FROM t2 WHERE a>=2;
+      SELECT d FROM t2 WHERE a>=2 ORDER BY a;
     }
   } {2.2 2.0 2.1 2.3 3.0 4.0 5.0 6.0}
   do_test descidx1-4.4 {
     execsql {
-      SELECT d FROM t2 WHERE a>2;
+      SELECT d FROM t2 WHERE a>2 ORDER BY a;
     }
   } {3.0 4.0 5.0 6.0}
   do_test descidx1-4.5 {
     execsql {
       SELECT d FROM t2 WHERE a=2 AND b>'two';
     }
   } {2.2}
   do_test descidx1-4.6 {
     execsql {
       SELECT d FROM t2 WHERE a=2 AND b>='two';
@@ skipping 74 matching lines @@
     SELECT a||b||c FROM t3 WHERE d=0 ORDER BY a DESC, b DESC, c ASC
   }
 } {110 111 100 101 010 011 000 001 sort}
 
 # Test the legacy_file_format pragma here because we have access to
 # the get_file_format command.
 #
 ifcapable legacyformat {
   do_test descidx1-6.1 {
     db close
-    file delete -force test.db test.db-journal
+    forcedelete test.db test.db-journal
     sqlite3 db test.db
     execsql {PRAGMA legacy_file_format}
   } {1}
 } else {
   do_test descidx1-6.1 {
     db close
-    file delete -force test.db test.db-journal
+    forcedelete test.db test.db-journal
     sqlite3 db test.db
     execsql {PRAGMA legacy_file_format}
   } {0}
 }
 do_test descidx1-6.2 {
   execsql {PRAGMA legacy_file_format=YES}
   execsql {PRAGMA legacy_file_format}
 } {1}
 do_test descidx1-6.3 {
   execsql {
     CREATE TABLE t1(a,b,c);
   }
   get_file_format
 } {1}
 ifcapable vacuum {
   # Verify that the file format is preserved across a vacuum.
   do_test descidx1-6.3.1 {
     execsql {VACUUM}
     get_file_format
   } {1}
 }
 do_test descidx1-6.4 {
   db close
-  file delete -force test.db test.db-journal
+  forcedelete test.db test.db-journal
   sqlite3 db test.db
   execsql {PRAGMA legacy_file_format=NO}
   execsql {PRAGMA legacy_file_format}
 } {0}
 do_test descidx1-6.5 {
   execsql {
     CREATE TABLE t1(a,b,c);
     CREATE INDEX i1 ON t1(a ASC, b DESC, c ASC);
     INSERT INTO t1 VALUES(1,2,3);
     INSERT INTO t1 VALUES(1,1,0);
@@ skipping 13 matching lines @@
       PRAGMA legacy_file_format=ON;
       VACUUM;
     }
     get_file_format
   } {4}
 } 
 
 
 
 finish_test