Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in temptable2.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | tempfiles-lazy-open |
| Files: | files | file ages | folders |
| SHA1: |
04b1890fbc19eb3fa935083c1664fbbf |
| User & Date: | dan 2016-04-11 19:24:56 |
Context
|
2016-04-12
| ||
| 16:10 | Merge enhancements from trunk. check-in: 9682c043 user: drh tags: tempfiles-lazy-open | |
|
2016-04-11
| ||
| 19:24 | Fix a typo in temptable2.test. check-in: 04b1890f user: dan tags: tempfiles-lazy-open | |
| 19:23 | Add tests for wal mode to temptable2.test. check-in: c6d0d441 user: dan tags: tempfiles-lazy-open | |
Changes
Changes to test/temptable2.test.
273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 |
# Try inserts and deletes with a large db in auto-vacuum mode. Check
#
foreach {tn mode} {
1 delete
2 wal
} {
reset_db
do_execsql_test 9.$tn.1.1 {
PRAGMA cache_size = 15;
PRAGMA auto_vacuum = 1;
}
do_execsql_test 9.$tn.1.2 "PRAGMA journal_mode = $mode" $mode
do_execsql_test 9.$tn.1.3 {
CREATE TABLE tx(a, b);
CREATE INDEX i1 ON tx(a);
CREATE INDEX i2 ON tx(b);
WITH x(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM x WHERE i<1000 )
INSERT INTO tx SELECT randomblob(100), randomblob(100) FROM x;
|
> | |
273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 |
# Try inserts and deletes with a large db in auto-vacuum mode. Check
#
foreach {tn mode} {
1 delete
2 wal
} {
reset_db
sqlite3 db ""
do_execsql_test 9.$tn.1.1 {
PRAGMA cache_size = 15;
PRAGMA auto_vacuum = 1;
}
do_execsql_test 9.$tn.1.2 "PRAGMA journal_mode = $mode" delete
do_execsql_test 9.$tn.1.3 {
CREATE TABLE tx(a, b);
CREATE INDEX i1 ON tx(a);
CREATE INDEX i2 ON tx(b);
WITH x(i) AS ( SELECT 1 UNION ALL SELECT i+1 FROM x WHERE i<1000 )
INSERT INTO tx SELECT randomblob(100), randomblob(100) FROM x;
|