/ Check-in [6a818afb]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix the wal2.test script so that it works in auto_vacuum mode.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 6a818afb93ca8383abb55e3835e14c74c3e3de23
User & Date: drh 2010-05-24 17:00:20
Context
2010-05-24
20:24
Remove the walmode.test case from the inmemory_journal test of permutations.test. check-in: 27ba9c21 user: drh tags: trunk
17:00
Fix the wal2.test script so that it works in auto_vacuum mode. check-in: 6a818afb user: drh tags: trunk
13:57
Change the checksum used in WAL files so that each frames checksum depends on the content of the WAL header and all frame headers and content up to and including the frame to which the checksum is attached. check-in: 8a53f12c user: dan tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/wal2.test.

634
635
636
637
638
639
640

641
642
643
644
645
646
647
...
675
676
677
678
679
680
681
682
} {}
db2 close

file delete -force test.db test.db-wal test.db-journal
do_test wal2-8.1.2 {
  sqlite3 db test.db
  execsql {

    PRAGMA page_size = 1024;
    PRAGMA journal_mode = WAL;
    CREATE TABLE t1(x);
    INSERT INTO t1 VALUES(zeroblob(8188*1020));
    CREATE TABLE t2(y);
  }
  execsql {
................................................................................
  sqlite3 db2 test.db
  execsql { SELECT * FROM t2 }
} {goodbye}
db2 close


finish_test








>







 







<
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
...
676
677
678
679
680
681
682

} {}
db2 close

file delete -force test.db test.db-wal test.db-journal
do_test wal2-8.1.2 {
  sqlite3 db test.db
  execsql {
    PRAGMA auto_vacuum=OFF;
    PRAGMA page_size = 1024;
    PRAGMA journal_mode = WAL;
    CREATE TABLE t1(x);
    INSERT INTO t1 VALUES(zeroblob(8188*1020));
    CREATE TABLE t2(y);
  }
  execsql {
................................................................................
  sqlite3 db2 test.db
  execsql { SELECT * FROM t2 }
} {goodbye}
db2 close


finish_test