Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fixed a few tests in pagerfault.test so they work correctly on Windows. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
ffbdd954a05c003a213069e39ad0655e |
| User & Date: | shaneh 2010-07-08 13:33:47 |
Context
|
2010-07-08
| ||
| 14:59 | Fix to lock5.test so that it runs with the inmemory_journal permutation on osx. check-in: 948bb545 user: dan tags: trunk | |
| 13:33 | Fixed a few tests in pagerfault.test so they work correctly on Windows. check-in: ffbdd954 user: shaneh tags: trunk | |
| 09:44 | Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a]. check-in: f553c8ed user: dan tags: trunk | |
Changes
Changes to test/pagerfault.test.
675 676 677 678 679 680 681 682 683 684 685 686 687 688 ... 689 690 691 692 693 694 695 696 697 698 699 700 701 702 ... 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 |
faultsim_restore_and_reopen
} -body {
if {[catch {db backup test.db2} msg]} { error [regsub {.*: } $msg {}] }
} -test {
faultsim_test_result {0 {}} {1 {}} {1 {SQL logic error or missing database}}
}
do_faultsim_test pagerfault-14b -prep {
faultsim_restore_and_reopen
sqlite3 db2 ""
db2 eval { PRAGMA page_size = 4096; CREATE TABLE xx(a) }
} -body {
sqlite3_backup B db2 main db main
B step 200
set rc [B finish]
................................................................................
if {[string match SQLITE_IOERR_* $rc]} {set rc SQLITE_IOERR}
if {$rc != "SQLITE_OK"} { error [sqlite3_test_errstr $rc] }
set {} {}
} -test {
faultsim_test_result {0 {}}
}
do_faultsim_test pagerfault-14c -prep {
faultsim_restore_and_reopen
sqlite3 db2 test.db2
db2 eval {
PRAGMA synchronous = off;
PRAGMA page_size = 4096;
CREATE TABLE xx(a);
}
................................................................................
} -body {
execsql { PRAGMA journal_mode = delete }
} -test {
faultsim_test_result {0 delete}
faultsim_integrity_check
}
do_faultsim_test pagerfault-17d -prep {
faultsim_restore_and_reopen
sqlite3 db2 test.db
execsql { PRAGMA journal_mode = delete }
execsql { PRAGMA journal_mode = wal }
execsql { INSERT INTO t1 VALUES(99, 'Bradman') } db2
} -body {
execsql { PRAGMA journal_mode = delete }
} -test {
faultsim_test_result {1 {database is locked}}
faultsim_integrity_check
}
do_faultsim_test pagerfault-17e -prep {
faultsim_restore_and_reopen
sqlite3 db2 test.db
execsql { PRAGMA journal_mode = delete }
execsql { PRAGMA journal_mode = wal }
set ::chan [launch_testfixture]
testfixture $::chan {
sqlite3 db test.db
|
> > > > |
675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 ... 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 ... 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 |
faultsim_restore_and_reopen
} -body {
if {[catch {db backup test.db2} msg]} { error [regsub {.*: } $msg {}] }
} -test {
faultsim_test_result {0 {}} {1 {}} {1 {SQL logic error or missing database}}
}
do_faultsim_test pagerfault-14b -prep {
catch { db2 close }
faultsim_restore_and_reopen
sqlite3 db2 ""
db2 eval { PRAGMA page_size = 4096; CREATE TABLE xx(a) }
} -body {
sqlite3_backup B db2 main db main
B step 200
set rc [B finish]
................................................................................
if {[string match SQLITE_IOERR_* $rc]} {set rc SQLITE_IOERR}
if {$rc != "SQLITE_OK"} { error [sqlite3_test_errstr $rc] }
set {} {}
} -test {
faultsim_test_result {0 {}}
}
do_faultsim_test pagerfault-14c -prep {
catch { db2 close }
faultsim_restore_and_reopen
sqlite3 db2 test.db2
db2 eval {
PRAGMA synchronous = off;
PRAGMA page_size = 4096;
CREATE TABLE xx(a);
}
................................................................................
} -body {
execsql { PRAGMA journal_mode = delete }
} -test {
faultsim_test_result {0 delete}
faultsim_integrity_check
}
do_faultsim_test pagerfault-17d -prep {
catch { db2 close }
faultsim_restore_and_reopen
sqlite3 db2 test.db
execsql { PRAGMA journal_mode = delete }
execsql { PRAGMA journal_mode = wal }
execsql { INSERT INTO t1 VALUES(99, 'Bradman') } db2
} -body {
execsql { PRAGMA journal_mode = delete }
} -test {
faultsim_test_result {1 {database is locked}}
faultsim_integrity_check
}
do_faultsim_test pagerfault-17e -prep {
catch { db2 close }
faultsim_restore_and_reopen
sqlite3 db2 test.db
execsql { PRAGMA journal_mode = delete }
execsql { PRAGMA journal_mode = wal }
set ::chan [launch_testfixture]
testfixture $::chan {
sqlite3 db test.db
|