/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around f820b815c9bff368.

2010-07-02
15:35
Remove an unused call to sqlite3PageBegin() from pager_write(). Replace it with an assert(). check-in: 01c12782 user: drh tags: trunk
13:49
Run tkt-9d68c883.test along with the other pager.c coverage tests. Add a test case to pager1.test. check-in: c6714b0d user: dan tags: trunk
11:27
Additional test cases to cover branches in pager.c. check-in: eddfb2b4 user: dan tags: trunk
01:18
Add a NEVER to sqlite3PagerCommitPhaseTwo() because it is now no longer possible to invoke that function without holding a RESERVED lock. check-in: 6ae76172 user: drh tags: trunk
2010-07-01
19:45
If you delete a database file but not its *-wal file, then open the database (thus creating a new empty database file) the *-wal file is automatically deleted. check-in: 95c69dfb user: drh tags: trunk
19:01
Add tests to pager1.test and pagerfault.test. check-in: c6e75950 user: dan tags: trunk
15:09
Add pager test cases. Change a condition in pager.c to NEVER(). check-in: a8f6341d user: dan tags: trunk
2010-06-30
10:36
Add further test cases. Fix an assert() in pager.c. check-in: 8e65c0e3 user: dan tags: trunk
04:36
Do not call pager_open_journal() from within PagerBegin() if the connection is in exclusive-access mode. It will be called from within PagerWrite() just as it is for non-exclusive mode anyway. check-in: cdf2c5c2 user: dan tags: trunk
04:29
Add coverage test cases. Have sqlite3_backup_step() transform SQLITE_IOERR_NOMEM to SQLITE_NOMEM before returning. check-in: 5e19bc36 user: dan tags: trunk
2010-06-29
10:30
Add tests to pager1.test and pagerfault.test. check-in: 008513ee user: dan tags: trunk
2010-06-28
19:04
Add extra pager tests. check-in: 6b7e419d user: dan tags: trunk
11:23
Fix some errors when compiling with SQLITE_OMIT_WAL. check-in: 3b68cb9c user: dan tags: trunk
11:06
Remove debugging code from test script. check-in: a85ae332 user: dan tags: trunk
10:15
Currently, if SQLite cannot find a table or index referred to by a query, it reloads the database schema from disk to see if the table or index has been added since the schema was cached in memory. Extend this behaviour to columns (which may have been added using ALTER TABLE) and fix some obscure cases related to tables and indexes (INDEXED BY, DROP TABLE etc.). check-in: 4932f228 user: dan tags: trunk
2010-06-26
22:16
Make walIndexTryHdr() a private function. Fix an issue with SQLITE_MUTEX_NOOP. check-in: ec65bbd0 user: drh tags: trunk
21:34
Suppress various compiler warnings. check-in: e82d008e user: drh tags: trunk
20:25
Fix two asserts on the scratch allocator to allow for up to two outstanding scratch allocations per thread. check-in: f149b498 user: drh tags: trunk
20:00
Suppress a couple uninitialized variable warnings. check-in: 29571e22 user: drh tags: trunk
19:03
Add test file tkt-d11f09d36e.test. check-in: 6e469b63 user: dan tags: trunk
19:02
Remove a NEVER() in pager that can in fact be reached in obscure failure cases. check-in: 42b8bd1c user: drh tags: trunk
17:15
Fix a case where the doNotSyncSpill flag may remain permanently set following an IO error. check-in: 56c7d111 user: dan tags: trunk
15:42
When synchronous=NORMAL, use the same journal file format as with synchronous=FULL (i.e. multiple journal headers within the one journal). Fix for [d11f09d36e]. check-in: 2eaf5ee0 user: dan tags: trunk
2010-06-25
19:09
Further test cases for pager1.test and pagerfault.test. check-in: bfd563c4 user: dan tags: trunk
16:34
Reduce the average (but not maximum) size of the allocations made as part of a checkpoint. check-in: 4a7fd91b user: dan tags: trunk
15:16
Reduce the size of the large allocation (approx 8KB for every 4000 frames in the log) that occurs during checkpoint. Use the 'scratch' memory for this allocation instead of the general purpose allocation. check-in: 29887487 user: dan tags: trunk
14:17
Fix up a branch in sqlite3ValueFromExpr() so that we can achieve full branch test coverage regardless of whether or not SQLITE_ENABLE_STAT2 is used. check-in: af471ed7 user: drh tags: trunk
12:52
Change the name of the shared-memory file on windows from *-wal-index to *-shm, for consistency with unix. check-in: 5995cb15 user: drh tags: trunk
11:35
Modify the merge-sort in wal.c so that it does not use recursion. check-in: daea6c05 user: dan tags: trunk
2010-06-24
19:16
Add test cases to pager1.test and pagerfault.test. check-in: 4941e437 user: dan tags: trunk
18:36
Revert to allowing a cache spill during writes of multiple pages within a single sector as long as the spill does not require a journal sync and a new journal header. check-in: 7d83fbae user: drh tags: trunk
17:37
Modify ctime.test to work with SQLITE_THREADSAFE=2. check-in: c6db3b30 user: dan tags: trunk
14:52
Disable memory-pressure induced cache spill during savepoint rollback. check-in: a55eb4c3 user: drh tags: trunk
13:24
Add a coverage test to pagerfault.test. check-in: b58db67e user: dan tags: trunk
10:50
Add coverage tests. Remove a NEVER macro from pager.c, as the condition can now be true in wal mode. check-in: 7aac9ad6 user: dan tags: trunk
02:46
Make sure the wal-index reader detects an incorrect version number even if it had to hold a lock in order to read the wal-index. Also, expand and enhance various comments in wal.c. check-in: 2e6a462c user: drh tags: trunk
2010-06-23
22:00
Fix and/or improve comments in wal.c. No code changes. check-in: ee9991be user: drh tags: trunk
19:27
Add test case for SQLITE_FULL errors to pagerfault.test. Remove a NEVER macro in pager.c that this hits. check-in: 3e9680c4 user: dan tags: trunk
17:59
Include the SOURCE_ID value in the log messages output for corruption, misuse, and CANTOPEN errors. check-in: 1727a81f user: drh tags: trunk
17:58
Adjust the shared-memory locking range to account for the new version number values in the wal-index header. check-in: a6dc0df3 user: drh tags: trunk
15:55
Add a version number to the wal-index header. If SQLite encounters a version number in either the wal or wal-index files that it does not understand, the operation is abandoned and SQLITE_CANTOPEN returned. check-in: 8d0f8a7f user: dan tags: trunk
15:18
Fix the xCurrentTimeInt64 interface on windows. It was off by a factor of 10. check-in: 51ef43b9 user: drh tags: trunk
15:04
Simplifications to the pager_delmaster() implementation. check-in: 8bfbdec6 user: drh tags: trunk
2010-06-22
21:15
Disable code used only by the codec when the codec is not deployed. check-in: 2c90276e user: drh tags: trunk
15:18
Add codec support to wal mode. check-in: 393741eb user: dan tags: trunk
14:49
When trying to transition from journal_mode MEMORY to WAL, use OFF as an intermediate journal mode. check-in: 4775b8f9 user: drh tags: trunk
13:46
Some changes to test scripts related to codec enabled versions of sqlite. check-in: 85dd51a7 user: dan tags: trunk
11:10
Fix problem with handling of -vfs option in tcl interface. check-in: 8f98e8b5 user: dan tags: trunk
2010-06-21
21:45
Minor tweaks to get the pager working for corner cases when the SQLITE_IOCAP_UNDELETABLE_WHEN_OPEN flag is set. check-in: 82b38fca user: drh tags: trunk
20:19
Fix comment inside the pager_unlock() routine. Always close the master journal file before trying to delete it. check-in: f820b815 user: drh tags: trunk
18:29
Add test cases to pager1.test and pager2.test. check-in: cc9ddae6 user: dan tags: trunk
12:47
Merge the experimental UNDELETABLE_WHEN_OPEN optimization into the trunk. check-in: ee0acef1 user: drh tags: trunk
12:34
Change things so that journal2.test works with ENABLE_ATOMIC_WRITE. Closed-Leaf check-in: a64d96db user: dan tags: experimental
07:45
Add further pager tests. check-in: 4104b175 user: dan tags: experimental
06:00
Merge latest trunk change. check-in: f6d26e07 user: dan tags: experimental
05:40
Fix jrnlmode2.test so that it works on systems where UNDELETABLE_WHEN_OPEN is defined. check-in: 59be370e user: dan tags: experimental
2010-06-19
23:53
Fix an uninitialized variable in os_unix.c. check-in: 822a0283 user: drh tags: trunk
19:06
Fix an assert() failure that could occur if compiling with OMIT_SHARED_CACHE. check-in: 3e76a9f2 user: dan tags: experimental
18:12
Change the name of IOCAP_SAFE_DELETE to IOCAP_UNDELETABLE_WHEN_OPEN. Have the xDeviceCharacteristics() method of the win32 VFS return this flag. check-in: 5a5ff4e3 user: dan tags: experimental
17:26
Add tests to pager1.test and pagerfault.test. check-in: f5df83fd user: dan tags: experimental
15:10
Change the unix VFS to always allocate shared-memory using a file in the same directory as the database. Otherwise, a chroot might cause different processes to use different shared memory files resulting in database corruption. check-in: 2241788b user: drh tags: trunk
11:30
Add tests to pager1.test and pagerfault.test. check-in: 58c0b5bf user: dan tags: experimental
2010-06-18
18:59
Add tests to pager1.test. check-in: 582fca89 user: dan tags: experimental
16:13
Rearrange some code in OP_JournalMode to avoid incorrect returns from subsequent invocations of "PRAGMA journal_mode" following an IO error. check-in: ce0a4a9b user: dan tags: experimental
11:10
Change the implementation of the unix implementation of xAccess() so that it returns 0 (does not exist) to an SQLITE_ACCESS_EXISTS query on a file that exists but is zero bytes in size. check-in: 077b0e5b user: dan tags: experimental
2010-06-17
17:05
Apply [b9b11855e8] (the alternate fix to [fc62af4523]) to the trunk. check-in: 9a949a3a user: dan tags: trunk
16:44
Merge trunk change [7c3a86b9c7]. check-in: bd7bc4e0 user: dan tags: experimental
16:44
A different fix to [fc62af4523]. When changing from journal_mode=PERSIST or TRINCATE to some other rollback mode, delete the journal file only if a RESERVED lock can be obtained on the database file first. check-in: b9b11855 user: dan tags: experimental
16:08
Fix the tkt-fc62af4523.test to work around non-randomness of the randomblob() function when in testing mode. check-in: 7c3a86b9 user: drh tags: trunk
11:36
Fix bug in journal2.test. check-in: c1e04f1d user: dan tags: experimental
10:52
Merge trunk updates with experimental branch. Also add tests to journal2.test. check-in: 9f6ea1de user: dan tags: experimental
10:42
Do not delete the journal file in "PRAGMA journal_mode" commands. This fixes [fc62af4523]. check-in: 1ec74591 user: dan tags: trunk
10:24
Add test case for [fc62af4523]. check-in: cccd32c6 user: dan tags: trunk
06:19
Merge fix [f80c3f922a] with experimental changes. check-in: 20133e9c user: dan tags: experimental
02:13
Bug fix: Only trust the database size number at offset 28 if the change counter at offset 24 matches the version number counter at offset 92. This prevents corruption in the case of two applications writing to the database where one is an older version of SQLite and the other is a newer version. check-in: f80c3f92 user: drh tags: trunk
2010-06-16
19:48
Merge in changes up to and including the 3.6.23.1 release. check-in: 21ca87f6 user: drh tags: apple-osx
19:04
Experimental change: On systems where it is not possible to unlink a file while one or more processes has it open (i.e. not unix), avoid closing the journal file each time the database is unlocked and reopening it at the start of each transaction. check-in: bede8c8a user: dan tags: experimental
12:30
Add extra test cases to pager1.test. check-in: ad320957 user: dan tags: trunk
10:55
Fix a memory leak that can occur in os_unix.c if an IO error occurs within the xUnlock method. check-in: 6c5c04ee user: dan tags: trunk
2010-06-15
19:07
Rationalize a common pattern in tcl test cases into proc do_multiclient_test. check-in: efe44564 user: dan tags: trunk
18:00
Fix a problem introduced into lock2.test by the previous commit. check-in: c1c9f6fa user: dan tags: trunk
17:44
Add test file pager1.test, containing tests of inter-process locking in non-wal mode. check-in: 6e43eed9 user: dan tags: trunk
14:21
Run extra iterations in wal3.test to ensure test coverage. check-in: ea80cbe5 user: dan tags: trunk
14:06
Merge in [2c5e48a485]. Merge in [2c5e48a485]. Merge in [2c5e48a485]. check-in: 03c0f4fd user: dan tags: trunk
13:56
Changes to the way tcl test scripts work. No changes to production code. Closed-Leaf check-in: 2c5e48a4 user: dan tags: experimental
12:09
Minor tweaks to the interface documentation - adding hyperlinks. check-in: 07b2fdd1 user: drh tags: trunk
11:21
Updates to comments and testcase() macros in wal.c. check-in: 4d90cc0b user: drh tags: trunk
2010-06-14
18:06
Fix an error in the walfault.test script introduced by the previous check-in. check-in: a2b9374f user: drh tags: trunk
18:01
Move the xShmMap method to in between xShmLock and xShmBarrier, since it seems to fit in there logically. check-in: 58dfd83d user: drh tags: trunk
17:09
Merge the experimental shared-memory mmap-by-chunk changes into the trunk. check-in: f295e7ed user: drh tags: trunk
16:16
Add the new xShmMap (formerly xShmPage) to os_win.c. check-in: 13e7a824 user: dan tags: experimental
14:07
Remove xShmGet/Size/Release from the sqlite3_vfs structure. Change the name of xShmPage to xShmMap. Remove some code that is now unused from os_unix.c and some of the test VFS implementations. check-in: fc0cabc1 user: dan tags: experimental
11:49
Update some comments in wal.c. No code changes. check-in: 1ce9c92b user: dan tags: experimental
11:18
Change the interface to internal function walGetHash() to make it easier to follow. check-in: 5e8e2e97 user: dan tags: experimental
10:30
Add the xShmPage method to the "crash" vfs in test6.c. check-in: 1008f536 user: dan tags: experimental
07:53
Add some fault-injection tests to improve coverage. check-in: 37b26d12 user: dan tags: experimental
2010-06-12
12:02
Fix some problems with handling IO errors on the experimental branch. check-in: eade8bc2 user: dan tags: experimental
2010-06-11
19:04
Experimental change to the xShmXXX parts of the VFS interface. check-in: ca68472d user: dan tags: experimental
17:01
Refactor and simplify the logic used to change journalmode. check-in: 95cc3f6f user: drh tags: trunk
2010-06-10
16:25
Adding original art for the new SQLite logo. check-in: af353bd8 user: drh tags: trunk