/ Check-in [1a5aa734]
Login

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

Overview
Comment:Add extra test case to wal2recover.test.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | wal2
Files: files | file ages | folders
SHA3-256: 1a5aa73435b11fff0567672dc921d34aad57adf0381ad430e1389f39a6f025b7
User & Date: dan 2018-12-17 15:22:24
Wiki:wal2
Context
2018-12-22
15:50
Enhance the wal2 header comment in wal.c to explain how the wal-hook is invoked in wal2 mode. check-in: 118aa7e3 user: dan tags: wal2
2018-12-17
15:22
Merge changes from wal2 branch. check-in: 85f49f0d user: dan tags: begin-concurrent-wal2
15:22
Add extra test case to wal2recover.test. check-in: 1a5aa734 user: dan tags: wal2
2018-12-15
20:20
Further test cases for wal2 mode. check-in: 9cb5f8da user: dan tags: wal2
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/wal2recover.test.

   222    222       PRAGMA integrity_check;
   223    223     }
   224    224   } {211 ok}
   225    225   
   226    226   do_test 3.5 {
   227    227     list [file size test.db] [file size test.db-wal] [file size test.db-wal2]
   228    228   } {5120 15752 18896}
          229  +
          230  +#-------------------------------------------------------------------------
          231  +#
          232  +reset_db
          233  +do_execsql_test 4.0 {
          234  +  PRAGMA journal_mode = wal2;
          235  +  CREATE TABLE xyz(x, y, z);
          236  +  INSERT INTO xyz VALUES('x', 'y', 'z');
          237  +} {wal2}
          238  +db close
          239  +do_test 4.1 {
          240  +  close [open test.db-wal w]
          241  +  file mkdir test.db-wal2
          242  +  sqlite3 db test.db
          243  +  catchsql { SELECT * FROM xyz }
          244  +} {1 {unable to open database file}}
          245  +db close
          246  +file delete test.db-wal2
          247  +
          248  +do_test 4.2 {
          249  +  sqlite3 db test.db
          250  +  execsql { 
          251  +    INSERT INTO xyz VALUES('a', 'b', 'c');
          252  +  }
          253  +  forcecopy test.db test.db2
          254  +  forcecopy test.db-wal test.db2-wal
          255  +  forcedelete test.db2-wal2
          256  +  file mkdir test.db2-wal2
          257  +  sqlite3 db2 test.db2
          258  +  catchsql { SELECT * FROM xyz } db2
          259  +} {1 {unable to open database file}}
          260  +db2 close
          261  +file delete test.db2-wal2
   229    262   
   230    263   
   231    264   finish_test
   232    265