/ 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 68a49f7fe382e4d3.

2010-08-24
01:08
Merge changes through release 3.7.2 into the apple-osx branch. check-in: 415c448d user: drh tags: apple-osx
00:40
Version 3.7.2 check-in: 42537b60 user: drh tags: trunk, release, version-3.7.2
2010-08-23
18:19
Fixes for the SQLITE_CHECK_PAGES debugging feature. check-in: 21a1e596 user: dan tags: trunk
17:09
Update the version number in preparation for the 3.7.2 release. check-in: 77889510 user: drh tags: trunk
15:41
Fix for ticket [5e10420e8d]. check-in: 255f1eef user: dan tags: trunk
15:26
Update the "showdb" debug utility to handle 64K pages and with extra options to decode the freelist structure. check-in: 1070918e user: drh tags: trunk
01:25
Version 3.7.1 check-in: 3613b069 user: drh tags: trunk, release
2010-08-21
15:51
Add some tests to e_expr.test and pagerfault.test. No code changes. check-in: 44de3cab user: dan tags: trunk
15:09
Fix the ptrmapPageno() routine so that it works correctly for an input of 1. check-in: 699a9bf2 user: drh tags: trunk
2010-08-20
15:32
Do not allow a backup to change the page size if a codec is in use. check-in: 5523ecd3 user: drh tags: trunk
12:43
Fix typo in backcompat.test. check-in: 6a0cbb27 user: dan tags: trunk
12:34
Merge leaf created by accident. check-in: 1f680cb3 user: dan tags: trunk
12:31
Avoid assuming that the user has "." in their path when running multi-process tests. check-in: daa5d461 user: dan tags: trunk
10:28
Do not attempt run backwards compatibility tests if no historical "testfixture" binaries are available. check-in: 40e11aab user: drh tags: trunk
09:53
Disable the MEMSYS2 auxiliary routines if MEMSYS2 is changed to an alternative memory allocator using SQLITE_CONFIG_MALLOC. check-in: 541dd3b8 user: drh tags: trunk
09:14
Fix the sqlite3_release_memory() interface so that it does not attempt to free SQLITE_CONFIG_PAGECACHE memory. check-in: 0426cd62 user: drh tags: trunk
2010-08-19
18:05
Adjust filename globbing in backcompat.test for Windows. check-in: b0f47963 user: shaneh tags: trunk
17:16
Fix backcompat.test so that it works with windows mandatory locking. check-in: 8d05f66d user: dan tags: trunk
15:48
Add tests for WAL mode to test/backcompat.test. check-in: 7999910e user: dan tags: trunk
15:12
Merge two leaves. check-in: b03091fc user: dan tags: trunk
15:11
Modify the code for reading hot-journal files so that it can handle journals generated by versions 3.5.7 and earlier. check-in: b9170f29 user: dan tags: trunk
14:41
Fix typo in TCL stubs support for configure in Makefile.in check-in: 4c7ad73d user: shaneh tags: trunk
14:22
Remove a NEVER from balance_quick() that can occur in WAL mode on a corrupt database file. check-in: b273891a user: drh tags: trunk
11:05
Add new test script backcompat.test, for testing database/journal/wal file compatibility against previous versions. check-in: 8804f498 user: dan tags: trunk
2010-08-18
21:19
Fix two asserts in the btree logic so that they work correctly even for maximum-size index entries for 32K and 64K pages. check-in: e127192d user: drh tags: trunk
17:16
Updated tests for CLI. Added some basic tests for the .import command. check-in: d46567e5 user: shaneh tags: trunk
15:25
Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files. check-in: 56cc883d user: dan tags: trunk
14:54
Fix issue with wal.test on Windows. check-in: 3497f54a user: shaneh tags: trunk
02:28
Fix some compiler warnings in the MSVC build. check-in: 1f5662b7 user: shaneh tags: trunk
00:24
Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. check-in: 866e9286 user: drh tags: apple-osx
00:09
Updating apple-osx with minor source fixes, database truncate and replace private calls and a bunch of conditionalization for tests running in different environments check-in: 5e2ee7db user: adam tags: apple-osx
2010-08-17
23:13
Cherrypick the changes for enhancement requests [e090183531fc27474] (use indices on LIKE with no wildcards) and [4711020446da7d93d993] (use nocase index for LIKE even if the column is binary) into the 3.6.23.1 release of the Apple-OSX branch. check-in: 220cca50 user: drh tags: apple-osx-3623
19:49
Remove a NEVER() that is actually reachable. check-in: acb171d4 user: drh tags: trunk
19:40
Suppress harmless compiler warning. check-in: 3f8c068a user: drh tags: trunk
19:34
Return an error when parsing "?NNN" if NNN is so large it cannot be stored as a 32-bit int. check-in: fc9014be user: dan tags: trunk
18:37
It is no longer possible to reach pagerStress() while in the error state, so put a NEVER() around the error state test of that routine. check-in: d7ed4634 user: drh tags: trunk
18:15
If an SQLITE_FULL error occurs during rollback or journal finalization, treat it in the same way as SQLITE_IOERR (i.e. require that the pager internals be completely reset before it is next read from or written to). check-in: 8ac18523 user: dan tags: trunk
17:25
Changes to pager for improved testability. check-in: 61c64b3a user: drh tags: trunk
16:06
Add tests for the BETWEEN operator to e_expr.test. check-in: ced6a348 user: dan tags: trunk
14:52
Invoke sqlite3_log() whenever one or more frames are recovered from a WAL file. check-in: e05089aa user: dan tags: trunk
05:55
Fix some non-ANSI C code in test_demovfs.c. Also change the same file so that attempting to delete a file that does not exist does not return an error. check-in: 07570ce3 user: dan tags: trunk
2010-08-16
20:02
Remove an superfluous branch from pager.c. check-in: 4271a95c user: drh tags: trunk
19:23
Add tests for different page sizes to wal.test. Including 64K pages. check-in: d95bcc05 user: dan tags: trunk
18:26
Add test cases designed to exercise all syntax diagram paths in lang_expr.html check-in: d4a26bb6 user: dan tags: trunk
16:31
Fix a typo in a comment in wal.c. No code changes. check-in: d854a3d4 user: drh tags: trunk
14:18
Add ALWAYS() macros in wal.c to cover branches that are no longer reachable following the pager refactoring. check-in: 24f24c92 user: drh tags: trunk
2010-08-14
21:21
Adjustments for better 64K page size handling. check-in: faf1974e user: drh tags: trunk
18:32
Add test case to e_expr.test. check-in: db9539f2 user: dan tags: trunk
17:12
Change sqlite3PagerPagecount() to return void, since the return value was always SQLITE_OK and was never used. check-in: 7dd78eb7 user: drh tags: trunk
16:02
Minor simplifications to btree.c in support of full-coverage testing. check-in: 364df6c7 user: drh tags: trunk
12:42
Tweaks to comments in pager.c. Fix two compiler warnings. check-in: 68a49f7f user: drh tags: trunk
12:25
Add test cases to e_expr.test. check-in: d8bbab78 user: dan tags: trunk
05:04
Test that it is possible to drop a trigger while there are active statements belonging to the same connection. check-in: d4ec61e2 user: dan tags: trunk
2010-08-13
18:41
Add tests to test file e_expr.test. check-in: 3fd1059e user: dan tags: trunk
16:38
Do not apply the flattening optimization if the sub-query is DISTINCT. Fix for [e4b8a2ba6e]. check-in: 497aafd8 user: dan tags: trunk
2010-08-12
16:36
If an error occurs in PagerSetPagesize(), set the output variable to the unmodified page-size before returning. check-in: 02def8f9 user: dan tags: trunk
11:25
Add coverage tests for pager.c. check-in: 228c5b16 user: dan tags: trunk
02:41
Increase the maximum page size from 32k to 64k. check-in: 45362437 user: drh tags: trunk
2010-08-11
18:56
Improve coverage of pager.c. check-in: 2fa05d01 user: dan tags: trunk
12:26
Update an r-tree extension test case to account for recent changes to the query planner. Also fix a comment in rtree.c. check-in: eaaca669 user: dan tags: trunk
11:59
Use sqlite3DbFree() instead of sqlite3_free() to free any error message reported by the parser layer while attempting to parse a CREATE TABLE statement passed to sqlite3_declare_vtab(). check-in: 7c674aab user: dan tags: trunk
11:35
Fixes to tcl test files so that they work in auto-vacuum mode. check-in: ea9eaf74 user: dan tags: trunk
06:14
Fix memory allocation in proxy locking so that it works with SQLITE_MEMDEBUG. check-in: f854cbe0 user: drh tags: trunk
06:04
Merge experimental changes into trunk. check-in: aa092ac9 user: dan tags: trunk
2010-08-10
15:46
Fix a bug in pager.c causing it to omit the xSync() call required following a hot-journal rollback. Closed-Leaf check-in: 42ba43ac user: dan tags: experimental
09:58
Add variable pager.dbHintSize, used to limit the number of calls made to the xFileControl(FCNTL_SIZE_HINT) method. check-in: eb3ac895 user: dan tags: experimental
07:12
Changes to debugging code in mutex_unix.c and mutex_w32.c to make an assert() statement threadsafe. check-in: e82e32bd user: dan tags: trunk
2010-08-09
19:17
Modify some comments in pager.c. check-in: 5662da6d user: dan tags: experimental
16:52
Merge latest trunk changes with experimental branch. check-in: aecbd890 user: dan tags: experimental
16:12
Fix a memory leak in test_journal.c causing tests to fail. check-in: f229487c user: dan tags: experimental
15:44
Fix typos in comments. No functional changes to the code. check-in: 9cebaf2d user: drh tags: trunk
14:47
Change to tcl test infrastructure so that --malloctrace=1 works when sizeof(int)!=sizeof(void*). check-in: c3e771b3 user: dan tags: experimental
14:26
Fix two comment typos that were reported on the mailing list. check-in: 88bf9016 user: drh tags: trunk
07:51
Fix a problem causing the return code of an xSync call to be ignored in wal.c. check-in: f1b2b5f9 user: dan tags: experimental
07:07
In WAL mode, ignore any error returned by an xFileControl(FCNTL_SIZE_HINT) call. This matches the behaviour in rollback mode. check-in: 158a3097 user: dan tags: experimental
2010-08-07
16:17
Fix minor problems and update comments in pager.c. check-in: 92e45637 user: dan tags: experimental
11:46
Merge in all changes up to the 3.7.0.1 release. check-in: f88c6367 user: drh tags: apple-osx
09:31
Fix a problem wherein changing the journal-mode immediately after leaving exclusive-locking mode could lead to the database being unlocked without clearing the changeCountDone flag. check-in: 531abc80 user: dan tags: experimental
05:15
Add test case 'cgt_pager_1', intended for use with callgrind to detect performance regression in the pager module, to threadtest3.c. check-in: b5d46f1e user: dan tags: experimental
2010-08-06
19:00
Remove all vestiges of ctype.h from FTS3. This addresses ticket [991789d9f3136a] among other bug reports. check-in: b8b465ed user: drh tags: trunk
17:18
Further enhancements to comments in pager.c. check-in: 876162c7 user: dan tags: experimental
14:37
Fix some problems with running test scripts with the inmemory_journal permutation. check-in: 7bd8ba08 user: dan tags: experimental
13:53
Merge trunk changes into experimental branch. check-in: aef6698c user: dan tags: experimental
13:50
Do not run some tests in notify3.test with the inmemory_journal permutation. They do not pass as the tests assume that the database schema is not loaded until the first invocation of [db eval]. This is not true with the inmemory_journal permutation. check-in: 698fba82 user: dan tags: trunk
12:00
Further updates to comments in pager.c. check-in: 5f4c17a3 user: dan tags: experimental
09:43
Modify test_journal.c to work with pre-allocated databases. check-in: 4894a5d2 user: dan tags: experimental
06:54
Fix a bug to do with deleting the journal file when exiting exclusive-locking mode. check-in: 6217b607 user: dan tags: experimental
02:10
Change two automatic array variables into static constant arrays. Update and reformat some comments for cleaner presentation. check-in: a7a15547 user: drh tags: trunk
2010-08-05
18:53
Add comments describing UNKNOWN_LOCK to pager.c. Improve some other comments in the same file. check-in: 54eff6de user: dan tags: experimental
16:22
Merge trunk changes with experimental branch. check-in: acd26b8b user: dan tags: experimental
16:08
Catch an error code that was not being propagated back to the caller. check-in: 800f4969 user: dan tags: experimental
15:30
Fixes for error handling with temp databases. And for errors that occur within OS locking primitives. check-in: f99a902f user: dan tags: experimental
11:56
Make the size of a Bitvec object 512 bytes on all platforms, instead of having the size depend on the size of a pointer. This makes testing easier. check-in: ca479f3d user: drh tags: trunk
03:21
Do not read the database file size on a SAVEPOINT rollback any more since after checkin [65b8636ac6e5] the in-header-size field is always valid. check-in: fbe70e11 user: drh tags: trunk
02:52
Fix the query planner so that when it has a choice of full-scan tables to move to the outer loop, it chooses the one that is likely to give the fewest output rows. Ticket [13f033c865f878]. check-in: 309bbedf user: drh tags: trunk
2010-08-04
21:17
If the outer loop of a join must be a full table scan, make sure that an incomplete ANALYZE does not trick the planner into use a table that might be indexable in an inner loop. Ticket [13f033c865f878] check-in: e7a714b5 user: drh tags: trunk
19:14
Fix some problems with error recovery introduced while reworking pager state. check-in: 77eaab6f user: dan tags: experimental
12:31
Version 3.7.0.1 Leaf check-in: 042a1abb user: drh tags: release, branch-3.7.0
12:19
Update the version number to 3.7.0.1. check-in: 5074b859 user: drh tags: branch-3.7.0
12:13
Backport fix [267492d3a7eff7b] for the performance regression caused by automatic indexing and reported by ticket [8011086c85c6c4040]. check-in: 3f367fe0 user: drh tags: branch-3.7.0