Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Get io.test to work even if auto_vacuum is on by default and we are running with a reduced maximum page size. (CVS 4463) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
0d05f3fbaad44a0d3723cd543b865326 |
User & Date: | drh 2007-10-03 21:18:20.000 |
Context
2007-10-04
| ||
00:29 | Updates to the documentation index page. (CVS 4464) (check-in: 837fc86166 user: drh tags: trunk) | |
2007-10-03
| ||
21:18 | Get io.test to work even if auto_vacuum is on by default and we are running with a reduced maximum page size. (CVS 4463) (check-in: 0d05f3fbaa user: drh tags: trunk) | |
21:10 | Fix a syntax error that comes up when memory debugging is disabled. (CVS 4462) (check-in: 96dd3c336b user: drh tags: trunk) | |
Changes
Changes to test/io.test.
︙ | ︙ | |||
9 10 11 12 13 14 15 | # #*********************************************************************** # # The focus of this file is testing some specific characteristics of the # IO traffic generated by SQLite (making sure SQLite is not writing out # more database pages than it has to, stuff like that). # | | | 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | # #*********************************************************************** # # The focus of this file is testing some specific characteristics of the # IO traffic generated by SQLite (making sure SQLite is not writing out # more database pages than it has to, stuff like that). # # $Id: io.test,v 1.11 2007/10/03 21:18:20 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Test summary: # # io-1.* - Test that quick-balance does not journal pages unnecessarily. |
︙ | ︙ | |||
53 54 55 56 57 58 59 60 61 62 63 64 65 66 | set res [expr {$::sqlite_sync_count - $::nSync}] set ::nSync $::sqlite_sync_count set res } do_test io-1.1 { execsql { PRAGMA page_size = 1024; CREATE TABLE abc(a,b); } nWrite db } {2} # Insert into the table 4 records of aproximately 240 bytes each. | > | 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 | set res [expr {$::sqlite_sync_count - $::nSync}] set ::nSync $::sqlite_sync_count set res } do_test io-1.1 { execsql { PRAGMA auto_vacuum = OFF; PRAGMA page_size = 1024; CREATE TABLE abc(a,b); } nWrite db } {2} # Insert into the table 4 records of aproximately 240 bytes each. |
︙ | ︙ | |||
291 292 293 294 295 296 297 298 299 300 301 302 303 304 | } {1} do_test io-2.9.2 { execsql { ROLLBACK; } db close file delete -force test.db test.db-journal sqlite3 db test.db execsql { PRAGMA page_size = 2048; CREATE TABLE abc(a, b); } execsql { BEGIN; INSERT INTO abc VALUES(9, 10); } | > | 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 | } {1} do_test io-2.9.2 { execsql { ROLLBACK; } db close file delete -force test.db test.db-journal sqlite3 db test.db execsql { PRAGMA auto_vacuum = OFF; PRAGMA page_size = 2048; CREATE TABLE abc(a, b); } execsql { BEGIN; INSERT INTO abc VALUES(9, 10); } |
︙ | ︙ | |||
362 363 364 365 366 367 368 369 370 371 372 373 374 375 | # sqlite3_simulate_device -char sequential -sectorsize 0 ifcapable pager_pragmas { do_test io-3.1 { db close file delete -force test.db test.db-journal sqlite3 db test.db file size test.db } {0} do_test io-3.2 { execsql { CREATE TABLE abc(a, b) } nSync execsql { PRAGMA cache_size = 10; | > > > | 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 | # sqlite3_simulate_device -char sequential -sectorsize 0 ifcapable pager_pragmas { do_test io-3.1 { db close file delete -force test.db test.db-journal sqlite3 db test.db db eval { PRAGMA auto_vacuum=OFF; } file size test.db } {0} do_test io-3.2 { execsql { CREATE TABLE abc(a, b) } nSync execsql { PRAGMA cache_size = 10; |
︙ | ︙ | |||
517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 | {atomic512} 512 1024 {atomic2K} 512 2048 {atomic2K} 4096 4096 {atomic2K atomic} 512 8192 {atomic64K} 512 1024 } { incr tn db close file delete -force test.db test.db-journal sqlite3_simulate_device -char $char -sectorsize $sectorsize sqlite3 db test.db ifcapable !atomicwrite { if {[regexp {^atomic} $char]} continue } do_test io-5.$tn { execsql { CREATE TABLE abc(a, b, c); } expr {[file size test.db]/2} } $pgsize } sqlite3_simulate_device -char {} -sectorsize 0 finish_test | > > > > | 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 | {atomic512} 512 1024 {atomic2K} 512 2048 {atomic2K} 4096 4096 {atomic2K atomic} 512 8192 {atomic64K} 512 1024 } { incr tn if {$pgsize>$::SQLITE_MAX_PAGE_SIZE} continue db close file delete -force test.db test.db-journal sqlite3_simulate_device -char $char -sectorsize $sectorsize sqlite3 db test.db db eval { PRAGMA auto_vacuum=OFF; } ifcapable !atomicwrite { if {[regexp {^atomic} $char]} continue } do_test io-5.$tn { execsql { CREATE TABLE abc(a, b, c); } expr {[file size test.db]/2} } $pgsize } sqlite3_simulate_device -char {} -sectorsize 0 finish_test |