AryaWu/sqlite

1# 2005 March 152#3# The author disclaims copyright to this source code.  In place of4# a legal notice, here is a blessing:5#6#    May you do good and not evil.7#    May you find forgiveness for yourself and forgive others.8#    May you share freely, never taking more than you give.9#10#***********************************************************************11# This file implements regression tests for SQLite library.12#13# This file implements tests to make sure that leftover journals from14# prior databases do not try to rollback into new databases.15#16# $Id: journal1.test,v 1.2 2005/03/20 22:54:56 drh Exp $17 18 19set testdir [file dirname $argv0]20source $testdir/tester.tcl21 22# These tests will not work on windows because windows uses23# manditory file locking which breaks the copy_file command.24#25# Or with atomic_batch_write systems, as journal files are26# not created.27#28if {$tcl_platform(platform) eq "windows"29 || [atomic_batch_write test.db]30} {31  finish_test32  return33}34 35# Create a smaple database36#37do_test journal1-1.1 {38  execsql {39    CREATE TABLE t1(a,b);40    INSERT INTO t1 VALUES(1,randstr(10,400));41    INSERT INTO t1 VALUES(2,randstr(10,400));42    INSERT INTO t1 SELECT a+2, a||b FROM t1;43    INSERT INTO t1 SELECT a+4, a||b FROM t1;44    SELECT count(*) FROM t1;45  }46} 847 48# Make changes to the database and save the journal file.49# Then delete the database.  Replace the journal file50# and try to create a new database with the same name.  The51# old journal should not attempt to rollback into the new52# database.53#54do_test journal1-1.2 {55  execsql {56    BEGIN;57    DELETE FROM t1;58  }59  forcecopy test.db-journal test.db-journal-bu60  execsql {61    ROLLBACK;62  }63  db close64  delete_file test.db65  copy_file test.db-journal-bu test.db-journal66  sqlite3 db test.db67  catchsql {68    SELECT * FROM sqlite_master69  }70} {0 {}}71 72finish_test73