Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix the wal7.test script so that it works even if secure_delete is engaged. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
68fb7a548c8fe00bcb9c6d71f2863b55 |
| User & Date: | drh 2011-06-15 16:07:30 |
Context
|
2011-06-15
| ||
| 17:04 | Add a couple of pointer type casts to test file test_quota.c. check-in: 0df061b0 user: dan tags: trunk | |
| 16:07 | Fix the wal7.test script so that it works even if secure_delete is engaged. check-in: 68fb7a54 user: drh tags: trunk | |
| 13:11 | Merge the improved incremental doclist loading test from the broken-build branch (which is now fixed) into trunk. check-in: f9750870 user: drh tags: trunk | |
Changes
Changes to test/wal7.test.
57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 .. 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 ... 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 |
PRAGMA wal_autocheckpoint=50; -- 50 pages
PRAGMA journal_size_limit=25000;
CREATE TABLE t1(x, y UNIQUE);
INSERT INTO t1 VALUES(1,2);
INSERT INTO t1 VALUES(zeroblob(200000),4);
CREATE TABLE t2(z);
DELETE FROM t1;
INSERT INTO t2 SELECT x FROM t1;
}
file size test.db-wal
} 25000
# Case 3: Size limit of zero.
#
................................................................................
PRAGMA wal_autocheckpoint=50; -- 50 pages
PRAGMA journal_size_limit=0;
CREATE TABLE t1(x, y UNIQUE);
INSERT INTO t1 VALUES(1,2);
INSERT INTO t1 VALUES(zeroblob(200000),4);
CREATE TABLE t2(z);
DELETE FROM t1;
INSERT INTO t2 SELECT x FROM t1;
}
set sz [file size test.db-wal]
expr {$sz>0 && $sz<10000}
} 1
# Case 4: Size limit set before going WAL
................................................................................
PRAGMA journal_mode=WAL;
PRAGMA wal_autocheckpoint=50; -- 50 pages
CREATE TABLE t1(x, y UNIQUE);
INSERT INTO t1 VALUES(1,2);
INSERT INTO t1 VALUES(zeroblob(200000),4);
CREATE TABLE t2(z);
DELETE FROM t1;
INSERT INTO t2 SELECT x FROM t1;
}
set sz [file size test.db-wal]
} 25000
finish_test
|
| | | |
57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 .. 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 ... 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 |
PRAGMA wal_autocheckpoint=50; -- 50 pages
PRAGMA journal_size_limit=25000;
CREATE TABLE t1(x, y UNIQUE);
INSERT INTO t1 VALUES(1,2);
INSERT INTO t1 VALUES(zeroblob(200000),4);
CREATE TABLE t2(z);
DELETE FROM t1;
INSERT INTO t2 VALUES(1);
}
file size test.db-wal
} 25000
# Case 3: Size limit of zero.
#
................................................................................
PRAGMA wal_autocheckpoint=50; -- 50 pages
PRAGMA journal_size_limit=0;
CREATE TABLE t1(x, y UNIQUE);
INSERT INTO t1 VALUES(1,2);
INSERT INTO t1 VALUES(zeroblob(200000),4);
CREATE TABLE t2(z);
DELETE FROM t1;
INSERT INTO t2 VALUES(1);
}
set sz [file size test.db-wal]
expr {$sz>0 && $sz<10000}
} 1
# Case 4: Size limit set before going WAL
................................................................................
PRAGMA journal_mode=WAL;
PRAGMA wal_autocheckpoint=50; -- 50 pages
CREATE TABLE t1(x, y UNIQUE);
INSERT INTO t1 VALUES(1,2);
INSERT INTO t1 VALUES(zeroblob(200000),4);
CREATE TABLE t2(z);
DELETE FROM t1;
INSERT INTO t2 VALUES(1);
}
set sz [file size test.db-wal]
} 25000
finish_test
|