Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Further fixes for test scripts. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | two-mappings |
| Files: | files | file ages | folders |
| SHA1: |
23ffa4f9fbad2e39cbe4776c7fdb61f7 |
| User & Date: | dan 2013-03-29 19:38:52 |
Context
|
2013-04-01
| ||
| 14:20 | Minor changes to unixMapfile() function. Leaf check-in: 80c63443 user: dan tags: two-mappings | |
|
2013-03-29
| ||
| 19:38 | Further fixes for test scripts. check-in: 23ffa4f9 user: dan tags: two-mappings | |
| 18:52 | Fix a problem in btree.c that could cause a crash following an OOM. Also various test script problems. check-in: e8bcdf93 user: dan tags: two-mappings | |
Changes
Changes to test/corruptC.test.
266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 |
forcecopy test.bu test.db
sqlite3 db test.db
set blob [string repeat abcdefghij 10000]
execsql { INSERT INTO t1 VALUES (1, $blob) }
sqlite3 db test.db
set filesize [file size test.db]
hexio_write test.db [expr $filesize-2048] 00000001
catchsql {DELETE FROM t1 WHERE rowid = (SELECT max(rowid) FROM t1)}
} {1 {database disk image is malformed}}
# At one point this particular corrupt database was causing a buffer
# overread. Which caused a crash in a run of all.test once.
#
|
| |
266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 |
forcecopy test.bu test.db
sqlite3 db test.db
set blob [string repeat abcdefghij 10000]
execsql { INSERT INTO t1 VALUES (1, $blob) }
sqlite3 db test.db
set filesize [expr [file_page_count test.db] * [file_page_size test.db]]
hexio_write test.db [expr $filesize-2048] 00000001
catchsql {DELETE FROM t1 WHERE rowid = (SELECT max(rowid) FROM t1)}
} {1 {database disk image is malformed}}
# At one point this particular corrupt database was causing a buffer
# overread. Which caused a crash in a run of all.test once.
#
|
Changes to test/crash.test.
326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 |
INSERT INTO abc VALUES(randstr(1500,1500), 0, 0); -- Overflow page 4
INSERT INTO abc SELECT * FROM abc;
INSERT INTO abc SELECT * FROM abc;
INSERT INTO abc SELECT * FROM abc;
}
} {}
do_test crash-5.2 {
expr [file size test.db] / 1024
} [expr [string match [execsql {pragma auto_vacuum}] 1] ? 11 : 10]
set sig [signature]
do_test crash-5.3 {
# The SQL below is used to expose a bug that existed in
# sqlite3pager_movepage() during development of the auto-vacuum feature. It
# functions as follows:
#
|
| |
326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 |
INSERT INTO abc VALUES(randstr(1500,1500), 0, 0); -- Overflow page 4
INSERT INTO abc SELECT * FROM abc;
INSERT INTO abc SELECT * FROM abc;
INSERT INTO abc SELECT * FROM abc;
}
} {}
do_test crash-5.2 {
file_page_count test.db
} [expr [string match [execsql {pragma auto_vacuum}] 1] ? 11 : 10]
set sig [signature]
do_test crash-5.3 {
# The SQL below is used to expose a bug that existed in
# sqlite3pager_movepage() during development of the auto-vacuum feature. It
# functions as follows:
#
|
Changes to test/permutations.test.
164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 |
]
test_suite "full" -prefix "" -description {
Full test suite. Takes a long time.
} -files [
test_set $alltests
] -initialize {
unset -nocomplain ::G(isquick)
}
test_suite "threads" -prefix "" -description {
All multi-threaded tests.
} -files {
notify2.test thread001.test thread002.test thread003.test
thread004.test thread005.test walthread.test
|
| |
164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 |
]
test_suite "full" -prefix "" -description {
Full test suite. Takes a long time.
} -files [
test_set $alltests
] -initialize {
# unset -nocomplain ::G(isquick)
}
test_suite "threads" -prefix "" -description {
All multi-threaded tests.
} -files {
notify2.test thread001.test thread002.test thread003.test
thread004.test thread005.test walthread.test
|
Changes to test/sqllimits1.test.
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
...
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
|
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a, b, c FROM abc;
INSERT INTO abc SELECT b, a, c FROM abc;
INSERT INTO abc SELECT c, b, a FROM abc;
}
expr [file size test.db] / 1024
} $fsize
do_test sqllimits1-7.7.2 {
db close
sqlite3 db test.db
execsql {
PRAGMA max_page_count = 1000;
}
................................................................................
SELECT count(*) FROM sqlite_master;
}
} {6}
do_test sqllimits1-7.7.3 {
execsql {
PRAGMA max_page_count;
}
} $fsize
do_test sqllimits1-7.7.4 {
execsql {
DROP TABLE abc;
}
} {}
#--------------------------------------------------------------------
|
|
|
|
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
...
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
|
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a||b||c, b||c||a, c||a||b FROM abc;
INSERT INTO abc SELECT a, b, c FROM abc;
INSERT INTO abc SELECT b, a, c FROM abc;
INSERT INTO abc SELECT c, b, a FROM abc;
}
file_page_count test.db
} $fsize
do_test sqllimits1-7.7.2 {
db close
sqlite3 db test.db
execsql {
PRAGMA max_page_count = 1000;
}
................................................................................
SELECT count(*) FROM sqlite_master;
}
} {6}
do_test sqllimits1-7.7.3 {
execsql {
PRAGMA max_page_count;
}
} [expr [file size test.db] / 1024]
do_test sqllimits1-7.7.4 {
execsql {
DROP TABLE abc;
}
} {}
#--------------------------------------------------------------------
|
Changes to test/vacuum3.test.
38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 .. 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 .. 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 |
INSERT INTO t1 VALUES(1, 2, 3);
}
} {}
do_test vacuum3-1.2 {
execsql { PRAGMA page_size }
} {1024}
do_test vacuum3-1.3 {
file size test.db
} {2048}
set I 4
foreach {request actual database} [list \
2048 2048 4096 \
1024 1024 2048 \
1170 1024 2048 \
256 1024 2048 \
................................................................................
execsql "
PRAGMA page_size = $request;
VACUUM;
"
execsql { PRAGMA page_size }
} $actual
do_test vacuum3-1.$I.2 {
file size test.db
} $database
do_test vacuum3-1.$I.3 {
execsql { SELECT * FROM t1 }
} {1 2 3}
integrity_check vacuum3-1.$I.4
incr I
................................................................................
do_test vacuum3-2.1 {
execsql {
PRAGMA page_size = 1024;
VACUUM;
ALTER TABLE t1 ADD COLUMN d;
UPDATE t1 SET d = randomblob(1000);
}
file size test.db
} {3072}
do_test vacuum3-2.2 {
execsql { PRAGMA page_size }
} {1024}
do_test vacuum3-2.3 {
set blob [db one {select d from t1}]
string length $blob
} {1000}
|
| | | > | | |
38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 .. 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 .. 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 |
INSERT INTO t1 VALUES(1, 2, 3);
}
} {}
do_test vacuum3-1.2 {
execsql { PRAGMA page_size }
} {1024}
do_test vacuum3-1.3 {
file_page_count test.db
} {2}
set I 4
foreach {request actual database} [list \
2048 2048 4096 \
1024 1024 2048 \
1170 1024 2048 \
256 1024 2048 \
................................................................................
execsql "
PRAGMA page_size = $request;
VACUUM;
"
execsql { PRAGMA page_size }
} $actual
do_test vacuum3-1.$I.2 {
set nPg [file_page_count test.db]
expr {$nPg * $actual}
} $database
do_test vacuum3-1.$I.3 {
execsql { SELECT * FROM t1 }
} {1 2 3}
integrity_check vacuum3-1.$I.4
incr I
................................................................................
do_test vacuum3-2.1 {
execsql {
PRAGMA page_size = 1024;
VACUUM;
ALTER TABLE t1 ADD COLUMN d;
UPDATE t1 SET d = randomblob(1000);
}
file_page_count test.db
} {3}
do_test vacuum3-2.2 {
execsql { PRAGMA page_size }
} {1024}
do_test vacuum3-2.3 {
set blob [db one {select d from t1}]
string length $blob
} {1000}
|