/ Check-in [5d7c0928]
Login

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

Overview
Comment:Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5d7c092869137a0ba69f93324fe4ed56a05b5985
User & Date: dan 2016-02-01 16:36:47
Context
2016-02-01
17:20
Number VDBE opcodes starting with 0 instead of 1, as this obviates the lower-bound test on "switch(opcode){...}", making the code smaller and faster. check-in: 4c9222f7 user: drh tags: trunk
16:36
Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times. check-in: 5d7c0928 user: dan tags: trunk
13:58
Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30. check-in: a17712bf user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/walcrash.test.

   233    233         INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 28 */
   234    234         INSERT INTO t1 SELECT randomblob(900) FROM t1 LIMIT 4;   /* 32 */
   235    235   
   236    236         PRAGMA wal_checkpoint;
   237    237         INSERT INTO t1 VALUES(randomblob(9000));
   238    238         INSERT INTO t1 VALUES(randomblob(9000));
   239    239         INSERT INTO t1 VALUES(randomblob(9000));
          240  +      INSERT INTO t1 VALUES(randomblob(9000));
   240    241       }
   241    242     } {1 {child process exited abnormally}}
   242    243   
   243    244     do_test walcrash-6.$i.2 {
   244    245       sqlite3 db test.db
   245         -    execsql { SELECT count(*)==34 OR count(*)==35 FROM t1 WHERE x != 1 }
          246  +    execsql { SELECT count(*) BETWEEN 34 AND 36 FROM t1 WHERE x != 1 }
   246    247     } {1}
   247    248     do_test walcrash-6.$i.3 { execsql { PRAGMA main.integrity_check } } {ok}
   248    249     do_test walcrash-6.$i.4 { execsql { PRAGMA main.journal_mode } } {wal}
   249    250   
   250    251     db close
   251    252   }
   252    253