Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update another test case in wal.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | wal-incr-ckpt |
| Files: | files | file ages | folders |
| SHA1: |
99fde69e61d12cf95b47db70c4647c30 |
| User & Date: | dan 2010-05-31 14:18:46 |
Context
|
2010-05-31
| ||
| 14:28 | Remove the tests that enable tracing based on the existance of the "vdbe_*" files when in SQLITE_DEBUG mode. check-in: cdbb4e7c user: drh tags: wal-incr-ckpt | |
| 14:18 | Update another test case in wal.test. check-in: 99fde69e user: dan tags: wal-incr-ckpt | |
| 13:11 | Change WAL test cases to account for the improved concurrency in the new checkpoint logic. check-in: 2d6f2485 user: drh tags: wal-incr-ckpt | |
Changes
Changes to test/wal.test.
1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 |
do_test wal-15.3.2 {
sqlite3_errcode db
} {SQLITE_LOCKED}
do_test wal-15.3.3 {
sqlite3_errmsg db
} {database table is locked}
# Also test that an error is returned if the db cannot be checkpointed
# because of locks held by another connection.
#
sqlite3 db2 test.db
do_test wal-15.4.1 {
execsql {
BEGIN;
SELECT * FROM t1;
} db2
} {1 2}
do_test wal-15.4.2 {
execsql { COMMIT }
sqlite3_wal_checkpoint db
} {SQLITE_BUSY}
do_test wal-15.4.3 {
sqlite3_errmsg db
} {database is locked}
# After [db2] drops its lock, [db] may checkpoint the db.
#
do_test wal-15.4.4 {
execsql { COMMIT } db2
sqlite3_wal_checkpoint db
} {SQLITE_OK}
|
| | > | | |
1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 |
do_test wal-15.3.2 {
sqlite3_errcode db
} {SQLITE_LOCKED}
do_test wal-15.3.3 {
sqlite3_errmsg db
} {database table is locked}
# Earlier versions returned an error is returned if the db cannot be
# checkpointed because of locks held by another connection. Check that
# this is no longer the case.
#
sqlite3 db2 test.db
do_test wal-15.4.1 {
execsql {
BEGIN;
SELECT * FROM t1;
} db2
} {1 2}
do_test wal-15.4.2 {
execsql { COMMIT }
sqlite3_wal_checkpoint db
} {SQLITE_OK}
do_test wal-15.4.3 {
sqlite3_errmsg db
} {not an error}
# After [db2] drops its lock, [db] may checkpoint the db.
#
do_test wal-15.4.4 {
execsql { COMMIT } db2
sqlite3_wal_checkpoint db
} {SQLITE_OK}
|