Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Further fixes for test scripts. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | two-mappings |
Files: | files | file ages | folders |
SHA1: |
23ffa4f9fbad2e39cbe4776c7fdb61f7 |
User & Date: | dan 2013-03-29 19:38:52.044 |
Context
2013-04-01
| ||
14:20 | Minor changes to unixMapfile() function. (Leaf check-in: 80c63443c4 user: dan tags: two-mappings) | |
2013-03-29
| ||
19:38 | Further fixes for test scripts. (check-in: 23ffa4f9fb 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: e8bcdf938e user: dan tags: two-mappings) | |
Changes
Changes to test/corruptC.test.
︙ | ︙ | |||
266 267 268 269 270 271 272 | 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 | | | 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 | 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 { | | | 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 | ] test_suite "full" -prefix "" -description { Full test suite. Takes a long time. } -files [ test_set $alltests ] -initialize { | | | 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 | 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; } | | | | 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 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; } execsql { 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 | INSERT INTO t1 VALUES(1, 2, 3); } } {} do_test vacuum3-1.2 { execsql { PRAGMA page_size } } {1024} do_test vacuum3-1.3 { | | | | > | | | 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 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 \ 512 512 1024 \ 4096 4096 8192 \ 1024 1024 2048 \ ] { do_test vacuum3-1.$I.1 { 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 } #------------------------------------------------------------------- # Test cases vacuum3-2.* convert a simple 3-page database between a # few different page sizes. # 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} |
︙ | ︙ |