Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a couple of test script bugs. No changes to SQLite code. (CVS 6396) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
c9fa329f54736de517cddaf747595c9e |
| User & Date: | danielk1977 2009-03-28 07:03:42 |
Context
|
2009-03-28
| ||
| 10:54 | The fix in (6395) was not correct. Fix #3756 a different way. (CVS 6397) (check-in: 9278f7b1 user: danielk1977 tags: trunk) | |
| 07:03 | Fix a couple of test script bugs. No changes to SQLite code. (CVS 6396) (check-in: c9fa329f user: danielk1977 tags: trunk) | |
| 06:59 | Fix readDbPage() so that if an SQLITE_IOERR_SHORT_READ is encountered, the page content is zeroed. Ticket #3756. (CVS 6395) (check-in: 647e3b15 user: danielk1977 tags: trunk) | |
Changes
Changes to test/io.test.
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 ... 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 ... 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 |
# #*********************************************************************** # # 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.20 2009/01/11 00:42:02 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl db close sqlite3_simulate_device sqlite3 db test.db -vfs devsym ................................................................................ file exists test.db-journal } {0} do_test io-2.6.2 { # Create a file at "test.db-journal". This will prevent SQLite from # opening the journal for exclusive access. As a result, the COMMIT # should fail with SQLITE_CANTOPEN and the transaction rolled back. # set fd [open test.db-journal w] puts $fd "This is not a journal file" close $fd catchsql { COMMIT } } {1 {unable to open database file}} do_test io-2.6.3 { file delete -force test.db-journal catchsql { COMMIT } } {1 {cannot commit - no transaction is active}} do_test io-2.6.4 { ................................................................................ execsql { INSERT INTO abc2 SELECT * FROM abc } file exists test2.db-journal } {0} do_test io-2.7.3 { execsql { SELECT * FROM abc UNION ALL SELECT * FROM abc2 } } {1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10} do_test io-2.7.4 { set fd [open test2.db-journal w] puts $fd "This is not a journal file" close $fd catchsql { COMMIT } } {1 {unable to open database file}} do_test io-2.7.5 { file delete -force test2.db-journal catchsql { COMMIT } } {1 {cannot commit - no transaction is active}} do_test io-2.7.6 { |
| | < < | < < |
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 ... 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 ... 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 |
# #*********************************************************************** # # 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.21 2009/03/28 07:03:42 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl db close sqlite3_simulate_device sqlite3 db test.db -vfs devsym ................................................................................ file exists test.db-journal } {0} do_test io-2.6.2 { # Create a file at "test.db-journal". This will prevent SQLite from # opening the journal for exclusive access. As a result, the COMMIT # should fail with SQLITE_CANTOPEN and the transaction rolled back. # file mkdir test.db-journal catchsql { COMMIT } } {1 {unable to open database file}} do_test io-2.6.3 { file delete -force test.db-journal catchsql { COMMIT } } {1 {cannot commit - no transaction is active}} do_test io-2.6.4 { ................................................................................ execsql { INSERT INTO abc2 SELECT * FROM abc } file exists test2.db-journal } {0} do_test io-2.7.3 { execsql { SELECT * FROM abc UNION ALL SELECT * FROM abc2 } } {1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10} do_test io-2.7.4 { file mkdir test2.db-journal catchsql { COMMIT } } {1 {unable to open database file}} do_test io-2.7.5 { file delete -force test2.db-journal catchsql { COMMIT } } {1 {cannot commit - no transaction is active}} do_test io-2.7.6 { |
Changes to test/notify2.test.
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
# # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # $Id: notify2.test,v 1.5 2009/03/26 14:48:07 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl if {[run_thread_tests]==0} { finish_test ; return } # The tests in this file test the sqlite3_blocking_step() function in # test_thread.c. sqlite3_blocking_step() is not an SQLite API function, # it is just a demonstration of how the sqlite3_unlock_notify() function # can be used to synchronize multi-threaded access to SQLite databases # in shared-cache mode. # |
| > |
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
# # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # # $Id: notify2.test,v 1.6 2009/03/28 07:03:42 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl if {[run_thread_tests]==0} { finish_test ; return } ifcapable !unlock_notify||!shared_cache { finish_test ; return } # The tests in this file test the sqlite3_blocking_step() function in # test_thread.c. sqlite3_blocking_step() is not an SQLite API function, # it is just a demonstration of how the sqlite3_unlock_notify() function # can be used to synchronize multi-threaded access to SQLite databases # in shared-cache mode. # |