/ 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 descendants of [a64d96db]

2010-07-07
14:33
Fix a compiler warning in PRAGMA journal_mode. check-in: d94269e6 user: drh tags: trunk
14:19
Avoid the need for a NEVER() from pager_write_pagelist() by passing in pPager as an extra parameter. check-in: b3179379 user: drh tags: trunk
14:00
Merge together the accident fork. check-in: cdcf08cb user: drh tags: trunk
13:58
Fix minor issue in xAccess() method for Windows. check-in: 4bfd46f1 user: shaneh tags: trunk
13:54
Make sure the schema is loaded before preparing a "PRAGMA journal_mode" command. This helps it return meaningful results when it is the first command executed by a new database connection. check-in: ef126e77 user: dan tags: trunk
13:43
Add testcase macros to ensure that large-file cases are tested in WAL. check-in: 8156b57a user: drh tags: trunk
11:43
Run some fts3 tests as part of the "wal" permutation. check-in: 8657455a user: dan tags: trunk
11:05
Change the async-IO extension to return SQLITE_IOERR_SHORT_READ when appropriate. This prevents a valgrind warning in the test suite. check-in: d9e32879 user: dan tags: trunk
09:48
Fix a problem with writing to databases larger than 2^32 bytes with WAL mode. check-in: b956ddca user: dan tags: trunk
01:52
Remote the SQLITE_OMIT_GLOBALRECOVER macro - it is subsumed by SQLITE_OMIT_DEPRECATED. Add support to sqlite3_compileoption_used() for SQLITE_OMIT_WAL. check-in: 21a2db90 user: drh tags: trunk
2010-07-06
20:37
Minor changes to Makefile.in to bring it more inline with main.mk. check-in: 5621862b user: shaneh tags: trunk
20:34
Changes to pager1.test to support Windows. check-in: fce689eb user: shaneh tags: trunk
20:33
Modified the xWrite() method on Windows to differentiate between IO and disk full error returns. check-in: ca4b7ffb user: shaneh tags: trunk
11:26
Do not do the *-closeallfiles test for notify2.test. It uses multiple threads. check-in: fb09152d user: dan tags: trunk
10:55
Before calling Tcl_ExitThread() in a multi-threaded test, call Tcl_DoOneEvent() as many times as necessary to handle any queued events. check-in: b3399b40 user: dan tags: trunk
09:29
Reorder variable declarations in the previous check-in to avoid putting code before declarations when not testing. check-in: d1fe8ab4 user: drh tags: trunk
07:36
Ensure the correct error code is returned if an attempt to parse a database schema made by an ATTACH statement fails. check-in: c2721961 user: dan tags: trunk
2010-07-05
21:00
Modify the VFS xAccess() method on winNT so that it returns false for an exists test of a zero-length file. This makes the windows VFS work the same as the unix VFS. check-in: ec35f254 user: drh tags: trunk
19:13
Simplify the previous commit by removing the pagerCheckForOrDeleteWAL() wrapper. check-in: a1324d12 user: dan tags: trunk
19:03
Allocate a buffer containing the full path-name to the associated WAL file when a pager is created. This saves having to construct a new buffer each time a new read-transaction is opened and SQLite checks for the existance of a WAL file. check-in: 3053a4ad user: dan tags: trunk
17:43
When rolling back page 1 from a journal, restore the "nReserve" setting in case it has been corrupted by a prior crash. check-in: c0d124da user: drh tags: trunk
14:54
Do not report an error if the open-file-count is not as it should be after running a multi-threaded test. The counter instrumentation is not thread-safe. check-in: ea80b21c user: dan tags: trunk
12:54
Call Tcl_ExitThread() from within threads created using Tcl_CreateThread(). Not doing so causes notifier related errors on OSX. check-in: 684eae66 user: dan tags: trunk
05:54
Add any files specified as part of the QUICKTEST_INCLUDE environment variable to the set of test files run as part of "make test". Release testing uses this trick. check-in: a40a6e7d user: dan tags: trunk
05:31
Fix typos in permutations.test. check-in: b6600ecb user: dan tags: trunk
2010-07-03
19:08
Do not run the memsubsys1.test script under the memsubsys1 permutation. check-in: 3a1a8c77 user: dan tags: trunk
17:13
Remove the unused xRename() method from the sqlite3_vfs object. Add better documentation on the xCurrentTimeInt64() method. check-in: 51ec0e54 user: drh tags: trunk
16:37
Further changes to test scripts so that the "inmemory_journal" permutation works. check-in: 50f2f7df user: dan tags: trunk
13:59
Fix a bug in the permutations.test script. check-in: 3b20ad03 user: dan tags: trunk
13:50
Fix an assert in pager.c. And various test cases that fail with the in-memory journal permutation. check-in: 622378db user: dan tags: trunk
13:45
Fix an assert in pager.c. And various test cases that fail with the in-memory journal permutation. Closed-Leaf check-in: 78fc35ff user: dan tags: mistake
12:31
Cherry-pick the correct changes out of the recent "mistake" branch while omitting the bugs. check-in: 48bf3093 user: drh tags: trunk
12:26
Remove dead code from the pager. check-in: 7cbe175a user: drh tags: mistake
12:00
Print the SQLite source_id() string when running speed tests. check-in: 6d7640ed user: drh tags: mistake
10:00
Fix an assert() in pager.c added by the previous commit. And various problems with test scripts in autovacuum and in-memory journal mode. check-in: 62a10101 user: dan tags: mistake
08:01
Do not attempt to open a WAL file for an in-memory or temporary database. Even if the database header suggests that it is a WAL database. check-in: 0fd80924 user: dan tags: mistake
05:56
Change code in OP_Rewind to avoid a valgrind warning following an error in the btree layer. This change does not fix any bug, just a warning. check-in: 4f62dbcf user: dan tags: mistake
01:44
Fix a buffer overrun in the where.c. Problem detected by valgrind. check-in: 15bb6233 user: drh tags: mistake
2010-07-02
19:49
Changes to os_win.c to have it return same error code as os_unix.c. check-in: 33b6f069 user: shaneh tags: mistake
19:36
Omit the OP_JournalMode opcode from the VDBE when SQLITE_OMIT_PRAGMA is defined. check-in: 565ff65c user: drh tags: mistake
19:04
Fix a bug in test_vfs.c causing an assert to fail. Changes to test code only. check-in: 336ce7d2 user: dan tags: mistake
18:58
Do not run the tests in notify3.test unless the unlock-notify API is available. check-in: 0d7fd6fe user: dan tags: mistake
18:44
Take out the incomplete initializer on the constant "dummy" in sqlite3VdbeGetOp(). Add a comment that the MSVC warning there should be ignored. check-in: 452ccaa9 user: drh tags: mistake
18:15
Fix a couple more compiler warnings under MSVC. check-in: 26bc27e3 user: shaneh tags: mistake
17:10
Fix compiler warnings in the proxy locking code. check-in: 26c7689c user: drh tags: mistake
17:07
Remove a couple of C++ style comments from pager.c. check-in: 4f12e8eb user: drh tags: mistake
17:05
Fix some warnings when compiling under MSVC. check-in: 70833877 user: shaneh tags: mistake
16:36
Add initializers for the xShmXXX() members to an sqlite3_io_methods structure in journal.c. This doesn't fix any real problem, just prevents a compiler warning. check-in: dafb3577 user: dan tags: trunk
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