/ Check-in [b47ddefc]
Login

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

Overview
Comment:Fix jrnlmode.test so that it does not run tests involving in-memory journals during the "journaltest" permutation. (CVS 6166)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:b47ddefc772ee59aa1509ab8d8f229a3d7c4ddaf
User & Date: danielk1977 2009-01-11 05:54:40
Context
2009-01-11
17:00
Fix an assert() so that it works correctly with SQLITE_TEMP_STORE=3. (CVS 6167) check-in: fd2bbcf8 user: drh tags: trunk
05:54
Fix jrnlmode.test so that it does not run tests involving in-memory journals during the "journaltest" permutation. (CVS 6166) check-in: b47ddefc user: danielk1977 tags: trunk
00:44
The crash8.test depends on auto_vacuum being off. Make sure that is the case. (CVS 6165) check-in: 3538d2a9 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to test/jrnlmode.test.

7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
435
436
437
438
439
440
441




442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480

481
482
#    May you find forgiveness for yourself and forgive others.
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library. The focus
# of these tests is the journal mode pragma.
#
# $Id: jrnlmode.test,v 1.11 2009/01/10 16:15:09 danielk1977 Exp $

set testdir [file dirname $argv0]
source $testdir/tester.tcl

ifcapable {!pager_pragmas} {
  finish_test
  return
................................................................................
  do_test jrnlmode-5.22 {
    execsql COMMIT
    list [file exists test.db-journal] [file size test.db-journal]
  } {1 0}
}

ifcapable pragma {




  do_test jrnlmode-6.1 {
    execsql {
      PRAGMA journal_mode = truncate;
      CREATE TABLE t4(a, b);
      BEGIN;
        INSERT INTO t4 VALUES(1, 2);
        PRAGMA journal_mode = memory;
    }
  } {truncate memory}
  do_test jrnlmode-6.2 {
    file exists test.db-journal
  } {1}
  do_test jrnlmode-6.3 {
    execsql {
      COMMIT;
      SELECT * FROM t4;
    }
  } {1 2}
  do_test jrnlmode-6.4 {
    file exists test.db-journal
  } {0}
  do_test jrnlmode-6.5 {
    execsql {
      BEGIN;
        INSERT INTO t4 VALUES(3, 4);
    }
    file exists test.db-journal
  } {0}
  do_test jrnlmode-6.7 {
    execsql {
      COMMIT;
      SELECT * FROM t4;
    }
  } {1 2 3 4}
  do_test jrnlmode-6.8 {
    file exists test.db-journal
  } {0}
}


finish_test








|







 







>
>
>
>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
>


7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
#    May you find forgiveness for yourself and forgive others.
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library. The focus
# of these tests is the journal mode pragma.
#
# $Id: jrnlmode.test,v 1.12 2009/01/11 05:54:40 danielk1977 Exp $

set testdir [file dirname $argv0]
source $testdir/tester.tcl

ifcapable {!pager_pragmas} {
  finish_test
  return
................................................................................
  do_test jrnlmode-5.22 {
    execsql COMMIT
    list [file exists test.db-journal] [file size test.db-journal]
  } {1 0}
}

ifcapable pragma {
  # These tests are not run as part of the "journaltest" permutation,
  # as the test_journal.c layer is incompatible with in-memory journaling.
  if {[catch {set ::permutations_test_prefix} z] || $z ne "journaltest"} {

    do_test jrnlmode-6.1 {
      execsql {
        PRAGMA journal_mode = truncate;
        CREATE TABLE t4(a, b);
        BEGIN;
          INSERT INTO t4 VALUES(1, 2);
          PRAGMA journal_mode = memory;
      }
    } {truncate memory}
    do_test jrnlmode-6.2 {
      file exists test.db-journal
    } {1}
    do_test jrnlmode-6.3 {
      execsql {
        COMMIT;
        SELECT * FROM t4;
      }
    } {1 2}
    do_test jrnlmode-6.4 {
      file exists test.db-journal
    } {0}
    do_test jrnlmode-6.5 {
      execsql {
        BEGIN;
          INSERT INTO t4 VALUES(3, 4);
      }
      file exists test.db-journal
    } {0}
    do_test jrnlmode-6.7 {
      execsql {
        COMMIT;
        SELECT * FROM t4;
      }
    } {1 2 3 4}
    do_test jrnlmode-6.8 {
      file exists test.db-journal
    } {0}
  }
}

finish_test