SQLite

Check-in [a79914ccbc]
Login

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

Overview
Comment:Adjustment to tests for PRAGMA integrity_check so that they run under windows. (CVS 3613)
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: a79914ccbc9e33a1dbc9be3de805f99ab3b61c78
User & Date: drh 2007-01-27 14:04:13.000
Context
2007-01-27
14:11
More adjustments to the pragma test for windows. (CVS 3614) (check-in: 79a65436d1 user: drh tags: trunk)
14:04
Adjustment to tests for PRAGMA integrity_check so that they run under windows. (CVS 3613) (check-in: a79914ccbc user: drh tags: trunk)
13:38
Increment the version number in preparation for the 3.3.12 release. (CVS 3612) (check-in: 24e465af92 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/pragma.test.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library.
#
# This file implements tests for the PRAGMA command.
#
# $Id: pragma.test,v 1.48 2007/01/27 02:24:56 drh Exp $

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

# Test organization:
#
# pragma-1.*: Test cache_size, default_cache_size and synchronous on main db.







|







8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#    May you share freely, never taking more than you give.
#
#***********************************************************************
# This file implements regression tests for SQLite library.
#
# This file implements tests for the PRAGMA command.
#
# $Id: pragma.test,v 1.49 2007/01/27 14:04:13 drh Exp $

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

# Test organization:
#
# pragma-1.*: Test cache_size, default_cache_size and synchronous on main db.
385
386
387
388
389
390
391
392
393
394
395

396
397
398
399
400
401
402
    }
  } {{*** in database t2 ***
Page 4 is never used
Page 5 is never used
Page 6 is never used} {rowid 1 missing from index i2}}
}
do_test pragma-3.99 {
  file delete -force testerr.db testerr.db-journal
  catchsql {DETACH t3}
  catchsql {DETACH t2}
  catchsql {DROP INDEX i2}

} {0 {}}

# Test modifying the cache_size of an attached database.
ifcapable pager_pragmas {
do_test pragma-4.1 {
  execsql {
    pragma aux.cache_size;







<



>







385
386
387
388
389
390
391

392
393
394
395
396
397
398
399
400
401
402
    }
  } {{*** in database t2 ***
Page 4 is never used
Page 5 is never used
Page 6 is never used} {rowid 1 missing from index i2}}
}
do_test pragma-3.99 {

  catchsql {DETACH t3}
  catchsql {DETACH t2}
  catchsql {DROP INDEX i2}
  file delete -force testerr.db testerr.db-journal
} {0 {}}

# Test modifying the cache_size of an attached database.
ifcapable pager_pragmas {
do_test pragma-4.1 {
  execsql {
    pragma aux.cache_size;