Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix other problems in the WAL test scripts. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | wal |
| Files: | files | file ages | folders |
| SHA1: |
dcb31181db246dd3f81ce63b144dd0cf |
| User & Date: | dan 2010-04-13 11:45:31 |
Context
|
2010-04-13
| ||
| 11:56 | Remove old code to interpret an argument (no longer used) to "PRAGMA checkpoint". check-in: 27dc5977 user: dan tags: wal | |
| 11:45 | Fix other problems in the WAL test scripts. check-in: dcb31181 user: dan tags: wal | |
| 11:35 | Fix test script issues preventing walthread.test from running. check-in: d90b1dde user: dan tags: wal | |
Changes
Changes to test/quick.test.
100 101 102 103 104 105 106 107 108 109 110 111 112 113 |
shared_err.test
vtab_err.test
veryquick.test
mallocAll.test
walslow.test
walcrash.test
}
if {[sqlite3 -has-codec]} {
# lappend EXCLUDE \
# conflict.test
}
|
> |
100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 |
shared_err.test
vtab_err.test
veryquick.test
mallocAll.test
walslow.test
walcrash.test
walthread.test
}
if {[sqlite3 -has-codec]} {
# lappend EXCLUDE \
# conflict.test
}
|
Changes to test/wal.test.
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
...
556
557
558
559
560
561
562
563
564
565
|
INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 8 */
INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 16 */
INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 32 */
INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 64 */
PRAGMA checkpoint;
}
file size test.db
} [expr 67*1024]
do_test wal-12.3 {
execsql {
DELETE FROM t1 WHERE rowid<54;
PRAGMA checkpoint('1 100000');
}
file size test.db
} [expr 14*1024]
................................................................................
do_test wal-13.4 {
breakpoint
execsql { PRAGMA checkpoint }
db2 close
sqlite3_wal db2 test.db
execsql {PRAGMA integrity_check } db2
} {ok}
finish_test
|
|
>
>
>
|
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
...
556
557
558
559
560
561
562
563
564
565
566
567
568
|
INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 8 */
INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 16 */
INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 32 */
INSERT INTO t1 SELECT randomblob(900) FROM t1; /* 64 */
PRAGMA checkpoint;
}
file size test.db
} [expr 68*1024]
do_test wal-12.3 {
execsql {
DELETE FROM t1 WHERE rowid<54;
PRAGMA checkpoint('1 100000');
}
file size test.db
} [expr 14*1024]
................................................................................
do_test wal-13.4 {
breakpoint
execsql { PRAGMA checkpoint }
db2 close
sqlite3_wal db2 test.db
execsql {PRAGMA integrity_check } db2
} {ok}
foreach handle {db db2 db3} { catch { $handle close } }
unset handle
finish_test
|