Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Modify lock.test to account for "PRAGMA lock_status" returning "unknown" for in-memory databases. (CVS 6287) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 9a6e558ba6fe0b38376a85a6c1e2cea5570ea283 |
| User & Date: | danielk1977 2009-02-12 09:36:16 |
Context
|
2009-02-12
| ||
| 17:01 | Fix some edge cases with backing up databases that are exactly PENDING_BYTE bytes in size, or just slightly larger. (CVS 6288) check-in: 2fc450e8 user: danielk1977 tags: trunk | |
| 09:36 | Modify lock.test to account for "PRAGMA lock_status" returning "unknown" for in-memory databases. (CVS 6287) check-in: 9a6e558b user: danielk1977 tags: trunk | |
| 09:11 | Fix a case where during a rollback triggered by an IO or malloc error an unjournalled region of the database could be written to (with it's original data). This was causing an assert in test_journal.c to fail. Add a test case in ioerr2.test to trigger this case. (CVS 6286) check-in: 315a6692 user: danielk1977 tags: trunk | |
Changes
Changes to test/lock.test.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this script is database locks. # # $Id: lock.test,v 1.36 2009/01/17 16:59:41 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Create an alternative connection to the database # ................................................................................ # At one point the following set of conditions would cause SQLite to # retain a RESERVED or EXCLUSIVE lock after the transaction was committed: # # * The journal-mode is set to something other than 'delete', and # * there exists one or more active read-only statements, and # * a transaction that modified zero database pages is committed. # do_test lock-7.1 { set STMT [sqlite3_prepare $DB "SELECT * FROM sqlite_master" -1 TAIL] sqlite3_step $STMT } {SQLITE_ROW} do_test lock-7.2 { execsql { PRAGMA lock_status } } {main shared temp unlocked} do_test lock-7.3 { execsql { PRAGMA journal_mode = truncate; BEGIN; UPDATE t4 SET a = 10 WHERE 0; COMMIT; } execsql { PRAGMA lock_status } } {main shared temp unlocked} do_test lock-7.4 { sqlite3_finalize $STMT } {SQLITE_OK} do_test lock-999.1 { rename db2 {} } {} finish_test |
|
>
>
|
|
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this script is database locks. # # $Id: lock.test,v 1.37 2009/02/12 09:36:16 danielk1977 Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Create an alternative connection to the database # ................................................................................ # At one point the following set of conditions would cause SQLite to # retain a RESERVED or EXCLUSIVE lock after the transaction was committed: # # * The journal-mode is set to something other than 'delete', and # * there exists one or more active read-only statements, and # * a transaction that modified zero database pages is committed. # set temp_status unlocked if {$TEMP_STORE==3} {set temp_status unknown} do_test lock-7.1 { set STMT [sqlite3_prepare $DB "SELECT * FROM sqlite_master" -1 TAIL] sqlite3_step $STMT } {SQLITE_ROW} do_test lock-7.2 { execsql { PRAGMA lock_status } } [list main shared temp $temp_status] do_test lock-7.3 { execsql { PRAGMA journal_mode = truncate; BEGIN; UPDATE t4 SET a = 10 WHERE 0; COMMIT; } execsql { PRAGMA lock_status } } [list main shared temp $temp_status] do_test lock-7.4 { sqlite3_finalize $STMT } {SQLITE_OK} do_test lock-999.1 { rename db2 {} } {} finish_test |