Import SQLite 3.8.7.4.

third_party/sqlite/src/test/autoinc.test

 # 2004 November 12
 #
 # 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 198 matching lines @@
     SELECT * FROM t1;
   }
 } {235 1 1235 2 1236 3 1237 4 1238 5}
 do_test autoinc-2.27 {
   execsql {
     SELECT * FROM sqlite_sequence;
   }
 } {t1 1238}
 do_test autoinc-2.28 {
   execsql {
-    UPDATE sqlite_sequence SET seq='12345678901234567890'
+    UPDATE sqlite_sequence SET seq='-12345678901234567890'
       WHERE name='t1';
     INSERT INTO t1 VALUES(NULL,6);
     SELECT * FROM t1;
   }
 } {235 1 1235 2 1236 3 1237 4 1238 5 1239 6}
 do_test autoinc-2.29 {
   execsql {
     SELECT * FROM sqlite_sequence;
   }
 } {t1 1239}
@@ skipping 190 matching lines @@
       SELECT 1, * FROM main.sqlite_sequence;
       SELECT 2, * FROM temp.sqlite_sequence;
     }
   } {}
 }
 
 # Make sure AUTOINCREMENT works on ATTACH-ed tables.
 #
 ifcapable tempdb&&attach {
   do_test autoinc-5.1 {
-    file delete -force test2.db
-    file delete -force test2.db-journal
+    forcedelete test2.db
+    forcedelete test2.db-journal
     sqlite3 db2 test2.db
     execsql {
       CREATE TABLE t4(m INTEGER PRIMARY KEY AUTOINCREMENT, n);
       CREATE TABLE t5(o, p INTEGER PRIMARY KEY AUTOINCREMENT);
     } db2;
     execsql {
       ATTACH 'test2.db' as aux;
       SELECT 1, * FROM main.sqlite_sequence;
       SELECT 2, * FROM temp.sqlite_sequence;
       SELECT 3, * FROM aux.sqlite_sequence;
@@ skipping 71 matching lines @@
   }
 } {1 {AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY}}
 
 
 # Ticket #1283.  Make sure that preparing but never running a statement
 # that creates the sqlite_sequence table does not mess up the database.
 #
 do_test autoinc-8.1 {
   catch {db2 close}
   catch {db close}
-  file delete -force test.db
+  forcedelete test.db
   sqlite3 db test.db
   set DB [sqlite3_connection_pointer db]
   set STMT [sqlite3_prepare $DB {
      CREATE TABLE t1(
        x INTEGER PRIMARY KEY AUTOINCREMENT
      )
   } -1 TAIL]
   sqlite3_finalize $STMT
   set STMT [sqlite3_prepare $DB {
      CREATE TABLE t1(
@@ skipping 125 matching lines @@
       END;
       INSERT INTO va69637_2 VALUES(123);
       SELECT * FROM ta69637_1;
     }
   } {1 124 2 10123}
 }
 
 
 
 finish_test