/ Check-in [6ba6e59a]
Login

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

Overview
Comment:Fix walmode.test so that all tests pass with SQLITE_TEMP_STORE=3.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 6ba6e59a9d528fb1bdc530d48ab96a2de6e190d6
User & Date: dan 2010-09-13 19:03:38
Context
2010-09-14
10:53
Fix some test failures found running releasetest.tcl. check-in: 56a9ce77 user: dan tags: trunk
2010-09-13
19:03
Fix walmode.test so that all tests pass with SQLITE_TEMP_STORE=3. check-in: 6ba6e59a user: dan tags: trunk
18:58
Add tests for compound SELECT statements to e_select.test. check-in: 8b0b009f user: dan tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/walmode.test.

   203    203     execsql { 
   204    204       INSERT INTO t1 VALUES(3, 4);
   205    205       SELECT * FROM t1;
   206    206       PRAGMA main.journal_mode;
   207    207     }
   208    208   } {1 2 3 4 memory}
   209    209   
          210  +if {$TEMP_STORE>=2} {
          211  +  set tempJrnlMode memory
          212  +} else {
          213  +  set tempJrnlMode delete
          214  +}
   210    215   do_test walmode-5.2.1 {
   211    216     sqlite3 db ""
   212    217     execsql { PRAGMA main.journal_mode }
   213         -} {delete}
          218  +} $tempJrnlMode
   214    219   do_test walmode-5.2.2 {
   215    220     execsql { PRAGMA main.journal_mode = wal }
   216         -} {delete}
          221  +} $tempJrnlMode
   217    222   do_test walmode-5.2.3 {
   218    223     execsql {
   219    224       BEGIN;
   220    225         CREATE TABLE t1(a, b);
   221    226         INSERT INTO t1 VALUES(1, 2);
   222    227       COMMIT;
   223    228       SELECT * FROM t1;
   224    229       PRAGMA main.journal_mode;
   225    230     }
   226         -} {1 2 delete}
          231  +} [list 1 2 $tempJrnlMode]
   227    232   do_test walmode-5.2.4 {
   228    233     execsql { PRAGMA main.journal_mode = wal }
   229         -} {delete}
          234  +} $tempJrnlMode
   230    235   do_test walmode-5.2.5 {
   231    236     execsql { 
   232    237       INSERT INTO t1 VALUES(3, 4);
   233    238       SELECT * FROM t1;
   234    239       PRAGMA main.journal_mode;
   235    240     }
   236         -} {1 2 3 4 delete}
          241  +} [list 1 2 3 4 $tempJrnlMode]
   237    242   
   238         -if {$TEMP_STORE>=2} {
   239         -  set tempJrnlMode memory
   240         -} else {
   241         -  set tempJrnlMode delete
   242         -}
   243    243   do_test walmode-5.3.1 {
   244    244     sqlite3 db test.db
   245    245     execsql { PRAGMA temp.journal_mode }
   246    246   } $tempJrnlMode
   247    247   do_test walmode-5.3.2 {
   248    248     execsql { PRAGMA temp.journal_mode = wal }
   249    249   } $tempJrnlMode