Import SQLite 3.8.7.4.

third_party/sqlite/src/test/misc5.test

 # 2005 Mar 16
 #
 # 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 487 matching lines @@
             GROUP BY LOWER(artist)      
             ORDER BY total DESC      
             LIMIT 10    
           )    
           WHERE artist <> '' 
         )  
        )       
       )  
       ORDER BY LOWER(artist) ASC;
     }
-  } {one}
+  } {two}
 }
 
 # Ticket #1370.  Do not overwrite small files (less than 1024 bytes)
 # when trying to open them as a database.
 #
 if {[permutation] == ""} {
   do_test misc5-4.1 {
     db close
-    file delete -force test.db
+    forcedelete test.db
     set fd [open test.db w]
     puts $fd "This is not really a database"
     close $fd
     sqlite3 db test.db
     catchsql {
       CREATE TABLE t1(a,b,c);
     }
   } {1 {file is encrypted or is not a database}}
 }
 
 # Ticket #1371.  Allow floating point numbers of the form .N  or N.
 #
 do_test misc5-5.1 {
   execsql {SELECT .1 }
 } 0.1
 do_test misc5-5.2 {
   execsql {SELECT 2. }
 } 2.0
 do_test misc5-5.3 {
   execsql {SELECT 3.e0 }
 } 3.0
 do_test misc5-5.4 {
   execsql {SELECT .4e+1}
 } 4.0
 
 # Ticket #1582.  Ensure that an unknown table in a LIMIT clause applied to
 # a UNION ALL query causes an error, not a crash.
 #
 db close
-file delete -force test.db
+forcedelete test.db
 sqlite3 db test.db
 ifcapable subquery&&compound {
   do_test misc5-6.1 {
     catchsql {
       SELECT * FROM sqlite_master 
       UNION ALL 
       SELECT * FROM sqlite_master
       LIMIT (SELECT count(*) FROM blah);
     }
   } {1 {no such table: blah}}
@@ skipping 1307 matching lines @@
 2305843009213693954\
 4611686018427387902\
 4611686018427387903\
 4611686018427387904\
 4611686018427387905\
 4611686018427387906\
 9223372036854775806\
 9223372036854775807}
 
 finish_test